本例中使用的資料庫是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>
///////
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
