Mybatis与Spring整合连接MySQL-白红宇

1 maven依赖


        
           
      
       org.apache.commons
            
      
       commons-dbcp2
            
      
       2.0.1
          
         
           
      
       org.springframework
            
      
       spring-context
            
      
       ${spring.framework.version}
          
         
           
      
       mysql
            
      
       mysql-connector-java
            
      
       5.1.36
          
         
           
      
       org.mybatis
            
      
       mybatis-spring
            
      
       1.2.2
          
         
           
      
       org.mybatis
            
      
       mybatis
            
      
       3.2.8
          
         
           
      
       org.apache.commons
            
      
       commons-lang3
            
      
       3.1
          
         
           
      
       org.apache.commons
            
      
       commons-math
            
      
       2.2
          
         
           
      
       junit
            
      
       junit
            
      
       4.11
            
      
       test
          
         
           
      
       org.springframework
            
      
       spring-test
            
      
       3.1.1.RELEASE
            
      
       test

2 数据库表

表名为student，位于test库中。

CREATE TABLE `student` (  `id` int(11) NOT NULL,  `name` varchar(20) NOT NULL,  `age` int(11) DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB

3 数据库表的映射类

package club.chuxing.tech.learn.mybatis.domain;public class Student {
        private int id;    private String name;    private int age;    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public int getAge() {        return age;    }    public void setAge(int age) {        this.age = age;    }    @Override    public String toString() {        return "Student{" +                "id=" + id +                ", name='" + name + '\'' +                ", age=" + age +                '}';    }}

4 数据库访问DAO

package club.chuxing.tech.learn.mybatis.dao;import club.chuxing.tech.learn.mybatis.domain.Student;import org.apache.ibatis.annotations.Select;import org.springframework.stereotype.Component;@Componentpublic interface StudentDao {
        @Select("select * from student where id = #{id}")    Student selectStudent(int id);}

此DAO不需要对应的Mapper文件。

5 Mybatis配置文件

mybatis.xml:

6 Spring配置文件

applicationContext-common.xml:


    
        
         
         
         
         
             
              
              
              
          
         
             
              
              
                  
                       
        
         classpath:mybatis-mapper/*Mapper.xml

7 DAO单元测试

package club.chuxing.tech.learn.mybatis.dao;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.test.context.ContextConfiguration;import club.chuxing.tech.learn.mybatis.domain.Student;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;import static club.chuxing.tech.learn.utils.PrintUtil.*;@ContextConfiguration(locations = "classpath:applicationContext-common.xml")@RunWith(SpringJUnit4ClassRunner.class)public class StudentDaoTest {
        @Autowired    private StudentDao dao;    @Test    public void testSelectStudent() throws Exception {        Student student = dao.selectStudent(1);        print(student);    }}

也可以在Main函数中加载DAO bean：

package club.chuxing.tech.learn.mybatis;import club.chuxing.tech.learn.mybatis.dao.StudentDao;import club.chuxing.tech.learn.mybatis.domain.Student;import org.springframework.context.support.ClassPathXmlApplicationContext;import static club.chuxing.tech.learn.utils.PrintUtil.print;public class MyTest {
        public static void main(String[] args) {        ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("applicationContext-common.xml");        StudentDao  dao = context.getBean(StudentDao.class);        Student student = dao.selectStudent(1);        print(student);    }}

转自：http://blog.csdn.net/foreverling/article/details/50987203