editservlet.java

基于Oracle JDeveloper 10g IDE的简单用户浏览图书信息

/* EditServlet.java */
package mvcBook;
import javax.servlet.ServletException;
import javax.servlet.ServletConfig;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import javax.sql.DataSource;
import javax.naming.*;
import javax.sql.rowset.CachedRowSet;
import com.sun.rowset.CachedRowSetImpl;
public class EditServlet extends HttpServlet {
    public void init(ServletConfig config) throws ServletException {
        super.init(config);
    }
    public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException {
        doGet(req, res);
    }
    public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException {
        try {
            req.setCharacterEncoding("GBK");
            // 生成一个新的缓冲存储集
            CachedRowSet rs = new CachedRowSetImpl();
            // 生成JNDI初始上下文环境
            InitialContext ic=new InitialContext();
            // 查找JDBC数据源的JNDI名字
            DataSource ds=(DataSource)ic.lookup("jdbc/DBConnCoreDS");
            // 获得JDBC连接
            Connection conn=ds.getConnection();
            // 设置SQL命令
            rs.setCommand("select * from book where isbn = ?");
            // 设置选定图书号作为SQL输入参数
            rs.setString(1, req.getParameter("id"));
            // 填充行集并把它作为一个请求属性
            rs.execute(conn);            
            req.setAttribute("rs",rs);
            // 把请求转发到Edit.jsp页面
            getServletContext().getRequestDispatcher("/Edit.jsp").forward(req, res);
        }
        catch(Exception ex) {
            throw new ServletException(ex);
        }
    }
}