首先你那个要打包到一个文件夹里面
然后在Servlet里面首先要引入那个JavaBean
import 包名.JavaBean
还是发个实例你去看吧
package chap10.servlet;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import chap10.db.DBUtil;
import chap10.BookBean;
public class QueryBookServlet extends HttpServlet
{
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException,IOException
{
final String SQL = "select * from BookList where isbn=?";
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
String address = "unknownBook.jsp";
//创建JavaBean对象
BookBean book = new BookBean();
try
{
//获取数据库连接
conn = DBUtil.getConnection();
stmt = conn.prepareStatement(SQL);
//指定参数
stmt.setString(1,request.getParameter("isbn"));
//执行查询
rs = stmt.executeQuery();
if(rs != null)
{
rs.next();
//改变JavaBean中的属性
book.setIsbn(rs.getString("isbn"));
book.setTitle(rs.getString("title"));
book.setAuthor(rs.getString("author"));
book.setPublisher(rs.getString("publisher"));
book.setPrice(rs.getInt("price"));
address = "displayBook.jsp";
}
}
catch(SQLException e)
{
}
//清理
DBUtil.closeResultSet(rs);
DBUtil.closeConnection(conn);
//将JavaBean放到request作用域中
request.setAttribute("bookBean",book);
//跳转到JSP页面
RequestDispatcher dis = request.getRequestDispatcher(address);
dis.forward(request,response);
}
}
package chap10;
public class BookBean {
//ISBN号
private String isbn;
//书名
private String title;
//作者
private String author;
//出版社
private String publisher;
//价格
private int price;
public BookBean() {
}
public BookBean(String isbn,String title,String author,
String publisher,int price)
{
this.isbn = isbn;
this.title = title;
this.author = author;
this.publisher = publisher;
this.price = price;
}
public String getIsbn() {
return isbn;
}
public void setIsbn(String isbn) {
this.isbn = isbn;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
public String getPublisher() {
return publisher;
}
public void setPublisher(String publisher) {
this.publisher = publisher;
}
public int getPrice() {
return price;
}
public void setPrice(int price) {
this.price = price;
}
}
package chap10.db;
//不是一个javaBean,是一个封装了数据库的常用操作,有较强的可重用性
import java.sql.*;
public class DBUtil
{
static String serverName = "localhost";
static String sDBDriver = "oracle.jdbc.driver.OracleDriver";
static String dbInstance = "xdf";
static String sConnStr = "jdbc:oracle:thin:@"+serverName+":1521:"+dbInstance;
static String dbUser = "scott";
static String userPwd = "tiger";
/**
*得到一个Connection对象
*@return java.sql.Connection
*/
public static Connection getConnection()
{
Connection conn = null;
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr, dbUser, userPwd);
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e1)
{
e1.printStackTrace();
}
return conn;
}
/**
*关闭指定的结果集
*@param rs 要关闭的结果集
*/
public static void closeResultSet(ResultSet rs)
{
if( rs != null)
{
try
{
rs.close();
}
catch(SQLException e)
{
}
}
}
/**
*关闭指定的Statement
*@param stmt 要关闭的Statement
*/
public static void closeStatement(Statement stmt)
{
if( stmt != null)
{
try
{
stmt.close();
}
catch(SQLException e)
{
}
}
}
/**
*关闭连接
*@param conn 要关闭的连接
*/
public static void closeConnection(Connection conn)
{
if( conn != null)
{
try
{
conn.close();
}
catch(SQLException e)
{
}
}
}
}
你看了之后就晓得了!
然后在Servlet里面首先要引入那个JavaBean
import 包名.JavaBean
还是发个实例你去看吧
package chap10.servlet;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import chap10.db.DBUtil;
import chap10.BookBean;
public class QueryBookServlet extends HttpServlet
{
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException,IOException
{
final String SQL = "select * from BookList where isbn=?";
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
String address = "unknownBook.jsp";
//创建JavaBean对象
BookBean book = new BookBean();
try
{
//获取数据库连接
conn = DBUtil.getConnection();
stmt = conn.prepareStatement(SQL);
//指定参数
stmt.setString(1,request.getParameter("isbn"));
//执行查询
rs = stmt.executeQuery();
if(rs != null)
{
rs.next();
//改变JavaBean中的属性
book.setIsbn(rs.getString("isbn"));
book.setTitle(rs.getString("title"));
book.setAuthor(rs.getString("author"));
book.setPublisher(rs.getString("publisher"));
book.setPrice(rs.getInt("price"));
address = "displayBook.jsp";
}
}
catch(SQLException e)
{
}
//清理
DBUtil.closeResultSet(rs);
DBUtil.closeConnection(conn);
//将JavaBean放到request作用域中
request.setAttribute("bookBean",book);
//跳转到JSP页面
RequestDispatcher dis = request.getRequestDispatcher(address);
dis.forward(request,response);
}
}
package chap10;
public class BookBean {
//ISBN号
private String isbn;
//书名
private String title;
//作者
private String author;
//出版社
private String publisher;
//价格
private int price;
public BookBean() {
}
public BookBean(String isbn,String title,String author,
String publisher,int price)
{
this.isbn = isbn;
this.title = title;
this.author = author;
this.publisher = publisher;
this.price = price;
}
public String getIsbn() {
return isbn;
}
public void setIsbn(String isbn) {
this.isbn = isbn;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
public String getPublisher() {
return publisher;
}
public void setPublisher(String publisher) {
this.publisher = publisher;
}
public int getPrice() {
return price;
}
public void setPrice(int price) {
this.price = price;
}
}
package chap10.db;
//不是一个javaBean,是一个封装了数据库的常用操作,有较强的可重用性
import java.sql.*;
public class DBUtil
{
static String serverName = "localhost";
static String sDBDriver = "oracle.jdbc.driver.OracleDriver";
static String dbInstance = "xdf";
static String sConnStr = "jdbc:oracle:thin:@"+serverName+":1521:"+dbInstance;
static String dbUser = "scott";
static String userPwd = "tiger";
/**
*得到一个Connection对象
*@return java.sql.Connection
*/
public static Connection getConnection()
{
Connection conn = null;
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr, dbUser, userPwd);
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e1)
{
e1.printStackTrace();
}
return conn;
}
/**
*关闭指定的结果集
*@param rs 要关闭的结果集
*/
public static void closeResultSet(ResultSet rs)
{
if( rs != null)
{
try
{
rs.close();
}
catch(SQLException e)
{
}
}
}
/**
*关闭指定的Statement
*@param stmt 要关闭的Statement
*/
public static void closeStatement(Statement stmt)
{
if( stmt != null)
{
try
{
stmt.close();
}
catch(SQLException e)
{
}
}
}
/**
*关闭连接
*@param conn 要关闭的连接
*/
public static void closeConnection(Connection conn)
{
if( conn != null)
{
try
{
conn.close();
}
catch(SQLException e)
{
}
}
}
}
你看了之后就晓得了!