题目:
Notes表的CURD操作,改成MVC模式
一、
servlet代码
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
// TODO Auto-generated method stub
System.out.println("doget");
doPost(req, resp);// doGet接收交给doPost处理
}
@Override
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws IOException, ServletException {
request.setCharacterEncoding("utf-8");
//删除
if (request.getParameter("meth").equals("del")) {
String id = request.getParameter("nid");
int nid = Integer.parseInt(id);
NotesVO nv = new NotesVO();
NotesDAO nd = new NotesDAO();
nv.setNid(nid);
if (nd.deleteNotes(nv)) {
response.sendRedirect("Success.jsp");
}
}
//注册
if (request.getParameter("meth").equals("发布")) {
System.out.println("222");
NotesVO nv = new NotesVO();
NotesDAO ndao = new NotesDAO();
Date now = new Date();
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
String d = df.format(now);
Date da;
try {
da = df.parse(d);
nv.setTitle(request.getParameter("title"));
nv.setPage(request.getParameter("page"));
nv.setMoney(Double.parseDouble(request.getParameter("money")));
nv.setDate(da);
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if (ndao.insertRegister(nv)) {
response.sendRedirect("Success.jsp");
} else {
response.sendRedirect("Failed.jsp");
}
}
//修改
if (request.getParameter("meth").equals("修改")) {
String id = request.getParameter("nid");
int nid = Integer.parseInt(id);
NotesVO nv = new NotesVO();
NotesDAO nd = new NotesDAO();
nv.setNid(nid);
nv.setTitle(request.getParameter("title"));
nv.setMoney(Double.parseDouble(request.getParameter("money")));
if (nd.update_Notes(nv)) {
response.sendRedirect("Success.jsp");
}
}
}
二、
查询界面代码
<body>
<%!int total_page;
int up_page;
int down_page;
int every_page = 3;
int now_page;%>
<center>
<table border="1" cellspacing="0">
<tr>
<td>编号</td>
<td>主题</td>
<td>日期</td>
<td>图片</td>
<td>赏金</td>
<td>操作</td>
</tr>
<%
NotesDAO ndao = new NotesDAO();
List<NotesVO> ln = ndao.select_Notes();
int total_size = ln.size();
total_page = (total_size + every_page - 1) / every_page;
if (total_size == 0) {
out.println("亲,售罄了!!");
} else {
//当前页
String now_p = request.getParameter("now_page");
if (now_p != null) {
now_page = Integer.parseInt(now_p);
} else {
now_page = 1;
}
if (now_page == 1) {
up_page = now_page;
} else {
up_page = now_page - 1;
}
if (now_page == total_page) {
down_page = total_page;
} else {
down_page = now_page + 1;
}
List<NotesVO> l = ndao.select_Notes(
(now_page - 1) * every_page, every_page);
for (NotesVO nv : l) {
%>
<tr>
<td><%=nv.getNid()%></td>
<td><%=nv.getTitle()%></td>
<td><%=nv.getDate()%></td>
<td><img width="80" height="40" src="<%=nv.getPage()%>"></td>
<td><%=nv.getMoney()%></td>
<td><a href="SN?meth=del&&nid=<%=nv.getNid()%>">删除</a><a
href="Update.jsp?nid=<%=nv.getNid()%>">修改</a></td>
</tr>
<%
}
%>
</table>
<caption>
总页为<%=total_page%>
当前页为<%=now_page%>
<a href="Success.jsp?now_page=<%=up_page%>">上一页</a> <a
href="Success.jsp?now_page=<%=down_page%>">下一页</a>
</caption>
<%
}
%>
</center>
</body>
结果
发布
查询
删除第二项
修改:将小事赏金修改为88.8