MVC模式
Model:对应javaWeb里的javaBean/pojo 业务模型
View:对应javaWeb里的JSP 视图,界面展示
Controller:对应javaWeb里的servlet 控制器,处理请求,调用模型和视图
三层架构模型
表现层:C+V(接受请求、封装数据、调用业务层、响应数据) web/controller
业务逻辑层:登录注册之类的业务逻辑,可掉用数据访问层 service
数据访问层:增删改查(CURD操作) dao/mapper
Servlet+JSP+Mybatis小项目Demo——User的CRUD
项目结构
pom文件
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>MvcModule</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<dependencies>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.0.1</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.8</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<version>2.2</version>
<configuration>
<port>8080</port>
<path>/MvcModule</path><!--虚拟目录-->
</configuration>
</plugin>
</plugins>
</build>
</project>
数据层:POJO
@Data//包括get、set、equals、hashCode、canEqual、toString、无参构造,没有有参构造
@NoArgsConstructor
public class User {
private Integer id;
private String name;
private String password;
private String email;
private Date birthday;
private String infoId;
private String englishTeacher;
public User(Integer id, String name, String password, String email, Date birthday, String infoId, String englishTeacher) {
this.id = id;
this.name = name;
this.password = password;
this.email = email;
this.birthday = birthday;
this.infoId = infoId;
this.englishTeacher = englishTeacher;
}
}
resource的mybatis核心配置
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<typeAliases>
<package name="com.kdy.pojo"/>
</typeAliases>
<environments default="development">
<environment id="development"><!--环境development、test,可以配置多个数据库连接的环境信息,将来通过default属性切换-->
<transactionManager type="JDBC"/><!--事务管理器,spring可接管-->
<dataSource type="POOLED"><!--数据源-->
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql:///jdbc?useSSL=false"/>
<!--如果mysqlurl中有&符号需要进行转义为&,如useSSL=false&useServerPrepStmts=true
127.0.0.1:3306本机默认端口可省略不写,直接为///-->
<property name="username" value="root"/>
<property name="password" value="root123"/>
</dataSource>
</environment>
</environments>
<mappers>
<package name="com.kdy.mapper"/>
</mappers>
</configuration>
数据层:mapper接口
public interface UserMapper {
@Select("select * from users")
@ResultMap("userResultMap")
List<User> selectAll();
@Delete("delete from users where id = #{id}")
int delete(int id);
@Select("select * from users where name = #{name} and password = #{password}")
@ResultMap("userResultMap")
User selectByNameAndPwd(@Param("name")String name, @Param("password")String password);
@Select("select * from users where name = #{name}")
@ResultMap("userResultMap")
User selectByName(@Param("name") String name);
@Select("select * from users where id = #{id}")
@ResultMap("userResultMap")
User selectById(@Param("id") int id);
@Insert("insert into users(name,password,email,birthday,infoId,english_teacher)" +
" values(#{name},#{password},#{email},#{birthday},#{infoId},#{englishTeacher});")
int insert(User user);
@Update("update users set name=#{name},password=#{password},email=#{email},birthday=#{birthday}," +
"infoId=#{infoId},english_teacher=#{englishTeacher} where id = #{id}")
int update(User user);
}
sql映射文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.kdy.mapper.UserMapper">
<resultMap id="userResultMap" type="user">
<result column="english_teacher" property="englishTeacher"/>
<!--其他需要映射的字段接着上行格式往下写即可-->
</resultMap>
</mapper>
SqlSessionFactoryUtils
/**
* 通过静态代码块使得该类再被JVM加载时仅执行唯一一次静态代码块中的内容,生成一个sqlSessionFactory对象保存在该类变量中
* 后续直接通过public的getSqlSessionFactory方法拿到这个对象即可。避免重复频繁创建sqlSessionFactory对象的问题。
*/
public class SqlSessionFactoryUtils {
private static SqlSessionFactory sqlSessionFactory;
static {
try {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
} catch (IOException e) {
e.printStackTrace();
}
}
public static SqlSessionFactory getSqlSessionFactory(){
return sqlSessionFactory;
}
}
业务层:userService
public class UserService {
SqlSessionFactory factory = SqlSessionFactoryUtils.getSqlSessionFactory();
public List<User> selectAll(){
SqlSession sqlSession = factory.openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<User> userList = mapper.selectAll();
sqlSession.close();
return userList;
}
public int addUser(User user){
SqlSession sqlSession = factory.openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int count = mapper.insert(user);
if (count>0){
sqlSession.commit();
}
sqlSession.close();
return count;
}
public User selectById(int id){
SqlSession sqlSession = factory.openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User user = mapper.selectById(id);
return user;
}
public int updateUser(User user){
SqlSession sqlSession = factory.openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int count = mapper.update(user);
if (count>0){
sqlSession.commit();
}
sqlSession.close();
return count;
}
public int delete(int id){
SqlSession sqlSession = factory.openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int count = mapper.delete(id);
if (count>0){
sqlSession.commit();
}
sqlSession.close();
return count;
}
}
表现层:html/index.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>UserIndex</title>
</head>
<body>
<a href="/MvcModule/selectAllServlet">查询所有</a>
</body>
</html>
表现层:查全部列表
@WebServlet("/selectAllServlet")
public class SelectAllServlet extends HttpServlet {
UserService userService = new UserService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
List<User> users = userService.selectAll();
req.setAttribute("users",users);
req.getRequestDispatcher("/jsp/user.jsp").forward(req,resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req,resp);
}
}
user.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><!--引入jstl标签库URI-->
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<html>
<head>
<title>User</title>
</head>
<body>
<input type="button" value="新增" id="add"><br/>
<table border="1px">
<tr align="center">
<td>jstl序号</td>
<td>ID</td>
<td>name</td>
<td>密码></td>
<td>email</td>
<td>生日</td>
<td>infoId</td>
<td>englishTeacher</td>
<td>操作</td>
</tr>
<c:forEach items="${users}" var="user" varStatus="order">
<tr align="center">
<td>${order.index}</td>
<td>${user.id}</td>
<td>${user.name}</td>
<td>${user.password}</td>
<td>${user.email}</td>
<td><fmt:formatDate value="${user.birthday}" pattern="yyyy-MM-dd"/></td>
<td>${user.infoId}</td>
<td>${user.englishTeacher}</td>
<td><a href="/MvcModule/selectByIdServlet?id=${user.id}">修改</a>&<a href="/MvcModule/deleteByIdServlet?id=${user.id}">删除</a></td>
</tr>
</c:forEach>
</table>
<h3>分页</h3>
<c:forEach begin="1" end="10" step="1" var="i">
<a href="#">${i}</a>
</c:forEach>
</body>
<script>
document.getElementById("add").onclick = function () {
location.href = "/MvcModule/jsp/addUser.jsp";
}
</script>
</html>
表现层:新增
addUser.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>addUser</title>
</head>
<body>
<form action="/MvcModule/AddServlet" method="post">
用户名: <input name="name" type="text"/><br/>
密码: <input name="password" type="text"><br/>
邮箱: <input name="email" type="text"><br/>
生日: <input name="birthday" type="date"><br/>
infoId: <input name="infoId" type="text"><br/>
英语老师:<input name="englishTeacher" type="text">
<input type="submit" value="提交">
<input type="reset" value="重置">
</form>
</body>
</html>
@WebServlet("/AddServlet")
public class AddServlet extends HttpServlet {
private UserService userService = new UserService();
@SneakyThrows
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");//POST请求的参数的中文乱码解决方式
String name = req.getParameter("name");
String password = req.getParameter("password");
String email = req.getParameter("email");
String birthday = req.getParameter("birthday");
String infoId = req.getParameter("infoId");
String englishTeacher = req.getParameter("englishTeacher");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date dateBirthday = sdf.parse(birthday);
User user = new User(null, name, password, email, dateBirthday, infoId, englishTeacher);
int count = userService.addUser(user);
if (count>0){
req.getRequestDispatcher("/selectAllServlet").forward(req,resp);
}else{
resp.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
PrintWriter writer = resp.getWriter();
writer.write("新增失败");
}
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req,resp);
}
}
表现层:修改
@WebServlet("/selectByIdServlet")
public class SelectByIdServlet extends HttpServlet {
private UserService userService = new UserService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String id = req.getParameter("id");
User user = userService.selectById(Integer.parseInt(id));
req.setAttribute("user",user);
req.getRequestDispatcher("/jsp/update.jsp").forward(req,resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req,resp);
}
}
update.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<html>
<head>
<title>UpdateUser</title>
</head>
<body>
<h3>修改</h3>
<form action="/MvcModule/updateServlet" method="post">
<input style="display:none;" name="id" value="${user.id}">
用户名: <input name="name" type="text" value="${user.name}"><br/>
密码: <input name="password" type="text" value="${user.password}"><br/>
邮箱: <input name="email" type="text" value="${user.email}"><br/>
生日:<input name="birthday" type="date" value="<fmt:formatDate value="${user.birthday}" pattern="yyyy-MM-dd"/>" required="required"><br/>
infoId: <input name="infoId" type="text" value="${user.infoId}"><br/>
英语老师:<input name="englishTeacher" type="text" value="${user.englishTeacher}">
<input type="submit" value="提交">
</form>
</body>
</html>
@WebServlet("/updateServlet")
public class UpdateServlet extends HttpServlet {
UserService userService = new UserService();
@SneakyThrows
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");//POST请求的参数的中文乱码解决方式
String id = req.getParameter("id");
String name = req.getParameter("name");
String password = req.getParameter("password");
String email = req.getParameter("email");
String birthday = req.getParameter("birthday");
String infoId = req.getParameter("infoId");
String englishTeacher = req.getParameter("englishTeacher");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date dateBirthday = sdf.parse(birthday);
User user = new User(Integer.valueOf(id), name, password, email, dateBirthday, infoId, englishTeacher);
int count = userService.updateUser(user);
if (count > 0) {
req.getRequestDispatcher("/selectAllServlet").forward(req, resp);
} else {
resp.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
PrintWriter writer = resp.getWriter();
writer.write("修改失败");
}
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req, resp);
}
}
表现层:删除
@WebServlet("/deleteByIdServlet")
public class DeleteByIdServlet extends HttpServlet {
UserService userService = new UserService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String id = req.getParameter("id");
int count = userService.delete(Integer.valueOf(id));
if (count > 0) {
req.getRequestDispatcher("/selectAllServlet").forward(req, resp);
} else {
resp.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
PrintWriter writer = resp.getWriter();
writer.write("删除失败");
}
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req,resp);
}
}