Change your first statement to this pstat=con.prepareStatement(“select typeid from users where username=? and password=?”, ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); This way you can move forward and backward, so less things to worry about
For Java 7 you can simply omit the Class.forName() statement as it is not really required. For Java 8 you cannot use the JDBC-ODBC Bridge because it has been removed. You will need to use something like UCanAccess instead. For more information, see Manipulating an Access database from Java without ODBC
We can still use JDBC-ODBC Bridge in java 8 too, just follow this simple recipe: Download a JDK 7 or JRE 7. Goto JRE\lib folder and find the rt.jar Unzip it (if you have WinRAR or 7zip installed) or you can rename it to rt.zip and unzip it. Copy sun\jdbc and sun\security\action folders out, keep … Read more