
program of jdbc using ms access for creating table

import java.lang.*;
public class Hello {
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:mydsn");
Statement stmt=con.createStatement();
String s="Select userid from user";
ResultSet rs=stmt.executeQuery(s);
while(rs.next())
{
String st=rs.getString("userid");
System.out.println(st);
}
con.close();
}
catch(Exception ex){
System.out.println("there is an exception"+ex);
}
}// end main
}// end class