用JavaBean连接Access数据库

最新推荐文章于 2017-11-22 16:59:53 发布

wobuzhidaoni

最新推荐文章于 2017-11-22 16:59:53 发布

阅读量961

点赞数

文章标签： access 数据库 exception string database sql

本文链接：https://blog.csdn.net/wobuzhidaoni/article/details/6464451

版权

连接ACCESS

ConAccess.jsp

<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="gb2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id ="db" class="bean.DataBase" scope = "page"></jsp:useBean>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd ">

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>数据库连接JavaBean使用示例</title>
</head>
<body>
<h2 align="center" style="color:red"><strong>数据库连接JavaBean使用示例</strong></h3>
<hr>
<%
String sql = "select * from student";
ResultSet rs = db.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
%>
<table border="1" align="center">
<%
out.println("<tr>");
for(int i=1;i<=rsmd.getColumnCount(); i++)
{
  out.println("<th>"+rsmd.getColumnName(i) +"</th>");
}
while(rs.next())
{
  out.print("<tr>");
out.println("<td>"+rs.getString(1)+"</td>");
     out.println("<td>"+rs.getString(2)+"</td>");
     out.println("<td>"+rs.getString(3)+"</td>");
     out.println("<td>"+rs.getString(4)+"</td>");
     out.println("<td>"+rs.getString(5)+"</td>");
     out.println("<td>"+rs.getString(6)+"</td>");
     out.println("<td>"+rs.getString(7)+"</td>");
     out.println("<td>"+rs.getString(8)+"</td>");
     out.println("</tr>");
}
db.close();

%>
</table>
</body>
</html>

/**
*

DataBase.java

package bean;

/**
* @author *
*/
import java.sql.*;

public class DataBase
{
Connection conn = null;
Statement stm = null;
ResultSet rs = null;
public DataBase(){ }

public Connection getCon() throws ClassNotFoundException, SQLException
{
  try
  {
  // 加载数据库驱动类
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   String url = "jdbc:odbc:stu";
   String user = "";
   String password = "";
  // 根据数据库参数取得一个数据库连接
   conn = DriverManager.getConnection(url,user,password);
  }catch(Exception sqle)
  {
   sqle.printStackTrace();
  }
  return conn;
}

public ResultSet executeQuery(String sql) throws ClassNotFoundException
{
  try
  {
   conn = getCon();
   stm = conn.createStatement();
   rs = stm.executeQuery(sql);

  }catch(SQLException sqle)
  {
   sqle.printStackTrace();
  }
  return rs;
}

public void close()
{
  try
  {
   if(rs!=null) rs.close();
   if(stm!=null) rs.close();
   if(conn!=null) rs.close();

  }catch(Exception ex)
  {
   ex.printStackTrace();
  }
}
}