这是java wed(对数据库实现增删改查)项目的servlet(表现层)代码

package com.baisi.work.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.baisi.work.entity.Workclas;
import com.baisi.work.entity.Workser;
import com.baisi.work.service.Workclasvice;
import com.baisi.work.service.WorkclasviceImp;
import com.baisi.work.service.Workvice;
import com.baisi.work.service.WorkviceImp;
import com.baisi.work.utilclass.BaseDao;
import com.baisi.work.utilclass.BaseServlet;
import com.baisi.work.utilclass.PageBean;



@WebServlet("/allset/*")
public class allset extends BaseServlet {
	
	public void addt2(HttpServletRequest request, HttpServletResponse response) 
			throws ServletException, IOException {
			request.setCharacterEncoding("UTF-8");
			response.setCharacterEncoding("UTF-8");
			//逻辑层对象
			WorkviceImp wor= new WorkviceImp();
			//实体类对象
			Workser ser = new Workser();
			//获取用户输入的数据
			String id  = request.getParameter("id");
			//System.out.println("id");
			String name = request.getParameter("na");
			String sex = request.getParameter("se");
			String[] kecheng = request.getParameterValues("ke");
			//数组转字符串
			String  kecheng01= Arrays.toString(kecheng);
			kecheng01 = kecheng01.substring(1,kecheng01.length()-1);
			String birth = request.getParameter("bir");
			String seid= request.getParameter("clat3");
			
			ser.setId(0);
			ser.setName(name);
			ser.setSex(sex);
			ser.setCourse(kecheng01);
			ser.setBirth(birth);
			ser.setSeid(Integer.parseInt(seid));
			//调用逻辑层方法
			wor.add(ser);
			fen(request, response);
	}
	public void select2(HttpServletRequest request, HttpServletResponse response) 
			throws ServletException, IOException {
	    	request.setCharacterEncoding("UTF-8");
	   		response.setCharacterEncoding("UTF-8");
	        //1.调用Workvice完成查询
	   		Workvice wor= new WorkviceImp();
			//把实体类对象存到作用域中
			List<Workser> li= wor.selec();
			//2.把List存到request域中
			request.setAttribute("users",li);
			request.getRequestDispatcher("/smallallset/seleclat4").forward(request,response);
			
		}
//	public void selt2(HttpServletRequest request, HttpServletResponse response)
//			throws ServletException, IOException {
//			request.setCharacterEncoding("UTF-8");
//	   		response.setCharacterEncoding("UTF-8");
//	   		WorkviceImp wor= new WorkviceImp();
//			//实体类对象
//	   		String id = request.getParameter("id");
//			
//			Workser sel = wor.sel(Integer.parseInt(id));
//			request.setAttribute("all",sel);
//			request.getRequestDispatcher("/before/cha.jsp").forward(request,response);
//	}
	public void delet2(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
			//逻辑层对象
			WorkviceImp wor= new WorkviceImp();
			//获取请求id
			Integer parameter =Integer.parseInt(request.getParameter("id"));
			wor.del(parameter);
			fen(request, response);
	}
	public void updt2(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
			request.setCharacterEncoding("UTF-8");
			response.setCharacterEncoding("UTF-8");
			//逻辑层对象
			WorkviceImp wor= new WorkviceImp();
			//实体类对象
			Workser ser = new Workser();
			//获取用户输入的数据
			//System.out.println("id");
			String parameter = request.getParameter("hid");
			String name = request.getParameter("na");
			String sex = request.getParameter("se");
			String[] kecheng = request.getParameterValues("ke");
			
			System.out.println(parameter);
			//数组转字符串
			String  kecheng01= Arrays.toString(kecheng);
			kecheng01 = kecheng01.substring(1,kecheng01.length()-1);
			
			String birth = request.getParameter("bir");
			String seid= request.getParameter("clat3");
			
			ser.setName(name);
			ser.setSex(sex);
			ser.setCourse(kecheng01);
			ser.setBirth(birth);
			ser.setSeid(Integer.parseInt(seid));
			ser.setId(Integer.parseInt(parameter));
			wor.upd(ser);
			
			fen(request, response);
	}

	
//	public void semuot2(HttpServletRequest request, HttpServletResponse response)
//			  throws ServletException, IOException {
//	
//	  //业务层对象 
//	  WorkviceImp wor= new WorkviceImp();
//	  //实体类对象 
//	  Workser ser = new Workser();
//	  //获取请求数据
//	  String jian = request.getParameter("jiansuo"); 
//	  String clas= request.getParameter("clat3"); 
//	  List<Workser> smuo = wor.smuo(jian,clas);
//	  request.setAttribute("users", smuo);
//	  request.getRequestDispatcher("/smallallset/seleclat4").forward(request,response);
//	  }
	 
	public void fen(HttpServletRequest request, HttpServletResponse response) 
			throws ServletException, IOException {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		//业务层对象
		Workvice wor = new WorkviceImp();
		//接受请求参数
		String jian = request.getParameter("jiansuo"); 
		String clas= request.getParameter("clat3"); 
		
		if(jian == null) {
			jian = "";
		}
		if(clas == null) {
			clas = (String)"-1";
		}
		
		String cur_page2 = request.getParameter("cur_page");
		//判断cur_page是否为空
		if(cur_page2 == null || cur_page2.equals("") || cur_page2.equals("0")){
			cur_page2="1";
		}
		//转成int类型
		int cur_page = Integer.parseInt(cur_page2);
		//向业务层传值
		PageBean<Workser> pahe = wor.smuo(jian,clas,cur_page);
		//调用班级的逻辑层
		Workclasvice workclasvice = new WorkclasviceImp();
		List<Workclas> selec = workclasvice.selec();
		//存储作用域
		request.setAttribute("jian", jian);
		request.setAttribute("clas", clas);
		request.setAttribute("xia",selec);
		request.setAttribute("page", pahe);
		//转发到jsp页面
		request.getRequestDispatcher("/before/cha.jsp").forward(request, response);
	}
}

注释的一个是单表查询,一个是全表查询(因为后面我用了模糊查询,所以单表和全表就注释了)

单表查询好像不对

之后我会发逻辑层和访问层的代码(但我写增删改查时用了工具类)

需要用到的工具类一共有三个(一个是dao层的工具类(链接数据库的),一个是分发servlet的工具,还一个就是JavaBean的工具类)到时候再说(我是刚刚学打代码的小白,大佬要是看哪里不对可以指导我一下)[这个可以不看没有营养,我用来凑字数的,显得我厉害一点点,嘿嘿]

有需要要源代码的可以私我