weibo4j中用到的mysql2bean的java工具

这是JAVANIU作者根据网友的代码改写的。整理一下，发表上来。

原文下载地址：点击打开链接

由于时间紧迫，对代码质量没有做过多要求，大家有需要的也可以改写下。

主要是这块的逻辑。

String sql = "show tables";    ResultSet rs = DBManager.query(conn, sql);    try {        List<String> tablenames = new ArrayList<String>();        while (rs.next()) {            String tablename = rs.getString(1);            // 生成module            parseTableByShowCreateModule(conn, tablename, packname,                    outputdir);            // 生成repository            parseTableByShowCreateRepository(conn, tablename, packname,                    outputdir);            // 生成service            parseTableByShowCreateService(conn, tablename, packname,                    outputdir);            // 生成serviceimpl            parseTableByShowCreateServiceImpl(conn, tablename, packname,                    outputdir);            // 生成controller            parseTableByShowCreateController(conn, tablename, packname,                    outputdir);            tablenames.add(tablename);        }        // 生成basecontroller        parseTableByShowCreateBaseController(conn, tablenames, packname,                outputdir);        DBManager.close(conn, null, rs);    } catch (SQLException e) {        e.printStackTrace();    }

DBManager.java

package com.javaniu;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;//本类专门用来连接数据库,可以作为固定的工具类使用(记下来即可)public class DBManager {// 定义一个静态的连接对象用来连接数据库// private static Connection conn = null;// 定一个静态的语句对象,用来执行sql语句// private static Statement stmt = null;// 定义一个静态的结果集对象用来存放执行sql语句后查询得到的结果// private static ResultSet rs = null;/** * 连接数据库的方法 *  * @return conn 返回一个连接对象 */public static Connection mssql(String url, String user, String pass) {Connection conn = null;try {// 1、加载连接驱动// "jdbc:odbc:bookdemo"Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");// 2、连接到数据库（获得连接对象）// 通过连接管理器(DriverManager)类的一个方法来获得连接对象，里面的参数表示我们连接到数据源bookdemoconn = DriverManager.getConnection(url, user, pass);} catch (ClassNotFoundException e) {// 以堆栈的方式将错误信息打印出来e.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn; // 将连接对象返回}/** * 连接数据库的方法 *  * @return conn 返回一个连接对象 * @throws ClassNotFoundException * @throws SQLException */public static Connection mysql(String url, String user, String pass)throws ClassNotFoundException, SQLException {Connection conn = null;// 1、加载连接驱动// "jdbc:odbc:bookdemo"Class.forName("com.mysql.jdbc.Driver");// 2、连接到数据库（获得连接对象）// 通过连接管理器(DriverManager)类的一个方法来获得连接对象，里面的参数表示我们连接到数据源bookdemoconn = DriverManager.getConnection(url, user, pass);return conn; // 将连接对象返回}/** * 动漫网的mysql数据库连接 *  * @throws SQLException * @throws ClassNotFoundException */public static Connection mysql(String host, String database, String user,String pass) throws ClassNotFoundException, SQLException {String url = "jdbc:mysql://" + host + "/" + database+ "?useUnicode=true&characterEncoding=utf-8";return mysql(url, user, pass);}/** * 本函数用来执行用户传入的sql语句(仅限于select语句) *  * @param sql *            传入的sql语句，等待执行 * @return 返回执行sql语句后的结果集对象 */public static ResultSet query(Connection conn, String sql) {ResultSet rs = null;try {// 3、通过连接对象创建一个语句对象stmt，用来执行sql语句Statement stmt = conn.createStatement();// 4、执行sql语句，得到一个rs（结果集对象）rs = stmt.executeQuery(sql);} catch (Exception e) { // 错误处理，暂时不用理会e.printStackTrace();}return rs; // 将查询得到的结果集对象返回}/** * 本方法用来执行更新语句，并返回影响了多少行（insert,update,delete） *  * @param sql *            传入的sql语句，等待执行 * @return 返回执行sql语句后的结果集对象 */public static int update(Connection conn, String sql) {// 执行sql语句前先连接到数据库Statement stmt = null;int i = 0;try {// 通过连接对象创建一个语句对象stmt，用来执行sql语句stmt = conn.createStatement();// 执行更新语句，并返回影响了多少行i = stmt.executeUpdate(sql);} catch (Exception e) { // 错误处理，暂时不用理会e.printStackTrace();} finally {try {stmt.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}return i;}public static void close(Connection conn, Statement stmt, ResultSet rs) {try {if (rs != null) {rs.close();rs = null;}if (stmt != null) {stmt.close();stmt = null;}if (conn != null) {conn.close();conn = null;}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}

MySQLToBean.java

package com.javaniu;import java.awt.BorderLayout;import java.awt.Color;import java.awt.EventQueue;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.WindowAdapter;import java.awt.event.WindowEvent;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.FileWriter;import java.io.IOException;import java.io.InputStream;import java.io.OutputStream;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Date;import java.util.List;import java.util.Properties;import java.util.regex.Matcher;import java.util.regex.Pattern;import javax.swing.JButton;import javax.swing.JCheckBox;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JTextField;import javax.swing.UIManager;import javax.swing.UnsupportedLookAndFeelException;public class MySQLToBean extends JFrame {/** *  */private static final long serialVersionUID = 1L;private JCheckBox checkBox;Properties p = new Properties();String configFile = "config.ini";private JLabel lblNewLabel_4;public MySQLToBean() {setResizable(false);setTitle("MySQL生成javabean小工具");setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);setBounds(100, 100, 484, 324);JPanel panel = new JPanel();getContentPane().add(panel, BorderLayout.CENTER);panel.setLayout(null);txtLocalhost = new JTextField();txtLocalhost.setText("localhost");txtLocalhost.setBounds(146, 10, 147, 21);panel.add(txtLocalhost);txtLocalhost.setColumns(10);JLabel lblIp = new JLabel("IP:");lblIp.setBounds(80, 13, 30, 15);panel.add(lblIp);JLabel label = new JLabel("数据库:");label.setBounds(80, 42, 54, 15);panel.add(label);textField = new JTextField();textField.setBounds(146, 39, 147, 21);textField.setText("weibo4j");panel.add(textField);textField.setColumns(10);JLabel label_1 = new JLabel("表名:");label_1.setBounds(80, 127, 54, 15);panel.add(label_1);textField_1 = new JTextField();textField_1.setBounds(146, 124, 147, 21);panel.add(textField_1);textField_1.setColumns(10);JLabel label_2 = new JLabel("包名:");label_2.setBounds(79, 156, 54, 15);panel.add(label_2);txtComyourcom = new JTextField();txtComyourcom.setText("com.javaniu.weibo4j");txtComyourcom.setBounds(146, 155, 147, 21);panel.add(txtComyourcom);txtComyourcom.setColumns(10);JLabel lblNewLabel = new JLabel("输出目录：");lblNewLabel.setBounds(80, 190, 65, 15);panel.add(lblNewLabel);textField_3 = new JTextField();textField_3.setBounds(146, 186, 147, 21);textField_3.setText("c:/");panel.add(textField_3);textField_3.setColumns(10);checkBox = new JCheckBox("生成包结构目录");checkBox.setSelected(true);checkBox.setBounds(145, 213, 147, 23);panel.add(checkBox);JLabel lblNewLabel_1 = new JLabel("可以指定表名，也可以不指定");lblNewLabel_1.setBounds(303, 127, 176, 15);panel.add(lblNewLabel_1);JLabel lblNewLabel_2 = new JLabel("* 数据库名");lblNewLabel_2.setForeground(Color.RED);lblNewLabel_2.setBounds(303, 42, 66, 15);panel.add(lblNewLabel_2);JLabel lblNewLabel_3 = new JLabel("* 包结构");lblNewLabel_3.setForeground(Color.RED);lblNewLabel_3.setBounds(303, 158, 79, 15);panel.add(lblNewLabel_3);JButton button = new JButton("执行");button.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {go();}});button.setBounds(145, 242, 93, 23);panel.add(button);textField_4 = new JTextField();textField_4.setText("111111");textField_4.setBounds(145, 93, 147, 21);panel.add(textField_4);textField_4.setColumns(10);txtRoot = new JTextField();txtRoot.setText("root");txtRoot.setBounds(145, 66, 148, 21);panel.add(txtRoot);txtRoot.setColumns(10);JLabel label_3 = new JLabel("用户名:");label_3.setBounds(80, 69, 54, 15);panel.add(label_3);JLabel label_4 = new JLabel("密码:");label_4.setBounds(80, 96, 54, 15);panel.add(label_4);lblNewLabel_4 = new JLabel("");lblNewLabel_4.setForeground(Color.RED);lblNewLabel_4.setBounds(248, 242, 204, 23);panel.add(lblNewLabel_4);addWindowListener(new WindowAdapter() {public void windowClosing(WindowEvent e) {super.windowClosing(e);// export();System.exit(0);}});// inport();}static SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");private JTextField txtLocalhost;private JTextField textField;private JTextField textField_1;private JTextField txtComyourcom;private JTextField textField_3;private JTextField textField_4;private JTextField txtRoot;/** * @param args */public static void main(String[] args) {//// String field = "create_time";// int idx = field.indexOf("_");// if (idx != -1) {// String temp = field.substring(idx + 1, idx + 2);// String temp2 = new MySQLToBean().upperFirestChar(temp);// field = field.replaceFirst("_" + temp, temp2);// }// System.out.println(field);try {UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());} catch (ClassNotFoundException e) {e.printStackTrace();} catch (InstantiationException e) {e.printStackTrace();} catch (IllegalAccessException e) {e.printStackTrace();} catch (UnsupportedLookAndFeelException e) {e.printStackTrace();}EventQueue.invokeLater(new Runnable() {public void run() {try {MySQLToBean frame = new MySQLToBean();frame.setLocationRelativeTo(null);frame.setVisible(true);} catch (Exception e) {e.printStackTrace();}}});}private void inport() {File config = new File(configFile);if (config.exists()) {try {InputStream is = new FileInputStream(config);p.load(is);is.close();setUIVal();} catch (FileNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}} else {try {config.createNewFile();} catch (IOException e) {e.printStackTrace();}}}public void setUIVal() {txtLocalhost.setText(p.getProperty("host", "localhost"));textField.setText(p.getProperty("database", "javaniu2"));txtRoot.setText(p.getProperty("user", "root"));textField_4.setText(p.getProperty("pass", "111111"));txtComyourcom.setText(p.getProperty("packname", "com.javaniu.weibo4j"));textField_3.setText(p.getProperty("dirstr", "c:/"));textField_1.setText(p.getProperty("tablename", ""));}private void export() {String host = txtLocalhost.getText();String database = textField.getText();String user = txtRoot.getText();String pass = textField_4.getText();String packname = txtComyourcom.getText();String dirstr = textField_3.getText();// 空表示当前目录String tablename = textField_1.getText();p.setProperty("host", host);p.setProperty("database", database);p.setProperty("user", user);p.setProperty("pass", pass);p.setProperty("packname", packname);p.setProperty("dirstr", dirstr);p.setProperty("tablename", tablename);try {OutputStream out = new FileOutputStream(configFile);p.store(out, "退出保存文件," + sdf.format(new Date()));} catch (FileNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}public void setTips(String msg) {lblNewLabel_4.setText(msg);}public void go() {String host = txtLocalhost.getText();String database = textField.getText();if (database.length() == 0) {setTips("数据库名必填");return;}String user = txtRoot.getText();String pass = textField_4.getText();String packname = txtComyourcom.getText();String dirstr = textField_3.getText();// 空表示当前目录String tablename = textField_1.getText();boolean createPackage = checkBox.getSelectedObjects() != null;System.out.println(createPackage);if (dirstr != null && !dirstr.isEmpty()) {if (!dirstr.endsWith("/")) {dirstr += "/";}}File dir = new File(dirstr);if (createPackage) {dir = new File(dirstr + packname.replaceAll("\\.", "/"));if (!dir.exists()) {dir.mkdirs();}}String outputdir = dir.getAbsolutePath();// bean的生成目录Connection conn = null;try {conn = DBManager.mysql(host, database, user, pass);if (tablename.length() > 0) {parseTableByShowCreateModule(conn, tablename, packname,outputdir);} else {parseAllTable(conn, packname, outputdir);}} catch (ClassNotFoundException e) {e.printStackTrace();setTips("找不到MySQL的jar包");} catch (SQLException e) {e.printStackTrace();}}/** * 开始处理生成所有表 如果不传入表名，表示将数据库中所有表生成bean; 可以指定表名生成bean; */public void parseAllTable(Connection conn, String packname, String outputdir) {String sql = "show tables";ResultSet rs = DBManager.query(conn, sql);try {List tablenames = new ArrayList();while (rs.next()) {String tablename = rs.getString(1);// 生成moduleparseTableByShowCreateModule(conn, tablename, packname,outputdir);// 生成repositoryparseTableByShowCreateRepository(conn, tablename, packname,outputdir);// 生成serviceparseTableByShowCreateService(conn, tablename, packname,outputdir);// 生成serviceimplparseTableByShowCreateServiceImpl(conn, tablename, packname,outputdir);// 生成controllerparseTableByShowCreateController(conn, tablename, packname,outputdir);tablenames.add(tablename);}// 生成basecontrollerparseTableByShowCreateBaseController(conn, tablenames, packname,outputdir);DBManager.close(conn, null, rs);} catch (SQLException e) {e.printStackTrace();}}/** * 通过 mysql的 show create table TABLE_NAME逆向生成Bean; *  * @param conn * @param tname * @param outputdir * @param packname */private void parseTableByShowCreateModule(Connection conn,String tablename, String packname, String outputdir) {StringBuilder classInfo = new StringBuilder("/**\r\n\t*");String sql = "show create table " + tablename;String _tablename = tablename;tablename = replaceS(tablename);ResultSet rs = null;try {rs = DBManager.query(conn, sql);StringBuilder fields = new StringBuilder();StringBuilder methods = new StringBuilder();while (rs.next()) {String sqlstr = rs.getString(2);String lines[] = sqlstr.split("\r\n");for (int i = 0; i < lines.length; i++) {String line = lines[i];System.out.println(line);// System.out.println("------------");String regex = "\\s*`([^`]*)`\\s*(\\w+[^ ]*)\\s*(NOT\\s+NULL\\s*)?(AUTO_INCREMENT\\s*)?(DEFAULT\\s*([^ ]*|NULL|'0'|''|CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)\\s*)?(COMMENT\\s*'([^']*)')?\\s*,\\s*";Pattern p = Pattern.compile(regex);Matcher m = p.matcher(line);while (m.find()) {String field = m.group(1);if (field.equals("created_at")) {continue;}if (field.equals("id")) {continue;}field = replaceS(field);String type = typeTrans(m.group(2));fields.append(getFieldStr(field, type));methods.append(getMethodStr(field, type));}if (i == lines.length - 1) {classInfo.append("*@author javaniu\r\n");classInfo.append(sdf.format(new Date()));classInfo.append("\r\n*/\r\n");}}}classInfo.append("import javax.persistence.Entity;\n");classInfo.append("import javax.persistence.Table;\n");classInfo.append("import org.apache.commons.lang.builder.ToStringBuilder;\n");classInfo.append("import java.util.Date;\n");classInfo.append("@Entity\n");classInfo.append("@Table(name = \"" + _tablename + "\")\n");classInfo.append("public class ").append(tablename + " extends BaseEntity").append("{\r\n");classInfo.append(fields);classInfo.append("\t public " + tablename + "() {\n");classInfo.append("\t \tthis.createAt = new Date();\n");classInfo.append("\t }\n");classInfo.append(methods);classInfo.append("\t @Override\n");classInfo.append("\t public String toString() {\n");classInfo.append("\t \treturn ToStringBuilder.reflectionToString(this);\n");classInfo.append("\t }");classInfo.append("\r\n");classInfo.append("}");} catch (SQLException e) {e.printStackTrace();}String packageinfo = "package " + packname + ".module;\r\n\r\n";File file = new File(outputdir + "/module", tablename + ".java");System.out.println(file.getAbsolutePath());try {File parent = file.getParentFile();if (!parent.exists()) {parent.mkdirs();}FileWriter fw = new FileWriter(file);fw.write(packageinfo);fw.write(classInfo.toString());fw.flush();fw.close();} catch (IOException e) {e.printStackTrace();}}private void parseTableByShowCreateRepository(Connection conn,String tablename, String packname, String outputdir) {StringBuilder classInfo = new StringBuilder("");tablename = replaceS(tablename);classInfo.append("import org.springframework.data.jpa.repository.JpaRepository;\n");classInfo.append("import com.javaniu.weibo4j.module." + tablename+ ";\n");classInfo.append("\t/**\r\n\t*");classInfo.append("\t*@author javaniu\r\n");classInfo.append(sdf.format(new Date()));classInfo.append("\r\n\t*/\r\n\r\n");classInfo.append("public interface ").append(tablename + "Repository").append(" extends JpaRepository<" + tablename + ", Long>").append("{\r\n");classInfo.append("\r\n");classInfo.append("}");String packageinfo = "package " + packname + ".repository;\r\n\r\n";File file = new File(outputdir + "/repository", tablename+ "Repository.java");System.out.println(file.getAbsolutePath());try {File parent = file.getParentFile();if (!parent.exists()) {parent.mkdirs();}FileWriter fw = new FileWriter(file);fw.write(packageinfo);fw.write(classInfo.toString());fw.flush();fw.close();} catch (IOException e) {e.printStackTrace();}}private void parseTableByShowCreateService(Connection conn,String tablename, String packname, String outputdir) {StringBuilder classInfo = new StringBuilder("");tablename = replaceS(tablename);classInfo.append("import com.javaniu.weibo4j.module." + tablename+ ";\n");classInfo.append("import java.util.List;\n");classInfo.append("\t/**\r\n\t*");classInfo.append("\t*@author javaniu\r\n");classInfo.append(sdf.format(new Date()));classInfo.append("\r\n\t*/\r\n\r\n");classInfo.append("public interface ").append(tablename + "Service").append("{\r\n");classInfo.append("\t public void save(" + tablename + " "+ lowerFirestChar(tablename) + ");\n");classInfo.append("\t public void save(List<" + tablename + "> "+ lowerFirestChar(tablename) + "s);\n");classInfo.append("\t public void delete(long id);\n");classInfo.append("\t public " + tablename + " findById(long id);\n");classInfo.append("\t public Iterable<" + tablename+ "> findByIds(List ids);\n");classInfo.append("}");String packageinfo = "package " + packname + ".service;\r\n\r\n";File file = new File(outputdir + "/service", tablename + "Service.java");System.out.println(file.getAbsolutePath());try {File parent = file.getParentFile();if (!parent.exists()) {parent.mkdirs();}FileWriter fw = new FileWriter(file);fw.write(packageinfo);fw.write(classInfo.toString());fw.flush();fw.close();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}private void parseTableByShowCreateServiceImpl(Connection conn,String tablename, String packname, String outputdir) {StringBuilder classInfo = new StringBuilder("");tablename = replaceS(tablename);classInfo.append("import org.springframework.stereotype.Service;\n");classInfo.append("import com.javaniu.weibo4j.service." + tablename+ "Service;\n");classInfo.append("import com.javaniu.weibo4j.module." + tablename+ ";\n");classInfo.append("import java.util.List;\n");classInfo.append("import com.javaniu.weibo4j.repository." + tablename+ "Repository;\n");classInfo.append("import org.springframework.transaction.annotation.Transactional;\n");classInfo.append("import javax.annotation.Resource;\n");classInfo.append("\t/**\r\n\t*");classInfo.append("\t*@author javaniu\r\n");classInfo.append(sdf.format(new Date()));classInfo.append("\r\n\t*/\r\n\r\n");classInfo.append("@Service\n");classInfo.append("@Transactional(readOnly = true)\n");classInfo.append("public class ").append(tablename + "ServiceImpl implements " + tablename+ "Service").append("{\r\n");classInfo.append("@Resource\n");classInfo.append("private " + tablename + "Repository "+ lowerFirestChar(tablename) + "Repository;\n");classInfo.append("\t @Override\n");classInfo.append("\t @Transactional(readOnly = false)\n");classInfo.append("\t public void save(" + tablename + " "+ lowerFirestChar(tablename) + ") {\n");classInfo.append("\t \t " + lowerFirestChar(tablename)+ "Repository.save(" + lowerFirestChar(tablename) + ");\n");classInfo.append("\t }\n");classInfo.append("\t @Override\n");classInfo.append("\t @Transactional(readOnly = false)\n");classInfo.append("\t public void save(List<" + tablename + "> "+ lowerFirestChar(tablename) + "s) {\n");classInfo.append("\t \t " + lowerFirestChar(tablename)+ "Repository.save(" + lowerFirestChar(tablename) + "s);\n");classInfo.append("}\n");classInfo.append("\t @Override\n");classInfo.append("\t @Transactional(readOnly = false)\n");classInfo.append("\t public void delete(long id) {\n");classInfo.append("\t \t " + lowerFirestChar(tablename)+ "Repository.delete(id);\n");classInfo.append("\t }\n");classInfo.append("\t @Override\n");classInfo.append("\t public " + tablename + " findById(long id) {\n");classInfo.append("\t \t return " + lowerFirestChar(tablename)+ "Repository.findOne(id);\n");classInfo.append("\t }\n");classInfo.append("\t @Override\n");classInfo.append("\t public Iterable<" + tablename+ "> findByIds(List ids) {\n");classInfo.append("\t \t return " + lowerFirestChar(tablename)+ "Repository.findAll(ids);\n");classInfo.append("\t }\n");classInfo.append("}");String packageinfo = "package " + packname + ".service.impl;\r\n\r\n";File file = new File(outputdir + "/service/impl/", tablename+ "ServiceImpl.java");System.out.println(file.getAbsolutePath());try {File parent = file.getParentFile();if (!parent.exists()) {parent.mkdirs();}FileWriter fw = new FileWriter(file);fw.write(packageinfo);fw.write(classInfo.toString());fw.flush();fw.close();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}private void parseTableByShowCreateBaseController(Connection conn,List tablenames, String packname, String outputdir) {String packageinfo = "package " + packname + ".controller;\r\n\r\n";StringBuilder classInfo = new StringBuilder("");classInfo.append("import org.springframework.beans.factory.annotation.Autowired;\n");for (String tablename : tablenames) {tablename = replaceS(tablename);classInfo.append("import com.javaniu.weibo4j.service." + tablename+ "Service;\n");}classInfo.append("public abstract class BaseController").append("{\r\n");for (String tablename : tablenames) {tablename = replaceS(tablename);classInfo.append("\t @Autowired\n");classInfo.append("\t public " + tablename + "Service "+ lowerFirestChar(tablename) + "Service;\n");}classInfo.append("}");File file = new File(outputdir + "/controller", "BaseController.java");System.out.println(file.getAbsolutePath());try {File parent = file.getParentFile();if (!parent.exists()) {parent.mkdirs();}FileWriter fw = new FileWriter(file);fw.write(packageinfo);fw.write(classInfo.toString());fw.flush();fw.close();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}private void parseTableByShowCreateController(Connection conn,String tablename, String packname, String outputdir) {StringBuilder classInfo = new StringBuilder("");String _tablename = tablename;tablename = replaceS(tablename);classInfo.append("import org.springframework.stereotype.Controller;\n");classInfo.append("import org.springframework.web.bind.annotation.RequestMapping;\n");classInfo.append("\t/**\r\n\t*");classInfo.append("\t*@author javaniu\r\n");classInfo.append(sdf.format(new Date()));classInfo.append("\r\n\t*/\r\n\r\n");classInfo.append("@Controller\n");classInfo.append("@RequestMapping({ \"/" + _tablename + "\" })\n");classInfo.append("public class ").append(tablename + "Controller extends BaseController").append("{\r\n");classInfo.append("}");String packageinfo = "package " + packname + ".controller;\r\n\r\n";File file = new File(outputdir + "/controller/", tablename+ "Controller.java");System.out.println(file.getAbsolutePath());try {File parent = file.getParentFile();if (!parent.exists()) {parent.mkdirs();}FileWriter fw = new FileWriter(file);fw.write(packageinfo);fw.write(classInfo.toString());fw.flush();fw.close();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}/** *  * @param type * @return */private String getMethodStr(String field, String type) {StringBuilder get = new StringBuilder("\tpublic ");get.append(type).append(" ");if (type.equals("boolean")) {get.append(field);} else {get.append("get");get.append(field);}get.append("(){").append("\r\n\t\treturn this.").append(lowerFirestChar(field)).append(";\r\n\t}\r\n");StringBuilder set = new StringBuilder("\tpublic void ");if (type.equals("boolean")) {set.append(field);} else {set.append("set");set.append(field);}set.append("(").append(type).append(" ").append(lowerFirestChar(field)).append("){\r\n\t\tthis.").append(lowerFirestChar(field)).append("=").append(lowerFirestChar(field)).append(";\r\n\t}\r\n");get.append(set);return get.toString();}public String upperFirestChar(String src) {return src.substring(0, 1).toUpperCase().concat(src.substring(1));}public String lowerFirestChar(String src) {return src.substring(0, 1).toLowerCase().concat(src.substring(1));}private String getFieldStr(String field, String type) {StringBuilder sb = new StringBuilder();sb.append("\t").append("private ").append(type).append(" ").append(lowerFirestChar(field)).append(";");sb.append("\r\n");return sb.toString();}/** * mysql的类型转换到java 类型参考文章 * http://hi.baidu.com/wwtvanessa/blog/item/9fe555945a07bd16d31b70cd.html */public String typeTrans(String type) {if (type.contains("tinyint")) {return "boolean";} else if (type.contains("bigint")) {return "long";} else if (type.contains("int")) {return "int";} else if (type.contains("varchar") || type.contains("date")|| type.contains("time") || type.contains("datetime")|| type.contains("timestamp") || type.contains("text")|| type.contains("enum") || type.contains("set")) {return "String";} else if (type.contains("binary") || type.contains("blob")) {return "byte[]";} else {return "String";}}public String replaceS(String input) {StringBuffer output = new StringBuffer();int idx = input.indexOf("_");if (idx == -1) {output.append(new MySQLToBean().upperFirestChar(input));} else {String[] inputs = input.split("_");for (String _input : inputs) {output.append(new MySQLToBean().upperFirestChar(_input));}}return output.toString();}}