mybatis:sql传参
导航
目录结构
单个参数
<?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注入攻击
支持我-微信扫一扫-加入微信公众号
赞赏作者
![赞赏作者](https://img.znyd365.com/torey/Aseven/zanShang2.jpg)