servlet的增删改查

这是一个简单的servlet增删改查界面

t3.sql数据库：

/*
SQLyog 企业版 - MySQL GUI v8.14 
MySQL - 5.5.25a : Database - test
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`test` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `test`;

/*Table structure for table `t3` */

DROP TABLE IF EXISTS `t3`;

CREATE TABLE `t3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `password` varchar(32) DEFAULT NULL,
  `userName` varchar(32) DEFAULT NULL,
  `sex` varchar(5) DEFAULT NULL,
  `age` int(2) DEFAULT NULL,
  `address` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;

/*Data for the table `t3` */

insert  into `t3`(`id`,`password`,`userName`,`sex`,`age`,`address`) values (1,'23','123','女',12,' '),(36,'5345423','李四','男',12,'沙河'),(37,'654321','admin','男',30,'中国北京'),(38,'123456','admin2','女',28,'中国北京'),(39,'654321','admin','男',29,'中国河北'),(40,'123456','admin3','男',29,'中国河北'),(41,'12345678','admin4','男',29,'中国河北'),(42,'123','张三','男',22,'中国'),(43,'12345','王五','男',32,'山东济南'),(44,'123456','老刘','男',33,'中国河南'),(45,'654321','老刘','男',33,'中国河南'),(46,'123','老王','男',33,'中国河南'),(48,'12345678','老八','男',21,'234'),(49,'456123','admin','女',21,'123456');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

servletAction.java源代码：

package com.action;

import java.io.IOException;
import java.io.PrintWriter;
import java.io.UnsupportedEncodingException;
import java.util.List;
import java.util.Map;

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

import com.service.stuInfoService;

@SuppressWarnings("serial")
public class servletAction extends HttpServlet {
	
	//导入service服务包
	stuInfoService stuinfoService=new stuInfoService();
	
	//影响行数默认为-1，因为数据操作后的返回结果不为-1
	private int i=-1;
	
	//创建list数组
	private List list=null;
	
	//设定初始状态
	private boolean state=false;

	/*
	 * servlet action
	 * */
	public servletAction() {
		super();
	}

	/*
	 * servlet销毁方法
	 * */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/*
	 * doGet方法
	 * */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		//如果是get方法，自动带参数跳转到post()方法
		doPost(request, response);
		
	}

	/*
	 * doPost()方法
	 * */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		//设置页面编码格式为utf-8
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		
		//获取页面路径请求参数action
		String action=request.getParameter("action");
		
		//根据页面路径请求参数判断应该跳转的页面
		if(action.equals("insert")){
			
			//跳转到插入页面
			insert(request,response);
			
		}else if(action.equals("delete")){
			
			//跳转到删除页面
			delete(request,response);
			
		}else if(action.equals("update")){
			
			//跳转到修改页面
			update(request,response);
			
		}else if(action.equals("select")){
			
			//跳转到查询页面
			select(request,response);
			
		}
		
	}

	/*
	 * 查询方法
	 * */
	private void select(HttpServletRequest request, HttpServletResponse response) throws UnsupportedEncodingException,ServletException, IOException {
		// TODO Auto-generated method stub
		
		//设置页面编码格式为utf-8
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		System.out.println("这里是查询方法！");
		
		//获取页面请求参数
		String userName=request.getParameter("userName");
		String password=request.getParameter("password");
		String sex=request.getParameter("sex");
		String age=request.getParameter("age");
		String address=request.getParameter("address");
		
		//判断性别是否则”请选择“，如果是则置空，因为性别中只有”男“，”女“，没有”请选择“
		if("请选择".equals(sex)){
		
			sex="";	
			System.out.println("sex:"+sex);
			
		}
		
		//在控制台打印出来页面传递过来的参数
		System.out.println("userName:"+userName+"   password："+password+"   sex："+sex+"   age："+age+"   address："+address);
		
		//穿点String数组，方便参数调用
		String[] keyOption=new String[]{"userName","password","sex","age","address"};
		String[] valOption=new String[]{userName,password,sex,age,address};
		
		//循环遍历页面参数
		for(int i=0;i<valOption.length;i++){
			
			//判断页面传递来的参数是否存在，如果不存在则置空
			if(null==valOption[i]){
				valOption[i]="";
			}
			
		}
		
		//查询方法，获取mysql数据库的返回结果数组
		list=stuinfoService.select(keyOption,valOption);
		
		//将servlet获取的查询结果打印到控制台
		System.out.println("姓名"+"     密码"+"     性别"+"     年龄"+"     地址");
		
		//判断获取的来自mysql数据库的数组是否存在
		if(list!=null){
			
			//判断list数组是否为空
			if(list.size()>0){
				
				//循环遍历list数组