Mybatis操作原生sql

mybatis操作原生sql

• service 业务层

 /**
     * 根据表名查询字段值和数据库字段对应
     * @return
     */
    public List<Map<String,Object>> findFieldByTableName(String tableName) {

        //对所要查询的字符串进行拼接,然后将sql作为参数传入dao层
        //查询t_fieldorder表中field_name的值
        String  sql = "SELECT  *  FROM  t_fieldorder where table_name "+" = "  +"'"+tableName+"'" + " ORDER BY id" ;
        List<Map<String,Object>>  list = excelMapper.findFieldByTableName(sql);
        return list;
    }

• mapper.java dao层

 	//@Param的vaalue值与mapper.xml中${value}的值相对应
    //根据表名查询字段名称
    List<Map<String,Object>> findFieldByTableName(@Param(value="value") String sql);

• mapper.xml 操作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>