insertnewbook.java

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

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*; 
import java.sql.*;
import data.LoginData;
public class InsertNewBook extends HttpServlet{
	private static final String CONTENT_TYPE="text/html;charset=GBK";
	public void doPost(HttpServletRequest request,HttpServletResponse response)
	throws ServletException,IOException{
		String strSql=null;
		String strSql1=null;
		String stautes=null;
		ResultSet rs=null;
		Statement stmt=null;
		int result=0;
		int result1=0;
		request.setCharacterEncoding("GBK");
    	String Bnumber =(String) request.getParameter("Bnumber");
		String Bname = request.getParameter("Bname");
		String Bpincipal = request.getParameter("Bpincipal");
		String Bconcern= request.getParameter("Bconcern");
		String Bpdate = request.getParameter("Bpdate");
       	String Bsort = request.getParameter("Bsort");
        HttpSession session =request.getSession(false);
         if(session==null)
        {
         response.sendRedirect("tushu/error.jsp");
         return;
        }
        session.setAttribute("Bnum",Bnumber);
        session.setAttribute("Bnam",Bname );
		LoginData loginData = new LoginData();
		Connection conn = loginData.getConn();
        try{
             stmt = conn.createStatement();
             strSql="insert into Book(Bnumber,Bname,Bpincipal,Bconcern,Bpdate,Bsort) values('"+Bnumber+"','"+Bname+"','"+Bpincipal+"','"+Bconcern+"','"+Bpdate+"','"+Bsort+"')";
   			 strSql1="insert into Bnominate(Bnname,Bnreader,Bnconcern,Bnpdate) values('"+Bname+"','"+Bpincipal+"','"+Bconcern+"','"+Bpdate+"')";
   			 result1=stmt.executeUpdate(strSql1);
   			 result=stmt.executeUpdate(strSql);
		     if(result>0&&result1>0){
			   	  	      stautes ="插入成功!";
			   	  	      session.setAttribute("Modify",stautes);
			   		   	  response.sendRedirect("tushu/InsertNewBook_Sucess.jsp");
			   		     }
			   		else 
			   		  {        stautes ="插入失败,系统问题,请下次插入!";
			   		  	       session.setAttribute("Modify",stautes);
			   		    	  response.sendRedirect("tushu/InsertNewBook_Sucess.jsp");	
			   		  }
			   
		   }catch(Exception ex){
		   	ex.printStackTrace();
		   	}
		
		}
		public void destroy(){
			}
	
	}