Spring-shiro-Boot-12 JDBC方式-自动生成代码

1、获取表结构

select column_name, data_type, column_comment, column_default 
FROM information_schema.columns 
WHERE table_name= "sys_user" 
and table_schema = (select database())

2、转换组装为java数据结构 --- 【BeanField】 

    public class BeanField implements Serializable {

	private static final long serialVersionUID = 4279960350136806659L;

	//列名
	private String columnName;
    //列类型
	private String columnType;
    //列备注
	private String columnComment;
    //列默认值
	private String columnDefault;
	//将SQL列名转换为驼峰---java列名
	private String name;
	//将SQL列类型转换---java类型
	private String type;

    }

================================================================

    /**
	 * mysql类型与java类型部分对应关系
	 */

	private static Map<String, String> map = Maps.newHashMap();

	static {
		map.put("int", Integer.class.getSimpleName());
		map.put("tinyint", Integer.class.getSimpleName());
		map.put("double", Double.class.getSimpleName());
		map.put("float", Float.class.getSimpleName());
		map.put("decimal", BigDecimal.class.getSimpleName());
		map.put("date", Date.class.getSimpleName());
		map.put("timestamp", Date.class.getSimpleName());
		map.put("datetime", Date.class.getSimpleName());
		map.put("varchar", String.class.getSimpleName());
		map.put("text", String.class.getSimpleName());
		map.put("longtext", String.class.getSimpleName());

	}

3、准备基本参数

路径࿱