Spring整合mybatis完整示例

实现功能：根据id查找用户信息。

1、首先创建一个与表中数据相对应的实体类，User.java

package bean;



public class User {

    int id;

    String name;

    int age;

    String sex;

    String school;



    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;

    }



    public String getSex() {

        return sex;

    }



    public void setSex(String sex) {

        this.sex = sex;

    }



    public String getSchool() {

        return school;

    }



    public void setSchool(String school) {

        this.school = school;

    }



    @Override

    public String toString() {

        return ("姓名："+name+"\n年龄："+age+"\n性别"+sex+"\n学校"+school);

    }

}

2、写出这个类的映射接口，里面有我们要实现的查询的抽象方法。

package dao;



import bean.User;



public interface IUser {

    User getUserByID (int id);

}

3、写出这个类的映射Mapper文件，里面有select语句。

        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">





    
        SELECT * from user where id = #{id}
    

4、以上都准备好之后，后面就是与没用spring不同的地方。

准备mysql.properteis的参数配置文件，里面写上数据库连接要用到的参数。

        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

        xmlns:p="http://www.springframework.org/schema/p"

        xmlns:aop="http://www.springframework.org/schema/aop"

        xmlns:context="http://www.springframework.org/schema/context"

        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-4.2.xsd

        http://www.springframework.org/schema/aop

        http://www.springframework.org/schema/aop/spring-aop-4.3.xsd

        http://www.springframework.org/schema/tx

        http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">











    

        

            

                mysql-local.properties

            

        

    







    

    

        

        

        

        

        

        

        

        

        

     





    

    

        

        

        



    



    

        

    



    

    

        

        

    

5、以上3个xml文件都配置完成之后，我们调用这个查询方法就只需要短短几行代码。

package bean;



import dao.IUser;

import org.apache.ibatis.session.SqlSession;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;



public class DemoTest {

    public static void main(String[] args) {

        ApplicationContext context = new ClassPathXmlApplicationContext("spring-config.xml");

        IUser userMapper = (IUser)context.getBean("userMapper");

        User user = userMapper.getUserByID(2);

        System.out.println(user);



    }



}

6、运行结果