Spring整成Mybatis注意事项：

　　 1. 关键jar包不能少

　　2.可以单独整理好Mybatis框架，测试无误再集成Spring

　　3.集成时，参数级别的细节可以选择忽略，但思路必须清晰

 

代码如下：

　　1.jar包 

　　  

　　2.项目目录结构

　　

 

　　3.SqlMapConfig.xml　

 

 

 

　　4.applicationContext.xml

 

 

 

　   5.UserMapper.xml

     
             
              select user_id as id,name,age from t_user where user_id=#{id}    
     

 

 

 

　　6.log4j.properties

log4j.rootLogger=DEBUG, stdoutlog4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n

 

 

 

　　7.jdbc.properties

jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8jdbc.username=rootjdbc.password=leifei

 

 

 

　　8.Dao接口以及Dao实现

package com.lf.dao;import com.lf.entity.User;public interface UserDao {        public User queryUserById(int userId) throws Exception;}

 

package com.lf.dao.impl;import org.apache.ibatis.session.SqlSession;import org.mybatis.spring.support.SqlSessionDaoSupport;import com.lf.dao.UserDao;import com.lf.entity.User;public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao {        @Override    public User queryUserById(int userId) throws Exception {        SqlSession session = this.getSqlSession();        //执行查询        User user = session.selectOne("userMapper.queryUserById",userId);        return user;    }}

 

 

　　9.User实体

package com.lf.entity;public class User {    private int id;    private String name;    private int age;    private String address;        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 "User [id=" + id + ", name=" + name + ", age=" + age + "]";    }    }

 

 

 

　　10.Junit测试类

package com.lf.test;import org.junit.Before;import org.junit.Test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import com.lf.dao.UserDao;import com.lf.entity.User;public class UserDaoImplTest {    private ApplicationContext applicationContext;        @Before    public void setUp() throws Exception {        applicationContext = new ClassPathXmlApplicationContext("spring/applicationContext.xml");    }    @Test    public void test() throws Exception {        UserDao userDao =  (UserDao) applicationContext.getBean("userDao");        User user = userDao.queryUserById(1);        System.out.println(user);            }}

 

 

 

 　　11.测试结果