本例中使用的数据库是SQL Server 2000
Java 源文件:
package jdbc;
import java.sql.*;
public class JDBCBean
{
String dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dwjj";
String username="sa";
String password="";
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
//实例化,装载JDBC驱动程序
public JDBCBean()
{
try
{
Class.forName(dbDriver);
}
catch(ClassNotFoundException e){}
}
//返回查询后的数据集
public ResultSet executeQuery(String sql)
{
try
{
con=DriverManager.getConnection(url,username,password);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
}
catch(SQLException e){}
return rs;
}
//关闭数据库
public void closeDB()
{
try{
rs.close();
con.close();
}
catch(SQLException e) {}
}
}
测试文件:
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>Test Bean</title>
</head>
<body>
<jsp:useBean id="jdbc" class="jdbc.JDBCBean" scope="page" />
<%
String sql="select * from Member_Base order by mb_regtime desc";
ResultSet rs=jdbc.executeQuery(sql);
while(rs.next())
{
out.println(rs.getString("MB_pwd")+"<br/>");
}
%>
</body>
</html>
///////