JSP连接Access的代码,该如何处理
日期：2014-05-18 浏览次数：20705 次
JSP连接Access的代码
JSP连接Access的代码怎么写？
------解决方案--------------------
String url = "jdbc:odbc:DNSName ";
String user = " ";
String password = " ";
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
Connection conn = DriverManager.getConnection(url, user, password);
String sql= "select * from tablename where XXXX "
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{ .....
}
rs.close();
stmt.close();
conn.close();
在系统中控制面板－管理工具－数据源要配置access数据源。
------解决方案--------------------
String url = "jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ = c:\\test.mdb ";
------解决方案--------------------
<%@page contentType= "text/html;charset=gb2312 "%>
<%@page import= "java.sql.* "%>
<html>
<body>
<%
try{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
}
catch(ClassNotFoundException e){
out.print(e);
}
try{
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf( '\ '))+ "\ ";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ= "+strDirPath+ "jcc.mdb ";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery( "SELECT * FROM user ");
out.println( "User-list "+ " <br> ");
while(rs.next()){
out.print(rs.getString(1)+ " ");
out.print(rs.getString(2)+ " <br> ");
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception ex){
out.print(ex);
}
%>
</body>
</html>
JSP连接Access的代码怎么写？
------解决方案--------------------
String url = "jdbc:odbc:DNSName ";
String user = " ";
String password = " ";
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
Connection conn = DriverManager.getConnection(url, user, password);
String sql= "select * from tablename where XXXX "
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{ .....
}
rs.close();
stmt.close();
conn.close();
在系统中控制面板－管理工具－数据源要配置access数据源。
------解决方案--------------------
String url = "jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ = c:\\test.mdb ";
------解决方案--------------------
<%@page contentType= "text/html;charset=gb2312 "%>
<%@page import= "java.sql.* "%>
<html>
<body>
<%
try{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
}
catch(ClassNotFoundException e){
out.print(e);
}
try{
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf( '\ '))+ "\ ";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ= "+strDirPath+ "jcc.mdb ";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery( "SELECT * FROM user ");
out.println( "User-list "+ " <br> ");
while(rs.next()){
out.print(rs.getString(1)+ " ");
out.print(rs.getString(2)+ " <br> ");
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception ex){
out.print(ex);
}
%>
</body>
</html>
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
