mysql自动生成实体类_Java实现自动生成Mysql数据库表实体类

一个工具类就可以实现啦，直接看代码及注释，很方便理解，从一位博主那里拿到加上自己优化一部分的

注：侵删(忘了原博主信息)

Mysql2EntityGenerator.java

/**

* @(#) GenEntityMysql.java2017-2-8 下午3:06:18

*

* Copyright (c) 2014-2015 Diyvc, Inc.

* 103 Sports Road, Victoria Plaza tower 1104, Tianhe District Guangzhou City, China.

* All rights reserved.

*

*/

package com.frend.controller;

import java.io.File;

import java.io.FileWriter;

import java.io.IOException;

import java.io.PrintWriter;

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.sql.SQLException;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;

public class Mysql2EntityGenerator {

private String packageOutPath = "com.test.domain";//指定实体生成所在包的路径

private String authorName = "frend";//作者名字

private String tablename = "";//表名

private String[] colnames; // 列名数组

private String[] colTypes; //列名类型数组

private int[] colSizes; //列名大小数组

private boolean f_util = false; // 是否需要导入包java.util.*

private boolean f_sql = false; // 是否需要导入包java.sql.*

//数据库连接

private static final String URL ="jdbc:mysql://127.0.0.1:3306/sqlname";

private static final String NAME = "root";

private static final String PASSWORD = "root";

private static final String DRIVER ="com.mysql.jdbc.Driver";

/*

* 构造函数

*/

public Mysql2EntityGenerator(Connection con,String tableName){

this.tablename = tableName;

//创建连接

//查要生成实体类的表

String sql = "select * from " + tablename;

PreparedStatement pStemt = null;

try {

pStemt = con.prepareStatement(sql);

ResultSetMetaData rsmd = pStemt.getMetaData();

int size = rsmd.getColumnCount();//统计列

colnames = new String[size];

colTypes = new String[size];

colSizes = new int[size];

for (int i =