java读取数据库指定表，生成bean，获取主键，自动生成get、set方法

开发一个程序涉及很多数据库表，之前介绍过用

EXCEL通过VBA生成SQL，自动生成创建表结构SQL

在使用mvc架构开发要将数据库表变成bean,这也是个重复性无技术含量的工作，为了打发无聊编写一个小工具，自动读取数据库并生成bean，同时生成get、set方法。

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class BeanUtil {
	private static final String TABLE_NAME = "TABLE_NAME";
	private static final String COLUMN_NAME = "COLUMN_NAME";
	private static final String DATA_TYPE = "DATA_TYPE";
	private static final String DATA_SCALE = "DATA_SCALE";
	private static final String ISPK = "ISPK";
	private static final String COMMENTS = "COMMENTS";
	

	public static void main(String[] args) {
		BeanUtil beanUtil = new BeanUtil();
		beanUtil.createBean("tablename","beanname","com.test.bean","E:\\trunk\\Sources\\trust\\com\\test\\bean\\");//填写表名，bean名，bean存放路径
                                                                         
	}
	
	@SuppressWarnings({ "rawtypes", "unchecked" })
	private void createBean(String tableName,String className,String packageName,String path){
		StringBuffer result = new StringBuffer(); 
		StringBuffer getsetresult = new StringBuffer();
		try{
			Class.forName(&