风沙电脑技术网

DBConnection.java

package ConnectionDB;

import java.sql.*;
public class DBConnection
{
private String driver;
private StringBuffer accessURL;
private String accessFileName;
private String accessFilePath;
private Connection conn;
public DBConnection()
{
driver="sun.jdbc.odbc.JdbcOdbcDriver";
accessURL=new StringBuffer("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=");
accessFilePath="";
accessFileName="";
conn=null;
}
public Connection getConnectionToAccess(String s)throws SQLException,ClassNotFoundException{
accessURL.append(s);
Class.forName(driver);
conn=DriverManager.getConnection(accessURL.toString());
return conn;
}
public void close()
{
try{
conn.close();
   }
catch(SQLException sqlexception)
{
sqlexception.printStackTrace();
}
}
}

 

 

test.jsp

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<jsp:useBean id="DBConnection" scope="page" class="ConnectionDB.DBConnection"/>
<%
  Connection conn=DBConnection.getConnectionToAccess(application.getRealPath("data/guestbook.mdb"));
  Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
%>

<%
  String sql="select * from Guestbook order by id DESC";
  ResultSet Rs=stmt.executeQuery(sql);
  while(Rs.next()) {%>  
  您的第一个字段内容为：<%=Rs.getString(1)%>  
  您的第二个字段内容为：<%=Rs.getString(2)%>  
  <%}%>  
  <%out.print("数据库操作成功，恭喜你");%>  
  <%Rs.close();  
  stmt.close();  
  conn.close();  
  %>