listbook.java

JAVA的MVC三层开发的图书馆管理系统。

package mypackage;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.PrintWriter;
import java.io.IOException;
import java.util.Vector;
import java.sql.*;
import javax.sql.DataSource;

public class ListBook extends HttpServlet 
{
  private static final String CONTENT_TYPE = "text/html; charset=GBK";

  public void init(ServletConfig config) throws ServletException
  {
    super.init(config);
  }

  public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  {
    DataSource ds = (DataSource)request.getSession().getServletContext().getAttribute("DataSrc");
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
    String sql = "select * from book";
    Vector result = new Vector();
    Book book;
    
    try{
      conn = ds.getConnection();
      stmt = conn.createStatement();
      rs = stmt.executeQuery(sql);
      
      while(rs.next()){
        book = new Book();
        book.bookID = rs.getString("bookid");
        book.bookName = rs.getString("bookname");
        book.author = rs.getString("author");
        book.pubcom = rs.getString("pubcom");
        book.adddate = rs.getDate("adddate");
        book.notes = rs.getString("notes");
        result.add(book);
      }
      rs.close();
      stmt.close();
      conn.close();
    }
    catch(Exception e){
      System.out.println(e.getMessage());
    }
    request.setAttribute("result",result);
    request.getSession().getServletContext().getRequestDispatcher("DisplayBookList.jsp").forward(request, response);
  }
}