springmvc+mybatis整合

最新推荐文章于 2023-05-17 20:45:53 发布

yuan宝

最新推荐文章于 2023-05-17 20:45:53 发布

阅读量340

点赞数

分类专栏： springmvc 框架搭建文章标签： spring mvc mybaitis

本文链接：https://blog.csdn.net/weixin_39110767/article/details/78220245

版权

springmvc 同时被 2 个专栏收录

3 篇文章 0 订阅

订阅专栏

框架搭建

2 篇文章 0 订阅

订阅专栏

环境搭建
- 创建项目动态网络工程
- 引入jar包
- 全部jar包，包含MySql和Oracle驱动包
db.properties配置数据库连接文件

oracle_driver=oracle.jdbc.driver.OracleDriver
oracle_url=jdbc:oracle:thin:@localhost:1521:XE
oracle_username=system
oracle_password=dhee

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration SYSTEM "com/dhee/dtd/mybatis-3-config.dtd" >
<configuration>
    <settings>
        <!-- 开启驼峰命名规则，如果表中的列名为:employee_id,则mybatis可以自动对应到类中名为employeeId的成员变量 -->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>


</configuration>

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"
    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.3.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd">

    <!-- 配置自动扫描的包 -->
    <context:component-scan base-package="com.dhee.ssm"></context:component-scan>

    <!-- 配置视图解析器 如何把handler 方法返回值解析为实际的物理视图 -->
    <bean
        class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/views/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>

    <mvc:annotation-driven></mvc:annotation-driven>

    <mvc:default-servlet-handler></mvc:default-servlet-handler>
</beans>

applicationContext.xml加载数据源，在Spring添加mybatis，使用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"
    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">

    <!-- 加载db.properties -->
    <context:property-placeholder location="classpath:db.properties" />

    <!-- 配置数据源 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
        destroy-method="close">
        <property name="driverClass" value="${oracle_driver}" />
        <property name="jdbcUrl" value="${oracle_url}" />
        <property name="user" value="${oracle_username}" />
        <property name="password" value="${oracle_password}" />
    </bean>

    <!-- sqlSessionFactory(在Spring中添加mybatis) -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!-- 需要修改mybatis配置文件路径 -->
        <property name="configLocation" value="classpath:mybatis/mybatis-config.xml" />
    </bean>

    <!-- mapper扫描器(配置mybatis生成的接口与xxxMapper.xml文件的位置) -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!-- 需要修改位置,可能需要创建包 -->
        <property name="basePackage" value="com.dhee.ssm.mapper"></property>
    </bean>

    <!-- 使用spring的事务管理 -->
    <bean id="transactionManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    </bean>

    <!-- 通知 -->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <!-- 以下3种方法出现异常时需要rollback -->
            <tx:method name="insert*" propagation="REQUIRED" read-only="false"
                rollback-for="java.lang.Exception" />
            <tx:method name="delete*" propagation="REQUIRED" read-only="false"
                rollback-for="java.lang.Exception" />
            <tx:method name="update*" propagation="REQUIRED" read-only="false"
                rollback-for="java.lang.Exception" />
            <!-- 以下4种方法不需要进行事务管理 -->
            <tx:method name="find*" propagation="SUPPORTS" read-only="true" />
            <tx:method name="get*" propagation="SUPPORTS" read-only="true" />
            <tx:method name="select*" propagation="SUPPORTS" read-only="true" />
            <tx:method name="list*" propagation="SUPPORTS" read-only="true" />
        </tx:attributes>
    </tx:advice>

    <!-- aop,需要修改位置 -->
    <aop:config>
        <aop:advisor advice-ref="txAdvice"
            pointcut="execution(* com.dhee.springmvc.service.*.*(..))" />
    </aop:config>

    <!-- 自动扫描Service,需要修改位置 -->
    <!-- <context:component-scan base-package="com.dhee.springmvc.service"></context:component-scan> -->
</beans>

web.xml配置Spring，配置前端控制器，配置Spring自带的解决乱码的过滤器

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns="http://java.sun.com/xml/ns/javaee"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
    id="WebApp_ID" version="3.0">
    <display-name>testsystem</display-name>
    <welcome-file-list>

        <welcome-file>index.jsp</welcome-file>

    </welcome-file-list>

    <!-- 配置Spring -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:spring/applicationContext.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

    <!-- SpringMVC自带用于解决乱码的过滤器 -->
    <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>
    </filter>
    <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <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/springmvc.xml</param-value>
        </init-param>
    </servlet>
    <servlet-mapping>
        <servlet-name>dispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
</web-app>

用例驱动
- 向items表中插入输入的数据，成功跳转到success页面，页面显示success
- 页面定义
  - index.jsp

<body>
    <!-- name的命名必须和定义的实体类一致，
    其中实体类属性的命名要和数据库的保持一致 -->
    <form action="items/insertItems" method="post">
        <input type="text" name="itemsName"/>
        <input type="text" name="itemsPrice"/>
        <input type="text" name="itemsDetails"/>
        <input type="submit" value="插入"/>
    </form>

实体类创建
- Items.java

public class Items {
    private Short itemsId;

    private String itemsName;

    private BigDecimal itemsPrice;

    private String itemsDetails;

mapper定义
- ItemsCustomMapper.java

public interface ItemsCustomMapper {

    public void insert(Items items) throws Exception;

}

mapper对应的xml文件定义
- ItemsCustomMapper.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" >
<!-- namespace:指向对应的mapper接口 -->
<mapper namespace="com.dhee.ssm.mapper.ItemsCustomMapper" >
    <!-- id要和mapper接口定义的方法名保持一致
        parameterType：接收的数据类型 -->
    <insert id = "insert" parameterType="com.dhee.ssm.po.Items">
        insert into items (items_id,items_name,items_price,items_details)
        values (items_id_seq.nextval,#{itemsName},#{itemsPrice},#{itemsDetails})
    </insert>
</mapper>

service和controller的定义

@Service
public class ItemsInsertService {

    @Autowired
    private ItemsCustomMapper mapper;


    public void insert(Items items) throws Exception{
         mapper.insert(items);
    }


}

public class ItemsController {

    @Autowired
    private ItemsInsertService service;
    @RequestMapping(value="/insert")
    public String insert(Items record){
        try {

            service.insert(record);

        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return "success";
    }
}