packagecom.databi.utils;importjava.io.File;importjava.io.FileOutputStream;importjava.io.IOException;importjava.io.Serializable;importjava.sql.CallableStatement;importjava.sql.Connection;importjava.sql.DatabaseMetaData;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importjava.util.Map;/*** 为了链接oracle数据库 生成表对应的javabean
*@authorAdministrator
**/
public class JavaBeanUtils implementsSerializable{private PreparedStatement ps = null;private ResultSet rs = null;private static Connection con = null;private CallableStatement cst = null;static classOra{static final String DRIVER_CLASS = "oracle.jdbc.driver.OracleDriver";static final String DATABASE_URL = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";static final String DATABASE_USER = "databi";static final String DATABASE_PASSWORD = "123456";static final String DATABASE_TABLE = "bas_dept"; //需要生成的表名
}static classMySql{static final String DRIVER_CLASS = "com.mysql.jdbc.Driver";static final String DATABASE_URL = "jdbc:mysql://localhost/plusoft_test?useUnicode=true&characterEncoding=GBK";static final String DATABASE_USER = "root";static final String DATABASE_PASSWORD = "1234";
}public staticConnection getOracleConnection() {try{
Class.forName(Ora.DRIVER_CLASS);
con=DriverManager.getConnection(Ora.DATABASE_URL,Ora.DATABASE_USER,Ora.DATABASE_PASSWORD);returncon;
}catch(Exception ex) {
System.out.println(ex.getMessage());
}returncon;
}public staticConnection getMySqlConnection() {try{
Class.forName(MySql.DRIVER_CLASS);
con=DriverManager.getConnection(MySql.DATABASE_URL,MySql.DATABASE_USER,MySql.DATABASE_PASSWORD);returncon;
}catch(Exception ex) {
ex.printStackTrace();
}returncon;
}public static List getOracleTable(String Table) throwsSQLException{
getOracleConnection();
List list = new ArrayList();try{
DatabaseMetaData m_DBMetaData=con.getMetaData();//getColumns(java.lang.String catalog, java.lang.String schema,java.lang.String table, java.lang.String col)
ResultSet colrs = m_DBMetaData.getColumns(null,Ora.DATABASE_USER.toUpperCase(), Table.toUpperCase(),"%");while(colrs.next()) {
Map map= newHashMap();
String columnName= colrs.getString("COLUMN_NAME");
String columnType= colrs.getString("TYPE_NAME");int datasize = colrs.getInt("COLUMN_SIZE");int digits = colrs.getInt("DECIMAL_DIGITS");int nullable = colrs.getInt("NULLABLE");
String remarks= colrs.getString("REMARKS");//System.out.println(columnName+" "+columnType+" "+datasize+" "+digits+" "+ nullable);
map.put("columnName", columnName);
map.put("columnType", columnType);
map.put("datasize", datasize);
map.put("remarks", remarks);
list.add(map);//System.out.println("TABLE_CAT" + "===" + colrs.getString("TABLE_CAT"));//System.out.println("TABLE_SCHEM" + "===" + colrs.getString("TABLE_SCHEM"));//System.out.println("TABLE_NAME" + "===" + colrs.getString("TABLE_NAME"));//System.out.println("COLUMN_NAME" + "===" + colrs.getString("COLUMN_NAME"));//System.out.println("DATA_TYPE" + "===" + colrs.getString("DATA_TYPE"));//System.out.println("TYPE_NAME" + "===" + colrs.getString("TYPE_NAME"));//System.out.println("COLUMN_SIZE" + "===" + colrs.getString("COLUMN_SIZE"));//System.out.println("BUFFER_LENGTH" + "===" + colrs.getString("BUFFER_LENGTH"));//System.out.println("DECIMAL_DIGITS" + "===" + colrs.getString("DECIMAL_DIGITS"));//System.out.println("NUM_PREC_RADIX" + "===" + colrs.getString("NUM_PREC_RADIX"));//System.out.println("NULLABLE" + "===" + colrs.getString("NULLABLE"));//System.out.println("REMARKS" + "===" + colrs.getString("REMARKS"));//System.out.println("COLUMN_DEF" + "===" + colrs.getString("COLUMN_DEF"));//System.out.println("SQL_DATA_TYPE" + "===" + colrs.getString("SQL_DATA_TYPE"));//System.out.println("SQL_DATETIME_SUB" + "===" + colrs.getString("SQL_DATETIME_SUB"));//System.out.println("CHAR_OCTET_LENGTH" + "===" + colrs.getString("CHAR_OCTET_LENGTH"));//System.out.println("ORDINAL_POSITION" + "===" + colrs.getString("ORDINAL_POSITION"));//System.out.println("IS_NULLABLE" + "===" + colrs.getString("IS_NULLABLE"));
}//while(colRet.next()){//System.out.print("列名:"+colRet.getString("COLUMN_NAME"));//System.out.print(" 数据类型是:"+colRet.getString("DATA_TYPE"));//System.out.print(" 类型名称是:"+colRet.getString("TYPE_NAME"));//System.out.print(" 列大小是:"+colRet.getString("COLUMN_SIZE"));//System.out.println(" 注释是:"+colRet.getString("REMARKS"));//}
}catch(Exception e) {
e.printStackTrace();
}finally{
con.close();
}returnlist;
}/*** 把Oracle字段类型 转化为 java类型
*@paramsqlType 字段类型
*@paramsize 字段大小
*@paramscale 默认=0
*@return
*/
public static String oracleSqlType2JavaType(String sqlType,int size,intscale){if (sqlType.equals("integer")) {return "Integer";
}else if (sqlType.equals("long")) {return "Long";
}else if (sqlType.equals("float")|| sqlType.equals("float precision")|| sqlType.equals("double")|| sqlType.equals("double precision")
) {return "BigDecimal";
}else if (sqlType.equals("number")||sqlType.equals("decimal")|| sqlType.equals("numeric")|| sqlType.equals("real")) {return scale==0? (size<10? "Integer" : "Long") : "BigDecimal";
}else if (sqlType.equals("varchar")|| sqlType.equals("varchar2")|| sqlType.equals("char")|| sqlType.equals("nvarchar")|| sqlType.equals("nchar")) {return "String";
}else if (sqlType.equals("datetime")|| sqlType.equals("date")|| sqlType.equals("timestamp")) {return "Date";
}return "String";
}public static String getItems(Listmap,String tablename){//记得转化成小写
StringBuffer sb = newStringBuffer();
sb.append("package com.databi.bean;");
sb.append("\r\n");
sb.append("import java.util.Date;\r\n");
sb.append("/** \r\n "
+" * \r\n"
+" * @author lsp \r\n"
+" *\r\n"
+ "*/\r\n");
sb.append("\r\n");
sb.append("public class "+ getUpperOne(tablename.toLowerCase()) + " implements java.io.Serializable {\r\n");//得到私有属性
for(Map map0 : map) {
String columnname= map0.get("columnName").toString();
String columntype= map0.get("columnType").toString();
String columnsize= map0.get("datasize").toString();
String remarks= map0.get("remarks")==null?"":map0.get("remarks").toString();
String javaType= oracleSqlType2JavaType(columntype.toLowerCase(),Integer.parseInt(columnsize),0);
String temp= "\tprivate "+javaType+" "+columnname.toLowerCase()+"; //"+remarks+"\r\n";
sb.append(temp);
}//得到getter和setter
for(Map map0 : map) {
String columnname= map0.get("columnName").toString();
String columntype= map0.get("columnType").toString();
String columnsize= map0.get("datasize").toString();
String javaType= oracleSqlType2JavaType(columntype.toLowerCase(),Integer.parseInt(columnsize),0);
String temp= "\tpublic "+javaType+" "+"get"+getUpperOne(columnname.toLowerCase())+"(){\r\n";
String temp1= "\t\treturn "+columnname.toLowerCase()+";\r\n";
String temp2= "\t}\r\n";
sb.append(temp+temp1+temp2);
temp= "\tpublic void "+"set"+getUpperOne(columnname.toLowerCase())+"("+javaType+" "+columnname.toLowerCase()+"){\r\n";
temp1= "\t\tthis."+columnname.toLowerCase()+" = "+columnname.toLowerCase()+";\r\n";
temp2= "\t}\r\n";
sb.append(temp+temp1+temp2);
}
sb.append("}");returnsb.toString();
}/*** 把输入字符串的首字母改成大写
*@paramstr
*@return
*/
public staticString getUpperOne(String str){char[] ch =str.toCharArray();if (ch[0] >= 'a' && ch[0] <= 'z') {
ch[0] = (char) (ch[0] - 32);
}return newString(ch);
}public static void main(String[] args) throwsIOException {//JavaBeanUtils.sysoutOracleTCloumns("pexam_items_title", "his_yhkf");
try{
String tables= "bi_bas_dept";
String[] arr= tables.split(",");for(String string : arr) {
String name=getUpperOne(string.toLowerCase());
List map =getOracleTable(string);
String a=getItems(map,string);
File file= new File("D:\\bbb\\"+name+".java");if (!file.exists()) {
file.createNewFile();
}
FileOutputStream fos= new FileOutputStream(file,true);//true表示在文件末尾追加
fos.write(a.getBytes());
fos.close();//流要及时关闭
}
System.out.println("生成java完成");
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}
}
}