思维
1.分析需求
2.建立数据库(非常简单,这里我用SqlServer)
3.在eclipse中,建立实体类,这里建三个,Student,Teacher,Clazz(避免关键字)
4.三层架构,一般项目都需要建立三层架构,不过这里的逻辑结构非常简单,所以咳咳。。。
首先dao层,从com.util包开始,然后再给每个表写dao类的接口,先包含最基本的增删改查,其余的方法不急 ,之后在写biz层。
5.主页面,主页面的Servlet类,再依次实现增加,删除,修改,模糊查询
具体项目
首页
从首页的赋值Servlet开始进入项目,这里使用了jstl标准标签库,和el表达式,
增加
这里的教员和班级都是需要从数据库里查询而来,所以可以将这一步放到之前使用的Servlet里,也可以另外写一个,我使用的是第二种,
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<a href="add1.do">新增学生</a>
<table>
<thead>
<form action="mohu.do">
<tr>
<td></td>
<td>教员: <select name="teacher">
<option value="0">全部</option>
<c:forEach var="i" items="${allt }">
<option value="${i.tid }">${i.tname }</option>
</c:forEach>
</select>
</td>
<td>班级: <select name="clazz">
<option value="0">全部</option>
<c:forEach var="i" items="${allc }">
<option value="${i.cid }">${i.cname }</option>
</c:forEach>
</select>
</td>
<td>爱好:
篮球<input name="like" type="checkbox" value='篮球'>
足球<input name="like" type="checkbox" value='足球'>
唱歌<input name="like" type="checkbox" value='唱歌'>
跳舞<input name="like" type="checkbox" value='跳舞'>
</td>
<td><button>查寻</button></td>
<td></td>
</tr>
</form>
<tr>
<td>学生ID</td>
<td>学生姓名</td>
<td>教员姓名</td>
<td>班级名称</td>
<td>学生爱好</td>
<td>操作</td>
</tr>
</thead>
<tbody>
<c:forEach var='i' items='${alls }'>
<tr>
<td>${i.sid }</td>
<td>${i.sname }</td>
<td>${i.tname }</td>
<td>${i.cname }</td>
<td>${i.slike }</td>
<td><a href='query.do?sid=${i.sid }'>修改</a> <a
href='del.do?sid=${i.sid }' onclick="return confirm('确定要删除嘛')">删除</a></td>
</tr>
</c:forEach>
</tbody>
</table>
</body>
<style>
table, tr, td {
border: 2px solid #00988B;
}
</style>
</html>
这是首页的代码
在add1.do中,查询所有教员和班级,
再带到增加的处理页面中。
增加的处理页面需要接受相应的值,在进行数据库操作。
AddServlet代码:
package com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.dao.impl.StudentDao;
import com.entity.Student;
/**
* Servlet implementation class AddServlet
*/
@WebServlet("/add.do")
public class AddServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
PrintWriter out=resp.getWriter();
String name = req.getParameter("name");
String st = req.getParameter("st");
String sc = req.getParameter("sc");
String[] ah = req.getParameterValues("ah");
String shabit="";
for (String s : ah) {
shabit+=s+",";
}
StudentDao sd=new StudentDao();
int a = sd.add(new Student(0, name, st, sc, shabit));
if(a>0) {
out.print("<script>alert('增加成功');location.href='index.do'</script>");
}else {
out.print("<script>alert('增加失败');location.href='add1.do'</script>");
}
}
}
注意要条转至首页的index.do数据才会更新。
删除:
在删除的处理页面,只需要拿到所需要删除的学生ID就行,所以只需要将每个学生后面的删除按钮带上相应的学生id
删除的处理页面代码
package com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.dao.impl.StudentDao;
/**
* Servlet implementation class DelServlet
*/
@WebServlet("/del.do")
public class DelServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
PrintWriter out=resp.getWriter();
int sid = Integer.parseInt(req.getParameter("sid"));
StudentDao sd=new StudentDao();
int d = sd.del(sid);
if(d>0) {
out.print("<script>alert('删除成功');location.href='index.do'</script>");
}else {
out.print("<script>alert('删除失败');location.href='index.do'</script>");
}
}
}
所有对数据进行修改的操作之后,都跳转至index.do,数据才会时时更新
修改
修改需要拿到学生原有的属性,所以要带学生id去查询的servlet在将数据带到查询页面,很简单,这里不演示了。之后也只需要将修改页面上所有的值赋值给数据库中相应id的行就行
查询
是这个项目中比较麻烦的一点,模糊查询需要分别多种情况,这里我只写了三种,根据教员,班级,爱好进行查询。
由于教员和班级都是唯一的,所以在进行查询时,只需要随便根据一个就行了
查询的Servlet
package com.servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.dao.impl.ClazzDao;
import com.dao.impl.StudentDao;
import com.dao.impl.TeacherDao;
import com.entity.Student;
import com.entity.Clazz;
import com.entity.Teacher;
@WebServlet("/mohu.do")
public class MoServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
System.out.println("jjjjjj");
HttpSession session = req.getSession();
String tid = "0";
String cid = "0";
String ah = "";
if (req.getParameter("teacher") != null) {
tid = req.getParameter("teacher");
}
if (req.getParameter("clazz") != null) {
cid = req.getParameter("clazz");
System.out.println("sssssssss" + req.getParameter("clazz"));
}
if (req.getParameter("like") != null) {
ah = req.getParameter("like");
}
StudentDao sd = new StudentDao();
ClazzDao cd = new ClazzDao();
TeacherDao td = new TeacherDao();
if (tid.equals("0") && cid.equals("0") && ah.equals("")) {
System.out.println("进来了");
List<Student> all = sd.getAll();
req.setAttribute("alls", all);
List<Clazz> call = cd.getAll();
List<Teacher> tall = td.getAll();
session.setAttribute("allc", call);
session.setAttribute("allt", tall);
req.getRequestDispatcher("index.jsp").forward(req, resp);
} else {
System.out.println("没进来");
System.out.println("teacher:" + tid);
System.out.println("clazz:" + cid);
System.out.println("ah:" + ah);
List<Student> all = sd.getByKey(tid, cid, ah);
req.setAttribute("alls", all);
List<Clazz> call = cd.getAll();
List<Teacher> tall = td.getAll();
session.setAttribute("allc", call);
session.setAttribute("allt", tall);
req.getRequestDispatcher("index.jsp").forward(req, resp);
}
}
}
ok.最简单的增删改查就写完了。
不过,这里的数据库逻辑结构很简单,只是一对一,而实际我们需要的,可能是,一对多,多对多,所以还有很多地方需要改进。
下次一定。
目录