bookservlet.java

因为是初学所以做得不是很完善 希望大家见谅

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import service.bookservice;


public class bookservlet extends HttpServlet {
	bookservice service=new bookservice();

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("UTF-8");
		 String action=request.getParameter("action");
		 
		
		 if(action.equals("list"))
		 { ResultSet rs=service.list();
	    
		    request.setAttribute("resultSet", rs);
	       request.getRequestDispatcher("/list.jsp").forward(request, response);			 
		 }
		 if(action.equals("list1"))
		 { ResultSet rs=service.list();
	    
		    request.setAttribute("resultSet", rs);
	       request.getRequestDispatcher("/list1.jsp").forward(request, response);			 
		 }
		
		 
		 else if(action.equals("edit"))
		 {
			// System.out.println("你好");
			 
			 String bid=request.getParameter("bid");
			 String bname=request.getParameter("bname");
			 String bauthor=request.getParameter("bauthor");
			 String bpublish=request.getParameter("bpublish");
			 String bprice=request.getParameter("bprice");
			 
			 
			 int id=Integer.parseInt(request.getParameter("id"));
			 service.Update(bid, bname, bauthor, bpublish, bprice,id);
			//System.out.println("你好");
			 request.getRequestDispatcher("/servlet/bookservlet?action=list").forward(request, response);
			 
		 }
		 
		 else if(action.equals("del"))
		 {
			 int id=Integer.parseInt(request.getParameter("id"));
			 
			 service.Del(id);
			 request.getRequestDispatcher("/servlet/bookservlet?action=list").forward(request, response);
		 }
		 
		 
		 else if(action.equals("add"))
		 {
			 
			 
		 //System.out.println("你好");
			 
			 String bid=request.getParameter("bid");
			String bname=request.getParameter("bname");
			String bauthor=request.getParameter("bauthor");
			String bpublish=request.getParameter("bpublish");
			String bprice=request.getParameter("bprice");
			 
			 
			//System.out.print(bid+bname+bauthor+bpublish+bprice);
			 
			 
			 service.AddBook(bid, bname, bauthor, bpublish, bprice);
			 request.getRequestDispatcher("/servlet/bookservlet?action=list").forward(request, response);
			 
		 }
		
		}
	
	
	

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request,response);
		
	}

	

}