1.概述
本文主要演示如何使用代码直接使用mabatis而不是通过spring配置,mybatis本身就是一个拼sql都工具,xml里实现了多种sql表达式。
2.实现
this.configuration = new Configuration(); SqlSource raw = new XMLLanguageDriver().createSqlSource(configuration,"select * from ${srcTable} where id=#{id})",Map.class); MappedStatement.Builder mb = new MappedStatement.Builder(configuration,"mdata",raw, SqlCommandType.SELECT); List<ResultMap> resultMaps = new ArrayList<ResultMap>(); resultMaps.add(new ResultMap.Builder(configuration,"mdataMap", Map.class,new ArrayList<ResultMapping>()).build()); mb.resultMaps(resultMaps); MappedStatement mappedStatement = mb.build(); configuration.addMappedStatement(mappedStatement); configuration.setLogImpl(org.apache.ibatis.logging.stdout.StdOutImpl.class);
调用时只需sqlSession.selectList("mdata")
mdata本质上只是id,如果是想使用mapper,只需将id定义为 全类名.方法名的形式
package com.demo; public interface UserMapper{ Map<String,String> test(Integer id); }
MappedStatement.Builder mb = new MappedStatement.Builder(configuration,"com.demo.UserMapper.test",raw, SqlCommandType.SELECT);标签:MappedStatement,Builder,class,mybatis,new,configuration,id From: https://www.cnblogs.com/yangyang12138/p/16714241.html
sqlSession.createMapper(UserMapper.class).test(1);