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>最后一个 单侧 就搞定啦
@Testpublic 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());    }}