Java with MS Access Database User login

[pateldpk]

Friends need help...

I'm trying to Connect with MS Access database.. and the connection succesfully established .. but when i'm trying to check whether username and password is matching or not with databse login table ..its not working..
might be there is a Problem with try block inside check method... check image also..
Database Name=loginuser1
Table Name=login

I have also configured the ODBC data source ....

Below is the code...


import java.sql.*;
public class check{
Connection con;
Statement st;
ResultSet rs;

public check(){
connect();
}
public void connect(){

try{
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver);
String db="jdbc:odbc:loginuser1";
con=DriverManager.getConnection(db);
st=con.createStatement();
System.out.println("Connection established");
}
catch(Exception ex){
System.out.println("Connection problem"+ex);
}
}
public static void main(String[] args){
String userName="Deepak";
int password=123;
check ck=new check();
ck.check(userName,password);
}
public void check(String userName,int password){
try{
String sql="select user,pass from login where user='"+userName+"'pass='"+password+"'";
rs=st.executeQuery(sql);
System.out.println(rs);
int count=0;
while(rs.next()){
count=count+1;
}
if(count==1){
System.out.println("SQL done");
}else{
System.out.println("again error");
}
}catch(Exception ex){System.out.println("Problem with query...");}-------->(showing this user-defined error)
}
}

problem with try block...

[pateldpk]

When i execute .class file ....

[Tolls]

1. Please use [code] tags [/code] when posting code so it retains formatting and is readable.
2. When catching exceptions it's advisable to do <exception>.printStackTrace() to get as much information about the exception as possible.
3. Finally, I'd recommend using a PreparedStatement and binding (eg setString()) the variables in. Concatenating your parameters into your SQL like that invariably leads to bugs.