Mybatis基于SqlSession实现CRUD

之前我们讲的基于XML还是接口注解配置都是使用接口实现CRUD，本文我们将要讲解通过splsession来实现CRUD，这种方法比较灵活。

基本配置

 <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="mapperLocations" value="classpath:mapping/*.xml"></property>
        <!-- 分页插件 -->
        <property name="plugins">
            <array>
                <bean class="com.github.pagehelper.PageHelper">
                    <property name="properties">
                        <value>
                            dialect=mysql
                        </value>
                    </property>
                </bean>
            </array>
        </property>
    </bean>


    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        <constructor-arg index="0" ref="sqlSessionFactory" />
    </bean>

Mapper实现

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="sysUserMapper">
    <select id="SelectOne" parameterType="java.util.HashMap" resultType="java.util.HashMap">
    select * from user_ where id = #{id,jdbcType=VARCHAR} limit 0,20
  </select>
    <select id="SelectProc" parameterType="java.util.HashMap" resultType="java.util.HashMap" >
        {call get_user(#{id,jdbcType=VARCHAR})}
  </select>
    <select id="SelectList" parameterType="java.util.HashMap" resultType="java.util.HashMap" >
        select * from user_
        <where>
            <if test="male_ != null and male_!=''">
                AND  male_ = #{male_,jdbcType=VARCHAR}
            </if>
        </where>
        limit 0,20
    </select>
    <insert id="insert" parameterType="java.util.HashMap">
        insert into user_test(id, name) values(#{id}, #{name})
    </insert>
</mapper>

数据实现

首先我们 添加SqlSession 属性注入

@Autowired
    private  SqlSession sqlSession;

然后我们实现具体的CRUD操作

public Map<String, String> SelectOne(String method,Object Para)
    {
        return sqlSession.selectOne(method, Para);
    }

    public List<Map<String, String>> SelectList(String method,Object Para)
    {
        return sqlSession.selectList(method, Para);
    }

    public List<Map<String, String>> SelectProc(String method,Object Para)
    {
        return sqlSession.selectList(method, Para);
    }


    public void  insert(String method,Object Para)
    {
        if(Para.getClass().getName().equals("java.util.ArrayList"))
        {
            ArrayList list = (ArrayList) Para;
            for (int i = 0; i < list.size(); i++) {
                HashMap hm = (HashMap) list.get(i);
                sqlSession.insert(method, hm);
            }
        }
        else
        {
             sqlSession.insert(method, Para);
        }
    }


    public void  update(String method,Object Para)
    {
        if(Para.getClass().getName().equals("java.util.ArrayList"))
        {
            ArrayList list = (ArrayList) Para;
            for (int i = 0; i < list.size(); i++) {
                HashMap hm = (HashMap) list.get(i);
                sqlSession.update(method, hm);
            }
        }
        else
        {
            sqlSession.update(method, Para);
        }

    }


    public void delete(String method,Object Para)
    {
        if(Para.getClass().getName().equals("java.util.ArrayList"))
        {
            ArrayList list = (ArrayList) Para;
            for (int i = 0; i < list.size(); i++) {
                HashMap hm = (HashMap) list.get(i);
                sqlSession.delete(method, hm);
            }
        }
        else
        {
            sqlSession.delete(method, Para);
        }
    }

路由中转操作

public  Object doProess(String BsCode,String Operation, Object Para) {
        String method=BsCode.trim()+"."+Operation.trim();
       // try {
            switch (Operation) {
                case "SelectOne":
                    return SelectOne(method, Para);
                case "SelectList":
                    return SelectList(method, Para);
                case "SelectProc":
                    return SelectProc(method, Para);
                case "insert":
                     insert(method, Para);
                     return 1;
                case "update":
                     update(method, Para);
                     return 1;
                case "delete":
                     delete(method, Para);
                     return 1;
                default:
                    return "无相关操作类型";

            }
       // }catch (Exception e)
       // {
           // return e.getMessage();
       // }
    }

数据验证测试

@RunWith(SpringJUnit4ClassRunner.class)  //使用junit4进行测试
@ContextConfiguration({"classpath:spring-base.xml"})
public class commServiceImplTest {

    @Autowired
    private commService commservice;

    @Test
    public void selectOne() throws Exception {
        String bsCode="sysUserMapper";
        String Operation="SelectOne";
        Map<String, String> para=new HashMap<String, String>();
        para.put("id","fjx");
        Map<String, String> userinfo=(Map<String, String>) commservice.doProess(bsCode,Operation, para);
        System.out.print(userinfo);
    }

   @Test
    public void doProess2() throws Exception {
        String bsCode="sysUserMapper";
        String Operation="SelectProc";
        Map<String, String> para=new HashMap<String, String>();
        para.put("id","fjx");
        Object userinfo=commservice.doProess(bsCode,Operation,para);
        System.out.print(userinfo);
    }

    @Test
    public void doProess3() throws Exception {
        String bsCode="sysUserMapper";
        String Operation="SelectList";
        Map<String, String> para=new HashMap<String, String>();
        para.put("male_","1");
        Object users=commservice.doProess(bsCode,Operation,para);
        System.out.print(users);
    }

}

GITHUB

github :  https://github.com/nbfujx/Goku.WebService.Bus