insertservlet.java

图书管理

package library;

import java.io.IOException;
import java.io.PrintWriter;

import java.sql.SQLException;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

import javax.sql.rowset.CachedRowSet;

public class InsertServlet extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GBK";
    BookInfo bookInfo;
    AuthorInfo authorInfo;
    BookModel bookModel;
    public void init(ServletConfig config) throws ServletException {
        super.init(config);
        bookModel = new BookModel();
    }

    public void doPost(HttpServletRequest request, 
                       HttpServletResponse response) throws ServletException, IOException {response.setContentType(CONTENT_TYPE);
        request.setCharacterEncoding("gb2312");
        String bookNum = request.getParameter("bookNum");
        String bookName = request.getParameter("bookName");
        String authorNum = request.getParameter("authorNum");
        String press = request.getParameter("press");
        String authorName = request.getParameter("authorName");
        String address = request.getParameter("address");
        String email = request.getParameter("email");
        String tel = request.getParameter("tel");
        bookInfo = new BookInfo(bookNum,bookName,authorNum,press);
        authorInfo = new AuthorInfo(authorNum,authorName,address,email,tel);
        javax.sql.rowset.CachedRowSet crs = bookModel.Query();
        if(crs!=null){
            try {
                while(crs.next()){
                if(bookNum.equals(crs.getString(1))){
                    System.out.println(crs.getString(1));
                    getServletContext().getRequestDispatcher("/error.jsp").forward(request,response); 
                }
                
            }
               bookModel.IsInsertBook(bookInfo,authorInfo);
               request.setAttribute("rs",bookModel.Query());
               getServletContext().getRequestDispatcher("/Login_success.jsp").forward(request,response);
            } catch (SQLException e) {
                System.out.println("insertServlet:"+e);
            }
        }
      }
    public void doGet(HttpServletRequest request, 
                       HttpServletResponse response) throws ServletException, IOException{
            doPost(request,response); 
     }
}