JSP连接ACCESS数据库

little_cat

1、相对路径连接

try
    {
        String spath = "db/ApplycationDataSets.mdb";
        String dbpath = application.getRealPath(spath);
        String dbname = "";
        String user = "";
        String url ="jdbc:odbc:Driver={Microsoft Access Driver  (*.mdb)};DBQ="+dbpath;
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection conn= DriverManager.getConnection(url);
        Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        String sql = "select * from student";
        stmt.executeUpdate(sql);
        stmt.close();
        conn.close();
    }catch(Exception e){
        out.print(e.getMessage);
    }

2、绝对路径连接

try
    {
        String dbname = "";
        String user = "";
        String url ="jdbc:odbc:Driver={Microsoft Access Driver  (*.mdb)};DBQ=D://db/ApplycationDataSets.mdb";
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection conn= DriverManager.getConnection(url);
        Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        String sql = "select * from student";
        stmt.executeUpdate(sql);
        stmt.close();
        conn.close();
    }catch(Exception e){
        out.print(e.getMessage);
    }


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/19013/showart_366130.html