mysql 生成实体类_mysql数据库表生成实体类

mysql数据库表生成实体类代码如下，稍微改造了一下：

package com.chinamobile.pumpValve.util;

import java.io.File;

import java.io.FileWriter;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.*;

import java.text.DateFormat;

import java.text.SimpleDateFormat;

import java.util.*;

import java.util.Date;

/**

* on 2016/5/27.

*/

public class GenTableToCode {

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

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

private String tableName = "user";//表名

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

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

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

private String changeTableNameStr = "";//驼峰转换后的类名

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

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

private boolean f_decimal = false;//是否需要导入java.math.BigDecimal

//数据库连接

private static final String URL ="jdbc:mysql://localhost:3306/pump_valve";

private static final String NAME = "root";

private static final String PASS = "";

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

/*

* 构造函数

*/

public GenTableToCode(){

}

public void genTableToCode(){

//创建连接

Connection con = null;

//查要生成实体类的表

String sql = "select * from " + tableName;

PreparedStatement pStemt = null;

try {

Class.forName(DRIVER);

con = DriverManager.getConnection(URL,NAME,PASS);

pStemt = con.prepareStatement(sql);

ResultSetMetaData rsmd = pStemt.getMetaData();

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

colNames = new String[size-4];

colTypes = new String[size-4];

colSizes = new int[size-4];

for (int i = 0; i < size; i++) {

String columnName