实现新增消费账单
1.main_left.jsp中该部分,调用add.jsp
2.
add.jsp,提交到Servlet的add方法
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<style type="text/css">
.a{margin-top:20px;}
.b{font-size:20px;width:160px;color:white; background-color:greenyellow;}
</style>
</head>
<body>
<%
Object message = request.getAttribute("message");
if(message!=null && !"".equals(message)){
%>
<script type="text/javascript">
alert("<%=request.getAttribute("message")%>");
</script>
<%} %>
<div align="center">
<form action="ShangServlet?method=add" method="post" οnsubmit="return check()">
<div class="a">消费名称:<input type="text" name="name" id="name"></div>
<div class="a">消费金额:<input type="text" name="money" id="money"></div>
<div class="a">消费日期:<input type="text" name="date" id="date"></div>
<div class="a"><button type="submit" class="b">保 存</button></div>
</form>
</div>
<script type="text/javascript">
function check(){
var name=document.getElementById("name");
var money=document.getElementById("money");
var date=document.getElementById("date");
if(name.value==''){
alert('消费名称为空');
name.focus();
return false;
}
if(money.value==''){
alert('消费金额为空');
money.focus();
return false;
}
if(date.value==''){
alert('消费日期为空');
date.focus();
return false;
}
}
</script>
</body>
</html>
3.Servlet中add方法,调用Dao层的add方法
//添加
private void add(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
req.setCharacterEncoding("utf-8");
String name = req.getParameter("name");
String money = req.getParameter("money");
String date = req.getParameter("date");
Student course = new Student(name,money,date);
//添加后消息显示
if(dao.add(course)) {
req.setAttribute("message", "添加成功");
req.getRequestDispatcher("add.jsp").forward(req,resp);
} else {
req.setAttribute("message", "添加失败");
req.getRequestDispatcher("add.jsp").forward(req,resp);
}
}
4.Dao层的add方法,实现与数据库的操作,添加成功
//添加
public boolean add(Student course) {
String sql = "insert into home(name,money,date) values('"+ course.getName() + "','" + course.getMoney()+"','" + course.getDate() + "')";
Connection conn = DBUtil.getConn();
Statement state = null;
boolean f = false;
int a = 0;
try {
state = conn.createStatement();
a=state.executeUpdate(sql);
} catch (Exception e) {
e.printStackTrace();
} finally {
DBUtil.close(state, conn);
}
if (a > 0) {
f = true;
}
return f;
}
总结:
add.jsp-->Servlet?method=add-->Dao?method=add
作品: