程序博客网 > 淘宝设计师平台

简单的方式由数据库的物理表(TABLE)生成实体类(DTO)

来源：互联网 发布：淘宝设计师平台 编辑：程序博客网 时间：2024/05/22 04:41

步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




步骤：通过DataBaseMetaData一次获取想要的各个表和相关的列信息。

再分析各个列的类型，生成文件。

---------------------------------------------------------------------------------------------------

非常简单，只需要读一次数据库，同样的原理可以来实现DAO层。

配合几个利用元数据和反射来处理DTO和DAO,即可实现简单的ORM.

正在实验中...

---------------------------------------------------------------------------------------------------


import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Set;
import java.util.Map.Entry;


/**
 * @author KimmKing
 */
public class test {

 private static final String T = "/t";

 private static final String CRLF = "/r/n";

 static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

 static String url = "jdbc:odbc:qsoft";

 static String user = "sa";

 static String password = "q11";

 static HashMap map = new HashMap();

 static HashMap type = new HashMap();
 static {
  type.put("4", "int");
  type.put("12", "String");
  type.put("93", "Date");
  type.put("-1", "String");
 }

 static String path = "d://DTO";

 public static void main(String[] args) {
  // testODBC();

  findTableAndColumn();
  Set set = map.entrySet();
  for (Iterator iter = set.iterator(); iter.hasNext();) {
   Entry element = (Entry) iter.next();
   TableBean table = (TableBean) element.getValue();
   createDto(table);
  }
 }

 private static void createDto(TableBean table) {

  StringBuffer sb = new StringBuffer();
  StringBuffer tostring = new StringBuffer();

  sb.append("package com.qsoft.dto;");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("/**");
  sb.append(CRLF);
  sb.append(" * @author KimmKing");
  sb.append(CRLF);
  sb.append(" * create time:" + new Date().toLocaleString());
  sb.append(CRLF);
  sb.append("*/");
  sb.append(CRLF);
  sb.append(CRLF);

  sb.append("import java.util.Date;");
  sb.append(CRLF);
  sb.append(CRLF);

  String tablename = table.getName();
  String classname = convertT2C(tablename);
  List list = table.getColumns();

//  tostring.append(classname);
//  tostring.append("[");
  
  sb.append("public class " + classname + " implements IDto {");
  sb.append(CRLF);

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   ColumnBean column = (ColumnBean) iter.next();

   String columnname = column.getName().toLowerCase();

   String stype = type.get(column.getType() + "").toString();
   sb.append(T);
   sb.append("private " + stype + " " + columnname + ";");
   sb.append(T);
   sb.append("//Length:");
   sb.append(column.getLength());
   sb.append(CRLF);

   sb.append(CRLF);

   // getter
   sb.append(T);
   sb.append("public " + stype + " " + getGetter(columnname) + "() {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("return " + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);

   // setter
   sb.append(T);
   sb.append("public void " + getSetter(columnname) + "(" + stype
     + " _" + columnname + ") {");
   sb.append(CRLF);

   sb.append(T);
   sb.append(T);
   sb.append("this." + columnname + "=_" + columnname + ";");
   sb.append(CRLF);

   sb.append(T);
   sb.append("}");
   sb.append(CRLF);

   sb.append(CRLF);
   sb.append(CRLF);
   
   //
   tostring.append("/"," + columnname + "=/" + " + columnname + " + ");
   

  }
  
  String pv = tostring.toString();
  pv = pv.substring(2);
//   toString
  sb.append(T);
  sb.append("public String toString() {");
  sb.append(CRLF);

  sb.append(T);
  sb.append(T);
  sb.append("return /"" + classname + "[" + pv +  "/"]/";");
  sb.append(CRLF);

  sb.append(T);
  sb.append("}");
  sb.append(CRLF);

  sb.append(CRLF);

  sb.append("}");
  sb.append(CRLF);

  File dir = new File(path);
  if (!dir.exists())
   dir.mkdirs();

  File file = new File(path + "//" + classname + ".java");
  try {

   FileWriter writer = new FileWriter(file);
   writer.write(sb.toString());
   writer.close();

  } catch (IOException e) {
   e.printStackTrace();
  }

 }

 private static String convertT2C(String tablename) {
  
  String classname = tablename.substring(1).toUpperCase();

  String first = classname.substring(0,1).toUpperCase();
  
  classname = first + classname.substring(1).toLowerCase() + "Dto";

  return classname;
 }

 private static String getSetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "set" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static String getGetter(String propertyName) {

  String first = propertyName.substring(0, 1).toUpperCase();
  String methodName = "get" + first
    + propertyName.substring(1).toLowerCase();

  return methodName;
 }

 private static void findTableAndColumn() {

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {

    String tablename = rs.getString(3);
    TableBean table = (TableBean) map.get(tablename);
    if (table == null) {
     table = new TableBean();
     table.setName(tablename);
     map.put(tablename, table);
    }

    ColumnBean column = new ColumnBean();
    column.setName(rs.getString(4));
    column.setType(rs.getInt(5));
    column.setLength(rs.getInt(7));
    table.getColumns().add(column);
   }

   rs.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }

 }

 private static void testmeta() {

  // String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);

   DatabaseMetaData meta = conn.getMetaData();
   ResultSet rs = meta.getColumns(null, null, "c%", null);

   while (rs.next()) {
    print(rs);
    System.out.println();
   }

   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(ResultSet rs) {

  try {
   int count = rs.getMetaData().getColumnCount();
   for (int i = 0; i < count; i++) {
    System.out.print(rs.getString(1 + i));
    System.out.print("/t");
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

 }

 private static void testODBC() {

  String sql = "select * from cuser ";

  try {
   Class.forName(driverName);
   Connection conn = DriverManager.getConnection(url, user, password);
   Statement stmt = conn.createStatement();

   ResultSet rs = stmt.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getString(2));
   }

   rs.close();
   stmt.close();
   conn.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException ex) {
   ex.printStackTrace();
  }
 }

 private static void print(List list) {

  for (Iterator iter = list.iterator(); iter.hasNext();) {
   System.out.println(iter.next());
  }

 }
}

 

 

/**
 * @author KimmKing
 *
 */

public class ColumnBean {

 private String name;
 private int type;
 private int length;
 
 public int getLength() {
  return length;
 }
 public void setLength(int length) {
  this.length = length;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getType() {
  return type;
 }
 public void setType(int type) {
  this.type = type;
 }
 
}

 

 

 

import java.util.ArrayList;
import java.util.List;

 

/**
 * @author KimmKing
 *
 */
public class TableBean {

 private String name;
 private List columns = new ArrayList();
 
 public List getColumns() {
  return columns;
 }
 public void setColumns(List columns) {
  this.columns = columns;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 
 
}

 

 




淘宝设计师平台 淘宝设计师平台
原创粉丝点击
热门IT博客
超级基因优化液2超级基因优化液2
搜狐畅游网络招聘搜狐畅游网络招聘
淘宝二手电脑回收
物业公摊水电费算法
mac不能下载软件
如何看大非农数据
mac app tore图片问号
excel数据分类统计
淘宝名改了有影响吗?
拐个弯爱你网络剧网盘
云狄网络
web后端 数据库
大数据前景怎么样
ab post json
五子棋java程序代码
淘宝卖家折扣设置
软件配置文件用途
直播间刷人气协议源码
怎样写编程
数码煲仔饭的知乎
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 室内健身 健身是什么 办公室健身 健身好 健身节目 健身比赛 拳击健身 健身健康 健身前 被健身教练玩晕 keep健身软件 踢屁股健身机 健身学院梦想青成 演员国庆健身图片 健身教练床上是不是很厉害 健身教练干诗涵 健身教练圈到底有多乱 李嫣登山健身 健身教练隔着裤子顶女学员 为什么说健身后悔三个月 健身环大冒险 健身时女教练胸衣突然炸开 健身励志图片 健身教练月收入 流汗吧健身少女 健身器材使用方法图解 办健身卡有多少人后悔 男士健身app排行 健身励志语录 健身知识大全 怎样健身能快速长肌肉 在家健身的方法 一周健身计划表 健身女孩图片 好用的健身软件 哑铃健身计划 健身计划一周表图解 瘦人健身计划 男人健身的好处 男士一周健身计划表配图 健身英文单词

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里