SSM整合小项目

最新推荐文章于 2024-08-10 10:30:00 发布

kickmyeyes

最新推荐文章于 2024-08-10 10:30:00 发布

阅读量142

点赞数 2

分类专栏：框架文章标签： ssm spring springmvc mybatis

本文链接：https://blog.csdn.net/qq_50048558/article/details/121387058

版权

框架专栏收录该内容

7 篇文章 0 订阅

订阅专栏

一、实现SSM框架整合

1.需求和步骤分析

需求
　使用SSM框架完成对 account 表的增删改查操作。
步骤分析

准备数据库和表记录
创建web项目
编写mybatis在ssm环境中可以单独使用
编写spring在ssm环境中可以单独使用
spring整合mybatis
编写springMVC在ssm环境中可以单独使用
spring整合springMVC

2.环境搭建

①准备数据库和表记录

CREATE TABLE `account` (
	id int(11) NOT NULL AUTO_INCREMENT,
	name varchar(32) DEFAULT NULL,
	money double DEFAULT NULL,
	PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

insert into account(id,name,money) values (1,'tom',1000),(2,'jerry',1000);

②创建web项目

3.编写mybatis在ssm环境中可以单独使用

需求：基于mybatis先来实现对account表的查询

①相关坐标

<!--mybatis坐标-->
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>5.1.47</version>
</dependency>
<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid</artifactId>
	<version>1.1.15</version>
</dependency>
<dependency>
	<groupId>org.mybatis</groupId>
	<artifactId>mybatis</artifactId>
	<version>3.5.1</version>
</dependency>
<dependency>
	<groupId>junit</groupId>
	<artifactId>junit</artifactId>
	<version>4.12</version>
</dependency>

②Account实体

public class Account {
	private Integer id;
	private String name;
	private Double money;
	getter/setter方法
	toString方法
}

③AccountDao接口

public interface AccountDao {
	public List<Account> findAll();
}

④AccountDao.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 namespace="com.ssm.dao.AccountDao">
    <select id="findAll" resultType="Account">
        select * from account
    </select>
</mapper>

⑤mybatis核心配置文件

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/spring_db
jdbc.username=root
jdbc.password=root

SqlMapConfig.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>
    <!--加载properties文件-->
    <properties resource="jdbc.properties"/>
    <!--类型设置别名-->
    <typeAliases>
        <package name="com.ssm.domain"/>
    </typeAliases>
    <!--配置数据源-->
    <environments default="dev">
        <environment id="dev">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <!--加载映射-->
    <mappers>
        <package name="com.ssm.dao"/>
    </mappers>
</configuration>

⑥测试代码

public class MybatisTest {
    @Test
    public void testMybatis() throws IOException {
        // 加载核心配置文件
        InputStream resourceAsStream = Resources.getResourceAsStream("SqlMapConfig.xml");
        // 获得sqlsession工厂对象
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        // 获得sqlsession会话对象
        SqlSession sqlSession = sqlSessionFactory.openSession();
        // 获得mapper代理对象
        AccountDao mapper = sqlSession.getMapper(AccountDao.class);
        List<Account> all = mapper.findAll();
        for (Account account : all) {
            System.out.println(account);
        }
        // 释放资源
        sqlSession.close();
    }
}

4.编写spring在ssm环境中可以单独使用

①相关坐标

<!--spring坐标-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.1.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.8.13</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.1.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.1.5.RELEASE</version>
        </dependency>
        <dependency>
        <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.1.5.RELEASE</version>
        </dependency>

②AccountService接口

public interface AccountService {
	public List<Account> findAll();
}

③AccountServiceImpl实现

@Service
public class AccountServiceImpl implements AccountService {
	@Override
	public List<Account> findAll() {
		//测试单独使用spring
		System.out.println("findAll方法执行了....");
		return null;
	}
}

④spring核心配置文件

applicationContext.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:tx="http://www.springframework.org/schema/tx"
       xmlns:aop="http://www.springframework.org/schema/aop"
       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">
    
    <!--配置IOC相关操作：开启注解扫描 -->
    <context:component-scan base-package="com.ssm.service"/>
</beans>

⑤测试代码

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class SpringTest {
    @Autowired
    private AccountService accountService;
    @Test
    public void testSpring(){
        accountService.findAll();
    }
}

5.spring整合mybatis

①整合思想

将mybatis接口代理对象的创建权交给spring管理，我们就可以把dao的代理对象注入到service中，
此时也就完成了spring与mybatis的整合了。

②导入整合包

<!--mybatis整合spring坐标-->
<dependency>
	<groupId>org.mybatis</groupId>
	<artifactId>mybatis-spring</artifactId>
	<version>1.3.1</version>
</dependency>

③spring配置文件管理mybatis

注意：此时可以将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:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:aop="http://www.springframework.org/schema/aop"
       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">

    <!--配置IOC相关操作：开启注解扫描 -->
    <context:component-scan base-package="com.ssm.service"/>
    <!--引入properties文件-->
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <!--配置DataSource数据源-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
    <!--sqlSessionFactory的创建权交给spring 生产sqlSession-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <!--设置别名-->
        <property name="typeAliasesPackage" value="com.ssm.domain"/>
        <!--引入加载mybatis核心配置文件  可以不用加载-->
        <!--<property name="configLocation" value="classpath:SqlMapConfig.xml"/>-->
    </bean>
    <!--mapper映射扫描 MapperScannerConfigurer扫描该包下的所有接口 生成代理对象存到IOC容器中-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.ssm.dao"/>
    </bean>
</beans>

④修改AccountServiceImpl

@Service
public class AccountServiceImpl implements AccountService {
	@Autowired
	private AccountDao accountDao;
	@Override
	public List<Account> findAll() {
		return accountDao.findAll();
	}
}

6.编写springMVC在ssm环境中可以单独使用

需求：访问到controller里面的方法查询所有账户，并跳转到list.jsp页面进行列表展示

①相关坐标

<!--springMVC坐标-->
<dependency>
	<groupId>org.springframework</groupId>
	<artifactId>spring-webmvc</artifactId>
	<version>5.1.5.RELEASE</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.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>

②导入页面资源

在这里插入图片描述

③前端控制器DispathcerServlet

<?xml version="1.0" encoding="UTF-8"?>
<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_4_0.xsd"
         version="4.0">
    
    <!--前端控制器-->
    <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:spring-mvc.xml</param-value>
        </init-param>
        <load-on-startup>2</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>DispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
    
    <!--中文乱码过滤器： 解决post方式提交的乱码-->
    <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>
    </filter>
    <filter-mapping>
        <filter-name>CharacterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
</web-app>

④AccountController和 list.jsp

@Controller
@RequestMapping("/account")
public class AccountController {
    @RequestMapping("/findAll")
    public String findAll(Model model){
        List<Account> list = new ArrayList<>();
        list.add(new Account(1,"张三",1000d));
        list.add(new Account(2,"李四",1000d));
        model.addAttribute("list", list);
        return "list";
    }
}

<c:forEach items="${list}" var="account">
	<tr>
		<td>
			<input type="checkbox" name="ids">
		</td>
		<td>${account.id}</td>
		<td>${account.name}</td>
		<td>${account.money}</td>
		<td>
			<a class="btn btn-default btn-sm" href="update.jsp">修改</a>&nbsp;
			<a class="btn btn-default btn-sm" href="">删除</a>
		</td>
	</tr>
</c:forEach>

⑤springMVC核心配置文件

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       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
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd">

    <!--1.开启注解扫描-->
    <context:component-scan base-package="com.lagou.controller"/>
    <!--2.mvc注解增强-->
    <mvc:annotation-driven></mvc:annotation-driven>
    <!--3.视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
    <!--4.放行静态资源-->
    <mvc:default-servlet-handler/>
</beans>

7.spring整合springMVC

①整合思想

spring和springMVC其实根本就不用整合，本来就是一家。
但是我们需要做到spring和web容器整合，让web容器启动的时候自动加载spring配置文件，web容器销毁的时候spring的ioc容器也销毁。

②spring和web容器整合

ContextLoaderListener加载
可以使用spring-web包中的ContextLoaderListener监听器，可以监听servletContext容器的创建和销毁，来同时创建或销毁IOC容器。

<!--spring 与 web容器整合-->
<listener>
	<listener-class>
		org.springframework.web.context.ContextLoaderListener
	</listener-class>
</listener>
<context-param>
	<param-name>contextConfigLocation</param-name>
	<param-value>classpath:applicationContext.xml</param-value>
</context-param>

③修改AccountController

@Controller
@RequestMapping("/account")
public class AccountController {
	@Autowired
	private AccountService accountService;
	@RequestMapping("/findAll")
	public String findAll(Model model) {
		List<Account> list = accountService.findAll();
		model.addAttribute("list", list);
		return "list";
	}
}

8.spring配置声明式事务

①spring配置文件加入声明式事务

<!--spring的声明式事务-->
    <!--1.配置事务管理器-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    <!--2.开启事务注解支持-->
    <tx:annotation-driven/>

@Service
@Transactional
public class AccountServiceImpl implements AccountService {
}

②add.jsp

			<form action="${pageContext.request.contextPath}/account/save" method="post">
                <div class="form-group">
                    <label for="name">姓名：</label>
                    <input type="text" class="form-control" id="name" name="name" placeholder="请输入姓名">
                </div>
                      <div class="form-group">
                    <label for="money">余额：</label>
                    <input type="text" class="form-control" id="money" name="money" placeholder="请输入余额">
                </div>

                <div class="form-group" style="text-align: center">
                    <input class="btn btn-primary" type="submit" value="提交" />
                    <input class="btn btn-default" type="reset" value="重置" />
                    <input class="btn btn-default" type="button" onclick="history.go(-1)" value="返回" />
                </div>
            </form>

③AccountController

@RequestMapping("/save")
public String save(Account account){
	accountService.save(account);
	return "redirect:/account/findAll";
}

④AccountService接口和实现类

public void save(Account account);

@Service
@Transactional
public class AccountServiceImpl implements AccountService {
	@Override
	public void save(Account account) {
		accountDao.save(account);
	}
}

⑤AccountDao

public void save(Account account);

⑥AccountDao.xml映射

<insert id="save" parameterType="Account">
	insert into account (name, money) values (#{name}, #{money})
</insert>

9.修改操作

①数据回显

a. AccountController

@RequestMapping("/findById")
public String findById(Integer id, Model model) {
	Account account = accountService.findById(id);
	model.addAttribute("account", account);
	return "update";
}

b. AccountService接口和实现类

public Account findById(Integer id);

@Override
public Account findById(Integer id) {
	return accountDao.findById(id);
}

c. AccountDao接口和映射文件

public Account findById(Integer id);

<select id="findById" parameterType="int" resultType="Account">
	select * from account where id = #{id}
</select>

d. update.jsp

			<form action="${pageContext.request.contextPath}/account/update" method="post">
                <%--隐藏回显ID的input框--%>
                <input type="hidden" name="id" value="${account.id}">
                <div class="form-group">
                    <label for="name">姓名：</label>
                    <input type="text" class="form-control" id="name" name="name" value="${account.name}" placeholder="请输入姓名">
                </div>
                <div class="form-group">
                    <label for="money">余额：</label>
                    <input type="text" class="form-control" id="money" name="money"  value="${account.money}" placeholder="请输入余额">
                </div>

                <div class="form-group" style="text-align: center">
                    <input class="btn btn-primary" type="submit" value="提交" />
                    <input class="btn btn-default" type="reset" value="重置" />
                    <input class="btn btn-default" type="button" onclick="history.go(-1)" value="返回" />
                </div>
            </form>

②账户更新

a. AccountController

@RequestMapping("/update")
public String update(Account account){
	accountService.update(account);
	return "redirect:/account/findAll";
}

b. AccountService接口和实现类

public void update(Account account);

@Override
public void update(Account account) {
	accountDao.update(account);
}

c. AccountDao接口和映射文件

public void update(Account account);

<update id="update" parameterType="Account">
	update account set name = #{name},money = #{money} where id = #{id}
</update>

10.批量删除

①list.jsp

<script>
    /*给删除选中按钮绑定点击事件*/
    $('#deleteBatchBtn').click(function () {
            if(confirm('您确定要删除吗')){
                if($('input[name=ids]:checked').length > 0){
                    /*提交表单*/
                    $('#deleteBatchForm').submit();
                }
            }else {
                alert('想啥呢，没事瞎操作啥')
            }
    })
</script>

②AccountController

@RequestMapping("/deleteBatch")
public String deleteBatch(Integer[] ids) {
	accountService.deleteBatch(ids);
	return "redirect:/account/findAll";
}

③AccountService接口和实现类

public void deleteBatch(Integer[] ids);

@Override
public void deleteBatch(Integer[] ids) {
	accountDao.deleteBatch(ids);
}

④AccountDao接口和映射文件

public void deleteBatch(Integer[] ids);

	<!--批量删除-->
    <delete id="deleteBatch" parameterType="int">
        delete from account
        <where>
            <foreach collection="array" open="id in(" close=")" separator="," item="id">
                #{id}
            </foreach>
        </where>
    </delete>