jsp与access的数据库连接
jsp怎样与access的数据库连接啊 |
<% String path=request.getRequestURI(); int end1=path.lastIndexOf('/'); path=path.substring(0,end1+1); String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; String sConnStr = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+request.getRealPath(path+"jx0713.mdb"); //String sConnStr = "jdbc:odbc:stu"; Connection conn = null; ResultSet rs = null; try { Class.forName(sDBDriver); }catch(java.lang.ClassNotFoundException e) { System.err.println("faq(): " + e.getMessage()); } conn = DriverManager.getConnection(sConnStr,"",""); Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql="select * from 完成情况表 order by 名称,月份"; rs=stmt.executeQuery(sql); %> |
JSP访问MS-SOL Server
1、JSP访问Access
(1)载入驱动程序类别:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
(2)建立数据库连接,注:jspdata为用户自定义的ODBC数据源名称
Connection con = DriverManager.getConnection("jdbc:odbc:jspdata");
(3)建立Statenment对象
Statenment stmt = con.createStatenment(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_ONLY);
(4)建立ResultSet(结果集)对象,并执行SQL语句
ResultSet rs = stmt.executeQuery("select * from 表名");
2、JSP访问MS-SOL Server
String url = "jdbc:odbc:jsql"; 注:jspl为用户自定义的ODBC数据源名称
(1)载入驱动程序类别:
Class.f