addnewbook.java

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

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

public class AddNewBook 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
  {
    response.setContentType(CONTENT_TYPE);
    request.setCharacterEncoding("GBK");  
    String bookID = request.getParameter("bookID");
    String bookName = request.getParameter("bookName");
    String author = request.getParameter("author");
    String pubcom = request.getParameter("pubcom");
    String adddate = new FormatDate().nowDate();
    String notes = request.getParameter("notes");
    int success = 0;
    DataSource ds = null;
    Connection conn = null;
    PreparedStatement pstm = null;
    
    try{
      ds = (DataSource)request.getSession().getServletContext().getAttribute("DataSrc");
      conn = ds.getConnection();
      pstm = conn.prepareStatement("insert into book(bookid,bookname,author,pubcom,adddate,notes) values(?,?,?,?,?,?)");
      pstm.setString(1,bookID);
      pstm.setString(2,bookName);
      pstm.setString(3,author);
      pstm.setString(4,pubcom);
      pstm.setString(5,adddate);
      pstm.setString(6,notes);
      success = pstm.executeUpdate();
      pstm.close();
      conn.close();
    }
    catch(Exception e){
      System.out.println(e.getMessage());
    }
    
    if(success > 0)
      request.getSession().getServletContext().getRequestDispatcher("Seccess.jsp").forward(request, response);
    else
      request.getSession().getServletContext().getRequestDispatcher("Fail.jsp").forward(request, response);
  }
}