Mybatis 手动创建Statement 并获取查询结果

代码如下:

Configuration config = sqlSessionFactory.getConfiguration();
String sql = "select * from dp_birp_manage_user where usercode = #{usercode,jdbcType=VARCHAR}";
SqlSource sqlSource = new SqlSourceBuilder(config)
        .parse(sql,Object.class,new HashMap<>());
MappedStatement statement = new MappedStatement
        .Builder( config, "selectUser11", sqlSource, SqlCommandType.SELECT)
        .resultMaps(
                Collections.singletonList(
                        new ResultMap.Builder(config, "defaultResultMap", Map.class, new ArrayList<>(0)).build()
                )
        )
        .build();

Environment env = config.getEnvironment();
Transaction tx = config.getEnvironment().getTransactionFactory().newTransaction(env.getDataSource(),TransactionIsolationLevel.READ_COMMITTED,true);
DefaultResultHandler resultHandler = new DefaultResultHandler();
config.newExecutor(tx).query(
        statement,
        ImmutableMap.of("usercode", "admin"),
        RowBounds.DEFAULT,
        resultHandler
);
tx.close();
System.out.println(resultHandler.getResultList());