Servlet层添加方法
@WebServlet("/addServlet")
public class AddServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public AddServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html; charset=utf-8");
//1. 获取数据 调用业务层
String districtName=request.getParameter("districtName");
String date=request.getParameter("monitorTime");
String rain=request.getParameter("rain");
String monitorStation=request.getParameter("monitorStation");
String monitorAddress=request.getParameter("monitorAddress");
Date monitorTime = null;
SimpleDateFormat sdf= new SimpleDateFormat("yyyy.MM.dd");
try {
monitorTime=sdf.parse(date);
} catch (ParseException e) {
e.printStackTrace();
}
RainManage rainManage = new RainManage(districtName, monitorTime,Integer.valueOf(rain), monitorStation, monitorAddress);
RainManageService biz = new RainManageServiceImpl();
//2.保存数据,跳转页面 或者输出数据
PrintWriter out= response.getWriter();
if(biz.add(rainManage)>0) {
out.print("<script>alert('保存成功！');location.href='queryAllServlet';</script>");
}else {
out.print("<script>alert('保存失败！');location.href='add.jsp';</script>");
}
out.flush();
out.close();
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
网页添加方法
function check(){
var districtName= $("#districtName").val();
var monitorTime= $("#monitorTime").val();
var rain= $("#rain").val();
var monitorStation= $("#monitorStation").val();
var monitorAddress= $("#monitorAddress").val();
var rainReg = /^\d+$/
var monitorTimeReg = /^\d{4}\.\d{2}\.\d{2}$/
var flag = false;
if(districtName==""||monitorTime==""||
rain==""||monitorStation==""||monitorAddress==""){
alert("所有选项不能为空!");
}else if(!rainReg.test(rain)){
alert("雨量值有误!");
}else if(!monitorTimeReg.test(monitorTime)){
alert("日期有误必须为 yyyy.MM.dd!");
}else{
flag = true;
}
return flag;
}
function back(){
location.href="queryAllServlet";
}
</script>
删除和查询网页
<%@ page language="java"
contentType="text/html; charset=utf-8"pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!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>雨量检测信息</title>
</head>
<body>
<h1 style="text-align: center;">雨量检测信息</h1>
<table border="1" width="100%">
<tr style="background-color: #ccc">
<th>序号</th>
<th>区域名称</th>
<th>监测时间</th>
<th>雨量值(mm)</th>
<th>监测站</th>
<th>站点地址</th>
<th>操作</th>
</tr>
<c:forEach var="rain" varStatus="status" items="${list }" >
<tr <c:if test="${status.index%2!=0 }"> style="background-color: #ccc" </c:if> >
<td>${rain.id }</td>
<td>${rain.districtName }</td>
<td>${rain.monitorTime }</td>
<td>${rain.rain }</td>
<td>${rain.monitorStation }</td>
<td>${rain.monitorAddress }</td>
<td><a href="#" id="id${rain.id }" onclick="del(${rain.id })">删除</a></td>
</tr>
</c:forEach>
</table>
<a href="add.jsp">新增雨量监测信息</a>
<script type="text/javascript"
src="js/jquery-1.12.4.js"></script>
<script type="text/javascript">
function del(id){
var flag=confirm("确认要删除吗");
if(flag){
$.getJSON("delServlet","id="+id,function(result){
if(result.msg=="success"){
alert("删除成功!");
$("#id"+id).parent().parent().remove();
}else{
alert("删除失败!");
}
});
}
}
</script>
</body>
</html>
查询Servlet
@WebServlet("/queryAllServlet")
public class QueryAllServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public QueryAllServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html; charset=utf-8");
//1. 获取数据 调用业务层
RainManageService biz = new RainManageServiceImpl();
List<RainManage> list = biz.queryAll();
//2.保存数据,跳转页面 或者输出数据
request.setAttribute("list", list);
request.getRequestDispatcher("index.jsp").forward(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
删除Servlet
@WebServlet("/delServlet")
public class DelServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public DelServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html; charset=utf-8");
//1. 获取数据 调用业务层
String id= request.getParameter("id");
RainManageService biz = new
RainManageServiceImpl();
//2.保存数据,跳转页面 或者输出数据
PrintWriter out= response.getWriter();
if(biz.del(Integer.valueOf(id))>0) {
out.print("{\"msg\":\"success\"}");
}else {
out.print("{\"msg\":\"error\"}");
}
out.flush();
out.close();
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
分页步骤的网页代码
<%@ 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>请假记录列表</title>
</head>
<body>
<h1>请假记录列表</h1>
<a href="add.jsp">添加请假记录</a>
<table id="tabList" border="1">
</table
<div id="pageDiv"></div>
<input type="hidden" value="1" id="pageTotal" />
<script type="text/javascript" src="js/jquery-1.12.4.js"></script>
<script type="text/javascript">
function findByPage(pageNo) {
if (pageNo <= 0) {
return;
}
var totalPage = $("#pageTotal").val();
if (pageNo > totalPage) {
return;
}
$.getJSON(
"SearchByPageServlet",
"pageNo=" + pageNo,
function(result) {
var tabStr = "<tr><td>编号</td><td>姓名</td><td>请假时间</td><td>请假原因</td><td>操作</td></tr>";
for (var i = 0; i < result.datas.length; i++) {
tabStr += "<tr><td>"
+ result.datas[i].id
+ "</td><td>"
+ result.datas[i].name
+ "</td><td>"
+ result.datas[i].leaveTime
+ "</td><td>"
+ result.datas[i].reason
+"</td><td><a href='#' onclick='del("+result.datas[i].id+")'>删除</a></td></tr>";
}
$("#tabList").html(tabStr);
var pageStr = "";
pageStr += "<a href='#' onclick='findByPage(1)'>首页</a> ";
pageStr += "<a href='#' onclick='findByPage("+ (result.pageNo – 1)+ ")'>上一页</a> ";
pageStr += "<a href='#' onclick='findByPage("+ (result.pageNo + 1)+ ")'>下一页</a> ";
pageStr += "<a href='#' onclick='findByPage("+ (result.totalPage)+ ")'>尾页</a> ";
$("#pageDiv").html(pageStr);
$("#pageTotal").val(result.totalPage);
});
}
function del(id){
var result=confirm("确定要删除吗？");
if(result ==true){
$.ajax({
"url":"DeleteServlet",
"data":"id="+id,
"dataType":"json",
"type":"post",
"success":function(data){
if(data==1){
alert("删除成功!");
findByPage(1);
}else{
alert("删除失败!")
}
}
});
}
}
$(function() {
//默认 查询第一页
findByPage(1);
});
</script>
</body>
</html>
分页步骤的Servlet
@WebServlet("/SearchByPageServlet")
public class SearchByPageServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public SearchByPageServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
//获取当前页码
String pageNo = request.getParameter("pageNo");
if(pageNo==null||pageNo=="") {
pageNo = "1";
}
LeaveRecordsService biz = new LeaveRecordsServiceImpl();
Pager<LeaveRecords> pager=biz.findByPage(Integer.parseInt( pageNo), 2);
String result=JSON.toJSONStringWithDateFormat(pager, "yyyy-MM-dd");
PrintWriter out =response.getWriter();
out.print(result);
out.flush();
out.close();
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
更新的网页代码
<%@ 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>修改学员信息</title>
</head>
<body>
<form action="updateServlet?sid=${stu.sid }"
id="form" method="post">
<table border="1" >
<tr style="background-color: #ccc">
<td colspan="2"><h1 style="text-
align: center;">学员信息</h1></td>
</tr>
<tr>
<td>学员姓名</td>
<td>
<input type="text" value="${stu.sname }" name="sname" id="sname" /></td>
</tr>
<tr>
<td>学员性别</td>
<td><input type="text" value="${stu.sgender }" name="sgender" id="sgender" /></td>
</tr>
<tr>
<td>学员年龄</td>
<td><input type="text" value="${stu.sage }" name="sage" id="sage" /></td>
</tr>
<tr>
<td>家庭住址</td>
<td><input type="text" value="${stu.saddress }" name="saddress" id="saddress" /></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" value="${stu.semail }" name="semail" id="semail" /></td>
</tr>
<tr>
<td colspan="2" style="text-align: center;"><input type="submit" value="修改" /></td>
</tr>
</table>
</form>
<script src="js/jquery-1.12.4.js"></script>
<script>
$("#form").submit(function(){
var sname=$("#sname").val();
var sgender=$("#sgender").val();
var sage=$("#sage").val();
var falg= false;
if(sname==""){
alert("学员姓名不能为空！");
}else if(sgender==""){
alert("学员性别不能为空！");
}else if(sage==""){
alert("学员年龄不能为空！");
}else{
falg = true;
}
return falg;
});
</script>
</body>
</html>
更新的servlet代码
@WebServlet("/updateServlet")
public class UpdateServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public UpdateServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html; charset=UTF-8");
String sid=request.getParameter("sid");
String sname=request.getParameter("sname");
String sgender=request.getParameter("sgender");
String sage=request.getParameter("sage");
String saddress=request.getParameter("saddress");
String semail=request.getParameter("semail");
//调用业务层
StudentInfoService biz = new StudentInfoServiceImpl();
StudentInfo stu=new StudentInfo(Integer.valueOf(sid),sname,sgender,Integer.valueOf(sage),saddress,semail);
int result = biz.updateStu(stu);
if(result>0) {
//存储结果
request.getSession().setAttribute("msg", "更新成功！");
}else {
//存储结果
request.getSession().setAttribute("msg", "更新失败！");
}
//修改完成后 回到查询所有
response.sendRedirect("queryAllServlet");
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
网友评论