//TMD 写几个demo 还有大站采集
<a target=_blank href="http://hao947.com/" target="_blank">好947</a>
映射配置文件
<!-- type:映射实体类的数据类型 id：resultMap的唯一标识 --> <RESULTMAP id=BaseResultMap type="person"><pre name="code" class="java"><a target=_blank href="http://hao947.com/" target="_blank">好947</a><!-- column:库表的字段名 property:实体类里的属性名 --> <ID property="personId" column="person_id" /> <RESULT property="name" column="name" /> <RESULT property="gender" column="gender" /> <RESULT property="personAddr" column="person_addr" /> <RESULT property="birthday" column="birthday" /> </RESULTMAP>
映射配置查询语句
<!-- 当查询值得时候resultMap指定key与value。
map.put("name","项目经理")
map.put("gender" 1)<pre name="code" class="java"><a target=_blank href="http://hao947.com/" target="_blank">好947</a> --> <SELECT id=selectPersonByParams resultmap="BaseResultMap" parametertype="java.util.Map"> select * from person p where p.name = #{name} and p.gender =#{gender} </SELECT>
映射管理库表文件
<!-- 集中管理库表的映射文件 --><pre name="code" class="java"><a target=_blank href="http://hao947.com/" target="_blank">好947</a><MAPPERS> <MAPPER resource="com/hao947/sql/mapper/PersonMapper.xml" /> </MAPPERS>
测试文件
@Test
public void selectPersonByParams() {
// 创建一个sqlSession <a target=_blank href="http://hao947.com" target="_blank">好947</a>
SqlSession session = sqlSessionFactory.openSession();
try {
Map<STRING, object=""> map = new HashMap<STRING, object="">();
map.put("name", "项目经理");
map.put("gender", 0);
// 第一个参数查找sql，规则namespace+"."+sql的id，第二个参数是sql要接收的参数
List<PERSON> list = session
.selectList("com.hao947.sql.mapper.PersonMapper.selectPersonByParams",map);
for (Person p : list) {
System.out.println(p);
}
} finally {
session.close();
}
}
}
好947 Mybatis 配置resultMap 带参数查询Map 注意selectOne数据库返回结果一条数据库 否则会报错,布布扣,bubuko.com
好947 Mybatis 配置resultMap 带参数查询Map 注意selectOne数据库返回结果一条数据库 否则会报错