文章目录
前言
记录SSM的整合过程
环境准备
- IDEA
- MySQL 8.0.28
- Tomcat 9.0.65
- Maven 3.6.3
一、SSM是什么?
SSM(Spring+SpringMVC+MyBatis)框架集由Spring、MyBatis两个开源框架整合而成(SpringMVC是Spring中的部分内容)。 常作为数据源较简单的web项目的框架。
二、整合步骤
2.1 创建MAVEN-web工程
2.2 Maven本地仓库配置
配置项目名称和项目路径
配置Maven
配置好后点击完成,之后项目像这样就表明项目创建成功(生成的maven项目需要手动创建java和resource包)
三、添加依赖
在pom.xml文件中添加依赖,配置好后记得刷新,确保项目中存在相关依赖
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>
<spring.version>5.2.5.RELEASE</spring.version>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<!--log4j核心依赖-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!-- mysql 数据库驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.29</version>
</dependency>
<!-- spring依赖 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.9.7</version>
</dependency>
<!-- mybatis依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</dependency>
<!-- 参考版本对应 http://www.mybatis.org/spring/ -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.3</version>
</dependency>
<!-- 数据源管理 使用了dbcp2数据 -->
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-dbcp2</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-pool2</artifactId>
<version>2.4.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
<scope>provided</scope>
</dependency>
<!-- commons 文件上传jar -->
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>1.4</version>
</dependency>
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.1</version>
</dependency>
<!-- jstl -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- 加入JSON转换工具 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.47</version>
</dependency>
</dependencies>
四、配置文件编写
4.1 配置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="logImpl" value="LOG4J"/>
</settings>
</configuration>
由于我们可以使用spring的IOC来对bean进行统一的管理,这里就不需要再配置过多的东西,我们只需要把日志配置放在这里即可
4.2 配置数据源jdbc.properties
driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/bianlidian?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT-8
username1=root
pwd=123456
4.3 配置applicationContext.xml
spring配置文件是整合文件的核心,绝大多数的mybatis配置都可以在这里进行配置。
<?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:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:p="http://www.springframework.org/schema/p"
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/aop
https://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 加载数据库文件 -->
<context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
<!--数据库连接池
dbcp 半自动化操作 不能自动连接
c3p0 自动化操作(自动的加载配置文件 并且设置到对象里面)
-->
<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
<!-- 配置连接池属性 -->
<property name="driverClassName" value="${driver}"></property>
<property name="url" value="${url}"></property>
<property name="username" value="${username1}"></property>
<property name="password" value="${pwd}"></property>
</bean>
<!-- 配置SqlSessionFactory对象 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 引用数据库连接池 -->
<property name="dataSource" ref="dataSource"></property>
<!-- 引用MyBatis配置文件中的配置 -->
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
<!-- 配置SQL映射文件信息 -->
<property name="mapperLocations" value="classpath:mappers/*.xml"></property>
</bean>
<!-- 扫描mapper接口 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.xinxi2.dao"></property>
</bean>
<!-- 扫描component注解的 -->
<context:component-scan base-package="com.xinxi2"></context:component-scan>
<!-- 定义数据源事务管理器 自动装配:autowire-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager" autowire="byName">
</bean>
<!-- 事务管理器增强,配置方法的事务传播机制 -->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="get*" propagation="SUPPORTS" />
<tx:method name="add*" propagation="REQUIRED" />
<tx:method name="del*" propagation="REQUIRED" />
<tx:method name="update*" propagation="REQUIRED" />
<tx:method name="*" propagation="REQUIRED" />
</tx:attributes>
</tx:advice>
<!-- 定义切面 -->
<aop:config>
<aop:pointcut id="serviceMethod"
expression="execution(* com.xinxi2.service..*.*(..))" />
<aop:advisor advice-ref="txAdvice" pointcut-ref="serviceMethod" />
</aop:config>
</beans>
4.4 配置springMVC.xml
SpringMVC配置的大多是和前端处理有关的内容,不涉及后端的配置。
<?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: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/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
https://www.springframework.org/schema/mvc/spring-mvc.xsd">
<!-- 扫描web相关的bean -->
<context:component-scan base-package="com.xinxi2.controller,com.xinxi2.service"></context:component-scan>
<mvc:annotation-driven>
<!-- 解决ajax请求返回值的乱码和统一设置日期类型转换的问题。控制层到视图层 -->
<mvc:message-converters>
<bean class="org.springframework.http.converter.StringHttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>application/json;charset=UTF-8</value>
<value>text/html;charset=UTF-8</value>
</list>
</property>
</bean>
<bean class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>text/html;charset=UTF-8</value>
<value>application/json</value>
</list>
</property>
<property name="features">
<list>
<!-- Date的日期转换器 -->
<value>WriteDateUseDateFormat</value>
</list>
</property>
</bean>
</mvc:message-converters>
</mvc:annotation-driven>
<!-- 配置多视图解析器 -->
<bean id="contentNegotiationManager" class="org.springframework.web.accept.ContentNegotiationManagerFactoryBean">
<!-- 是否启用参数支持,默认为true(支持),即xxx?format=json、xml等形式。 -->
<property name="favorParameter" value="true" />
<!-- favorPathExtension:是否支持扩展名,默认为true(支持),扩展名指xxx.json、xxx.xml等形式 -->
<property name="favorPathExtension" value="true" />
<!-- 默认ContentType -->
<property name="defaultContentType" value="application/json" />
<!-- 配置映射关系 -->
<!--扩展名到MIME的映射;favorPathExtension, favorParameter是true时起作用 -->
<property name= "mediaTypes">
<value>
json=application/json
xml=application/xml
html=text/html
</value>
</property>
</bean>
<!-- VIEW解析定义。内容协商视图解析器;根据contentNegotiationManager使用的不同mediaTypes决定不同的 view进行响应 默认使用json-->
<bean class="org.springframework.web.servlet.view.ContentNegotiatingViewResolver">
<!-- 内容协商管理器 用于决定media type -->
<property name="contentNegotiationManager" ref="contentNegotiationManager"/>
<!-- 默认视图 解析 -->
<property name="defaultViews">
<list>
<bean class="com.alibaba.fastjson.support.spring.FastJsonJsonView">
<property name="charset" value="UTF-8"/>
</bean>
</list>
</property>
<property name="viewResolvers">
<list>
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- JSP文件所在的目录 -->
<property name="prefix" value="/WEB-INF/jsp/"/>
<!-- 文件的后缀名 -->
<property name="suffix" value=".jsp"/>
</bean>
</list>
</property>
</bean>
<!-- 解决静态资源的加载问题 -->
<mvc:resources mapping="/static/**" location="/static/"></mvc:resources>
<!-- 配置MultipartResolver,用于上传文件,使用spring的CommonsMultipartResolver -->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="maxUploadSize" value="500000"/>
<property name="defaultEncoding" value="UTF-8"/>
</bean>
</beans>
4.5 web.xml配置
web.xml文件配置的一般是对SSM整合的补充,是全局的配置。
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<!-- wep-app这里的代码用来解决jsp界面EL表达式没有的问题 -->
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
version="3.1">
<display-name>Archetype Created Web Application</display-name>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:ApplicationContext.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 加载MVC -->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 配置初始化参数,加载springmvc.xml配置文件 -->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:SpringMVC.xml</param-value>
</init-param>
<!-- 启动服务器,创建该servlet -->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 解决视图层到控制层的中文乱码问题,加入过滤器解决 -->
<filter>
<filter-name>encodingFilter</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>
<!-- 过滤的范围,name和上面对照: encodingFilter = encodingFilter -->
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
五、项目包结构
六、代码实现
6.1 创建bean
package com.xinxi2.bean;
import java.io.Serializable;
import java.util.Date;
public class TsYsUser implements Serializable {
private Integer id ;
private String acccunt ;
private String realname ;
private String password ;
private Integer sex ;
private Date birthday ;
private String phone ;
private String address ;
private Integer roleid ;
private Integer createduserid ;
private Date createdtime ;
private Integer updateduserid ;
private Date updatedtime ;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getAcccunt() {
return acccunt;
}
public void setAcccunt(String acccunt) {
this.acccunt = acccunt;
}
public String getRealname() {
return realname;
}
public void setRealname(String realname) {
this.realname = realname;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public Integer getSex() {
return sex;
}
public void setSex(Integer sex) {
this.sex = sex;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public Integer getRoleid() {
return roleid;
}
public void setRoleid(Integer roleid) {
this.roleid = roleid;
}
public Integer getCreateduserid() {
return createduserid;
}
public void setCreateduserid(Integer createduserid) {
this.createduserid = createduserid;
}
public Date getCreatedtime() {
return createdtime;
}
public void setCreatedtime(Date createdtime) {
this.createdtime = createdtime;
}
public Integer getUpdateduserid() {
return updateduserid;
}
public void setUpdateduserid(Integer updateduserid) {
this.updateduserid = updateduserid;
}
public Date getUpdatedtime() {
return updatedtime;
}
public void setUpdatedtime(Date updatedtime) {
this.updatedtime = updatedtime;
}
}
6.2 controller层
控制器的实现
package com.xinxi2.controller;
import com.xinxi2.bean.TsYsUser;
import com.xinxi2.service.TsYsUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;
@Controller
@RequestMapping("/tsYsUser")
public class TsYsUserController {
@Autowired
private TsYsUserService tsYsUserService;
@RequestMapping("/list")
public String listPage(TsYsUser tsYsUser, Model model){
List<TsYsUser> list = tsYsUserService.getList(tsYsUser);
model.addAttribute("list",list);
return "list.jsp";
}
}
6.3 mapper层
实现持久层
package com.xinxi2.dao;
import com.xinxi2.bean.TsYsUser;
import org.apache.ibatis.annotations.Param;
import java.util.List;
/**
* SSM 增删改查
*/
public interface TsYsUserMapper {
// 增
int add(TsYsUser tsYsUser);
// 删
int delete(@Param("TsYsUserID") int id);
// 改
int update(TsYsUser tsYsUser);
// 全部查找
List<TsYsUser> getList(TsYsUser tsYsUser);
}
TsYsUserMapper.xml数据库映射文件编写
<?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,理解为接口的实现类 -->
<mapper namespace="com.xinxi2.dao.TsYsUserMapper">
<insert id="add" parameterType="com.xinxi2.bean.TsYsUser" useGeneratedKeys="true" keyColumn="id" keyProperty="id">
insert into t_sys_user(realName,password)
values(#{realname},#{password})
</insert>
<delete id="delete">
delete from t_sys_user where id = #{TsYsUserID}
</delete>
<update id="update">
update t_sys_user u
<set>
<if test="id!=null and id != ''">
u.id=#{id},
</if>
<if test="realname!=null and realname != ''">
u.realName=#{realname},
</if>
<if test="password!=0 and password != ''">
u.password=#{password},
</if>
</set>
where id=#{id}
</update>
<resultMap id="resultInfo" type="com.xinxi2.bean.TsYsUser">
<id property="id" column="id"></id>
<result property="realname" column="realName"></result>
</resultMap>
<select id="getList" parameterType="com.xinxi2.bean.TsYsUser" resultMap="resultInfo">
select * from t_sys_user
<where>
<if test="id!=null">
and id=#{id}
</if>
<if test="realname!=null">
and realName=#{realname}
</if>
<if test="password!=null">
and password=#{password}
</if>
</where>
</select>
</mapper>
6.4 service层
实现业务层
package com.xinxi2.service;
import com.xinxi2.bean.TsYsUser;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface TsYsUserService {
// 增
int add(TsYsUser tsYsUser);
// 删
int delete(@Param("xinid") int id);
// 改
int update(TsYsUser tsYsUser);
// 全部查找
List<TsYsUser> getList(TsYsUser tsYsUser);
}
接口实现
package com.xinxi2.service.impl;
import com.xinxi2.bean.TsYsUser;
import com.xinxi2.dao.TsYsUserMapper;
import com.xinxi2.service.TsYsUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service("tsYsUserService")
public class TsYsUserServiceImpl implements TsYsUserService {
@Autowired // 自动按照类型注入
private TsYsUserMapper tsYsUserMapper;
@Override
public List<TsYsUser> getList(TsYsUser tsYsUser) {
return tsYsUserMapper.getList(tsYsUser);
}
@Override
public int add(TsYsUser tsYsUser) {
return tsYsUserMapper.add(tsYsUser);
}
@Override
public int update(TsYsUser tsYsUser) {
return tsYsUserMapper.update(tsYsUser);
}
@Override
public int delete(int id) {
return tsYsUserMapper.delete(id);
}
}
6.5 前端界面
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>用户列表</title>
</head>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css" integrity="sha384-HSMxcRTRxnN+Bdg0JdbxYKrThecOKuH5zCYotlSAcp1+c8xmyTe9GYg1l9a69psu" crossorigin="anonymous">
<body>
<div class="container">
<div class="row clearfix">
<h1>用户展示</h1><hr />
<div>
<div class="col-md-4">
<button type="button" class="btn btn-primary" >
<a href="${pageContext.request.contextPath}/tsYsUser/add" style="color: black;text-decoration-line: none">添加用户</a>
</button>
<button type="button" class="btn btn-primary" >
<a href="${pageContext.request.contextPath}/tsYsUser/list" style="color: black;text-decoration-line: none">显示全部用户</a>
</button>
</div>
<div class="col-md-4" style="float: right">
<form class="form-inline" action="/tsYsUser/list" method="post">
<span>用户名称</span>
<input type="text" class="form-control" placeholder="用户名称" name="realname">
<input type="submit" class="btn btn-primary" value="提交">
</form>
</div>
</div>
</div>
<div class="row clearfix">
<table class="table table-condensed table-striped">
<thead>
<tr>
<td>用户名</td>
<td>用户密码</td>
<td>操作</td>
</tr>
</thead>
<tbody>
<c:forEach var="u" items="${list}">
<tr>
<td>${u.realname}</td>
<td>${u.password}</td>
<td>
<a href="${pageContext.request.contextPath}/tsYsUser/toupdate?id=${u.id}">更新</a>
丨
<a href="${pageContext.request.contextPath}/tsYsUser/deleteTsYsUser/${u.id}">删除</a>
</td>
</tr>
</c:forEach>
</tbody>
</table>
</div>
</div>
</body>
</html>
七、测试运行
项目启动,跳到浏览器输入请求路径localhost:8080/tsYsUser/list