Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- public class UserLogin2
- {
- public static void main(String args[])
- {
- try
- {
- //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- //String url = "jdbc:odbc:Driver={MicrosoftAccessDriver(*.mdb,*.accdb)};DBQ=+"C:\Users\RONITA DEBNATH\Documents\Student.accdb";
- Connection conn;
- conn = DriverManager.getConnection("jdbc:ucanaccess://C:\\Users\\Chandni\\Documents\\Student.accdb");
- System.out.println("Connection Successfull");
- Statement stmt;
- stmt = conn.createStatement();
- ResultSet rs=stmt.executeQuery("select * from Stu");
- if(rs!=null)
- {
- while(rs.next())
- {
- System.out.println("ID:"+rs.getString(1)+"Name:"+rs.getString(2));
- }
- }
- stmt.close();
- conn.close();
- }
- catch(Exception e)
- {
- System.err.println("got an exception");
- System.err.println(e.getMessage());
- }
- }
- }
Add Comment
Please, Sign In to add comment