Java 之Spring框架整合mybatis

一、配置maven

1.     <dependencies>
2.         <dependency>
3.             <groupId>org.springframework</groupId>
4.             <artifactId>spring-beans</artifactId>
5.             <version>4.1.7.RELEASE</version>
6.         </dependency>
7.         
8.         
9.         <dependency>
10.             <groupId>org.springframework</groupId>
11.             <artifactId>spring-context</artifactId>
12.             <version>4.1.7.RELEASE</version>
13.         </dependency>
14.         <dependency>
15.             <groupId>org.springframework</groupId>
16.             <artifactId>spring-jdbc</artifactId>
17.             <version>4.1.7.RELEASE</version>
18.         </dependency>
19.         
20.         <dependency>
21.             <groupId>org.mybatis</groupId>
22.             <artifactId>mybatis</artifactId>
23.             <version>3.2.3</version>
24.         </dependency>
25.         <dependency>
26.             <groupId>org.mybatis</groupId>
27.             <artifactId>mybatis-spring</artifactId>
28.             <version>1.2.0</version>
29.         </dependency>
30.         
31.         <dependency>
32.             <groupId>c3p0</groupId>
33.             <artifactId>c3p0</artifactId>
34.             <version>0.9.1.2</version>
35.         </dependency>
36.         <dependency>
37.             <groupId>mysql</groupId>
38.             <artifactId>mysql-connector-java</artifactId>
39.             <version>5.1.39</version>
40.         </dependency>
41.     </dependencies>

复制代码

二、applicationContext.xml配置

1. <?xml version="1.0" encoding="UTF-8"?>
2. <beans xmlns="http://www.springframework.org/schema/beans"
3.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
4.     xsi:schemaLocation="http://www.springframework.org/schema/beans
5.     http://www.springframework.org/schema/beans/spring-beans.xsd
6.     http://www.springframework.org/schema/context
7.     http://www.springframework.org/schema/context/spring-context-3.0.xsd">
9.    
10.     <context:component-scan base-package="com"></context:component-scan>
11.    
13.    
14.     <context:property-placeholder location="classpath:jdbc.properties" />
15.    
16.     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
17.         <property name="driverClass" value="${jdbc.driver}" />
18.         <property name="jdbcUrl" value="${jdbc.url}" />
19.         <property name="user" value="${jdbc.username}" />
20.         <property name="password" value="${jdbc.password}" />
21.     </bean>
22.    
23.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
24.         <property name="dataSource" ref="dataSource" />
25.         <property name="configLocation" value="classpath:mybatis-config.xml" />
26.         <property name="mapperLocations" value="classpath:com/dao/*.xml" />
27.     </bean>
28.    
29.     <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
30.         <constructor-arg index="0" ref="sqlSessionFactory" />
31.     </bean>
32.    
33. </beans>

复制代码

三、具体代码


 
 AdminMapper.java

1. package com.mapper;
3. import java.util.List;
5. import com.entity.Admin;
7. public interface AdminMapper {
8.     List<Admin> selectAdmin();
9. }

复制代码

AdminMapperImpl.java

1. package com.mapper.impl;
3. import java.util.List;
5. import javax.annotation.Resource;
7. import org.mybatis.spring.SqlSessionTemplate;
8. import org.springframework.stereotype.Component;
10. import com.entity.Admin;
11. import com.mapper.AdminMapper;
13. @Component(value = "AdminMapper1")
14. public class AdminMapperImpl implements AdminMapper{
15.     @Resource(name = "sqlSession")
16.     private SqlSessionTemplate sqlSession;
17.    
18.     public void setSqlSession(SqlSessionTemplate sqlSession) {
19.         this.sqlSession = sqlSession;
20.     }
22.     @Override
23.     public List<Admin> selectAdmin() {
24.         AdminMapper mapper = sqlSession.getMapper(AdminMapper.class);
25.         return mapper.selectAdmin();
26.     }
28. }

复制代码

adminMapper.xml

1. <?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE mapper
3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
5. <mapper namespace="com.mapper.AdminMapper">
6.     <select id="selectAdmin" resultType="com.entity.Admin">
7.         select * from j_admin
8.     </select>
9. </mapper>

复制代码

运行代码

1. package com.test;
3. import java.util.List;
5. import org.springframework.context.ApplicationContext;
6. import org.springframework.context.support.ClassPathXmlApplicationContext;
8. import com.entity.Admin;
9. import com.mapper.AdminMapper;
11. public class Test {
13.     public static void main(String[] args) {
14.         ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
15.         AdminMapper adminMapper = (AdminMapper) context.getBean("AdminMapper1");
16.         List<Admin> admin = adminMapper.selectAdmin();
17.         for(Admin i : admin){
18.             System.out.println(i);
19.         }
20.     }
21. }

复制代码

 

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！