家庭记账本小程序之增（java web基础版三）

最新推荐文章于 2023-05-16 17:09:14 发布

weixin_30595035

最新推荐文章于 2023-05-16 17:09:14 发布

阅读量587

点赞数

文章标签： java 前端 javascript ViewUI

原文链接：http://www.cnblogs.com/mawangwang/p/10439086.html

版权

实现新增消费账单

1.main_left.jsp中该部分，调用add.jsp

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

作品：

转载于:https://www.cnblogs.com/mawangwang/p/10439086.html

weixin_30595035

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
家庭记账本小程序之增（java web基础版三）

实现新增消费账单1.main_left.jsp中该部分，调用add.jsp2.add.jsp,提交到Servlet的add方法<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><!DOCTYPE html>...
复制链接

扫一扫