searchbook.java

基于jsp的图书管理系统的功能和实现

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import data.LoginData;
public class SearchAction extends HttpServlet{
	private static final String CONTENT_TYPE="text/html;charset=GBK";
	public void doPost(HttpServletRequest request,HttpServletResponse response)
	throws ServletException,IOException{
		String strSql="";
		String id="";
		String selectKid =request.getParameter("select");
		String infoKid = request.getParameter("textfield");
		LoginData loginData = new LoginData();
		Connection conn = loginData.getConn();
		ResultSet rs=null;
		try{
		   Statement stmt = conn.createStatement();
		   if(selectKid.equals("1")){
			  strSql="select * from Book where  Bname='"+textfield+"'";
			}
			else if(selectKid.equals("2")){
				strSql="select * from Book where Bnumber='"+textfield+"'";
			}
			else if(selectKid.equals("3")){
				strSql="select * from Book where Bpincipal='"+textfield+"'";
			}
			else if(selectKid.equals("4")){
				 	strSql="select * from Book where Bconcern='"+textfield+"'";
				}
			else if(selectKid.equals("5")){
				    	strSql="select * from Book where Bpdate='"+textfield+"'";
				}
			else{
		    	 strSql="";
			}
			if(strSql.equals("")||infoKid.equals("")||infoKid==null){
			
					response.sendRedirect("error.jsp");	
				}
			else{
			    
				response.sendRedirect("tushu/Search.jsp");
			}
		    
		   
		}catch(Exception ex){
		   	ex.printStackTrace();
		   	}
	
			 	}
		public void destroy(){
			}
	
	}