Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- How to connect java to Ms Access 2010?
- public void loadDb(){
- try{
- Class.forName("sun.jdbc.JdbcOdbcDriver");
- File f = new File(System.getProperty("user.dir"))
- con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Acess Driver (*.mdb, *.accdb)}; DBQ="+ f.getPath() + "//db//JavaAccess.accd","","");
- st = con. createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
- }catch(ClassNotFoundException e){e.printStackTrace();
- }catch(SQLException e){e.printStackTrace();}
- }
- //con and st are already defined
- public static Connection getConnection() {
- String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
- String url = "jdbc:odbc:anime"; //anime is the database
- String username = "ipieluser"; //leave blank if none
- String password = "ipielpassword"; //leave blank if none
- try {
- Class.forName(driver);
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- }
- try {
- return DriverManager.getConnection(url, username, password);
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- return null;
- }
- public static void main(String args[]) {
- try {
- Connection conn = getConnection();
- Statement st = conn.createStatement();
- st = conn.createStatement();
- ResultSet rs = st.executeQuery("SELECT * FROM localTable");
- //get and displays the number of columns
- ResultSetMetaData rsMetaData = rs.getMetaData();
- int numberOfColumns = rsMetaData.getColumnCount();
- System.out.println("resultSet MetaData column Count=" + numberOfColumns);
- st.close();
- conn.close();
- } catch(Exception e) {
- System.out.println(e.getMessage());
- }
- }
- con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Acess Driver (*.mdb, *.accdb)}; DBQ="+ f.getPath() + "//db//JavaAccess.accd","","");
- con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ="+ f.getPath() + "//db//JavaAccess.accd","","");
Add Comment
Please, Sign In to add comment