Mapper快速SQL生成

public class SQL {    private static final String COLUMS = "id,comId,createTime,createUser,num,relateNum,cardId,price,type,purchased,currency,payStatus,auditStatus,auditUser,auditTime,predictTime,payTime,payUser,remark,costType,fundType,deleted,";    private static final String TABLE_NAME = "pub_finance_pay";    private static final String CONDITION_ID = "xxxx";    public static void main(String[] args) {        insert();        delete();        getById();        update();        getList();        getListCondition();    }    public static void insert() {        String sql = "INSERT INTO " + TABLE_NAME + " (";        String[] es = COLUMS.split(",");        for (int i = 0; i < es.length; i++) {            if (i < es.length -1) {                sql += es[i] + ",";            } else {                sql += es[i] + ") ";            }        }        sql += "VALUES (";        for (int i = 0; i < es.length; i++) {            if (i < es.length -1) {                sql += "#{" + es[i] + "},";            } else {                sql += "#{" + es[i] + "})";            }        }        System.out.println(sql);    }    public static void delete() {        System.out.println("UPDATE " + TABLE_NAME + " SET deleted=${@com.sjdf.erp.common.dictionary.bean.WhetherState@YES} WHERE comId=#{comId} AND id=#{id}");    }    public static void getById() {        System.out.println("SELECT * FROM " + TABLE_NAME + " WHERE comId=#{comId} AND id=#{id} AND deleted=${@com.sjdf.erp.common.dictionary.bean.WhetherState@NO}");    }    public static void update() {        String sql = "UPDATE " + TABLE_NAME + " SET ";        String[] es = COLUMS.split(",");        for (int i = 0; i < es.length; i++) {            if (i < es.length -1) {                sql += es[i] + "=#{" +es[i]+"}, ";            } else {                sql += es[i] + "=#{" +es[i]+"} ";            }        }        sql += "WHERE id=#{id} AND comId=#{comId}";        System.out.println(sql);    }    public static void getListCondition() {        String[] es = COLUMS.split(",");        String sql = "<sql id=\"" + CONDITION_ID + "\">\n";        sql += "    <where>\n";        sql += "        deleted=${@com.sjdf.erp.common.dictionary.bean.WhetherState@NO}\n";        for (int i = 0; i < es.length; i++) {            if (!es.equals("deleted")) {                sql += String.format("        <if test=\"%s != null\">and %s = #{%s}</if>\n", es[i], es[i], es[i]);            }        }        sql += "    </where>\n";        sql += "</sql>";        System.out.println(sql);    };    public static void getList() {        System.out.println(String.format("SELECT * FROM %s <include refid=\"%s\"/>", TABLE_NAME, CONDITION_ID));    }}