一个非常有用工具软件

这个小工具非常有用，它可以将数据库表中的字段生成对应的JavaBean，可以自动生成插入和更新select语句，还可以生成对应xml文件，解析xml文件的功能，是WEB开发中非常有用的小工具软件。
http://blog.163.com/xing_mu_1/blog/static/66142902009117101416276/

package com.bperp;/* * Created on 2005-10-9 * * TODO To change the template for this generated file go to * Window - Preferences - Java - Code Style - Code Templates *//** * @author  Kevin *  * TODO To change the template for this generated type comment go to Window - * Preferences - Java - Code Style - Code Templates */import java.awt.BorderLayout;import java.awt.Color;import java.awt.Container;import java.awt.GridLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.io.File;import java.io.FileOutputStream;import java.io.FileWriter;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.SQLException;import java.sql.Statement;import java.sql.Types;import java.util.ArrayList;import java.util.Iterator;import java.util.Random;import java.util.StringTokenizer;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JPasswordField;import javax.swing.JScrollPane;import javax.swing.JTextArea;import javax.swing.JTextField;import org.dom4j.Document;import org.dom4j.DocumentHelper;import org.dom4j.Element;import org.dom4j.io.OutputFormat;import org.dom4j.io.SAXReader;import org.dom4j.io.XMLWriter;@SuppressWarnings("serial")public class tableTojava extends JFrame { private JPanel southpanel; private JButton createbutton; private JButton sqlbutton; private JButton readbutton; private JButton insertbutton; private JButton updatebutton; private JButton jspbutton;  private JButton xmlbutton;  private JButton xmlToDB; private Container con; private JPanel northpanel; private JLabel drivertext; private JTextField driver; private JLabel urltext; private JTextField url; private JLabel usertext; private JTextField user; private JLabel passwordtext; private JPasswordField password; private JButton conn; private JButton exit; public java.awt.List tablelist; private JTextArea text; private JLabel dirtext; private JTextField dir; private JButton zhengguiInsert; private JButton zhengguiUpdate; public tableTojava() {  this.setSize(500, 500);  this.setTitle("表到JAVABEAN转换小程序");  this.setVisible(true);  this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);  init(); } public void init() {  southpanel = new JPanel();  readbutton = new JButton("生成Select语句");  insertbutton = new JButton("生成Insert语句");  updatebutton = new JButton("生成update语句");  sqlbutton = new JButton("生成sql column");  createbutton = new JButton("生成JAVABEAN");  jspbutton = new JButton("生成jsp——update页面");  zhengguiInsert = new JButton("生成jsp—正规—Insert页面");  zhengguiUpdate = new JButton("生成jsp—正规—Update页面");  xmlbutton=new JButton("生成xml文件");  xmlToDB=new JButton("将xml文件写入数据库");  conn = new JButton("连接数据库");  exit = new JButton("退出");  southpanel.setLayout(new GridLayout(4, 4));  southpanel.add(conn);  southpanel.add(createbutton);  southpanel.add(sqlbutton);  southpanel.add(readbutton);  southpanel.add(insertbutton);  southpanel.add(updatebutton);  southpanel.add(jspbutton);  southpanel.add(zhengguiInsert);  southpanel.add(zhengguiUpdate);  southpanel.add(xmlbutton);  southpanel.add(xmlToDB);  southpanel.add(exit);  exit.setToolTipText("Exit......");  exit.addActionListener(new ActionListener() {   public void actionPerformed(ActionEvent e) {    System.exit(0);   }  });  con = this.getContentPane();  con.add(southpanel, BorderLayout.SOUTH);  northpanel = new JPanel();  northpanel.setLayout(new GridLayout(5, 2));  drivertext = new JLabel("输入驱动程序名字");  driver = new JTextField(30);  northpanel.add(drivertext);  northpanel.add(driver);  urltext = new JLabel("输入要连接的URL");  url = new JTextField(50);  northpanel.add(urltext);  northpanel.add(url);  usertext = new JLabel("输入用户名");  user = new JTextField(10);  northpanel.add(usertext);  northpanel.add(user);  passwordtext = new JLabel("输入密码");  password = new JPasswordField(10);  northpanel.add(passwordtext);  northpanel.add(password);  dirtext = new JLabel("输入你要保存JAVABEAN的目录");  dir = new JTextField(20);  northpanel.add(dirtext);  northpanel.add(dir);  driver.setText("com.mysql.jdbc.Driver");  url.setText("jdbc:mysql://192.168.1.201:3306/bperp");  user.setText("root");  password.setText("bpcrm");  tablelist = new java.awt.List();  text = new JTextArea(10, 30);  JScrollPane panel = new JScrollPane(text);  text.setLineWrap(true);  con.add(panel, BorderLayout.CENTER);  con.add(tablelist, BorderLayout.WEST);  con.add(northpanel, BorderLayout.NORTH);  sqlbutton.addActionListener(new SqlAction());  readbutton.addActionListener(new ReadAction());  insertbutton.addActionListener(new InsertAction());  updatebutton.addActionListener(new UpdateAction());  createbutton.addActionListener(new CreateAction());  jspbutton.addActionListener(new jspAction());  conn.addActionListener(new ConnAction());  tablelist.addActionListener(new ChooseAction());  zhengguiInsert.addActionListener(new zhengInsertAction());  zhengguiUpdate.addActionListener(new zhengguiUpdateAction());  xmlbutton.addActionListener(new writerXMLAction());  xmlToDB.addActionListener(new readXmlToDB()); } private class readXmlToDB implements ActionListener{  public void actionPerformed(ActionEvent e) {   text.setText("");    File f=new File("d:\\"+tablelist.getSelectedItem()+".xml");     SAXReader reader = new SAXReader();        try {     Document doc = reader.read(f);     Element root = doc.getRootElement();     Element baseInfo=root.element("BaseInfo");     String componentid=baseInfo.attributeValue("componentid");     String componentname=baseInfo.attributeValue("componentname");     Iterator it=root.elementIterator();     while(it.hasNext()){      Element child=(Element)it.next();      if(!(child.getName().equals("BaseInfo"))){       String sub=child.attributeValue("simname");       String obj=child.attributeValue("fieldname");       Random ran=new Random();       int a=ran.nextInt();       int cid=Integer.parseInt(componentid);       String id=System.currentTimeMillis()+""+a;       if(hasRecord(cid,obj)){        continue;       }       insertToDB(componentid,componentname,sub,id,obj);       System.out.println(sub);      }           }     text.setText("d:\\"+tablelist.getSelectedItem()+".xml文件成功写入数据库");    } catch (Exception e1) {     text.setForeground(new Color(255,0,0));     text.setText("d:\\"+tablelist.getSelectedItem()+".xml文件写入数据库失败"+"\n"+e1.getMessage());     e1.printStackTrace();    }      }  private void insertToDB(String componentid,String componentname,String subject,String id,String objectid)throws Exception{   try {    Class.forName(driver.getText());    Connection conn = DriverManager.getConnection(url.getText()+"?useUnicode=true&characterEncoding=GBK",      user.getText(), String.copyValueOf(password.getPassword()));    String sql="INSERT INTO comm_property VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";    PreparedStatement ps=conn.prepareStatement(sql);    int p=1;    ps.setString(p++, id);    ps.setString(p++, subject);    ps.setString(p++, "");    ps.setString(p++, componentid);    ps.setString(p++, componentname);    ps.setString(p++, objectid);    ps.setString(p++, "");    ps.setDate(p++, java.sql.Date.valueOf("2009-12-02"));    ps.setDate(p++,  java.sql.Date.valueOf("2009-12-02"));    ps.setString(p++, "091202");    ps.setString(p++, "kevin");    if (ps.executeUpdate() == 0) {      throw new Exception("插入错误");    }   } catch (Exception e) {    throw e;   }   }  private boolean hasRecord(int componentid, String objectid) throws Exception{   boolean b = false;   Connection conn = null;   PreparedStatement ps = null;   ResultSet rs = null;   try {    Class.forName(driver.getText());    conn = DriverManager.getConnection(url.getText()      + "?useUnicode=true&characterEncoding=GBK", user      .getText(), String.copyValueOf(password.getPassword()));    String sql = " SELECT * FROM comm_property  a "      + " where a.componentid = ? and objectid = ?";    ps = conn.prepareStatement(sql);    ps.setInt(1, componentid);    ps.setString(2, objectid);    rs=ps.executeQuery();    if(rs.next()){     b=true;    }   } catch (Exception e) {    throw e;   }finally{    try {     rs.close();    } catch (SQLException e) {     throw e;    }   }   return b;  } } private class writerXMLAction implements ActionListener{  public writerXMLAction(){     }  public void actionPerformed(ActionEvent e) {   text.setText("");    try {              XMLWriter writer = null;// 声明写XML的对象              OutputFormat format = OutputFormat.createPrettyPrint();              format.setEncoding("GB2312");// 设置XML文件的编码格式              String filePath = "d:\\"+tablelist.getSelectedItem()+".xml";              File file = new File(filePath);                 Document document = DocumentHelper.createDocument();                 Element root = document.addElement("TableInfo");                 Element baseInfo = root.addElement("BaseInfo");                 baseInfo.addAttribute("TableName", tablelist.getSelectedItem());                 baseInfo.addAttribute("componentid","");                 baseInfo.addAttribute("componentname","");                 java.util.List list = this.getList();                 Iterator it = list.iterator();                 while(it.hasNext()){                  String str = (String) it.next();                  String s[]=str.split(",");                  Element fieldInfo = root.addElement("FieldInfo");                  fieldInfo.addAttribute("fieldname",s[1]);                  fieldInfo.addAttribute("fieldtype",s[0]);                  fieldInfo.addAttribute("fieldlength",s[2]);                  fieldInfo.addAttribute("simname","");                 }                 writer = new XMLWriter(new FileWriter(file), format);                 writer.write(document);                 writer.close();                 text.setText("生成xml文件成功，文件路径为d:\\"+tablelist.getSelectedItem()+".xml");    }catch(Exception e1){     text.setForeground(new Color(255,0,0));     text.setText("生成xml文件失败"+"\n"+e1.getMessage());     e1.printStackTrace();    }     }  private java.util.List getList() throws Exception{   try {    java.util.List<String> list = new ArrayList<String>();    Class.forName(driver.getText());    Connection conn = DriverManager.getConnection(url.getText(),      user.getText(), String.copyValueOf(password.getPassword()));    Statement stmt = conn.createStatement();    ResultSet rs = stmt.executeQuery("select * from "      + tablelist.getSelectedItem());    ResultSetMetaData rsmd = rs.getMetaData();    for (int i = 1; i <= rsmd.getColumnCount(); i++)     list.add((String) getColumString(i, rs) + ","+rsmd.getColumnName(i)+","+       rsmd.getColumnDisplaySize(i));    return list;   } catch (Exception e) {    throw e;   }     }   } private class zhengguiUpdateAction implements ActionListener {  public zhengguiUpdateAction() {  }  public void actionPerformed(ActionEvent e) {   text.setText("");   try {    java.util.List list = this.getList();    StringBuffer bf = new StringBuffer();    bf.append("\"update  " + tablelist.getSelectedItem() + " set ");    Iterator it = list.iterator();    while (it.hasNext()) {     String str = (String) it.next();     bf.append(str + "=" + "\"+" + "\"'\"+" + "value.get"       + getFirst(str) + "()" + "+\"',");    }    // String str="update student set    // myid="+"'"+value.getMyid()+"',address="+"'"+value.getAddress()+"',email="+"'"+value.getEmail()+"';    text.setText(bf.toString());    // String s=    // String st= "update student set    // myid="+"'"+value.getMyid()+"',address="+"'"+value.getAddress()+"',email="+"'"+value.getEmail()+"';   } catch (Exception ex) {    ex.printStackTrace();   }     }  private java.util.List getList() {   try {    java.util.List<String> list = new ArrayList<String>();    Class.forName(driver.getText());    Connection conn = DriverManager.getConnection(url.getText(),      user.getText(), String.copyValueOf(password.getPassword()));    Statement stmt = conn.createStatement();    ResultSet rs = stmt.executeQuery("select * from "      + tablelist.getSelectedItem());    ResultSetMetaData rsmd = rs.getMetaData();    for (int i = 1; i <= rsmd.getColumnCount(); i++)     list.add(rsmd.getColumnName(i));    return list;   } catch (Exception e) {    e.printStackTrace();    return null;   }  } } private class zhengInsertAction implements ActionListener {  public zhengInsertAction() {  }  public void actionPerformed(ActionEvent e) {   text.setText("");   try {    java.util.List list = this.getList();    StringBuffer bf = new StringBuffer();    bf      .append("\" insert into " + tablelist.getSelectedItem()        + "(");    Iterator it = list.iterator();    while (it.hasNext()) {     bf.append((String) it.next() + ",");    }    bf.append(")");    bf.append("  values(" + "\"" + "\'");    Iterator itt = list.iterator();    while (itt.hasNext()) {     bf.append("," + "\'" + "\"" + "+value.get"       + getFirst((String) itt.next()) + "()" + "+\""       + "\'");    }    bf.append(")");    text.setText(bf.toString());   } catch (Exception ex) {    ex.printStackTrace();   }  }  private java.util.List getList() {   try {    java.util.List<String> list = new ArrayList<String>();    Class.forName(driver.getText());    Connection conn = DriverManager.getConnection(url.getText(),      user.getText(), String.copyValueOf(password.getPassword()));    Statement stmt = conn.createStatement();    ResultSet rs = stmt.executeQuery("select * from "      + tablelist.getSelectedItem());    ResultSetMetaData rsmd = rs.getMetaData();    for (int i = 1; i <= rsmd.getColumnCount(); i++)     list.add(rsmd.getColumnName(i));    return list;   } catch (Exception e) {    e.printStackTrace();    return null;   }  } } private class CreateAction implements ActionListener {  public CreateAction() {  }  public void actionPerformed(ActionEvent e) {   StringBuffer bf = new StringBuffer();   text.setText("");   bf.append("import java.io.Serializable;\n\n");   bf.append("//*对应的表：").append(tablelist.getSelectedItem() + "\n\n");   try {    Class.forName(driver.getText());    Connection conn = DriverManager.getConnection(url.getText(),      user.getText(), String.copyValueOf(password.getPassword()));    Statement stmt = conn.createStatement();    String tablename = tablelist.getSelectedItem();    ResultSet rs = stmt.executeQuery("select * from " + tablename);    String classname = getFirst(tablename.substring(3)) + "Value";    bf.append("public class " + classname      + "  implements Serializable \n { \n");    ArrayList rsmd = (ArrayList) getColumnNames(rs);    Iterator it = rsmd.iterator();    while (it.hasNext()) {     String temp = (String) it.next();     bf.append("           private  ").append(temp + ";\n");    }    bf.append("\n");    Iterator itt = rsmd.iterator();    while (itt.hasNext()) {     String temp = (String) itt.next();     StringTokenizer st = new StringTokenizer(temp, " ");     String type = st.nextToken();     String name = st.nextToken();     bf.append("          public void set").append(       getFirst(name)).append("(").append(type)       .append(" ").append(name).append(")\n");     bf.append("           {\n");     bf.append("            ").append("   this." + name).append(       "=").append(name).append(";\n");     bf.append("           }");     bf.append("\n");     bf.append("          public ").append(type).append(" get")       .append(getFirst(name)).append("(").append(")\n");     bf.append("           {\n");     bf.append("            ").append("   return this.").append(       name).append(";\n");     bf.append("           }");     bf.append("\n");    }    bf.append("}");    text.append(bf.toString());    String filename = dir.getText() + "\\";    File f = new File(filename + classname + ".java");    FileOutputStream out = new FileOutputStream(f);    out.write(text.getText().getBytes());    out.close();   } catch (Exception ex) {    ex.printStackTrace();   }  } } private class SqlAction implements ActionListener {  public SqlAction() {  }  public void actionPerformed(ActionEvent e) {   text.setText("");   try {    Class.forName(driver.getText());    Connection conn = DriverManager.getConnection(url.getText(),      user.getText(), String.copyValueOf(password.getPassword()));    Statement stmt = conn.createStatement();    String tablename = tablelist.getSelectedItem();    ResultSet rs = stmt.executeQuery("select * from " + tablename);    ArrayList rsmd = (ArrayList) getColumn(rs);    Iterator it = rsmd.iterator();    while (it.hasNext()) {     text.append((String) it.next());    }    rs.close();    stmt.close();    conn.close();   } catch (Exception ex) {    e.paramString();   }  } } private class ReadAction implements ActionListener {  public ReadAction() {  }  public void actionPerformed(ActionEvent e) {   text.setText("");   try {    Class.forName(driver.getText());    Connection conn = DriverManager.getConnection(url.getText(),      user.getText(), String.copyValueOf(password.getPassword()));    Statement stmt = conn.createStatement();    String tablename = tablelist.getSelectedItem();    ResultSet rs = stmt.executeQuery("select * from " + tablename);    ArrayList rsmd = (ArrayList) getReadColumn(rs);    Iterator it = rsmd.iterator();    while (it.hasNext()) {     text.append((String) it.next());    }    rs.close();    stmt.close();    conn.close();   } catch (Exception ex) {    e.paramString();   }  } } private class InsertAction implements ActionListener {  public InsertAction() {  }  public void actionPerformed(ActionEvent e) {   text.setText("");   try {    Class.forName(driver.getText());    Connection conn = DriverManager.getConnection(url.getText(),      user.getText(), String.copyValueOf(password.getPassword()));    Statement stmt = conn.createStatement();    String tablename = tablelist.getSelectedItem();    ResultSet rs = stmt.executeQuery("select * from " + tablename);    ArrayList rsmd = (ArrayList) getInsertColumn(rs);    Iterator it = rsmd.iterator();    while (it.hasNext()) {     text.append((String) it.next());    }    rs.close();    stmt.close();    conn.close();   } catch (Exception ex) {    e.paramString();   }  } } private class UpdateAction implements ActionListener {  public UpdateAction() {  }  public void actionPerformed(ActionEvent e) {   text.setText("");   try {    Class.forName(driver.getText());    Connection conn = DriverManager.getConnection(url.getText(),      user.getText(), String.copyValueOf(password.getPassword()));    Statement stmt = conn.createStatement();    String tablename = tablelist.getSelectedItem();    ResultSet rs = stmt.executeQuery("select * from " + tablename);    ArrayList rsmd = (ArrayList) getUpdateColumn(rs);    Iterator it = rsmd.iterator();    while (it.hasNext()) {     text.append((String) it.next());    }    rs.close();    stmt.close();    conn.close();   } catch (Exception ex) {    e.paramString();   }  } } private class ChooseAction implements ActionListener {  public ChooseAction() {  }  public void actionPerformed(ActionEvent e) {   text.setText("");   try {    Class.forName(driver.getText());    Connection conn = DriverManager.getConnection(url.getText(),      user.getText(), String.copyValueOf(password.getPassword()));    Statement stmt = conn.createStatement();    String tablename = tablelist.getSelectedItem();    ResultSet rs = stmt.executeQuery("select * from " + tablename);    ArrayList rsmd = (ArrayList) getColumnNames(rs);    Iterator it = rsmd.iterator();    while (it.hasNext()) {     text.append((String) it.next() + "\n");    }    rs.close();    stmt.close();    conn.close();   } catch (Exception ex) {    e.paramString();   }  } } private class ConnAction implements ActionListener {  public ConnAction() {  }  public void actionPerformed(ActionEvent e) {   try {    Class.forName(driver.getText());    Connection conn = DriverManager.getConnection(url.getText(),      user.getText(), String.copyValueOf(password.getPassword()));    Statement stmt = conn.createStatement();    ResultSet rs = stmt.executeQuery("show tables");    while (rs.next()) {     tablelist.add(rs.getString(1));    }    rs.close();    stmt.close();    conn.close();   } catch (Exception ex) {    ex.printStackTrace();   }  } } public java.util.List getColumnNames(ResultSet rs) {  java.util.List<String> list = new ArrayList<String>();  try {   ResultSetMetaData rsmd = rs.getMetaData();   for (int i = 1; i <= rsmd.getColumnCount(); i++)    list.add((String) getColumString(i, rs) + " "      + rsmd.getColumnName(i));   return list;  } catch (Exception e) {   e.printStackTrace();   return null;  } } public java.util.List getColumnPara(ResultSet rs) {  java.util.List<String> list = new ArrayList<String>();  try {   ResultSetMetaData rsmd = rs.getMetaData();   for (int i = 1; i <= rsmd.getColumnCount(); i++)    list.add("?");   return list;  } catch (Exception e) {   e.printStackTrace();   return null;  } } public java.util.List getColumnPara1(ResultSet rs) {  java.util.List<String> list = new ArrayList<String>();  try {   ResultSetMetaData rsmd = rs.getMetaData();   for (int i = 1; i <= rsmd.getColumnCount(); i++)    list.add("\"" + rsmd.getColumnName(i));   return list;  } catch (Exception e) {   e.printStackTrace();   return null;  } } public java.util.List getColumnUpdatePara(ResultSet rs) {  java.util.List<String> list = new ArrayList<String>();  try {   ResultSetMetaData rsmd = rs.getMetaData();   for (int i = 1; i <= rsmd.getColumnCount(); i++)    list.add(rsmd.getColumnName(i) + "=?");   return list;  } catch (Exception e) {   e.printStackTrace();   return null;  } } public java.util.List getColumn(ResultSet rs) {  java.util.List<String> list = new ArrayList<String>();  try {   ResultSetMetaData rsmd = rs.getMetaData();   for (int i = 1; i <= rsmd.getColumnCount(); i++)    list.add(rsmd.getColumnName(i) + ", ");   return list;  } catch (Exception e) {   e.printStackTrace();   return null;  } } public java.util.List getReadColumn(ResultSet rs) {  java.util.List<String> list = new ArrayList<String>();  try {   ResultSetMetaData rsmd = rs.getMetaData();   String tablename = tablelist.getSelectedItem();   String classname = getFirst(tablename.substring(3)) + "Value";   String strwhile = " Vector mList = new Vector();\n";   strwhile = " while (rs.next()) { \n ";   strwhile = strwhile + " int k = 1;\n";   strwhile = strwhile + " " + classname + " value = new " + classname     + "();\n";   list.add(strwhile);   for (int i = 1; i <= rsmd.getColumnCount(); i++) {    String sql = " value.set" + getFirst(rsmd.getColumnName(i))      + "(rs.getString(k++));\n";    list.add(sql);   }   list.add("  mList.add(value);\n");   list.add("}");   return list;  } catch (Exception e) {   e.printStackTrace();   return null;  } } public java.util.List getInsertColumn(ResultSet rs) {  java.util.List<String> list = new ArrayList<String>();  try {   ResultSetMetaData rsmd = rs.getMetaData();   String tablename = tablelist.getSelectedItem();   // String classname=getFirst(tablename.substring(3))+"Value";   String strsql = " String sql = \"\";\n";   strsql = strsql     + " sql = \"INSERT INTO "     + tablename     + "( \"+"     + tablename     + "Fields"     + "+\" ) VALUES ("     + getColumnPara(rs).toString().substring(1,       getColumnPara(rs).toString().length() - 1)     + ")\";\n";   strsql = strsql + " con = dataSource.getConnection(); \n";   strsql = strsql + " ps = con.prepareStatement(sql); \n";   strsql = strsql + " int p=1; \n";   list.add(strsql);   for (int i = 1; i <= rsmd.getColumnCount(); i++) {    String sql = " ps.setString(p++, value.get"      + getFirst(rsmd.getColumnName(i)) + "());\n";    list.add(sql);   }   return list;  } catch (Exception e) {   e.printStackTrace();   return null;  } } public java.util.List getUpdateColumn(ResultSet rs) {  java.util.List<String> list = new ArrayList<String>();  try {   ResultSetMetaData rsmd = rs.getMetaData();   String tablename = tablelist.getSelectedItem();   // String classname=getFirst(tablename.substring(3))+"Value";   String strsql = " String sql = \"\";\n";   strsql = strsql     + " sql = \"UPDATE "     + tablename     + " SET "     + getColumnUpdatePara(rs).toString().substring(1,       getColumnUpdatePara(rs).toString().length() - 1)     + " WHERE ****************=? " + "\";\n";   strsql = strsql + " con = dataSource.getConnection(); \n";   strsql = strsql + " ps = con.prepareStatement(sql); \n";   strsql = strsql + " int p=1; \n";   list.add(strsql);   for (int i = 1; i <= rsmd.getColumnCount(); i++) {    String sql = " ps.setString(p++, value.get"      + getFirst(rsmd.getColumnName(i)) + "());\n";    list.add(sql);   }   return list;  } catch (Exception e) {   e.printStackTrace();   return null;  } } private class jspAction implements ActionListener {  public jspAction() {  }  public void actionPerformed(ActionEvent e) {   text.setText("");   try {    Class.forName(driver.getText());    Connection conn = DriverManager.getConnection(url.getText(),      user.getText(), String.copyValueOf(password.getPassword()));    Statement stmt = conn.createStatement();    String tablename = tablelist.getSelectedItem();    ResultSet rs = stmt.executeQuery("select * from " + tablename);    ArrayList rsmd = (ArrayList) getColumnJSP(rs);    Iterator it = rsmd.iterator();    while (it.hasNext()) {     text.append((String) it.next() + "\n");    }    rs.close();    stmt.close();    conn.close();   } catch (Exception ex) {    e.paramString();   }  } } public java.util.List getColumnJSP(ResultSet rs) {  java.util.List<String> list = new ArrayList<String>();  try {   ResultSetMetaData rsmd = rs.getMetaData();   try {    for (int i = 1; i <= rsmd.getColumnCount(); i++)     list.add((String) getColumString(i, rs) + " "       + rsmd.getColumnName(i)       + " = request.getParameter(\""       + rsmd.getColumnName(i) + "\");");   } catch (Exception e) {    e.printStackTrace();    return null;   }   String tablename = tablelist.getSelectedItem();   String classname = getFirst(tablename.substring(3)) + "Value";   String strwhile = " " + classname + " value = new " + classname     + "();\n";   list.add(strwhile);   try {    for (int i = 1; i <= rsmd.getColumnCount(); i++) {     String xx = " value.set" + getFirst(rsmd.getColumnName(i))       + "(" + rsmd.getColumnName(i) + ");";     list.add(xx);    }   } catch (Exception e) {    e.printStackTrace();    return null;   }   return list;  } catch (Exception e) {   e.printStackTrace();   return null;  } } public Object getColumString(int col, ResultSet rs) {  Object obj = null;  int type = 0;  try {   type = rs.getMetaData().getColumnType(col);   switch (type) {   case Types.BIGINT:   case Types.INTEGER:   case Types.SMALLINT:   case Types.TINYINT:    obj = "int";    break;   case Types.DOUBLE:   case Types.DECIMAL:   case Types.NUMERIC:   case Types.FLOAT:    obj = "double";    break;   case Types.DATE:   case Types.TIMESTAMP:    obj = "Date";        break;   case Types.CHAR:   case Types.VARCHAR:   case Types.LONGVARCHAR:    obj = "String";    break;   default:    obj = "String";    break;   }   return obj;  } catch (Exception e) {   e.printStackTrace();   return null;  } } public static void main(String[] args) {  new tableTojava().setVisible(true); } public String getFirst(String str) {  String first = str.substring(0, 1).toUpperCase();  return first + str.substring(1); }}