高校问答x战警3最后什么意思:jsp页怎么和ACCESS数据库连接?代码是什么样的呢? 麻烦知道的说下,谢谢`
来源：百度文库 编辑：高校问答 时间：2024/05/05 08:25:22
给你个servlet的例子吧,可以直接运行的.
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class ConnectAccess extends HttpServlet {
Connection conn = null;
Statement stmt = null;
public void init() throws ServletException {
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\books.mdb";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(strurl);
stmt=conn.createStatement();
} catch (Exception e) {
System.out.println(e.getMessage());
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;");
PrintWriter out = response.getWriter();
try {
ResultSet rs=stmt.executeQuery("select * from books");
out.println("<html><body>");
out.println("<p>Database connection successfully created!</p>");
while (rs.next()) {
out.println("<p>The book's name is: " + rs.getString("book") +"</p>");
}
out.println("</body></html>");
} catch (Exception e) {
System.out.println(e.getMessage());
}
}
public void destroy() {
try {
conn.close();
} catch(SQLException e){}
}
}
package conn;
import java.sql.*;
public class DbOperate{
Connection conn=null;//初始化变量
ResultSet rs=null;
Statement stmt=null;
String path="";
String sql="";
public void InitOpenDb(String path,String sql){
this.path=path;
this.sql=sql;
}
public Connection InitConn(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载JdbcOdbc驱动，
}
catch(ClassNotFoundException e){
System.err.println(e.getMessage());
}
try{
conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+path,"","");//取得一个Connection对象conn
}
catch(Exception co){
System.err.println(co.getMessage());
}
return conn;
}
public ResultSet QueryDb(){
try{
stmt=InitConn().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
}
catch(SQLException f){
System.err.println(f.getMessage());
}
return rs;//返回结果集rs
}
public boolean UpdateDb(){
try{
stmt=InitConn().createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException qq){
System.err.println(qq.getMessage());
}
return true;
}
public boolean CloseDb(){//关闭连接
try{
if(rs!=null){
rs.close();
}
if(stmt!=null){
stmt.close();
}
if(conn!=null){
conn.close();
}
}
catch(Exception cl){
System.err.println(cl.getMessage());
}
return true;
}
}