mybatis:sql传参

导航

回到mybatis导航页

目录结构

单个参数

<?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="goods">
    <select id="selectById"
            parameterType="integer"
            resultType="com.torey.mybatis.entity.TGoodsEntity">
   SELECT * FROM t_goods where goods_id=#{id}
    </select>
</mapper>

@Test
    public void testSelectById() throws Exception {
        SqlSession sqlSession = null;
        try {
            sqlSession = MyBatisUtils.openSession();
            TGoodsEntity objects = sqlSession.selectOne("goods.selectById",748);
            System.out.println(objects);
        } catch (Exception ex) {
            throw ex;
        } finally {
            MyBatisUtils.closeSession(sqlSession);
        }
    }

多个参数

<?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="goods">
    <select id="selectByMap"
            parameterType="java.util.Map"
            resultType="com.torey.mybatis.entity.TGoodsEntity">
   SELECT * FROM t_goods
   where   current_Price between #{min} and #{max}
   order by current_Price
   limit 0,#{limit}
    </select>
</mapper>

@Test
public void selectByMap() throws Exception {
    SqlSession sqlSession = null;
    try {
        sqlSession = MyBatisUtils.openSession();
        Map<String,Object> objectMap=new HashMap<String, Object>();
        objectMap.put("min",10);
        objectMap.put("max",50);
        objectMap.put("limit",3);
        List<TGoodsEntity> objects =
                sqlSession.selectList("goods.selectByMap",objectMap);
        for (TGoodsEntity object : objects) {
            System.out.println(object.toString());
        }
    } catch (Exception ex) {
        throw ex;
    } finally {
        MyBatisUtils.closeSession(sqlSession);
    }
}

导航，上一页，下一页

4MyBatis数据查询

9MyBatis预防SQL注入攻击

支持我-微信扫一扫-加入微信公众号

赞赏作者