Source Author: follow-up
1. Create a Bean
Package guestbook;
Import java. SQL .*;
/**
* Title: connect to the database with Javabean
* Description: encapsulate common database functions with Bean and declare the Bean in JSP.
* Copyright: Copyright (c) 2001
* Company: Speed Network Team
* Editor: Speed Network Group
* Version 1.0
*/
Public class SQL _data
{
String sDBDriver = "sun. jdbc. odbc. JdbcOdbcDriver ";
String sConnStr = "jdbc: odbc: guestbook ";
Connection conn = null;
ResultSet rs = null;
Public SQL _data ()
{
Try {
Class. forName (sDBDriver );
}
Catch (java. lang. ClassNotFoundException e)
{
System. err. println ("SQL _data ():" + e. getMessage ());
}
}
Public void executeInsert (String SQL)
{
Try
{
Conn = DriverManager. getConnection (sConnStr );
Statement stmt = conn. createStatement ();
Stmt.exe cuteUpdate (SQL );
}
Catch (SQLException ex)
{
System. err. println ("SQL _data.executeUpdate:" + ex. getMessage ());
}
}
Public ResultSet executeQuery (String SQL)
{
Rs = null;
Try
{
Conn = DriverManager. getConnection (sConnStr );
Statement stmt = conn. createStatement ();
Rs1_stmt.exe cuteQuery (SQL );
}
Catch (SQLException ex)
{
System. err. println ("SQL _data.executeQuery:" + ex. getMessage ());
}
}
Public void executeDelete (String SQL)
{
Try
{
Conn = DriverManager. getConnection (sConnStr );
Statement stmt = conn. createStatement ();
Stmt.exe cuteUpdate (SQL );
}
Catch (SQLException ex)
{
System. err. println ("SQL _data.executeDelete:" + ex. getMessage ());
}
}
}
2. Declare Bean in JSP:
......
<Jsp: useBean id = "sqlbean" scope = "session" class = "guestbook. SQL _data"/>
<%! String SQL, name; %>
<%
SQL = "select * from table ";
ResultSet rsw.sqlbean.exe cuteQuery (SQL );
While (rs. nex ()){
Name = rs. getString ("name ")
}
%>
......
Name: <% = name %>
......
<%
Rs. close ();
%>
......