目录
4.2 mapper.java接口(UserMapper.java)
4.3 Mapper.xml文件(UserMapper.xml)
8. Contrller层(UserController.java)
10. springmvc配置(spring-mvc.xml)
SSM 整合
查询account表中所有账户的信息。
1. 整合思路
spring将各层进行整合,通过spring管理持久层mapper(相当于dao接口);通过spring管理业务层service(其中可以调用mapper接口);spring进行事务控制;通过spring管理表现层Handler,(其中可以调用service接口)。(mapper,service,Handler都是javabean)
第一步:整合dao层
mybatis和spring整合,通过spring管理mapper接口。使用mapper的扫描器自动扫描mapper接口在spring中进行注册。
第二步:整合service层
通过spring管理service接口。使用配置方式将service接口配置在spring配置文件中。实现事务控制。
第三步:整合springmvc
由于springmvc是spring的模块,不需要整合。
2. 数据准备
2.1 创建表user
CREATE TABLE `account` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`varchar(32) NOT NULL COMMENT '用户名称',
`money` int(100) DEFAULT NULL COMMENT '余额',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8
2.2 添加数据
insert into account(id,name,money) values(1,'dou',10000);
3. 依赖Jar包
依赖jar中需要包含spring的核心jar,mysql的驱动jar,mybatis的相关jar,spring和mybatis的整合jar。
<!--spring核心依赖-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.3.5.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.3.5.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.5.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>4.3.5.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>4.3.5.RELEASE</version>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.13</version>
</dependency>
<dependency>
<groupId>aopalliance</groupId>
<artifactId>aopalliance</artifactId>
<version>1.0</version>
</dependency>
<!--SpringMVC依赖-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.5.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>4.3.5.RELEASE</version>
</dependency>
<dependency>
<groupId>commons-logging</groupId>
<artifactId>commons-logging</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
</dependency>
<!--mybatis 依赖-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.1</version>
</dependency>
<!--mysql数据库驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.39</version>
</dependency>
<!--mybatis和spring整合-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.5.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>4.3.5.RELEASE</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.18</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
<!--c3p0连接池-->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
4. 开发dao层
4.1 在mybatis-config.xml文件中
在resources目录下创建mybatis-config.xml来作为mybatis配置文件。
<?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>
<!-- 全局setting配置,根据需要添加 -->
<!-- 配置mapper
由于使用spring和mybatis的整合包进行mapper扫描,这里不需要配置了。
但是必须遵循:mapper.xml和mapper.java文件同名且在一个目录
-->
<!-- <mappers></mappers> -->
</configuration>
4.2 mapper.java接口(UserMapper.java)
public interface UserMapper {
public List<User1> selectAllUsers();
}
4.3 Mapper.xml文件(UserMapper.xml)
在配置文件目录resources下创建mapper目录,专门用来存储sql的配置文件。
<?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.jing.dao.UserMapper">
<!--
需求查询所有用户信息
查询操作:select
-->
<select id="selectAllUsers" resultType="com.jing.pojo.User1" >
select * from account;
</select>
</mapper>
5. 实体类(User.java)
public class User1 {
private Integer id;
private String name;
private Integer money;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getMoney() {
return money;
}
public void setMoney(Integer money) {
this.money = money;
}
@Override
public String toString() {
return "User1{" +
"id=" + id +
", name='" + name + '\'' +
", money=" + money +
'}';
}
}
6. spring-config.xml
在resources目录下创建spring-config.xml文件,通过spring容器来管理对象
<?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"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd">
<!--开启注解,通过扫描com.tulun路径下的所有的注解-->
<context:component-scan base-package="com.jing"/>
<!--数据源-->
<!--c3p0连接-->
<bean id="dataSource1" class="com.mchange.v2.c3p0.DriverManagerDataSource">
<!--配置数据连接的核心配置-->
<property name="driverClass" value="com.mysql.jdbc.Driver"/>
<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/jing"/>
<property name="user" value="root"/>
<property name="password" value="123456"/>
</bean>
<!--
sqlSessionFactory配置
org.mybatis.spring.SqlSessionFactoryBean类来实例化sqlSessionFactory对象
-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--属性注入:数据源-->
<property name="dataSource" ref="dataSource1"/>
<!--读取mybatis的配置文件-->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
<!--读取mapper.xml文件-->
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
</bean>
<!--动态代理对象org.mybatis.spring.mapper.MapperFactoryBean-->
<bean class="org.mybatis.spring.mapper.MapperFactoryBean">
<!--接口-->
<property name="mapperInterface" value="com.jing.dao.UserMapper"/>
<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
</bean>
</beans>
7. Service层(UserService.java)
Service层调用dao层获取数据,而dao层到数据库获取结果进行返回。
/**
* service层调用dao层实现
*/
@Service
public class UserService {
//注入dao层依赖
@Autowired
private UserMapper userMapper;
//获取所有用户信息
public List<User1> findUsers(){
return userMapper.selectAllUsers();
}
}
8. Contrller层(UserController.java)
Controller调用service层提供的相应功能的方法进行业务逻辑处理。
@Controller
public class UserController {
//注入service层
@Autowired
private UserService userService;
@RequestMapping("/userlist")
public ModelAndView userList(){
List<User1> users = userService.findUsers();
ModelAndView modelAndView = new ModelAndView();
modelAndView.addObject("users",users);
modelAndView.setViewName("userList");
return modelAndView;
}
}
9. 前端页面(userList.jsp)
<%--
Created by IntelliJ IDEA.
User: dell
Date: 2021/11/14
Time: 16:25
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>account表数据展示</title>
</head>
<body>
<table align="center" width="50%" border="3">
<thead>
<tr>
<td align="center">用户id</td>
<td align="center">用户名</td>
<td align="center">余额</td>
</tr>
</thead>
<tbody>
<%--c:forEach --%>
<c:forEach items="${users}" var="users">
<%--var集合--%>
<tr>
<td align="center">${users.id}</td>
<td align="center">${users.name}</td>
<td align="center">${users.money}</td>
</tr>
</c:forEach>
</tbody>
</table>
</form>
</body>
</html>
10. springmvc配置(spring-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: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-4.1.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd">
<!--扫描Controller等web注解-->
<context:component-scan base-package="com.jing.contrller"/>
<!--采用注解方式,加载默认的处理器-->
<mvc:annotation-driven/>
<!--视图解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
<!--URL前缀-->
<property name="prefix" value="WEB-INF/jsp/"/>
<!--URL后缀-->
<property name="suffix" value=".jsp"/>
</bean>
</beans>
11. 配置web.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" 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_2_5.xsd">
<!-- 加载spring容器:Spring和mybatis的配置文件 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-config.xml</param-value>
</context-param>
<!--监听器在启动时进行spring配置-->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- springMvc前端控制器配置 -->
<servlet>
<servlet-name>SSM</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mvc.xml</param-value>
</init-param>
<!-- load-on-startup:表示servlet随服务启动; -->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>SSM</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
运行结果截图
web代码运行需要部署的服务器上,常见的web服务器有Tomcat、jetty。Jetty属于轻量级服务器,启动块。这里以jetty来使用部署服务,在idea中直接以插件的形式来添加jetty服务器,比较方便,关于具体的引入及配置可以看
SpringMVC | SpringMVC的使用(通过IDEA从零搭建项目)_quwenjing_blog-CSDN博客
项目结构目录
以上都是学习过程中的整理的笔记,会持续更新,如果有错误或者有疑问,欢迎一起交流吖~~