Login Page

项目：SSM框架整合实例一、简介 1、内容：SSM（Spring+Spring MVC+MyBatis）是媲美SSH框架的轻量级Java EE框架； 2、项目场景：开发一个简单的用户基本信息管理网站，在数据库中存在的每个用户都可以登录网站，然后在网站上进行用户管理（增删改查）； 3、主要目的：展示如何整合SSM框架； 4、知识点：Spring框架、Spring MVC框架、MyBatis框架、MySQL。二、实验原理 1、前置课程：先学习Spring、Spring MVC、MyBatis三个框架基本知识。项目场景：开发简单用户基本信息管理网站，在数据库中存在的每个用户可登录网站，然后在网站上进行用户管理（增删改查）。 2、SSM框架分析实现项目中，采用SSM框架开发： Spring MVC用户Web层，相当于Controller，处理请求并做出响应； MyBatis作为持久层框架，可以自由控制SQL，更加简便快捷； Spring 依赖注入可以减少代码耦合，可以装配Bean，另外AOP、事务管理尤其方便，同时Spring可将各层整合。 ![图片描述](https://dn-simplecloud.shiyanlou.com/courses/uid239255-20190802-1564711950755) 3、准备 1）项目文件结构 ![图片描述](https://dn-simplecloud.shiyanlou.com/courses/uid239255-20190802-1564712020496) 2）数据库 sudo service mysql start mysql -u root create database ssm; use ssm; create table user( id int primary key auto_increment, username varchar(20), password varchar(20), sex varchar(10), age int ); insert into user(username,password,sex,age) value('shiyanlou','123456','male',22); 3）新建项目 mvn archetype:generate -DgroupId=com.shiyanlou -DartifactId=SSMTest -DarchetypeArtifactId=maven-archetype-webapp 4、修改pom.xml …… …… 5、Model层实体类User …… private Integer id; // 用户 id private String username; // 用户名 private String password; // 密码 private String sex; // 性别 private Integer age; // 年龄 …… 6、DAO层 1）UserMapper.java package com.shiyanlou.mapper; import com.shiyanlou.model.User; import java.util.List; public interface UserMapper { /** * 用户登录查询 * * @param user * @return User **/ User selectLogin(User user); /** * 查询全部用户 * * @return List **/ List selectAllUser(); /** * 新增用户 * * @param user **/ void addUser(User user); /** * 更新用户 * * @param user **/ void updateUser(User user); /** * 删除用户 * * @param id **/ void deleteUser(Integer id); } 2）src/main/resources/mappers/UserMapper.xml insert into user (username, password, sex, age) values (#{username}, #{password}, #{sex}, #{age}) update user set username = #{username}, password = #{password}, sex = #{sex}, age = #{age} where id = #{id} delete from user where id = #{id} 7、Service层实现 1）UserService.java package com.shiyanlou.service; import com.shiyanlou.model.User; import java.util.List; public interface UserService { /** * 用户登录 * * @param user * @return 登录成功返回 User 对象，失败返回 null **/ User login(User user); /** * 查询所有用户 * * @return 查询到的所有 User 对象的 list **/ List selectAllUser(); /** * 新增用户 * * @param user **/ void addUser(User user); /** * 更新用户 * * @param user **/ void updateUser(User user); /** * 删除用户 * * @param id（用户 id） **/ void deleteUser(Integer id); } 2）UserServiceImpl.java package com.shiyanlou.service.impl; import com.shiyanlou.mapper.UserMapper; import com.shiyanlou.model.User; import com.shiyanlou.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.util.List; /** * 将当前类注释为一个 Spring 的 bean * * @author shiyanlou */ @Service @Transactional(rollbackFor = Exception.class) public class UserServiceImpl implements UserService { /** * 自动注入 UserMapper **/ @Autowired public UserMapper userMapper; // 下面是 UserService 接口所有方法的具体实现 public User login(User user) { return userMapper.selectLogin(user); } public List selectAllUser() { return userMapper.selectAllUser(); } public void addUser(User user) { userMapper.addUser(user); } public void updateUser(User user) { userMapper.updateUser(user); } public void deleteUser(Integer id) { userMapper.deleteUser(id); } } 8、Spring和MyBatis整合 1）mybatis-config.xml 2）applicationContext.xml：Spring和MyBatis整合，包括自动扫描、自动注入、配置数据库等。

3） log4j.properties 配置日志 # Global logging configuration log4j.rootLogger=DEBUG, stdout # Console output... log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n 9、Spring、MyBatis整合测试 1）src/test/java/SpringMybatisTest.java import com.shiyanlou.model.User; import com.shiyanlou.service.UserService; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import java.util.List; /** * 配置spring和junit整合，junit启动时加载springIOC容器 spring-test,junit **/ @RunWith(SpringJUnit4ClassRunner.class) // 告诉junit spring配置文件 @ContextConfiguration({"classpath:applicationContext.xml"}) public class SpringMybatisTest { @Autowired private UserService userService; /* @Autowired private User user;*/ /* @Test public void testLogin() { //User user = new User(); user.setUsername("shiyanlou"); user.setPassword("123456"); System.out.println(userService.login(user).toString()); }*/ @Test public void testSelectAllUser() { List users = userService.selectAllUser(); for (User us : users) { System.out.println(us.toString()); } } /* @Test public void testAdd() { //User user = new User(); user.setUsername("user2"); user.setPassword("123456"); user.setSex("female"); user.setAge(25); userService.addUser(user); } @Test public void testUpdate() { //User user = new User(); user.setId(3); user.setUsername("user2"); user.setPassword("123"); user.setSex("female"); user.setAge(30); userService.updateUser(user); } @Test public void testUpdate() { int id = 3; userService.deleteUser(id); }*/ } 2）5.7 测试及结果：mvn test ![图片描述](https://dn-simplecloud.shiyanlou.com/courses/uid239255-20190730-1564484372842) 要做测试类注入User对象，需要： 1）在测试类添加代码 @Autowired private User user; 2）在model层User类添加@Component注解 @Component public class User { private Integer id; private String username; private String password; private String sex; private Integer age; ...... } 10、Controller层—UserController.java package com.shiyanlou.controller; import com.shiyanlou.model.User; import com.shiyanlou.service.UserService; import org.apache.ibatis.annotations.Param; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession; import java.util.List; /** * 处理用户请求 Controller **/ @Controller public class UserController { /** * 自动注入 UserService **/ @Autowired private UserService userService; // 登录 @RequestMapping("/login") public String login(User user, Model model, HttpSession session) { User loginUser = userService.login(user); if (loginUser != null) { session.setAttribute("user", loginUser); return "redirect:alluser"; } else { session.setAttribute("message", "username or password is wrong!"); return "redirect:loginform.jsp"; } } // 退出 @RequestMapping(value = "/loginout") public String loginout(HttpSession session) { session.invalidate(); return "redirect:loginform.jsp"; } // 查询所有用户 @RequestMapping("/alluser") public String selectAllUser(HttpServletRequest request) { List listUser = userService.selectAllUser(); request.setAttribute("listUser", listUser); return "userlist"; } // 跳转至新增用户页面 @RequestMapping("/toadduser") public String toAddUserPage() { return "adduser"; } // 新增用户 @RequestMapping("/adduser") public String addUser(User user, HttpServletRequest request) { userService.addUser(user); List listUser = userService.selectAllUser(); request.setAttribute("listUser", listUser); return "userlist"; } // 跳转至更新用户页面 @RequestMapping("/toupdateuser") public String toUpdateUser(@Param("id") Integer id, HttpServletRequest request, Model model) { model.addAttribute("user_id", id); return "updateuser"; } // 更新用户 @RequestMapping("/updateuser") public String updateUser(User user, HttpServletRequest request) { userService.updateUser(user); List listUser = userService.selectAllUser(); request.setAttribute("listUser", listUser); return "userlist"; } // 删除用户 @RequestMapping("/deleteuser") public String deleteUser(@Param("id") Integer id, HttpServletRequest request) { userService.deleteUser(id); List listUser = userService.selectAllUser(); request.setAttribute("listUser", listUser); return "userlist"; } } 11、JSP页面 1）loginform.jsp <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> Login Page

Login Page

2）userlist.jsp -- main page <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> ssm

Welcome,[${sessionScope.user.username}] | Exit

id	username	password	sex	age	Options
${user.id}	${user.username}	${user.password}	${user.sex}	${user.age}	modify	delete

Add a new user 3）adduser.jsp <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> Add Page

AddUser Page

4）updateuser.jsp <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> Modify Page

Modify Page

12、spring-mvc.xml 13、Spring和MyBatis整合完毕，进行测试mvn jetty:run ![图片描述](https://dn-simplecloud.shiyanlou.com/courses/uid239255-20190801-1564656275912) ![图片描述](https://dn-simplecloud.shiyanlou.com/courses/uid239255-20190731-1564539450863) ![图片描述](https://dn-simplecloud.shiyanlou.com/courses/uid239255-20190801-1564656349502)

username:
password:
sex:
age:

id:
username:
password:
sex:
age:

“SSM 框架整合实例”实验报告