spring整合mybatis

这是一个遍历数据库信息 的Spring和mybatis整合

首先要注意的是你Spring和mybatis这个是要引入 jar的

 <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis-spring</artifactId>
          <version>1.2.0</version>
      </dependency>

Entity层

public class User {
    private Integer id;
    private  String  userCode;
 private String userName;
 private String userPassword;
 private Integer gender;
 private Date birthday;
 private  String phone;
 private String address;
 private Integer userRole;
 private Integer  createdBy;
 private Date creationDate;
 private  Integer modifyBy;
 private  Date modifyDate;
 private String userRoleName;

}

进行封装；

DAO层

package cn.happy.DAO;

import cn.happy.entity.User;

import java.util.List;

/**
 * Created by Administrator on 2017/8/2 0002.
 */
public interface UserMapper {
    public List<User> selectUserinfo() throws  Exception;

}

实现类

package cn.happy.DAO.Impl;

import cn.happy.DAO.UserMapper;
import cn.happy.entity.User;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionTemplate;

import java.util.List;

/**
 * Created by Administrator on 2017/8/2 0002.
 */
public class userdaoimp implements UserMapper {
    SqlSessionTemplate sqlSession;
    private SqlSessionFactory sqlSessionFactory;

    public SqlSessionTemplate getSqlSession() {
        return sqlSession;
    }

    public void setSqlSession(SqlSessionTemplate sqlSession) {
        this.sqlSession = sqlSession;
    }
    public List<User> selectUserinfo() throws Exception {
        return sqlSession.selectList("selectUserinfo");
    }

    public void setSqlSessionFactory(SqlSessionFactory SqlSessionFactory) {
        sqlSessionFactory = SqlSessionFactory;
    }

    public SqlSessionFactory getSqlSessionFactory() {
        return sqlSessionFactory;
    }
}

写一个小配置   来写查询    我的小配置名字叫做   UserMapper.xml

<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.happy.DAO.UserMapper">
    <select id="selectUserinfo" resultType="User">
        SELECT * from  smbms_user
    </select>
</mapper>

service层（和dao层是一样的一个接口一个实现）

这是接口

public interface userservice {
    public List<User> selectUserinfo() throws  Exception;
}

这是实现、

package cn.happy.service.impl;

import cn.happy.DAO.UserMapper;
import cn.happy.entity.User;
import cn.happy.service.userservice;

import java.util.List;

/**
 * Created by Administrator on 2017/8/2 0002.
 */
public class userserviceimp implements userservice {

    UserMapper dao;

    public UserMapper getDao() {
        return dao;
    }

    public void setDao(UserMapper dao) {
        this.dao = dao;
    }

    public List<User> selectUserinfo() throws Exception {
        return dao.selectUserinfo();
    }
}
然后写大配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:p="http://www.springframework.org/schema/p"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:aop="http://www.springframework.org/schema/aop"
       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.xsd
         http://www.springframework.org/schema/aop
         http://www.springframework.org/schema/aop/spring-aop.xsd">
    <!--1.dbcp数据源-->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql:///smbms"></property>
        <property name="username" value="root"></property>
        <property name="password" value="root"></property>
    </bean>
    <!--2.配置SqlSessionFactoryBean-->
    <bean id="SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <property name="configLocation" value="classpath:mybatis-config.xml"></property>
  <!--      <property name="mapperLocations" value="classpath:cn/happy/DAO/*.xml"></property>-->
    </bean>
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="cn.happy.DAO"></property>
        <property name="sqlSessionFactoryBeanName" value="SqlSessionFactory"></property>

    </bean>




    <!--  5.sevice注入dao-->
    <bean id="userservice" class="cn.happy.service.impl.userserviceimp">

        <property name="dao" ref="userMapper"></property>

    </bean>


</beans>
 然后我写了一个mybatis-confier.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <typeAliases>
        <package name="cn.happy.entity"></package>
    </typeAliases>
</configuration>
最后一个 单侧 就搞定啦
@Test
public void show() throws  Exception{
    ApplicationContext context=new ClassPathXmlApplicationContext("applectionContext.xml");
    userserviceimp service=(userserviceimp)context.getBean("userservice");
    List<User> user=service.selectUserinfo();
    for (User item:user){
        System.out.println(item.getUserName());
    }

}