authentication (java / sql)

[Girvan]

Hello,
I make a java program with a SQL database.
My problem:
I made a window (GUI) for a login.
On the other hand, I have a table with an identifying and a password.
I am unable to check if the IDs exist in the sql table.
So in fact the thing is that it can not take names, so it can not compare ... how can I do?
Thank you in advance

[opaper]

try following code

import java.sql .*;
public class Pass (

public static void main (String args []) (
Statement statement = connection.createStatement (/ / error in line cett
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY);
String sql = "SELECT * FROM user";
ResultSet result = statement.executeQuery (sql);
while (resultat.next ()) (
String login = resultat.getString (1);
String pass = resultat.getString (2);
resultat.getRow int row = ();
System.out.println ( "Data in row" + row);
System.out.println ( "id:" + login + "name:" + pass);
)
)
)

[Modifier]

Do not worry, all mac users are not as embittered as

Indeed, the connection is not established, here's one answer:
Code:

/ / Connection settings to the database
String url = "jdbc: yourBDDAccess" / / ex: postgresql: / / localhost / postgres
String login = "yourBDDLogin";
String password = "youBDDPass";

try
(
/ / Connection
Connection connection = DriverManager.getConnection (url, login, password);
/ / interaction with the base
Statement st = connection.createStatement ();

/ / Treatment

st.close ();
connection.close ();
)
catch (SQLException sqle)
(
sqle.printStackTrace ();
)