Iai pessual, tudo certo?
To com o seguinte problema, tenho q fazer um trabalho pra faculdade usando access(pois é, tenho q usar esse lixo de banco, senão o profº ñ aceitará).
Tenho o seguinte método para verificar o login:
[code] public synchronized boolean lista(String login, String senha){
Statement stm = null;
ResultSet rs = null;
try{
stm = con.createStatement();
String sql = “SELECT login.log_user as user, login.log_pass as pass FROM login”;
rs = stm.executeQuery(sql);
while(rs.next()){
if(login.length() == rs.getString("user").length()){
if(senha.length() == rs.getString("pass").length()){
if(login.equals(rs.getString("user"))){
if(senha.equals(rs.getString("pass"))){
return true;
}
}
}
}
}
}catch(SQLException ex){
FileOutputStream fos = null;
try {
fos = new FileOutputStream("e:\\Zoo_Project\\dataBase\\dataBaseLog.txt");
} catch (FileNotFoundException ext) {
ext.printStackTrace();
}
PrintStream ps = new PrintStream( fos );
DriverManager.setLogStream( ps );
ex.printStackTrace();
}finally{
try{
rs.close();
stm.close();
con.close();
}catch(SQLException ex){
ex.printStackTrace();
}
}
return false;
}[/code]
ja fiz ele várias vezes em projetos, usando mySql e ele funcionou perfeitamente, mas no access ñ dá.
a JVM da o erro:
java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7138)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3907)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5698)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:354)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:411)
at classes.dataBase.DataBaseLogin.lista(DataBaseLogin.java:59)
at graphicalinterfaces.mainFrames.FrameLogin.validaPassword(FrameLogin.java:32)
at graphicalinterfaces.mainFrames.FrameLogin.jButtonEntrarActionPerformed(FrameLogin.java:153)
at graphicalinterfaces.mainFrames.FrameLogin.access$000(FrameLogin.java:12)
at graphicalinterfaces.mainFrames.FrameLogin$1.actionPerformed(FrameLogin.java:70)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
por favor alguem ai sabe oq é??
flw