0

Hi all..

I am having a table named "login" in MS access..
I am connecting it to a java application with th help of the following code..

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Driver loaded");
// Establish a connection
connection = DriverManager.getConnection("jdbc:odbc:ESMDB");
System.out.println ("Database connected");
String result="";
st = connection.createStatement();
rs = st.executeQuery("SELECT * FROM Login");


while(rs.next())
{


String user= rs.getString(1);
String pw=rs.getString(2);
System.out.println(username+password);

I am getting null value when i try to execute select * from Login..
what could be the reason..?Someone help in this regard as early as possible.

Regards,
Balagurunathan S

Edited by happygeek: fixed formatting

2
Contributors
1
Reply
2
Views
10 Years
Discussion Span
Last Post by jwenting
0

what "null value"?
It's highly unlikely the ResultSet will be null, though with that bad driver you're using it could maybe happen (as it was never intended to be more than a technology demonstrator, and possibly poorly written).
The database could contain NULL values for you to retrieve, if so you will indeed get them back.
It's your responsibility to handle those in some way appropriate to the data you're retrieving (maybe you get NULL for a password if it's not been set for example).

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.