import java.sql.*; /********************************************************************************* Program to demonstrate connection to MS Access database using JDBC driver Type - I Developed by : Malhar Vora Developed on : 6-1-2011 Development Status : Completed Email : vbmade2000@gmail.com WebSite : http://malhar2010.blogspot.com **********************************************************************************/ public class dbcon { public static void main(String[] args) { Connection conn=null; Statement st=null; ResultSet rs=null; try { Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); } catch (Exception E) { System.err.println ("Unable to load driver."); E.printStackTrace (); } try { String db = "jdbc:odbc:db1"; conn = DriverManager.getConnection (db, "",""); st = conn.createStatement(); rs = st.executeQuery("Select * from emp"); while(rs.next()) { System.out.println(rs.getString(1)); } System.out.println ("*** Connected to the database ***"); } catch (SQLException E) { System.out.println ("SQLException: " + E.getMessage()); System.out.println ("SQLState: " + E.getSQLState()); System.out.println ("VendorError: " + E.getErrorCode()); } try { st.close(); if(conn!=null) { conn.close (); } } catch (SQLException E) { System.err.println ("Unable to load driver."); E.printStackTrace (); } } }
Saturday, February 5, 2011
Connect MS Access database using Type - I JDBC driver
Labels:
Java
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.