在servlet设置javabean(最近学习j2ee遇到这个问题,在百度上找到的很好的回答)

 首先你那个要打包到一个文件夹里面
然后在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)
{
}
}
}

}
你看了之后就晓得了!
 
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值