listservlet.java

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

/* ListServlet.java */
package mvcBook;
import com.sun.rowset.CachedRowSetImpl;
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;
public class ListServlet 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");
            // 运行SQL命令
            rs.execute(conn);
            // 把行集作为一个请求属性进行存储
            req.setAttribute("rs",rs);
            // 把请求转发到List.jsp页面
            getServletContext().getRequestDispatcher("/List.jsp").forward(req,res);
        }
        catch(Exception ex) {
            throw new ServletException(ex);
        }  
    }
}