The database used in this example is SQL Server book
Java source file:
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;
Instantiating, loading the JDBC driver
Public Jdbcbean ()
{
Try
{
Class.forName (Dbdriver);
}
catch (ClassNotFoundException e) {}
}
Returns the data set after the query
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;
}
Close Database
public void Closedb ()
{
try{
Rs.close ();
Con.close ();
}
catch (SQLException e) {}
}
}
Test files:
<%@ page language= "java" contenttype= "text/html;charset=gb2312"%>
<%@ page import= "java.sql.*"%>
<title>test bean</title>
<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>
///////