其实也是基于以前很多demo的一个综合
准备
需要用到的jar包(包含数据库、POI、德鲁伊数据库池):百度网盘
提取码:Sjar
结构
前端页面
只是做简单的组件
用到了bootstarp来做简单的修饰
我这里仅提供用到的一些资源
bootstrap:百度网盘
提取码:bost
jquery:百度网盘
提取码:jqry
看结构要知道这些页面是在哪里创建的
login.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + request.getContextPath() + "/";
%>
<!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>
<!--jquery -->
<script type="text/javascript" src="js/jquery-3.3.1.min.js"></script>
<!-- bootstrap -->
<link type="text/css" rel="stylesheet" href="bootstrap3/css/bootstrap.min.css" />
<script type="text/javascript" src="bootstrap3/js/bootstrap.min.js"></script>
<base href="<%=basePath%>">
</head>
<body>
<div>
<h3 align="center">信息管理系统 <small>登录页</small></h3>
</div>
<div align="center">
<form action="user/login.do" method="post">
账号:<input type="text" name="username"/><br/><br/>
密码:<input type="text" name="password"/><br/><br/>
<input type="submit" value="提交" class="btn btn-primary btn-sm"/>
</form>
</div>
</body>
</html>
add.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + request.getContextPath() + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<base href="<%=basePath%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>信息添加页</title>
<!--jquery -->
<script type="text/javascript" src="js/jquery-3.3.1.min.js"></script>
<!-- bootstrap -->
<link type="text/css" rel="stylesheet" href="bootstrap3/css/bootstrap.min.css" />
<script type="text/javascript" src="bootstrap3/js/bootstrap.min.js"></script>
<script type="text/javascript">
$(function(){
$("#submitBtn").click(function(){
//取得表单的jquery对象 调用提交表单方法
$("#myForm").submit();
})
})
</script>
</head>
<body>
<div>
<h3 align="center">信息管理系统 <small>信息添加页</small></h3>
</div>
<div align="center">
<form action="student/save.do" method="post" id="myForm">
请输入姓名:<input type="text" name="name"/><br/><br/>
请输入年龄:<input type="text" name="age"/><br/><br/>
<!-- <input type="submit" value="提交"/> -->
<button type="button" id="submitBtn" class="btn btn-primary btn-sm">提交表单</button>
</form>
</div>
</body>
</html>
edit.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"
%>
<%
String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + request.getContextPath() + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<base href="<%=basePath%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>修改页</title>
<!--jquery -->
<script type="text/javascript" src="js/jquery-3.3.1.min.js"></script>
<!-- bootstrap -->
<link type="text/css" rel="stylesheet" href="bootstrap3/css/bootstrap.min.css" />
<script type="text/javascript" src="bootstrap3/js/bootstrap.min.js"></script>
<script type="text/javascript">
$(function(){
edit();
function edit(){
var id = "${param.id}";
$.ajax({
url : "student/edit.do",
data : {
//要传id
"id" : id
},
type : "get",
dataType : "json",
success : function(data){
//jquery方式赋值
$("#myId").val(data.id);
$("#myName").val(data.name);
$("#myAge").val(data.age);
}
})
}
$("#submitBtn").click(function(){
//取得表单的jquery对象 调用提交表单方法
$("#myForm").submit();
})
})
</script>
</head>
<body>
<div>
<h3 align="center">信息管理系统 <small>信息修改页</small></h3>
</div>
<div align="center">
<form action="student/update.do" method="post" id="myForm">
<input type="hidden" name="id" id="myId"/>
请编辑姓名:<input type="text" name="name" id="myName"/><br/><br/>
请编辑年龄:<input type="text" name="age" id="myAge"/><br/><br/>
<!-- <input type="submit" value="提交"/> -->
<button type="button" id="submitBtn" class="btn btn-primary btn-sm">提交表单</button>
</form>
</div>
</body>
</html>
index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"
%>
<%
String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + request.getContextPath() + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<base href="<%=basePath%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<style type="text/css">
td {
text-align: center;
}
a {
text-decoration: none;
}
</style>
<!--jquery -->
<script type="text/javascript" src="js/jquery-3.3.1.min.js"></script>
<!-- bootstrap -->
<link type="text/css" rel="stylesheet" href="bootstrap3/css/bootstrap.min.css"