com.webapp.utils.db.MybatisUtils Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of utils-common Show documentation
There is a newer version: 1.5.0
package com.webapp.utils.db;

import java.lang.reflect.Field;

import com.webapp.utils.string.Utils;
import com.webapp.utils.string.Utils.Symbol;

public final class MybatisUtils {

	private MybatisUtils(){}

	public static  void propSet(Class clz) {
		StringBuffer columns = new StringBuffer();
		String name = clz.getSimpleName();
		String camel = Utils.toCamel(name);
		columns.append(name + " " + camel + " = new " + name + "();\n");
        Field[] fields = clz.getDeclaredFields();
        for(Field field : fields){
            String col = field.getName();
            columns.append(camel + ".set" + Utils.toPascal(col) + "();\n");
        }
        String result = Utils.delTail(columns.toString());
        System.out.println(result);
	}

    public static  void insertCols(Class clz) {
    	 sql_insert(clz, false);
    }

    public static  void insertVals(Class clz) {
        sql_insert(clz, true);
    }

    private static  void sql_insert(Class clz, boolean isProp) {
        StringBuffer columns = new StringBuffer();
        Field[] fields = clz.getDeclaredFields();
        for(Field field : fields){
            String col = field.getName();
            if(isProp){
                columns.append("#{" + col + "},");
            }else {
                columns.append(Utils.toSnake(col) + ',');
            }
        }
        String result = Utils.delTail(columns.toString());
        System.out.println(result);
    }

    public static  void searchCols(Class clz) {
        StringBuffer columns = new StringBuffer();
        Field[] fields = clz.getDeclaredFields();
        for(Field field : fields){
            String col = field.getName();
            String consts = Utils.toSnake(col);
            columns.append(consts + (consts.contains(Symbol.LineUnder) ? " " + col : "") + ",");
        }
        String result = Utils.delTail(columns.toString());
        System.out.println(result);
    }

    public static  void updateCols(Class clz) {
        StringBuffer columns = new StringBuffer();
        Field[] fields = clz.getDeclaredFields();
        for(Field field : fields){
            String col = field.getName();
            String consts = Utils.toSnake(col);
            columns.append(consts + "=#{" + col + "},");
        }
        String result = Utils.delTail(columns.toString());
        System.out.println(result);
    }

    public static  void propConst(Class clz){
        StringBuffer columns = new StringBuffer();
        Field[] fields = clz.getDeclaredFields();
        for(Field field : fields){
            String col = field.getName();
            columns.append("public final static String ");

            String consts = Utils.toSnake(col);
            columns.append(consts.toUpperCase() + " = \"" + consts.toLowerCase() + "\";\n");
        }
        String result = Utils.delTail(columns.toString());
        System.out.println(result);
    }
}