• Home
• com.github.qq275860560
• github-qq275860560-common
• 20190523
• source code
• JdbcTemplateSqlGeneratorUtil.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.github.qq275860560.common.util.JdbcTemplateSqlGeneratorUtil Maven / Gradle / Ivy

package com.github.qq275860560.common.util;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.List;

import lombok.extern.slf4j.Slf4j;

/**
 * @author [email protected]
 *
 */
@Slf4j
public class JdbcTemplateSqlGeneratorUtil {

	public static String url;
	public static String username;
	public static String password;
	public static String driverClassName;
	public static String schemaName;

	public static String tableName;
	public static String modelName;

	public static void main(String[] args) throws Exception {
		JdbcTemplateSqlGeneratorUtil.url = "jdbc:mysql://10.18.96.50:3306/rest_home_hz?autoReconnect=true&useUnicode=true&characterEncoding=utf-8";
		JdbcTemplateSqlGeneratorUtil.username = "resthome";
		JdbcTemplateSqlGeneratorUtil.password = "resthome&*()";
		JdbcTemplateSqlGeneratorUtil.driverClassName = "com.mysql.jdbc.Driver";
		JdbcTemplateSqlGeneratorUtil.schemaName = "rest_home_hz";
		JdbcTemplateSqlGeneratorUtil.tableName = "t_user";
		JdbcTemplateSqlGeneratorUtil.modelName = "User";
		JdbcTemplateSqlGeneratorUtil.generate();
	}

	private static void generate() throws Exception {
		log.info(countInterface(schemaName, tableName, modelName) + "\n"
				+ checkInterface(schemaName, tableName, modelName) + "\n"
				+ deleteInterface(schemaName, tableName, modelName) + "\n"
				+ getInterface(schemaName, tableName, modelName) + "\n"
				+ getByKeyValueInterface(schemaName, tableName, modelName) + "\n"
				+ saveInterface(schemaName, tableName, modelName) + "\n"
				+ updateInterface(schemaName, tableName, modelName) + "\n"
				+ listInterface(schemaName, tableName, modelName) + "\n"
				+ pageInterface(schemaName, tableName, modelName));

		log.info("\n"+"@Autowired"+"\n"+"private JdbcTemplate jdbcTemplate;"+"\n"+countImplement(schemaName, tableName, modelName) + "\n"
				+ checkImplement(schemaName, tableName, modelName) + "\n"
				+ deleteImplement(schemaName, tableName, modelName) + "\n"
				+ getImplement(schemaName, tableName, modelName) + "\n"
				+ getByKeyValueImplement(schemaName, tableName, modelName) + "\n"
				+ saveImplement(schemaName, tableName, modelName) + "\n"
				+ updateImplement(schemaName, tableName, modelName) + "\n"
				+ listImplement(schemaName, tableName, modelName) + "\n"
				+ pageImplement(schemaName, tableName, modelName));

		log.info("" + assignNull(schemaName, tableName));
		log.info("" + assignFromMap(schemaName, tableName));
	}

	private static StringBuilder assignNull(String schemaName, String tableName) throws Exception {
		List list = getColumn(schemaName, tableName);
		StringBuilder sb1 = new StringBuilder();
		sb1.append("\n");
		for (String[] array : list) {
			sb1.append(array[0].equals("Date") ? "String" : array[0]).append(" ").append(array[1]).append("=")
					.append("null").append(";").append("\n");
		}
		return sb1;
	}

	private static StringBuilder assignFromMap(String schemaName, String tableName) throws Exception {
		List list = getColumn(schemaName, tableName);
		StringBuilder sb1 = new StringBuilder();
		sb1.append("\n");
		for (String[] array : list) {
			sb1.append(array[0].equals("Date") ? "String" : array[0]).append(" ").append(array[1]).append("=")
					.append("(" + (array[0].equals("Date") ? "String" : array[0]) + ")map.get(\"" + array[1] + "\")")
					.append(";").append("\n");
		}
		return sb1;
	}

	private static StringBuilder pageInterface(String schemaName, String tableName, String modelName) throws Exception {
		List list = getColumn(schemaName, tableName);
		StringBuilder sb1 = new StringBuilder();
		sb1.append("\n");

		if (modelName == null) {
			sb1.append("public Map page( ");
		} else {
			sb1.append("public Map page" + modelName + "( ");
		}
		sb1.append(")  throws Exception ; ");
		StringBuilder sb3 = new StringBuilder();
		return sb3;
	}

	private static StringBuilder pageImplement(String schemaName, String tableName, String modelName) throws Exception {
		List list = getColumn(schemaName, tableName);
		StringBuilder sb1 = new StringBuilder();
		sb1.append("\n");
		//sb1.append("@Override").append("\n");
		if (modelName == null) {
			sb1.append("public Map page( ");
		} else {
			sb1.append("public Map page" + modelName + "( ");
		}

		for (int i = 0; i < list.size(); i++) {
			String[] array = list.get(i);
			if (array[0].equals("Date")) {
				sb1.append("String").append(" ")
						.append("start" + array[1].substring(0, 1).toUpperCase() + array[1].substring(1)).append(",");
				sb1.append("String").append(" ")
						.append("end" + array[1].substring(0, 1).toUpperCase() + array[1].substring(1)).append(",");
			} else {
				sb1.append(array[0]).append(" ").append(array[1]).append(",");
			}

		}
		sb1.append("Integer").append(" ").append("pageNum").append(",");
		sb1.append("Integer").append(" ").append("pageSize").append(",");
		sb1.delete(sb1.length() - 1, sb1.length());
		sb1.append(") throws Exception  {").append("\n");

		sb1.append("    if(pageNum==null) pageNum=1;//取名pageNum为了兼容mybatis-pageHelper中的page对象的pageNum,注意spring的PageRequest使用page表示页号,综合比较，感觉pageNum更加直观,不需要看上下文能猜出字段是页号").append("\n");
		sb1.append("    if(pageSize==null)pageSize=10;//取名pageSize为了兼容mybatis-pageHelper中的page对象的pageSize,注意spring的PageRequest使用size表示页数量，综合比较，感觉pageSize会更加直观,不需要看上下文能猜出字段是分页时当前页的数量").append("\n");
		sb1.append("    int from = (pageNum-1)*pageSize;").append("\n");
		sb1.append("    int size = pageSize;").append("\n");

		sb1.append("    StringBuilder sb  = new StringBuilder();").append("\n");
		sb1.append("    List