mybatis返回jsonobject数据结果是空,怎么解决
准备不通过自己事先编写的类进行查询,如果有其他解决办法也可以
返回值[][]
数据库代码
public List<JSONObject> tableshow(String i) throws IOException {
//创建SqlSessionFactory,会在src根路径下获取List<Emp>
InputStream is = Resources.getResourceAsStream("mybatis.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
//创建SqlSession List<Emp> (String l)List<String> //mm List<Biaodan>
SqlSession session = factory.openSession(true);
i="SELECT * FROM "+i;//i是表名
List<JSONObject> st1 = session.selectList("mapper.EmpMapper.tableshow",i);
JSON.toJSONString(st1);
System.out.print(JSON.toJSONString(st1));
session.commit();
return st1;
}
mapper配置
<select id="tableshow" resultType="com.alibaba.fastjson.JSONObject">
${i};
<!--获取表结构DESC logisticsroute;show columns from logisticsroute;更改表名: 命令:rename table 原表名 to 新表名rename table myclass2 to myclass4-->
</select>