简单的 Java+mysql+Tomcat实现增、删、改、查、根据姓名和性别模糊查以及分页(模糊差分页有点小瑕疵,普通分页可以实现)

一、项目部署

(初学者,请多多指教)
1.Eclipse创建一个Dynamic Web Project
2.在src里面创建1个Package(com.airui),该包下面有5个子包 (dao,domain,service,servlet,utils),在src里导入c3p0-config.xml,如图下:
在这里插入图片描述
3.dao、domain、service里创建class,servlet里创建servlet,utils我是直接导入了一个封装好的jar包,如图下:
在这里插入图片描述
4.lib里导入一些jar包,WebContent里创建jsp文件、导入jq.js
在这里插入图片描述
5.重要的一步部署Tomcat环境
链接: https://pan.baidu.com/s/1nH6PVG4uaZbstJlxjf4ixA 提取码: 84as (项目源码+Tomcat7.0+jar包+连接池)
6.创建一个emp数据库
注:字段要与domain里的Emp实体类的字段一致
在这里插入图片描述

二.Dao层

//EmpDao

package com.airui.dao;import java.sql.SQLException;
import java.util.List;import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.commons.dbutils.handlers.ScalarHandler;import com.airui.domain.Emp;
import com.airui.domain.PageBean;public class EmpDao {public List<Emp> show(PageBean pb,QueryRunner qr) {//sql语句String sql="select * from emp limit ?,?;";/** Select * from xx limit x,y;*	X:(page-1)*tr*	Y:tr* *///要一一对应sql语句中的每一个'?'Object[] o= {(pb.getPage()-1)*pb.getTr(),pb.getTr()};try {//用集合封装数据List<Emp> list=qr.query(sql, new BeanListHandler<Emp>(Emp.class),o);return list;} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return null;}public void update(Emp e, QueryRunner qr) {//sql语句String sql="update emp set name=?,pwd=?,age=?,sex=?,dept=?,addr=?,birthday=? where id=?;";//要一一对应sql语句中的每一个'?'Object[] o= {e.getName(),e.getPwd(),e.getAge(),e.getSex(),e.getDept(),e.getAddr(),e.getBirthday(),e.getId()};try {qr.update(sql, o);} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}public Emp findbyid(int id, QueryRunner qr) {//sql语句String sql="select * from emp where id=?;";try {//返回一个Emp对象,'?'对应idEmp e=qr.query(sql, new BeanHandler<Emp>(Emp.class), id);return e;} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return null;}public void delete(int id, QueryRunner qr) {//sql语句String sql="delete from emp where id=?;";try {//'?'所对应的idqr.update(sql,id);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}public void add(Emp e, QueryRunner qr) {//sql语句String sql="insert into emp values(null,?,?,?,?,?,?,?);";//'?'所对应的值Object[] o= {e.getName(),e.getPwd(),e.getAge(),e.getSex(),e.getDept(),e.getAddr(),e.getBirthday()};try {qr.update(sql, o);} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}public int count(QueryRunner qr) {//sql语句String sql="select count(*) from emp;";try {//ScalarHandler:将单个值封装、例如select count(*),求内容的条数//如果查出结果为空,返回0,不是nullObject o=qr.query(sql, new ScalarHandler());return Integer.parseInt(o.toString());} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return 0;}public void deleteall(String[] ids, QueryRunner qr) {//sql语句String sql="delete from emp where id=?;";// 由于dbutils工具类的批量删除操作,需要的是二维数组来存放给?赋值的一维数组// 必须创建一个二维数组,这个二维数组的大小,就是一维数组的个数Object[][]  arr=new Object[ids.length][];for (int i = 0; i < ids.length; i++) {Object arr1[]={ids[i]};arr[i] = arr1;}try {//批量删除的方法,需要传入一个二维数组qr.batch(sql, arr);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}public List<Emp> selname(String selname, String sex, PageBean pb, QueryRunner qr) {String sql="select * from emp where name like ? and sex=? limit ?,?;";//'?'所对应的值Object[]o= {"%"+selname+"%",sex,(pb.getPage()-1)*pb.getTr(),pb.getTr()};try {return qr.query(sql, new BeanListHandler<Emp>(Emp.class),o);} 	catch (SQLException e) {e.printStackTrace();}return null;}public int count1(String selname, String sex, QueryRunner qr) {//sql语句String sql="select count(*) from emp where name like ? and sex=?;";//两个'?'所对应的值Object []o= {"%"+selname+"%",sex};try {//ScalarHandler:将单个值封装、例如select count(*),求内容的条数//如果查出结果为空,返回0,不是nullObject o1=qr.query(sql, new ScalarHandler(),o);return Integer.parseInt(o1.toString());} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return 0;}}

三.Domain层

//Emp实体类

package com.airui.domain;import java.util.Date;public class Emp {private Integer id;private String  name;private String  pwd;private Integer age;private String  sex;private String  dept;private String  addr;private Date  birthday;public Emp() {super();// TODO Auto-generated constructor stub}public Emp(Integer id, String name, String pwd, Integer age, String sex, String dept, String addr, Date birthday) {super();this.id = id;this.name = name;this.pwd = pwd;this.age = age;this.sex = sex;this.dept = dept;this.addr = addr;this.birthday = birthday;}public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getPwd() {return pwd;}public void setPwd(String pwd) {this.pwd = pwd;}public Integer getAge() {return age;}public void setAge(Integer age) {this.age = age;}public String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}public String getDept() {return dept;}public void setDept(String dept) {this.dept = dept;}public String getAddr() {return addr;}public void setAddr(String addr) {this.addr = addr;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}@Overridepublic String toString() {return "Emp [id=" + id + ", name=" + name + ", pwd=" + pwd + ", age=" + age + ", sex=" + sex + ", dept=" + dept+ ", addr=" + addr + ", birthday=" + birthday + "]";}}

//PageBean(分页)

package com.airui.domain;import java.util.List;public class PageBean {private int tr;        //每页要显示数据的个数private int trsum;     //一共有多少条数据private int page;      //当前是第几页,用户前端页面,传给后台的/** 用法:Math.ceil(double x)* 功能:返回大于或者等于指定表达式的最小整数,即向上取整* 用例:写分页的时候要根据查到的记录总数count和* 每页数据数roots,* 求出总共有多少页。这里都定义为int类型的* */private int pagesum;    //总页码,Matn.ceil(trsum/tr)private List<Emp> list;  //当前页的数据用list集合装起来public PageBean() {super();// TODO Auto-generated constructor stub}public PageBean(int tr, int trsum, int page, int pagesum, List<Emp> list) {super();this.tr = tr;this.trsum = trsum;this.page = page;this.pagesum = pagesum;this.list = list;}public int getTr() {return tr;}public void setTr(int tr) {this.tr = tr;}public int getTrsum() {return trsum;}public void setTrsum(int trsum) {this.trsum = trsum;}public int getPage() {return page;}public void setPage(int page) {this.page = page;}public int getPagesum() {return pagesum;}public void setPagesum(int pagesum) {this.pagesum = pagesum;}public List<Emp> getList() {return list;}public void setList(List<Emp> list) {this.list = list;}@Overridepublic String toString() {return "PageBean [tr=" + tr + ", trsum=" + trsum + ", page=" + page + ", pagesum=" + pagesum + ", list=" + list+ "]";}}

四.Service层

//EmpService

package com.airui.service;import java.util.List;import org.apache.commons.dbutils.QueryRunner;import com.airui.dao.EmpDao;
import com.airui.domain.Emp;
import com.airui.domain.PageBean;
import com.airui.utils.JDBCUtils;public class EmpService {EmpDao ed=new EmpDao();QueryRunner qr=JDBCUtils.getQR();//展示public List<Emp> show(PageBean pb) {//调用EmpDao的show方法List<Emp> list=ed.show(pb,qr);return list;}//修改public void update(Emp e) {//调用EmpDao的update方法ed.update(e,qr);}//根据id查找(修改和删除必须通过该方法)public Emp findbyid(int id) {//调用EmpDao的findbyid方法return ed.findbyid(id,qr);}//删除public void delete(int id) {//调用EmpDao的delete方法ed.delete(id,qr);}//添加public void add(Emp e) {//调用EmpDao的add方法ed.add(e,qr);}//计算总数public int count() {//调用EmpDao的count方法return ed.count(qr);}//删除选中的数据public void deleteall(String[] ids) {//调用EmpDao的deleteall方法ed.deleteall(ids,qr);}public List<Emp> selename(String selname, String sex, PageBean pb) {return ed.selname(selname,sex,pb,qr);}public int count1(String selname, String sex) {return ed.count1(selname,sex,qr);}}

五.Servlet层

//Show

package com.airui.servlet;import java.io.IOException;
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 com.airui.domain.Emp;
import com.airui.domain.PageBean;
import com.airui.service.EmpService;@WebServlet("/Show")
public class Show extends HttpServlet {private static final long serialVersionUID = 1L;public Show() {super();}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//处理中文乱码request.setCharacterEncoding("utf-8");response.setContentType("text/html;charset=utf-8");//创建EmpService层对象EmpService es = new EmpService();PageBean pb = new PageBean();//每页有多少条数据int tr=3;pb.setTr(tr);//一共有多少条数据int trsum=es.count();pb.setTrsum(trsum);//一共有多少页int pagesum=(int)Math.ceil(trsum*1.0/tr);pb.setPagesum(pagesum);//当前页数据int page=1;String p=request.getParameter("page");if (p!=null) {page=Integer.parseInt(p);}//setAttribute:获取当前页的pagerequest.getSession().setAttribute("page", page);pb.setPage(page);//每页的所有数据List<Emp> list=es.show(pb);pb.setList(list);//向前端服务器发送数据request.setAttribute("pb", pb);//发送到需要展示的界面'相当于'跳转到展示界面request.getRequestDispatcher("/show.jsp").forward(request, response);}protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request, response);}}

//Add

package com.airui.servlet;import java.io.IOException;
import java.sql.Date;
import java.util.Arrays;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 org.apache.commons.lang.StringUtils;import com.airui.domain.Emp;
import com.airui.service.EmpService;@WebServlet("/Add")
public class Add extends HttpServlet {private static final long serialVersionUID = 1L;public Add() {super();// TODO Auto-generated constructor stub}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//处理中文乱码request.setCharacterEncoding("utf-8");response.setContentType("text/html,charset=utf-8");//创建EmpService层对象EmpService es = new EmpService();//获取Emp表中字段的数据:request.getParameter("a"),a->show.jsp里面的input框的name属性值,即name="a";String name=request.getParameter("name");String pwd=request.getParameter("pwd");String age=request.getParameter("age");String sex=request.getParameter("sex");//将获取的部门信息放入一个一位数组里String[] depts=request.getParameterValues("dept");String dept="";if (depts!=null) {//格式转换:array->string;以','分割dept=StringUtils.join(depts,",");}String addr=request.getParameter("addr");String birthday=request.getParameter("birthday");//Date.valueOf方法是将字符串转换成date格式Emp e = new Emp(null,name,pwd,Integer.parseInt(age),sex,dept,addr,Date.valueOf(birthday));//调用Empservice中的add方法es.add(e);//将添加后的新数据发送到Servlet的Show中,再通过Show跳到show.jsp进行展示request.getRequestDispatcher("Show").forward(request, response);}protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stubdoGet(request, response);}}

//Delete

package com.airui.servlet;import java.io.IOException;
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 com.airui.service.EmpService;@WebServlet("/Delete")
public class Delete extends HttpServlet {private static final long serialVersionUID = 1L;public Delete() {super();}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//处理中文乱码request.setCharacterEncoding("utf-8");response.setContentType("text/html;charset=utf-8");//创建EmpService层对象EmpService es = new EmpService();//获取Emp表中字段的数据:request.getParameter("a"),a->show.jsp里面的input框的name属性值,即name="a";String i=request.getParameter("id");int id=Integer.parseInt(i);//getAttribute:得到删除后之前的page(Show里的request.getSession().setAttribute("page", page))Object page1=request.getSession().getAttribute("page");int page=Integer.parseInt(page1.toString());//调用Empservice中的delete方法es.delete(id);//将删除后的新数据发送到Servlet的Show中,再通过Show跳到show.jsp进行展示request.getRequestDispatcher("Show?page="+page).forward(request, response);}protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request, response);}}

//Update

package com.airui.servlet;import java.io.IOException;
import java.sql.Date;
import java.util.Arrays;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 org.apache.commons.lang.StringUtils;import com.airui.domain.Emp;
import com.airui.domain.PageBean;
import com.airui.service.EmpService;@WebServlet("/Update")
public class Update extends HttpServlet {private static final long serialVersionUID = 1L;public Update() {super();// TODO Auto-generated constructor stub}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//处理中文乱码request.setCharacterEncoding("utf-8");response.setContentType("text/html;charset=utf-8");//创建EmpService层对象EmpService es = new EmpService();//获取数据String i=request.getParameter("id");int id=Integer.parseInt(i);String name=request.getParameter("name");String pwd=request.getParameter("pwd");String age=request.getParameter("age");String sex=request.getParameter("sex");String[] depts=request.getParameterValues("dept");String dept="";if (depts!=null) {//格式转换:array->string,以','分割dept=StringUtils.join(depts,",");}String addr=request.getParameter("addr");String birthday=request.getParameter("birthday");//格式转换:string->dateEmp e = new Emp(id,name,pwd,Integer.parseInt(age),sex,dept,addr,Date.valueOf(birthday));//调用Empservice中的update方法es.update(e);//getAttribute:得到更新后之前的page(Show里的request.getSession().setAttribute("page", page))Object page1=request.getSession().getAttribute("page");int page=Integer.parseInt(page1.toString());//转发("Show?page="+page:留在当前页)request.getRequestDispatcher("Show?page="+page).forward(request, response);}protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request, response);}}

//FindById(增删需要根据id)

package com.airui.servlet;import java.io.IOException;
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 com.airui.domain.Emp;
import com.airui.service.EmpService;@WebServlet("/FindByID")
public class FindByID extends HttpServlet {private static final long serialVersionUID = 1L;public FindByID() {super();}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//处理中文乱码request.setCharacterEncoding("utf-8");response.setContentType("text/html,charset=utf-8");//创建EmpService层对象EmpService es = new EmpService();//获取数据String i=request.getParameter("id");int id=Integer.parseInt(i);//调用Empservice中的findbyid方法Emp e=es.findbyid(id);//传送数据request.setAttribute("e", e);//转发request.getRequestDispatcher("/update.jsp").forward(request, response);}protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request, response);}}

//DeleteAll(批量删除)

package com.airui.servlet;import java.io.IOException;
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 com.airui.service.EmpService;@WebServlet("/DeleteAll")
public class DeleteAll extends HttpServlet {private static final long serialVersionUID = 1L;public DeleteAll() {super();}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//处理中文乱码request.setCharacterEncoding("utf-8");response.setContentType("text/html,charset=utf-8");    //获取数据:request.getParameterValues("a"),a->show.jsp里面的input框的name属性值,即name="a";String[] ids=request.getParameterValues("ids");EmpService es = new EmpService();if (ids!=null) {es.deleteall(ids);}//转发request.getRequestDispatcher("Show").forward(request, response);}protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request, response);}}

//SelName(根据姓名和性别同时查询)

package com.airui.servlet;import java.io.IOException;
import java.sql.Date;
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 org.apache.commons.lang.StringUtils;import com.airui.domain.Emp;
import com.airui.domain.PageBean;
import com.airui.service.EmpService;@WebServlet("/SelName")
public class SelName extends HttpServlet {protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//处理中文乱码request.setCharacterEncoding("utf-8");response.setContentType("text/html,charset=utf-8");//创建EmpService层对象EmpService es = new EmpService();//获取数据String selname=request.getParameter("selname");String sex=request.getParameter("sex");PageBean pb = new PageBean();int tr=3;pb.setTr(tr);//通过模糊查查出来的数据的个数int trsum=es.count1(selname,sex);pb.setTrsum(trsum);//一共有多少页int pagesum=(int)Math.ceil(trsum*1.0/tr);pb.setPagesum(pagesum);//当前页数据int page=1;String p=request.getParameter("page");if (p!=null) {page=Integer.parseInt(p);}pb.setPage(page);//调用Empservice中的selename方法List<Emp> list=es.selename(selname,sex,pb);pb.setList(list);//System.out.println(list);request.setAttribute("pb", pb);request.getRequestDispatcher("/show.jsp").forward(request, response);}protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request, response);}}

六.Jsp

//show.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body background="cc.jpeg"><h1 align="center"><font size="7">在线信息管理系统</font></h1><div align="center"><!-- window.location方法可以链接到其他页面 --><button onclick="window.location='/work/add.jsp'">添加</button><form action="/work/SelName" method="post">姓名:<input type="text" name="selname"><br>性别:<input type="radio" name="sex" value="男"><input type="radio" name="sex" value="女"><br><input type="submit" value="根据姓名和性别查询"></form><!-- <form action="/work/SelAge" method="post">年龄:<input type="text" name="selage1">~<input type="text" name="selage2"><input type="submit" value="查询"></form> --><!-- post提交到Servlet中DeleteAll --><form action="/work/DeleteAll" method="post" ><input type="submit" id="del" value="批量删除"><table border="1" bordercolor="coral"><tr><td><input type="checkbox" id="all">全选/全不选</td><td>编号</td><td>姓名</td><td>密码</td><td>年龄</td><td>性别</td><td>部门</td><td>地址</td><td>生日</td><td>操作</td></tr><c:forEach items="${pb.list }" var="e"><tr><td><input type="checkbox" name="ids" value="${e.id }"></td><td>${e.id }</td><td>${e.name }</td><td>${e.pwd }</td><td>${e.age }</td><td>${e.sex }</td><td>${e.dept }</td><td>${e.addr }</td><td>${e.birthday }</td><td><a href="/work/FindByID?id=${e.id }">修改</a><a href="/work/Delete?id=${e.id }">删除</a></td></tr></c:forEach></table></form><!-- 首页直接显示page=1,默认为1,所以这边可以不用写/work/Show?page=1--><a href="/work/Show">首页</a><!-- 想要显示"上一页",必须保证当前页pb.page不等于1,同时'上一页的页码'='当前页的页码'-1才能显示'上一页'若当前页pb.page等于1时,就没有"上一页"--><c:if test="${pb.page!=1 }"><a href="/work/Show?page=${pb.page-1 }">上一页</a></c:if><!-- 中间显示:当前页/总页码  例:1/3 -->${pb.page }/${pb.pagesum }<!-- 想要显示"下一页",必须保证当前页pb.page不等于最后一页pb.pagesum,同时'下一页的页码'='当前页的页码'+1才能显示'下一页'若当前页pb.page等于pb.pagesum时,就没有"下一页"--><c:if test="${pb.page!=pb.pagesum }"><a href="/work/Show?page=${pb.page+1 }">下一页</a></c:if><!-- 首页直接显示page='最后一页' --><a href="/work/Show?page=${pb.pagesum }">尾页</a><input type="button" id="btn" value="退出"></div>
</body>
<script type="text/javascript" src="jq.js"></script><script type="text/javascript">/* all是全选/全不选多选框的id属性值,change是checkbox多选框被'✔'时即被选中 */$("#all").change(function(){/* 如果当前的多选按钮的,checked属性,是checked,表示,被选中attr()方法来获取和设置元素属性 */if($(this).attr("checked")=="checked"){$("input[type='checkbox']").attr("checked",true);	  		}else{$("input[type='checkbox']").attr("checked",false);}});$("#del").click(function(){alert("删除成功");});$("#btn").click(function(){var flag=confirm("请选择确认或取消");if (flag) {window.close();}});</script>
</html>

//update.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body><!-- post提交到Servlet中Update --><form action="/work/Update" method="post"><!-- hidden:显示的id被隐藏了 --><%-- 数据的回显:${e.id }--当点击修改按钮时会显示出原有的数据 --%><input type="hidden" name="id" value="${e.id }">姓名:<input type="text" name="name" value="${e.name }"><br>密码:<input type="password" name="pwd" value="${e.pwd }"><br>年龄:<input type="text" name="age" value="${e.age }"><br>性别:<input type="radio" name="sex" value="男" <c:if test="${e.sex=='男' }">checked</c:if>><input type="radio" name="sex" value="女" <c:if test="${e.sex=='女' }">checked</c:if>><br>部门:<input type="checkbox" name="dept" class="dept" value="流沙" <c:if test="${e.dept.contains('流沙') }">checked</c:if>>流沙<input type="checkbox" name="dept" class="dept" value="墨家" <c:if test="${e.dept.contains('墨家') }">checked</c:if>>墨家<input type="checkbox" name="dept" class="dept" value="天网" <c:if test="${e.dept.contains('天网') }">checked</c:if>>天网<input type="checkbox" name="dept" class="dept" value="影密卫" <c:if test="${e.dept.contains('影密卫') }">checked</c:if>>影密卫<input type="checkbox" name="dept" class="dept" value="农家" <c:if test="${e.dept.contains('农家') }">checked</c:if>>农家<br>住址:<input type="text" name="addr" value="${e.addr }"><br>生日:<input type="date" name="birthday" value="${e.birthday }"><br><input type="submit" id="modify" value="修改" ></form>
</body>
<script type="text/javascript" src="jq.js"></script><script type="text/javascript">$("#modify").click(function(){alert("修改成功");});</script>
</html>

//add.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body><!-- post提交到Servlet中的Add --><form action="/work/Add" method="post">姓名:<input type="text" name="name"><br>密码:<input type="password" name="pwd"><br>年龄:<input type="text" name="age"><br>性别:<input type="radio" name="sex" value="男"><input type="radio" name="sex" value="女"><br>部门:<input type="checkbox" name="dept" class="dept" value="流沙">流沙<input type="checkbox" name="dept" class="dept" value="墨家">墨家<input type="checkbox" name="dept" class="dept" value="天网">天网<input type="checkbox" name="dept" class="dept" value="影密卫">影密卫<input type="checkbox" name="dept" class="dept" value="农家">农家<br>地址:<input type="text" name="addr"><br>生日:<input type="date" name="birthday"><br><input type="submit" id="add" value="添加"></form>
</body>
<script type="text/javascript" src="jq.js"></script><script type="text/javascript">$("#add").click(function(){alert("添加成功");});</script>
</html>


本文来自互联网用户投稿,文章观点仅代表作者本人,不代表本站立场,不承担相关法律责任。如若转载,请注明出处。 如若内容造成侵权/违法违规/事实不符,请点击【内容举报】进行投诉反馈!

相关文章

立即
投稿

微信公众账号

微信扫一扫加关注

返回
顶部