[ Arbitar2 @ 11.01.2007. 00:01 ] @
Oci mi ispadose gledajuci u kod , pokusavajuci da pronadjem gresku,ali mi ne ide. 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; } |