queryservlet.java

图书管理

package library;

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

import java.sql.SQLException;

import javax.servlet.*;
import javax.servlet.http.*;

import javax.sql.rowset.CachedRowSet;

public class QueryServlet extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GBK";
    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 Binfo = request.getParameter("Binfo");
        System.out.println(Binfo);
        String text1 = request.getParameter("text1");
        System.out.println(text1);
        String Ainfo = request.getParameter("Ainfo");
        System.out.println(Ainfo);
        String text2 = " ";
        text2 = request.getParameter("text2");
        System.out.println("text2"+text2);
     //   String con = Binfo +" = " +text1 + " and "+ Ainfo+" = "+ text2 ;
        if((!"".equals(text1))&&("".equals(text2))){
            String con = Binfo + " = '" +text1 +"'";
            System.out.println("aaaaaaaaaaaaaaaaaa");
            request.setAttribute("rs",bookModel.Query(con));
        }else if(("".equals(text1))&&(!"".equals(text2))){
            String con = Ainfo +" = '" + text2 +"'";
            System.out.println("bbbbbbbbbbb");
            request.setAttribute("rs",bookModel.Query(con));
        }else if((!"".equals(text1))&&(!"".equals(text2))){
            System.out.println("bcccccccccccc");
            String con = Binfo + " = '" + text1 + "' and " +"authorInfo."+ Ainfo + " = " + "'"+text2+"'";
            System.out.println(con);
            request.setAttribute("rs",bookModel.Query(con));
            javax.sql.rowset.CachedRowSet rs = bookModel.Query(con);

            try {
                System.out.println(rs.next());
            } catch (SQLException e) {
                System.out.println("ddddd"+e);
            }
        }
        else{
            System.out.println("bookModel.query()");
            request.setAttribute("rs",bookModel.Query());
        }
        
        getServletContext().getRequestDispatcher("/Login_success.jsp").forward(request,response);
    }
    public void doGet(HttpServletRequest request, 
                       HttpServletResponse response) throws ServletException, IOException {
                       doPost(request,response);
     }
}