SSM整合(SpringMVC、Spring、Mybatis)

一、先看看SSM的特点

最近在使用bootstrap 可视化编辑器,就像发现新大陆一样,好爽

所谓的MVC
  • M,模型层:service/dao/entity(基于mybatis)
  • V,视图层:JSP
  • C,控制层:controller(基于SpringMVC)

1、SpringMVC

  • 通过controller控制视图与后台交互

2、Spring

  • 控制反转IoC
    • 当你依赖其他对象,Spring会自动的帮你填充,降低耦合
  • 面向切面
    • 分离业务逻辑与其他服务操作,让应用专注于自己的业务
  • 容器
    • 管理对象的创建与生命周期

3、Mybatis

  • 通过Sql语句与映射文件操作数据库
  • 多表查询更加灵活

二、配置文件的基本配置(要导的包在最后面)

  • SpringMVC:springmvc.xml
  • Mybatis:mybatis.cfg.xml
  • web.xml
  • log4j.properties
1、springmvc.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" 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/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd
        http://www.springframework.org/schema/aop 
        http://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd">

    <!-- 读取properties配置文件 -->
    <bean id="propertiesLoad" 
            class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:log4j.properties" />
    </bean>

    <!-- 开启组件扫面注解解析器 -->
    <context:component-scan base-package="com.iamzhuwh"></context:component-scan>
    <!-- 开启IOC注解解析器 -->
    <context:annotation-config></context:annotation-config>

    <!-- 开启springmvc的注解解析器 :(包含了注解映射器和注解适配器) -->
    <mvc:annotation-driven></mvc:annotation-driven>

    <!--
        spring对象mybaits进行管理 :实例化Dao对象 实例化一个mapper接口扫描对象 会自动扫描basePackage包和子包下的所有Mapper接口,为Mapper接口生成代理对象 
        (代理被放入spring的容器),代理对象的id属性的值为 mapper接口名的第一个字母小写 要求: mapper接口和mapper文件,建议放入同一个目录,名字相同 
        如果有多个Mapper包,用逗号隔开
     -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.iamzhuwh.dao"></property>
        <property name="sqlSessionFactory" ref="sessionFactory"></property>
    </bean>

    <!-- 配置数据源对象 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <!-- 注入数据库连接池需要的属性信息 -->
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url"
            value="jdbc:mysql://localhost:3306/dinnersys?characterEncoding=utf8"></property>
        <property name="username" value="zhu"></property>
        <property name="password" value="zhu"></property>

        <property name="maxActive" value="20"></property>
        <property name="initialSize" value="5"></property>
    </bean>

    <!-- 实例化SqlSessionFactory -->
    <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--给sessionFactory注入数据源对象 -->
        <property name="dataSource" ref="dataSource"></property>
        <!-- 加载mybatis的主配置文件 -->
        <property name="configLocation" value="classpath:mybatis.cfg.xml"></property>
    </bean>

     <!-- 实例化事务管理器对象 -->
     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <!-- 给事务管理器,注入数据源对象 -->
        <property name="dataSource" ref="dataSource"></property>
     </bean>

    <!-- 配置声明式事务 -->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="*" isolation="DEFAULT" propagation="REQUIRED"
                rollback-for="java.lang.Exception" />
            <tx:method name="login" read-only="true" />
            <tx:method name="get*" read-only="true" />
        </tx:attributes>
    </tx:advice>

    <!-- 配置切入点 PointCut -->
    <aop:config>
        <aop:pointcut expression="execution (* com.iamzhuwh.service.*.* (..))" id="pointcut" />
        <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut" />
    </aop:config>

</beans>
2、mybatis.cfg.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>
    <!-- 配置SQL映射文件 -->
    <mappers>
        <mapper resource="com/iamzhuwh/dao/mapper-dinnerTable.xml"/>
    </mappers>
</configuration>
3、web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
  <display-name>SSM</display-name>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>

  <!-- 配置springmvc的核心控制器  前端控制器-->
  <servlet>
    <servlet-name>contextConfigLocation</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:springmvc.xml</param-value>
    </init-param>
  </servlet>

  <servlet-mapping>
    <servlet-name>contextConfigLocation</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>

  <!-- 配置springmvc的编码器-->
   <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>
4、log4j.properties
log4j.rootLogger=debug,stdout,logfile
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.SimpleLayout
log4j.appender.logfile=org.apache.log4j.FileAppender
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %F %p %m%n
log4j.logger.com.nes=TRACE
log4j.logger.com.ibatis=DEBUG
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG

三、重头戏,使用

  • 对象通过注解交给Spring管理
  • mybatis的事务交给Spring管理
  • 使用mybatis的dao动态代理
1、实体:DinnerTable
public class DinnerTable implements Serializable{
    private int id; //INT AUTO_INCREMENT PRIMARY KEY,
    private int table_id; //INT UNIQUE, -- 编号
    private String table_name; //VARCHAR(20) UNIQUE, -- 桌名
    private int reservation_status; //INT DEFAULT 0, -- 状态
    private Date reservation_time; //DATETIME -- 预定时间
    ...省略get、set方法
}
//对应数据库
CREATE TABLE dinner_table(
    id INT AUTO_INCREMENT PRIMARY KEY,
    table_id INT, -- 编号
    table_name VARCHAR(20), -- 桌名
    reservation_status INT DEFAULT 0, -- 状态
    reservation_time DATETIME -- 预定时间
);
2、mybatis代理的dao与映射文件
  • 方法名要与映射文件的id一一对应
//接口:DinnerTableDao.java
public interface DinnerTableDao {
    List<DinnerTable> selectAllTables();
    int insert(DinnerTable dinnerTable);
}

//mapper-dinnerTable.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.iamzhuwh.dao.DinnerTableDao">
    <select id="selectAllTables" resultType="com.iamzhuwh.entity.DinnerTable">
        select * from dinner_table
    </select>

    <insert id="insert" parameterType="com.iamzhuwh.entity.DinnerTable">
        insert into dinner_table(table_id,table_name) values(#{table_id},#{table_name})
    </insert>
</mapper>
3、service层
//接口:DinnerTableService
public interface DinnerTableService {
    List<DinnerTable> selectAllTables()throws Exception;
    boolean insert(DinnerTable dinnerTable)throws Exception;
}

//实现类:DinnerTableServiceImpl
//要声明Component,如果有别的地方需要这个类,Spring会找这里,然后创建对象给对方
@Component("dinnerTableService")
public class DinnerTableServiceImpl implements DinnerTableService {

    //自动注入声明了Component的DinnerTableDao
    @Autowired
    DinnerTableDao dinnerTableDao;

    public DinnerTableDao getDinnerTableDao() {
        return dinnerTableDao;
    }

    public void setDinnerTableDao(DinnerTableDao dinnerTableDao) {
        this.dinnerTableDao = dinnerTableDao;
    }

    @Override
    public List<DinnerTable> selectAllTables() throws Exception{
        try {
            return dinnerTableDao.selectAllTables();
        } catch (Exception e) {
            e.printStackTrace();
            throw e;
        }
    }

    @Override
    public boolean insert(DinnerTable dinnerTable) throws Exception{
        try {
            int insert = dinnerTableDao.insert(dinnerTable);
            return insert>0?true:false;
        } catch (Exception e) {
            e.printStackTrace();
            throw e;
        }
    }

}
4、最终的调用者,Controller
@Controller //声明自己是一个Controller,SpringMVC才会给予前端交互
@RequestMapping("/table") //地址拼接
public class DinnerTableController {

    //自动注入声明了Component的DinnerTableService
    @Autowired
    DinnerTableService dinnerTableService;

    public DinnerTableService getDinnerTableService() {
        return dinnerTableService;
    }

    public void setDinnerTableService(DinnerTableService dinnerTableService) {
        this.dinnerTableService = dinnerTableService;
    }

    @RequestMapping("/contents") //地址拼接
    public String selectAllTables(HttpSession httpSession){
        String result = "/error.jsp";
        try {
            List<DinnerTable> selectAllTables = dinnerTableService.selectAllTables();
            System.out.println("from DinnerTableController,selectAllTables:"+selectAllTables);
            if(selectAllTables.size()>0)result = "/success.jsp";
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;
    }

    @RequestMapping("/insert") //地址拼接
    public String insert(DinnerTable dinnerTable){
        String result = "/error.jsp";
        try {
            boolean insert = dinnerTableService.insert(dinnerTable);
            System.out.println("from DinnerTableController,insert:"+insert);
            if(insert)result = "/success.jsp";
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;
    }
}
5、测试页面
//index.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title></title></head><body>
<form action="${pageContext.request.contextPath}/table/contents">
    <input type="submit" value="getContents">
</form>
<form action="${pageContext.request.contextPath}/table/insert">
    <input type="text" name="table_id" value="12345">
    <input type="text" name="table_name" value="zhu">
    <input type="submit" value="insert">
</form></body></html>

//error.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title></title></head><body>
失败
</body></html>

//success.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title></title></head><body>
成功
</body></html>

四、项目结构(记得导包)

├─config
│      log4j.properties
│      mybatis.cfg.xml
│      springmvc.xml
│
├─src
│  └─com
│      └─iamzhuwh
│          ├─controller
│          │      DinnerTableController.java
│          │
│          ├─dao
│          │      DinnerTableDao.java
│          │      mapper-dinnerTable.xml
│          │
│          ├─entity
│          │      DinnerTable.java
│          │
│          ├─service
│          │  │  DinnerTableService.java
│          │  │
│          │  └─impl
│          │          DinnerTableServiceImpl.java
│          │
│          └─utils
│                  MyDBUtil.java
│
└─WebContent
    │  error.jsp
    │  index.jsp
    │  success.jsp
    │
    ├─META-INF
    │      MANIFEST.MF
    │
    └─WEB-INF
        │  web.xml
        │
        └─lib
                aopalliance.jar
                asm-3.3.1.jar
                aspectjweaver.jar
                commons-dbcp-1.4.jar
                commons-logging.jar
                commons-pool-1.6.jar
                log4j-1.2.16.jar
                mybatis-3.2.7.jar
                mybatis-spring-1.2.2.jar
                mysql-connector-java-5.1.7-bin.jar
                slf4j-api-1.5.8.jar
                slf4j-log4j12.jar
                spring-aop-4.1.6.RELEASE.jar
                spring-aspects-4.1.6.RELEASE.jar
                spring-beans-4.1.6.RELEASE.jar
                spring-context-4.1.6.RELEASE.jar
                spring-context-support-4.1.6.RELEASE.jar
                spring-core-4.1.6.RELEASE.jar
                spring-expression-4.1.6.RELEASE.jar
                spring-instrument-4.1.6.RELEASE.jar
                spring-instrument-tomcat-4.1.6.RELEASE.jar
                spring-jdbc-4.1.6.RELEASE.jar
                spring-jms-4.1.6.RELEASE.jar
                spring-messaging-4.1.6.RELEASE.jar
                spring-orm-4.1.6.RELEASE.jar
                spring-oxm-4.1.6.RELEASE.jar
                spring-test-4.1.6.RELEASE.jar
                spring-tx-4.1.6.RELEASE.jar
                spring-web-4.1.6.RELEASE.jar
                spring-webmvc-4.1.6.RELEASE.jar
                spring-webmvc-portlet-4.1.6.RELEASE.jar
                spring-websocket-4.1.6.RELEASE.jar
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值