根据表结构自动转换为javabean文件

需要的依赖maven如下

 <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-lang3</artifactId>
            <version>3.0</version>
        </dependency>

代码如下

import org.apache.commons.lang3.StringUtils;

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.*;

public class SqlToJavaBean{
   
    public static Connection connection;

    //mysql DB连接字符串
    private static String DB_URL = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&noDatetimeStringSync=true&serverTimezone=UTC";

    private static String DB_USER = "root"; //账号

    private static String DB_PASSWD = "root"; //密码

    //mysql 驱动全限定名称
    public static String DB_DRIVER_CLASS_NAME = "com.mysql.cj.jdbc.Driver";

    static {
   
        try {
   
            Class.forName(DB_DRIVER_CLASS_NAME);
            if (connection == null || connection.isClosed())
                //获得链接
                connection = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWD);
        } catch (ClassNotFoundException ex) {
   
            ex.printStackTrace();
            System.out.println(ex.getMessage());
        } catch (SQLException e) {
   
            e.printStackTrace();
            System.out.println(e.getMessage());
        }
    }

    public SqlToJavaBean(){
   

    }

    /**
     * 表元数据
     * @param table
     * @return
     */
    public static Map<String, String> getDBTableMeta(String table){
   
        Map<String, String> colAndTypes = new HashMap();
        String sql = "select * from " + table;
        try {
   
            PreparedStatement statement = connection.prepareStatement(sql);
            //表 元数据<