import java.util.*;
import java.sql.*;
public class login {
public static void main(String[]args) throws SQLException{
Scanner scan = new Scanner (System.in);
Connection conn;
Statement stmt = null;
ResultSet rs = null;
String un= null;
String pw = null;
char ans = 0;
try{
String database = "jdbc
dbc
river={Microsoft Access Driver (*.mdb)};DBQ=database.mdb;";
conn=DriverManager.getConnection(database,"","");
stmt=conn.createStatement();
do{
System.out.println("Enter username");
un=scan.next();
System.out.println("Enter password");
pw=scan.next();
rs = stmt.executeQuery( "SELECT password FROM tbluser WHERE username ='"+un+"'");
while (rs.next()) {
un = rs.getString("username");
pw = rs.getString("password");
System.out.println("username = " + un);
System.out.println("password = " + pw);
}System.out.println("connected");
}while(ans=='Y' || (ans=='y'));
} catch(Exception exc){
exc.printStackTrace();
}
}
}
boss bali gumawa ulet ako ng bago mejo magulo kase ung una
eto po ung error.
Enter username
admin
Enter password
admin
java.sql.SQLException: Column not found
at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
at login.main(login.java:30)