1、目录结构
2、准备项目的依赖
pom.xml
<?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>com.xj</groupId>
<artifactId>SSM</artifactId>
<version>1.0.0</version>
<packaging>war</packaging>
<properties>
<project.spring.version>5.1.5.RELEASE</project.spring.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${project.spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${project.spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${project.spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${project.spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${project.spring.version}</version>
</dependency>
<!--mybatis和Spring的桥梁-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!-- 德鲁伊连接池 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.9</version>
</dependency>
<!--lombok-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.16.20</version>
</dependency>
<!--单元测试-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<!--日志的依赖-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.25</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.7.25</version>
</dependency>
<!--织入-->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.13</version>
</dependency>
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.7.0</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
</plugins>
<!--加载资源文件-->
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
<include>**/*.properties</include>
</includes>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.xml</include>
<include>**/*.properties</include>
</includes>
</resource>
</resources>
</build>
</project>
3.数据库
4.实体类
package com.xj.bean;
import lombok.*;
@Getter@Setter@ToString
@NoArgsConstructor
@AllArgsConstructor
public class Department {
private Integer id;
private String name;
private String location;
}
5.mapper接口
package com.xj.mapper;
import com.xj.bean.Department;
import java.util.List;
public interface DepartmentMapper {
Integer save(Department department);
Integer update(Department department);
Integer delete(Integer id);
Department get(Integer id);
List<Department> list();
}
6.mapper映射文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xj.mapper.DepartmentMapper">
<resultMap id="departmentMap" type="com.xj.bean.Department">
<id column="id" property="id"></id>
<result column="name" property="name"></result>
<result column="location" property="location"></result>
</resultMap>
<insert id="save" useGeneratedKeys="true" keyProperty="id">
insert into department (name,location) values (#{name},#{location})
</insert>
<update id="update">
update department set name=#{name},location=#{location}
where id=#{id}
</update>
<delete id="delete">
delete from department
where id=#{id}
</delete>
<select id="get" resultMap="departmentMap">
select id,name,location from department where id=#{id}
</select>
<select id="list" resultMap="departmentMap">
select id,name,location from department
</select>
</mapper>
7.service接口(department)
package com.xj.service;
import com.xj.bean.Department;
import java.util.List;
public interface IDepartmentService {
Integer save(Department department);
Integer update(Department department);
Integer delete(Integer id);
Department get(Integer id);
List<Department> list();
}
8.service实现类(department)
package com.xj.service.impl;
import com.xj.bean.Department;
import com.xj.mapper.DepartmentMapper;
import com.xj.service.IDepartmentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class DepartmentServiceImpl implements IDepartmentService {
@Autowired
private DepartmentMapper mapper;
@Override
public Integer save(Department department) {
return mapper.save(department);
}
@Override
public Integer update(Department department) {
return mapper.update(department);
}
@Override
public Integer delete(Integer id) {
return mapper.delete(id);
}
@Override
public Department get(Integer id) {
return mapper.get(id);
}
@Override
public List<Department> list() {
return mapper.list();
}
}
9.测试类APP(可不写)
package com.xj;
import com.xj.bean.Department;
import com.xj.service.IDepartmentService;
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;
/**
* Created by Administrator on 2020/1/2 0002.
*/
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:application.xml")
public class App {
@Autowired
private IDepartmentService service;
@Test
public void testSave(){
Department department = new Department(null,"开发部","朝阳区");
service.save(department);
}
@Test
public void testUpdate(){
Department department = new Department(1,"开发部","海淀区");
System.out.println(service.update(department));
}
@Test
public void testDelete(){
System.out.println(service.delete(1));
}
@Test
public void testGet(){
System.out.println(service.get(2));
}
@Test
public void testList(){
System.out.println(service.list());
}
}
10.db.properties
jdbc.driverClassName = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://127.0.0.1:3306/ssm
jdbc.username = root
jdbc.password = root
11.log4j.properties
# Global logging configuration
log4j.rootLogger=ERROR, stdout
# MyBatis logging configuration...
log4j.logger.com.xj=TRACE
# 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
12.mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<!--打开延迟加载的全局开关-->
<setting name="lazyLoadingEnabled" value="true"/>
<!--不要积极的去查询关联对象-->
<setting name="aggressiveLazyLoading" value="false"/>
<!--覆盖延迟加载的触发方法-->
<setting name="lazyLoadTriggerMethods" value=""/>
</settings>
</configuration>
13.application.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd">
<context:property-placeholder location="classpath:db.properties"/>
<!--配置德鲁伊的连接池-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--数据源-->
<property name="dataSource" ref="dataSource"/>
<!--配置别名-->
<property name="typeAliasesPackage" value="com.xj.bean"/>
<!--关联mapper映射文件-->
<property name="mapperLocations" value="classpath:com/xj/mapper/*Mapper.xml"/>
<!--关联mybatis的主配置文件-->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>
<!--如果有多个Mapper,一个一个配置这种方式很麻烦,所以使用注解的方式-->
<!-- <bean id="departmentMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
<property name="mapperInterface" value="com.xj.mapper.DepartmentMapper"></property>
</bean>
<bean id="service" class="com.xj.service.impl.DepartmentServiceImpl">
<property name="mapper" ref="departmentMapper"></property>
</bean>-->
<!--配置mapper接口扫描
从配置的包中,扫描所有的接口,并且创建接口的扫描对象
-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.xj.mapper"/>
<!--<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>--><!--只有一个sqlSessionFactory可以省略-->
</bean>
<!--IoC注解扫描-->
<context:component-scan base-package="com.xj"/>
<!--事务管理器-->
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!--配置事务-->
<aop:config>
<aop:pointcut id="txPoint" expression="execution( * com.xj.service..*.*(..))"/>
<aop:advisor advice-ref="txAdvice" pointcut-ref="txPoint"/>
</aop:config>
<tx:advice id="txAdvice" transaction-manager="txManager">
<tx:attributes>
<tx:method name="get*" read-only="true"/>
<tx:method name="list*" read-only="true"/>
<tx:method name="select*" read-only="true"/>
<tx:method name="*"/>
</tx:attributes>
</tx:advice>
</beans>
14.web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
version="3.0"
metadata-complete="true">
<!--前端控制器-->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:mvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<!--请求编码过滤器-->
<filter>
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<welcome-file-list>
<welcome-file>login.html</welcome-file>
</welcome-file-list>
</web-app>
15.mvc.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">
<!--引入后台的Spring配置文件-->
<import resource="classpath:application.xml"></import>
<!--mvc注解驱动-->
<mvc:annotation-driven/>
<!--视图解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/views/"/>
<property name="suffix" value=".jsp"/>
</bean>
<!--拦截器-->
<mvc:interceptors>
<!--登录检查拦截器-->
<mvc:interceptor>
<mvc:mapping path="/**"/>
<mvc:exclude-mapping path="/login.do"/>
<bean class="com.xj.interceptor.LoginIntercepter"/>
</mvc:interceptor>
</mvc:interceptors>
</beans>
16.Contrller(department)
package com.xj.controller;
import com.xj.bean.Department;
import com.xj.service.IDepartmentService;
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 java.util.List;
/**
* Created by Administrator on 2020/1/2 0002.
*/
@Controller
public class DepartmentController {
@Autowired
private IDepartmentService service;
@RequestMapping("/list")
public String list(Model model){
List<Department> list = service.list();
model.addAttribute("list",list);
return "department/list";
}
@RequestMapping("/edit")
public String edit(Integer id,Model model){
if(id!=null){
model.addAttribute("dept",service.get(id));
}
return "department/edit";
}
@RequestMapping("/SaveOrUpdate")
public String SaveOrUpdate(Department department){
if(department.getId()!=null){
service.update(department);
}else{
service.save(department);
}
return "redirect:/list.do";
}
@RequestMapping("/delete")
public String delete(Integer id){
if(id!=null){
service.delete(id);
}
return "redirect:/list.do";
}
}
17.list.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<h1>部门列表</h1>
<a href="/edit.do">新增</a>
<table border="1px" width="50%">
<tr>
<th>部门编号</th>
<th>部门名称</th>
<th>部门地址</th>
<th>操作</th>
</tr>
<c:forEach items="${list}" var="dept" varStatus="index">
<tr>
<th>${index.count}</th>
<th>${dept.name}</th>
<th>${dept.location}</th>
<th align="center">
<a href="/edit.do?id=${dept.id}">修改</a>
<a href="/delete.do?id=${dept.id}">删除</a>
</th>
</tr>
</c:forEach>
</table>
</body>
</html>
18.edit.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<h1>编辑部门</h1>
<form action="/SaveOrUpdate.do" method="post">
<input type="hidden" name="id" value="${dept.id}">
部门名称:<input type="text" name="name" value="${dept.name}"><br>
部门地址:<input type="text" name="location" value="${dept.location}"><br>
<input type="submit" value="保存">
</form>
</body>
</html>
19.login.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form action="/login.do" method="post">
用户姓名:<input type="text" name="username"><br>
用户密码:<input type="password" name="password"><br>
<input type="submit" value="登录">
</form>
</body>
</html>
20.service接口(user)
package com.xj.service;
public interface IUserService {
Boolean login(String username,String password);
}
21.service实现类
package com.xj.service.impl;
import com.xj.service.IUserService;
import org.springframework.stereotype.Service;
@Service
public class UserServiceImpl implements IUserService{
@Override
public Boolean login(String username, String password) {
if("rose".equals(username)&&"123".equals(password)){
return true;
}else{
return false;
}
}
}
22.Controller(user)
package com.xj.controller;
import com.xj.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import javax.servlet.http.HttpSession;
/**
* Created by Administrator on 2020/1/2 0002.
*/
@Controller
public class UserController {
@Autowired
private IUserService service;
@RequestMapping("/login")
public String login(String username, String password, HttpSession session){
Boolean res = service.login(username,password);
if(res){
//把登录的用户存入session作用域
session.setAttribute("USER_IN_SESSION","rose");
return "redirect:/list.do";
}else{
return "redirect:/login.html";
}
}
}
23.interceptor拦截器
package com.xj.interceptor;
import org.springframework.web.servlet.HandlerInterceptor;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class LoginIntercepter implements HandlerInterceptor{
public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handle) throws Exception{
//判断用户是否登录
Object obj = request.getSession().getAttribute("USER_IN_SESSION");
if(obj==null){
//没有登录,跳转到登录页面
response.sendRedirect("/login.html");
return false;
}
return true;
}
}