Java & MySQL

Kode 

Connection conc = DriverManager.getConnec.... //Det her går jeg ud fra du ved

Statement stmt = conc.createStatement();

ResultSet rs = stmt.executeQuery("select USER, PASS from USERLIST");

Kode 

String user = rs.getString("USER");
String pass = rs.getString("PASS");

Du kan vel bare bruge det således:

SELECT user, pass FROM userlist WHERE user ="user-variablen" AND pass ="pass-variablen"

Kender ikke så meget til Java, så ved ikke hvordan variabler skrives der men sådan her burde det kunne gøres.

Kode 

java.sql.SQLException: Der er en fejl i SQL syntaksen nær 'USERNAME, PASSWORD FROM USERS WHERE USERNAME =allan AND PASSWORD' på linje 1
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2949)
	at com.mysql.jdbc.Statement.executeQuery(Statement.java:959)
	at MySQL_Login.tjekBruger(MySQL_Login.java:31)

Kode 

ResultSet rs = stmt.executeQuery("Select USERNAME, PASSWORD FROM USERS WHERE "+"USERNAME='"+USERNAME+"'");