# 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>
1
2
3
4
5
6
7
8
9
10
11
12
2
3
4
5
6
7
8
9
10
11
12
@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);
}
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
2
3
4
5
6
7
8
9
10
11
12
13
14
# 多个参数
<?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>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
2
3
4
5
6
7
8
9
10
11
12
13
14
15
@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);
}
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
# 导航,上一页,下一页
4MyBatis数据查询
9MyBatis预防SQL注入攻击