spring与mybatis整合实例

- 日理万妓 2022-06-09 00:58 189阅读 0赞

spring与mybatis整合实例

在接触了一个后台需求之后，自己搭建了一个spring与mybatis框架项目，这里就与大家分享一下，所搭建的工程为maven工程，首先来看下代码结构，还是不太规范，对于配置文件的包有需要童鞋可自行建立规范的方式。

一、代码结构

![20170823175226345][]

二、所搭建的项目是maven工程，pom.xml包配置如下

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.starit.collection</groupId> <artifactId>gzzc-spring-mybatis</artifactId> <version>0.0.1-SNAPSHOT</version> <dependencies> <dependency> <groupId>io.netty</groupId> <artifactId>netty-all</artifactId> <version>5.0.0.Alpha2</version> </dependency>  <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>1.7.2</version> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-core</artifactId> <version>1.0.13</version> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-classic</artifactId> <version>1.0.13</version> </dependency>  <dependency> <groupId>org.apache.kafka</groupId> <artifactId>kafka-clients</artifactId> <version>0.10.0.1</version> </dependency>  <dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> <version>1.2.28</version> </dependency>  <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>4.3.7.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context-support</artifactId> <version>4.3.7.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>4.3.7.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>4.3.7.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>4.3.7.RELEASE</version> <scope>test</scope> </dependency>  <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc6</artifactId> <version>11.2.0.1.0</version> </dependency> <dependency> <groupId>proxool</groupId> <artifactId>proxool</artifactId> <version>0.9.1</version> </dependency> <dependency> <groupId>proxool</groupId> <artifactId>proxool-cglib</artifactId> <version>0.9.1</version> </dependency>  <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.0</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.3.0</version> <exclusions> <exclusion> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> </exclusion> <exclusion> <groupId>org.springframework</groupId> <artifactId>spring-beans</artifactId> </exclusion> <exclusion> <groupId>org.springframework</groupId> <artifactId>spring-core</artifactId> </exclusion> <exclusion> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> </exclusion> <exclusion> <groupId>org.springframework</groupId> <artifactId>spring-expression</artifactId> </exclusion> <exclusion> <groupId>org.springframework</groupId> <artifactId>spring-aop</artifactId> </exclusion> </exclusions> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-surefire-plugin</artifactId> <configuration> <skip>true</skip> </configuration> </plugin> <plugin> <groupId>org.codehaus.mojo</groupId> <artifactId>exec-maven-plugin</artifactId> <configuration> <executable>java</executable> <mainClass>com.starit.ipran.socket.ServerStart</mainClass> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-jar-plugin</artifactId> <configuration> <excludes> <exclude>*.xml</exclude> </excludes> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-assembly-plugin</artifactId> <configuration> <descriptors> <descriptor>src/main/assembly/assembly.xml</descriptor> </descriptors> </configuration> <executions> <execution> <id>make-assembly</id> <phase>package</phase> <goals> <goal>single</goal> </goals> </execution> </executions> </plugin> </plugins> </build> </project>

三、spring与mybatis集成，spring-mybatis.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:p="http://www.springframework.org/schema/p" 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-3.1.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">  <context:component-scan base-package="com.cn.hnust" />  <context:property-placeholder location="classpath:jdbc.properties" />  <bean id="dataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource">         <property name="driver" value="${db.driverName}" />         <property name="driverUrl" value="${db.url}" />         <property name="user" value="${db.username}" />         <property name="password" value="${db.password}" />         <property name="alias" value="${db.alias}" />         <property name="houseKeepingTestSql" value="${db.testSql}" />         <property name="trace" value="true" />         <property name="testBeforeUse" value="true" />     </bean>  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" />  <property name="mapperLocations" value="classpath:IpranAlarmInfoMapper.xml"></property> </bean>  <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.starit.ipran.dao" /> <property name="sqlSessionFactory" ref="sqlSessionFactory"></property> </bean>  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource" /> </bean> </beans>

ps:jdbc.properties数据库信息文件的内容格式为：

db.driverName=oracle.jdbc.OracleDriver db.url=jdbc:oracle:thin:@127.0.0.1:8765:gzzc db.username=spirits db.password=spirits2017test db.alias=spirits db.maxActiveTime=3600000 db.maxConnCount=50 db.minConnCount=1 db.testSql=select 'x' from DUAL hibernate.dialect=org.hibernate.dialect.OracleDialect hibernate.show_sql=true

四、IpranAlarmInfoDao.java dao层

package com.starit.ipran.dao;
     import java.util.List; import org.apache.ibatis.annotations.Param; import com.starit.ipran.model.IpranAlarm; public interface IpranAlarmInfoDao { /** * 插入告警 * @param ipranAlarm * @return */ public boolean insertAlarm(IpranAlarm ipranAlarm); /** * 查询告警 * @param serialId * @param alarmStatus * @return */ public List<IpranAlarm> queryAlarm(IpranAlarm ipranAlarm); /** * 查询告警 与当前告警状态不一样的 * @param serialId * @param alarmStatus * @return */ public List<IpranAlarm> queryAlarmStatusNotCurrent(IpranAlarm ipranAlarm); /** * 更新告警状态 更新与当前告警状态不相同的 * @param serialId * @param alarmStatus * @return */ public boolean updateAlarmStatusNotCurrent(IpranAlarm ipranAlarm); /** * 更新告警次数 * @param serialId * @param alarmCount * @return */ public boolean updateAlarmCount(IpranAlarm ipranAlarm); }

需要注意的是dao层的方法名应该与mapper.xml里面的sql语句的id相对应一致，在mapper.xml里面相应地也会标红。  
五、IpranAlarmInfoMapper.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.starit.ipran.dao.IpranAlarmInfoDao" > <resultMap id="BaseResultMap" type="com.starit.ipran.model.IpranAlarm" > <result column="ID" property="id" jdbcType="DECIMAL" /> <result column="SERIAL_ID" property="serialId" jdbcType="VARCHAR" /> <result column="NE_ID" property="neId" jdbcType="VARCHAR" /> <result column="NECITY" property="necity" jdbcType="VARCHAR" /> <result column="NE_IP" property="neIp" jdbcType="VARCHAR" /> <result column="ALARM_CAT" property="alarmCat" jdbcType="VARCHAR" /> <result column="ALARM_NAME" property="alarmName" jdbcType="VARCHAR" /> <result column="ALARM_LEVEL" property="alarmLevel" jdbcType="VARCHAR" /> <result column="ALARM_STATUS" property="alarmStatus" jdbcType="VARCHAR" /> <result column="ALARM_DETAIL" property="alarmDetail" jdbcType="VARCHAR" /> <result column="ALARM_AFFECTION" property="alarmAffection" jdbcType="VARCHAR" /> <result column="ALARM_TIME" property="alarmTime" jdbcType="VARCHAR" /> <result column="UPDATE_TIME" property="updateTime" jdbcType="VARCHAR" /> <result column="CLEARED_TIME" property="clearedTime" jdbcType="VARCHAR" /> <result column="ALARM_COUNT" property="alarmCount" jdbcType="DECIMAL" /> <result column="FLAG" property="flag" jdbcType="DECIMAL" /> <result column="BATCH" property="batch" jdbcType="DECIMAL" /> <result column="ENTRY_TIME" property="entryTime" jdbcType="VARCHAR" /> <result column="COMPARE_ID" property="compareId" jdbcType="VARCHAR" /> </resultMap> <insert id="insertAlarm" parameterType="com.starit.ipran.model.IpranAlarm" > insert into STG_INM.IN_IPRAN_ALARM (ID, SERIAL_ID, NE_ID, NECITY, NE_IP, ALARM_CAT, ALARM_NAME, ALARM_LEVEL, ALARM_STATUS, ALARM_DETAIL, ALARM_AFFECTION, ALARM_TIME, UPDATE_TIME, CLEARED_TIME, ALARM_COUNT, FLAG, BATCH, ENTRY_TIME, COMPARE_ID) values (STG_INM.IN_IPRAN_ALARM_SEQ.nextval, #{serialId,jdbcType=VARCHAR}, #{neId,jdbcType=VARCHAR}, #{necity,jdbcType=VARCHAR}, #{neIp,jdbcType=VARCHAR}, #{alarmCat,jdbcType=VARCHAR}, #{alarmName,jdbcType=VARCHAR}, #{alarmLevel,jdbcType=VARCHAR}, #{alarmStatus,jdbcType=VARCHAR}, #{alarmDetail,jdbcType=VARCHAR}, #{alarmAffection,jdbcType=VARCHAR}, #{alarmTime,jdbcType=VARCHAR}, #{updateTime,jdbcType=VARCHAR}, #{clearedTime,jdbcType=VARCHAR}, #{alarmCount,jdbcType=DECIMAL}, #{flag,jdbcType=DECIMAL}, #{batch,jdbcType=DECIMAL}, #{entryTime,jdbcType=VARCHAR}, #{compareId,jdbcType=VARCHAR}) </insert> <select id="queryAlarm" parameterType="com.starit.ipran.model.IpranAlarm" resultMap="BaseResultMap"> select * from STG_INM.IN_IPRAN_ALARM t where t.SERIAL_ID = #{serialId} and t.ALARM_STATUS = #{alarmStatus} </select> <select id="queryAlarmStatusNotCurrent" parameterType="com.starit.ipran.model.IpranAlarm" resultMap="BaseResultMap"> select * from STG_INM.IN_IPRAN_ALARM t where t.SERIAL_ID = #{serialId} and t.ALARM_STATUS != #{alarmStatus} </select> <update id="updateAlarmStatusNotCurrent" parameterType="com.starit.ipran.model.IpranAlarm"> UPDATE stg_inm.in_ipran_alarm t SET t.alarm_status = #{alarmStatus} WHERE t.serial_id = #{serialId} and t.alarm_status != #{alarmStatus} </update> <update id="updateAlarmCount" parameterType="com.starit.ipran.model.IpranAlarm"> UPDATE stg_inm.In_Ipran_Alarm t SET t.alarm_count = #{alarmCount,jdbcType=DECIMAL} WHERE t.serial_id = #{serialId,jdbcType=VARCHAR} and t.ALARM_STATUS = #{alarmStatus,jdbcType=VARCHAR} </update> </mapper>

此处标红id应该与dao层方法名一致，标蓝部分表示mapper.xml关联的是哪个dao层，标绿色部分表示返回的结果是model里面的哪些字段。

六、程序现在只需要加载spring-mybatis.xml然后获取bean，得到相应的dao对象之后就可以调用各种crud方法进行操作了，因为是介绍spring与mybatis集成，其他就不介绍了。

[20170823175226345]: /images/20220609/63e890a2fbdd4559be2b51fe5337561d.png