Mybatis操作原生sql

service 业务层

public List> findFieldByTableName(String tableName) {

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

mapper.java dao层

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

mapper.xml 操作sql

    ${value}