Potrebno je da pomocu username-a i password-a pronadje odgovarajuci row i podatke upise u varijable objekta.evo i koda:
Code:
public boolean logIn() {
boolean flag=true;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:news","","");
PreparedStatement pst=con.prepareStatement("SELECT IDuser,role FROM user WHERE username=? and password=?");
pst.setString(1,username);
pst.setString(2,password);
ResultSet rs=pst.executeQuery();
System.out.println("rs je:"+rs.next()); //Ovo je sigurno true
System.out.println(rs.getString(2));
if(rs.next()) { //Ovo mi preskace i flag prijavljuje kao false??
IDuser=rs.getInt(1);
role=rs.getString(2);
System.out.println(role); //nista nije upisano
}else {
IDuser=-1;
flag=false;
}
rs.close();
pst.close();
}catch (Exception e) {
System.err.println(" greska ");
e.printStackTrace();
flag=false;
}
System.out.println("flag je:"+flag);
return flag;
}
public boolean logIn() {
boolean flag=true;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:news","","");
PreparedStatement pst=con.prepareStatement("SELECT IDuser,role FROM user WHERE username=? and password=?");
pst.setString(1,username);
pst.setString(2,password);
ResultSet rs=pst.executeQuery();
System.out.println("rs je:"+rs.next()); //Ovo je sigurno true
System.out.println(rs.getString(2));
if(rs.next()) { //Ovo mi preskace i flag prijavljuje kao false??
IDuser=rs.getInt(1);
role=rs.getString(2);
System.out.println(role); //nista nije upisano
}else {
IDuser=-1;
flag=false;
}
rs.close();
pst.close();
}catch (Exception e) {
System.err.println(" greska ");
e.printStackTrace();
flag=false;
}
System.out.println("flag je:"+flag);
return flag;
}