自定义sql查询

 BaseDataSQL 类

public class BaseDataSQL {

    public String createTable(String tableName, String year) {

        String sql = "SELECT\n" +
                    "DATE_FORMAT( years, '%Y' ) years,ifnull(xxxxx,'') as  xxxx," +
                    "sum(xxxx) xxxx" +
            sql += " FROM tableName\n" +
                    " WHERE is_del=0 and\n" +
                    "\tDATE_FORMAT(years, '%Y') = '"+year+"'"+
                    " GROUP BY\n" +
                    "\xxxxx,DATE_FORMAT(years, '%Y')";
            return sql;

}

}

调用

String sql = new BaseDataSQL ().createTable(tableName, year);

在Mapper文件中写执行sql方法

List<Map<String,Object>> getParamsList(@Param("uSql")String uSql);

myBatis文件执行自定义sql

<select id="getParamsList" resultType="java.util.Map">
         ${uSql}
    </select>