mybatis操作原生sql
public List<Map<String,Object>> findFieldByTableName(String tableName) {
String sql = "SELECT * FROM t_fieldorder where table_name "+" = " +"'"+tableName+"'" + " ORDER BY id" ;
List<Map<String,Object>> list = excelMapper.findFieldByTableName(sql);
return list;
}
List<Map<String,Object>> findFieldByTableName(@Param(value="value") String 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="com.location.bjgwserver.mapper.ExcelMapper">
<select id="findFieldByTableName" resultType="java.util.Map">
${value}
</select>
</mapper>