spring整合mybatis依赖

spring整合mybatis依赖"/>

spring整合mybatis依赖

pom.xml文件

<dependencies><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.11</version><scope>test</scope></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>5.3.17</version></dependency><!--spring做事务的--><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>5.3.17</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>5.3.17</version></dependency><!--mybatis依赖--><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.5.9</version></dependency><!--mybatis和spring集成的依赖--><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>2.0.7</version></dependency><!--mysql驱动--><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.49</version></dependency><!--阿里的数据库连接池--><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>1.2.8</version></dependency></dependencies><build><resources><resource><directory>src/main/java</directory><!--所在的目录--><includes><!--包括目录下的.properties和.xml都会被扫描到--><include>**/*.properties</include><include>**/*.xml</include></includes><filtering>false</filtering></resource><resource><directory>src/main/resources</directory><!--所在的目录--><includes><!--包括目录下的.properties和.xml都会被扫描到--><include>**/*.properties</include><include>**/*.xml</include></includes><filtering>false</filtering></resource><resource><directory>src/main/resources</directory><includes><include>**/*.xml</include><include>**/*.properties</include></includes></resource></resources></build>

spring主配置文件（applicationContext.xml）

<context:property-placeholder location="classpath:jdbc.properties"/><!--声明数据源DataSource，连接数据库的--><bean id="myDataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"><property name="url" value="${jdbc.url}"/><property name="username" value="${jdbc.username}"/><property name="password" value="${jdbc.password}"/><property name="maxActive" value="20"/></bean><!--创建SqlSessionFactory对象--><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><!--set注入  把数据库连接池付给dataSource属性--><property name="dataSource" ref="myDataSource"/><!--mybatis主配置文件的位置--><property name="configLocation" value="classpath:mybatis.xml"/></bean><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/><!--把这个包下的所有接口都创建相应实现类并实例化，默认名称接口的首字母小写，多个包用逗号分隔--><property name="basePackage" value=" "/></bean>

mybatis主配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configurationPUBLIC "-//mybatis//DTD Config 3.0//EN"".dtd">
<configuration><settings><setting name="logImpl" value="STDOUT_LOGGING"/></settings><!--设置别名--><typeAliases><!--name：实体类的包名--><package name=" "/></typeAliases><mappers><!--mapper：一个mapper标签指定一个含有sql语句的配置文件的位置，从而可以执行配置文件中的sql语句从类路径开始的路径信息   即target/classes文件下以后的路径--><!--<mapper resource=""/>--><!--可以用包名   该包下所有的xml文件都会被加载--><package name=" "/></mappers>
</configuration>

mapper配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapperPUBLIC "-//mybatis//DTD Mapper 3.0//EN"".dtd"><mapper namespace=""><select id="" resultType=""><!--select语句--></select><insert id="insertStudent"><!--insert语句--></insert></mapper>

web.xml中创建监听器对象

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