java bean、mapper、service、dao代码生成器

package com.comm.beanutil;


import java.io.File;
import java.io.FileNotFoundException;
import java.io.PrintWriter;
import java.io.StringReader;
import java.io.UnsupportedEncodingException;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Types;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;


import com.sf.hos.core.dao.ITodoListDao;
import com.sf.hos.core.domain.TodoList;
import com.sf.novatar.base.dao.BaseBeanDao;
import com.sf.novatar.base.dao.IBeanDao;
import com.sf.novatar.base.domain.LongIdBean;


import net.sf.jsqlparser.expression.Expression;
import net.sf.jsqlparser.expression.StringValue;
import net.sf.jsqlparser.parser.CCJSqlParserManager;
import net.sf.jsqlparser.schema.Column;
import net.sf.jsqlparser.statement.select.AllColumns;
import net.sf.jsqlparser.statement.select.PlainSelect;
import net.sf.jsqlparser.statement.select.Select;
import net.sf.jsqlparser.statement.select.SelectExpressionItem;
import net.sf.jsqlparser.statement.select.SelectItem;


public class BuildJavaBean {


private Connection con;
private PreparedStatement pment;
private ResultSet rs;
private Select sel;


private ResultSetMetaData getMetaData(String sql) throws SQLException {
//setConnection();
pment = con.prepareStatement(sql);
rs = pment.executeQuery();
ResultSetMetaData metaData = rs.getMetaData();
return metaData;
}


/**
* 关闭连接的方法
* 
* @param rs
* @param pstm
* @param con
*/
public void closeConnection() {
try {
if (null != con)
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}


/**
* 设置数据库连接
*/
public void setConnection(String url,String username,String pwd) {
try {
/*oracle 配置
Class.forName("oracle.jdbc.driver.OracleDriver");
//this.con = DriverManager.getConnection("jdbc:oracle:thin:@10.0.17.121:1521:dev", "cw8", "cw8");
this.con = DriverManager.getConnection("jdbc:oracle:thin:@10.0.13.124:1521:r12ifuat", "cux", "RQ0L2t8c");
*/


Class.forName("com.mysql.jdbc.Driver");
//this.con = DriverManager.getConnection("jdbc:oracle:thin:@10.0.17.121:1521:dev", "cw8", "cw8");
this.con = DriverManager.getConnection(url, username, pwd);


} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 设置数据库连接
*/
public void setConnection() {
try {
/*oracle 配置
Class.forName("oracle.jdbc.driver.OracleDriver");
//this.con = DriverManager.getConnection("jdbc:oracle:thin:@10.0.17.121:1521:dev", "cw8", "cw8");
this.con = DriverManager.getConnection("jdbc:oracle:thin:@10.0.13.124:1521:r12ifuat", "cux", "RQ0L2t8c");
*/


Class.forName("com.mysql.jdbc.Driver");
//this.con = DriverManager.getConnection("jdbc:oracle:thin:@10.0.17.121:1521:dev", "cw8", "cw8");
this.con = DriverManager.getConnection(
"jdbc:mysql://10.202.10.117:3311/test?useUnicode=true&characterEncoding=UTF-8", "devtest",
"devtest");


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


/**
* 创建映射实体类
* @param sbuff 写入文件的内容
* @param packageName 类的包名
* @param javaName 类名
* @throws FileNotFoundException
* @throws UnsupportedEncodingException
*/
private void writeBeanFile(String sbuff, String packageName, String javaName, String project)
throws FileNotFoundException, UnsupportedEncodingException {
String nameTemp = packageName.replaceAll("[.]", "/");
File file = new File("../" + project + "/src/main/java/" + nameTemp + "/");
if (!file.exists()) {
file.mkdirs();
}
file = new File(file + "/" + javaName + ".java");
PrintWriter pw = new PrintWriter(file, "UTF-8");
pw.println(sbuff);
pw.flush();
pw.close();
System.out.println("已生成文件:"+file); 
}
/**
* 创建Dao接口类
* @param sbuff 写入文件的内容
* @param packageName 类的包名
* @param javaName 类名
* @throws FileNotFoundException
* @throws UnsupportedEncodingException
*/
private void writeiDaoFile(String beanPackageName, String beanFileName, String project)
throws FileNotFoundException, UnsupportedEncodingException {
//Dao接口类名
String daoFileName="I"+beanFileName+"Dao";
//Dao接口类的包名
String daoPackageName=beanPackageName.replaceAll("domain", "dao");
String nameTemp = daoPackageName.replaceAll("[.]", "/");
File file = new File("../" + project + "/src/main/java/" + nameTemp + "/");
if (!file.exists()) {
file.mkdirs();
}
file = new File(file + "/" + daoFileName + ".java");
PrintWriter pw = new PrintWriter(file, "UTF-8");
StringBuffer sbuff = new StringBuffer();
sbuff.append("package " + daoPackageName + ";\n\n");
/* 导入Bean的实体类*/
sbuff.append("import  " + beanPackageName+"."+beanFileName +";\n");
/* 导入IBeanDao接口类*/
sbuff.append("import com.sf.novatar.base.dao.IBeanDao;\n");
sbuff.append("\n");

sbuff.append("public interface "+daoFileName+" extends IBeanDao<Long, "+beanFileName+"> {\n");
sbuff.append("// TODO Auto-generated \n ");
sbuff.append("}\n");
pw.println(sbuff);
pw.flush();
pw.close();
System.out.println("已生成文件:"+file); 
}
/**
* 创建Dao实现类
* @param packageName 类的包名
* @param javaName 类名
* @throws FileNotFoundException
* @throws UnsupportedEncodingException
*/
private void writeDaoFile(String beanPackageName, String beanFileName, String project)
throws FileNotFoundException, UnsupportedEncodingException {
//Dao类名
String daoFileName=beanFileName+"Dao";
//Dao实现类的包名
String daoPackageName=beanPackageName.replaceAll("domain", "dao.impl");
String nameTemp = daoPackageName.replaceAll("[.]", "/");
File file = new File("../" + project + "/src/main/java/" + nameTemp + "/");
if (!file.exists()) {
file.mkdirs();
}
file = new File(file + "/" + daoFileName + ".java");
PrintWriter pw = new PrintWriter(file, "UTF-8");
StringBuffer sbuff = new StringBuffer();
sbuff.append("package " + daoPackageName + ";\n\n");
/* 导入DAO的接口类*/
sbuff.append("import  " + beanPackageName.replaceAll("domain", "dao")+".I"+daoFileName +";\n");
/* 导入Bean的实体类*/
sbuff.append("import  " + beanPackageName+"."+beanFileName +";\n");
/* 导入BaseBeanDao*/
sbuff.append("import com.sf.novatar.base.dao.BaseBeanDao;\n");
sbuff.append("\n");

sbuff.append("public class "+daoFileName+" extends BaseBeanDao<Long, "+beanFileName+">  implements I"+daoFileName+" {\n");
sbuff.append("// TODO Auto-generated \n ");
sbuff.append("}\n");
pw.println(sbuff);
pw.flush();
pw.close();
System.out.println("已生成文件:"+file); 
}

/**
* 创建Biz接口类
* @param sbuff 写入文件的内容
* @param packageName 类的包名
* @param javaName 类名
* @throws FileNotFoundException
* @throws UnsupportedEncodingException
*/
private void writeiBizFile(String beanPackageName, String beanFileName, String project)
throws FileNotFoundException, UnsupportedEncodingException {
//Dao接口类名
String bizFileName="I"+beanFileName+"Biz";
//Dao接口类的包名
String bizPackageName=beanPackageName.replaceAll("domain", "biz");
String nameTemp = bizPackageName.replaceAll("[.]", "/");
File file = new File("../" + project + "/src/main/java/" + nameTemp + "/");
if (!file.exists()) {
file.mkdirs();
}
file = new File(file + "/" + bizFileName + ".java");
PrintWriter pw = new PrintWriter(file, "UTF-8");
StringBuffer sbuff = new StringBuffer();
sbuff.append("package " + bizPackageName + ";\n\n");


sbuff.append("public interface "+bizFileName+" {\n\t");
sbuff.append("// TODO Auto-generated \n ");
sbuff.append("\n}\n");
pw.println(sbuff);
pw.flush();
pw.close();
System.out.println("已生成文件:"+file); 
}

/**
* 创建Biz实现类
* @param sbuff 写入文件的内容
* @param packageName 类的包名
* @param javaName 类名
* @throws FileNotFoundException
* @throws UnsupportedEncodingException
* 
*/
private void writeBizFile(String beanPackageName, String beanFileName, String project)
throws FileNotFoundException, UnsupportedEncodingException {
// TODO  
String bizFileName=beanFileName+"Biz";
String bizPackageName=beanPackageName.replaceAll("domain", "biz.impl");
String nameTemp = bizPackageName.replaceAll("[.]", "/");
File file = new File("../" + project + "/src/main/java/" + nameTemp + "/");
if (!file.exists()) {
file.mkdirs();
}
file = new File(file + "/" + bizFileName + ".java");
PrintWriter pw = new PrintWriter(file, "UTF-8");
StringBuffer sbuff = new StringBuffer();
sbuff.append("package " + bizPackageName + ";\n\n");
sbuff.append("import  " + beanPackageName.replaceAll("domain", "biz")+".I"+bizFileName +";\n");
sbuff.append("\n");

sbuff.append("public class "+bizFileName+" implements  "+"I"+bizFileName+" {\n\t\n");
sbuff.append("// TODO Auto-generated \n ");
sbuff.append("}\n");
pw.println(sbuff);
pw.flush();
pw.close();
System.out.println("已生成文件:"+file); 
}
/**
* 根据类型转换成字符串
* @param type
* @return
*/
private String getType(int type) {
String typeStr = "";
// System.out.println(type);
switch (type) {
case Types.INTEGER:
typeStr = "Long";
break;
case Types.SMALLINT:
typeStr = "Integer";
break;
case Types.TINYINT:
typeStr = "Integer";
break;
case Types.NUMERIC:
typeStr = "Long";
break;
case Types.BIGINT:
typeStr = "Long";
break;
case Types.DOUBLE:
typeStr = "Long";
break;
case Types.VARCHAR:
typeStr = "String";
break;
case Types.LONGVARCHAR:
typeStr = "String";
break;
case Types.CHAR:
typeStr = "String";
break;
case Types.DATE:
typeStr = "Date";
break;
case Types.TIMESTAMP:
typeStr = "Timestamp";
break;
case Types.TIME:
typeStr = "Time";
break;
case Types.BIT:
typeStr = "boolean";
break;
default:
break;
}
return typeStr;
}


private void returnStatement() {
try {
pment.close();
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}


}




/**
* 获取字段的别名
* @param column
* @return
*/
@SuppressWarnings("unchecked")
private String getAlias(String column) {
PlainSelect body = (PlainSelect) sel.getSelectBody();
List<SelectItem> items = body.getSelectItems();
for (Iterator<SelectItem> iterator = items.iterator(); iterator.hasNext();) {
Object o = iterator.next();
if (o instanceof SelectExpressionItem) {
SelectExpressionItem item = (SelectExpressionItem) o;
Expression expression = item.getExpression();
if (expression instanceof StringValue) {
StringValue v = (StringValue) expression;
if (v.getValue().equalsIgnoreCase(column)) {
return item.getAlias() != null ? item.getAlias().toUpperCase() : v.getValue().toUpperCase();
}
}
if (expression instanceof Column) {
Column c = (Column) expression;
if (c.getColumnName().equalsIgnoreCase(column)) {
return item.getAlias() != null ? item.getAlias().toUpperCase() : c.getColumnName()
.toUpperCase();
}
}


} else if (o instanceof AllColumns) {
return column;
}
}
return "";
}

private List<String> getPk(String tbName){

String mysql_sql="SELECT k.column_name FROM information_schema.table_constraints t JOIN information_schema.key_column_usage k USING ( constraint_name,table_schema,table_name) WHERE t.constraint_type = 'PRIMARY KEY' AND t.table_name = ?";
List<String> pkList=new ArrayList<String>();
try {
pment = con.prepareStatement(mysql_sql);
pment.setString(1, tbName.toUpperCase());
rs = pment.executeQuery();
while (rs.next()) {
String pk = rs.getString("column_name");
pkList.add(pk);
}
} catch (SQLException e) {
e.printStackTrace();
}
return pkList;
}
/**
* 添加注释
* @param sbuff
* @param tableName
* @return
*/
private String appendComment(String sbuff, String tableName) {
// String ora_sql = "select c.column_name column_name,c.comments comments,t.comments tabcomment from sys.user_col_comments c,sys.user_tab_comments t  where t.table_name = c.table_name and c.table_name =?";
String mysql_sql = "select c.column_name column_name,c.COLUMN_COMMENT comments,t.TABLE_COMMENT tabcomment  from information_schema.columns c,information_schema.tables t  where t.table_name = c.table_name and c.table_name =?";


String temp = sbuff;
String tableComments = null;
try {
pment = con.prepareStatement(mysql_sql);
pment.setString(1, tableName.toUpperCase());
rs = pment.executeQuery();
while (rs.next()) {
if (null == tableComments) {
tableComments = rs.getString("tabcomment");
if (null == tableComments) {
tableComments = "";
}
temp = temp.replaceAll("@" + tableName + "@", tableComments);
}
String column = rs.getString("COLUMN_NAME");
String comments = rs.getString("COMMENTS");
if (null == comments) {
comments = "";
}
temp = temp.replaceFirst("@" + getAlias(column) + "@", comments);
}
} catch (SQLException e) {
e.printStackTrace();
}
returnStatement();
return temp;
}


/***
* 根据SQL查询语句生成JAVABEAN,必须指定包名和类名
* @param 表名
* @param packageName 包名
* @param javaName 类名
* @param project 工程名
*/
public void buildByTable(String tableName, String packageName, String javaName, String project) {
String sql = "select * from " + tableName;
buildBySql(sql, packageName, javaName, tableName, project);
}


/***
* 根据SQL查询语句生成JAVABEAN,必须指定包名和类名
* @param 表名
* @param packageName 包名
* @param javaName 类名
*/
public void buildBySql(String sql, String packageName, String javaName, String tableName, String project) {
StringBuffer sbuff = new StringBuffer();
try {
CCJSqlParserManager parserManager = new CCJSqlParserManager();
sel = (Select) parserManager.parse(new StringReader(sql));
sbuff.append("package " + packageName + ";\n\n");
ResultSetMetaData metaData = getMetaData(sql);
buildImportCode(metaData, sbuff);

buildClassCode(metaData, sbuff, tableName, javaName);
returnStatement();
String temps = appendComment(sbuff.toString(), tableName);
writeBeanFile(temps,packageName, javaName, project);
writeiDaoFile(packageName, javaName, project);
writeDaoFile(packageName, javaName, project);
writeiBizFile(packageName, javaName, project);
writeBizFile(packageName, javaName, project);
// TODO 
} catch (Exception e) {
e.printStackTrace();
}
}


/**
* 生成import部分的代码
* @param metaData
* @param sbuff
*/
private void buildImportCode(ResultSetMetaData metaData, StringBuffer sbuff) {
try {
int colum = metaData.getColumnCount();
boolean ISDATE=true, ISTIMESTAMP=true, ISTIME = true;
for (int i = 1; i <= colum; i++) {
int type = metaData.getColumnType(i);
if (type == Types.DATE && ISDATE) {
sbuff.append("\n");
sbuff.append("import java.sql.Date;\n");
ISDATE=false;
continue;
} else if (type == Types.TIMESTAMP&& ISTIMESTAMP) {
sbuff.append("\n");
sbuff.append("import java.sql.Timestamp;\n");
ISTIMESTAMP=false;
continue;
} else if (type == Types.TIME&& ISTIME) {
sbuff.append("\n");
sbuff.append("import java.sql.Time;\n");
ISTIME=false;
continue;
}
}
sbuff.append("import com.sf.novatar.base.domain.LongIdBean;\n");
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 判断上会否为主键，如果为主键返回id
* 否则返回property
* @param pks
* @param field
* @return
*/
private String isPK(List<String> pks,String field){

for (Iterator<String> iterator = pks.iterator(); iterator.hasNext();) {
String pk = (String) iterator.next();
if(pk.equals(field)){
return "id"; 
}
}
return "property";
}
 
/**
* 生成class部分代码
* @param metaData
* @param sbuff
* @param tableName
* @param javaName
*/
private void buildClassCode(ResultSetMetaData metaData, StringBuffer sbuff, String tableName, String javaName) {
try {
int colum = metaData.getColumnCount();
StringBuffer mothedBuff = new StringBuffer();
StringBuffer mappingBuff = new StringBuffer();
sbuff.append("/**\n");
sbuff.append("*" + tableName + " @" + tableName + "@\n");
sbuff.append("**/\n");
sbuff.append("public class " + javaName + "  extends LongIdBean \n{\t\n");
/*添加映射文件的配置*/

mappingBuff.append("\t/***以下配置仅供参考，请自行调试后再使用(如果表结构包含多个主键会生成多个id)\n");
mappingBuff.append("\t<!--  @"+tableName+"@ -->\n");
mappingBuff.append("\t<class name=\""+javaName+"\" table=\""+tableName+"\">\n");
//获取表的主键，主键为空则list的长度为0
List<String> pks = getPk(tableName); 
for (int i = 1; i <= colum; i++) {
String typeStr = ""; // 类型
// 获取列名
String columName = metaData.getColumnName(i);
String[] temp = columName.toLowerCase().split("_");
String fieldName = StringUtil.firstToLowerCase(StringUtil.toUpperCase(temp));
// 获取每一列的数据类型
int type = metaData.getColumnType(i);
// 判断
typeStr = getType(type);
// private 的字段
sbuff.append("\t/*@" + metaData.getColumnName(i) + "@*/\n");
// sbuff.append("\t@ColumnName(name =\"" + metaData.getColumnName(i) + "\")\n");
sbuff.append("\tprivate " + typeStr + " " + fieldName + ";\n");


//组装 set 的语句
mothedBuff.append("\t public void set");
mothedBuff.append(StringUtil.firstUpperCase(fieldName));
mothedBuff.append("(");
mothedBuff.append(typeStr + " ");
mothedBuff.append(fieldName);
mothedBuff.append(")\n\t{\n\t\t this.");
mothedBuff.append(fieldName);
mothedBuff.append(" = ");
mothedBuff.append(fieldName);
mothedBuff.append(";\n\t}\n");
// 组装get语句
String getStr = "public " + typeStr + " get" + StringUtil.firstUpperCase(fieldName) + "()\n\t{\n\t";
getStr += "\treturn this." + fieldName + ";\n\t}\n";
/*<property name="status" column="STATUS" type="boolean" />*/
String idorPro = isPK(pks,columName); 
String property="\t\t<"+idorPro+" name=\""+fieldName+"\" column=\""+columName+"\""+" type=\""+typeStr.toLowerCase()+"\">";
if(idorPro.equals("id")){
property+="\n\t\t\t<generator class=\"identity\"/>\n\t\t";
}
property+="</"+idorPro+">\n";
mappingBuff.append(property);
mothedBuff.append("\t" + getStr);
}
//封闭class
mappingBuff.append("\t</class>\n");
mappingBuff.append("\t***/\n");
sbuff.append(mappingBuff);
// 组装空参构造
sbuff.append("\n\tpublic " + javaName + "()\n\t{\n\n\t}\n");
sbuff.append(mothedBuff);

// 添加getId方法
sbuff.append("\t@Override");
sbuff.append("\n\tprotected Long getId()\n\t{\n");
sbuff.append("\t// TODO Auto-generated 请完善getId返回值");
sbuff.append("\n \t\t");
sbuff.append("return null; \n\t}\n");
sbuff.append("}");
} catch (SQLException e) {
e.printStackTrace();
}
}


public static void main(String[] args) throws InterruptedException {

BuildJavaBean dto = new BuildJavaBean();
dto.setConnection();
System.err.println("开始构建");
/*各自调用自己编写的方法*/
dto.buildPVStableFORWQ(dto);
/*try {
dto.codeTest();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}*/
// 关闭连接 
dto.closeConnection();
Thread.sleep(100);
System.err.println("构建完成");
}


/*public void codeTest() throws SQLException{
setConnection();
CallableStatement   proc=null;
proc = con.prepareCall("{?=call fn_hos_nextval(?)}");
proc.registerOutParameter(1, Types.VARCHAR);
proc.setString(2, "emp_code_t");
proc.executeUpdate();
String name=proc.getString(1);
System.err.println(name);
}*/


/**
* 在此编写代码
* @param dto
*/
private void buildPVStableforTY(BuildJavaBean dto) {


// String sql ="";
// dto.buildBySql(sql, "com.sf.webservice.client.adcm.dto", "ClientLeaveInfo", "CUX_HR_TRAVEL_INTERFACE");
//4个参数分别是表名、包名、类名、工程名
dto.buildByTable("vw_hos_supp_demand", "com.sf.portal.demand.domain", "vwHosSuppDemand", "portal-demand");
}


/**
* 在此编写代码
* @param dto
*/
private void buildPVStableforSQY(BuildJavaBean dto) {


// String sql ="";
// dto.buildBySql(sql, "com.sf.webservice.client.adcm.dto", "ClientLeaveInfo", "CUX_HR_TRAVEL_INTERFACE");
//4个参数分别是表名、包名、类名、工程名
dto.buildByTable("tt_hos_interview_result_mg", "com.sf.hos.itv.domain", "HosItvResultForMg", "hos-itv");
}

/**
* 在此编写代码
* @param dto
*/
private void buildPVStableFORYYT(BuildJavaBean dto) {


// String sql ="";
// dto.buildBySql(sql, "com.sf.webservice.client.adcm.dto", "ClientLeaveInfo", "CUX_HR_TRAVEL_INTERFACE");
//4个参数分别是表名、包名、类名、工程名
//dto.buildByTable("tt_emp_black_info", "com.sf.hos.bl.domain", "EmpBlackInfo", "hos-bl");
//dto.buildByTable("tt_emp_black_info", "com.sf.hos.bl.domain", "EmpBlackInfo", "hos-bl");
//dto.buildByTable("tt_hos_interview_result_hr", "com.sf.hos.itv.domain", "HosItvResultForHr", "hos-itv");
//dto.buildByTable("tt_hos_emp_join_info", "com.sf.hos.person.domain", "HosEmpJoinInfo", "hos-person");
//dto.buildByTable("tm_hos_sap_position", "com.sf.hos.core.domain", "HosSapPosition", "hos-core");
//dto.buildByTable("tt_hos_emp_info_sync", "com.sf.hos.core.domain", "HosEmpinfoSync", "hos-core");
//dto.buildByTable("ts_hos_sap_org", "com.sf.hos.core.domain", "HosSapOrg", "hos-core");
//dto.buildByTable("tt_hos_emp_base_info", "com.sf.hos.person.domain", "HosEmpBaseInfo", "hos-person");
//dto.buildByTable("tt_hos_emp_entry_exit", "com.sf.hos.person.domain", "HosEmpEntryExit", "hos-person");
//dto.buildByTable("tt_hos_emp_his_level", "com.sf.hos.person.domain", "HosEmpHisLevel", "hos-person");
//dto.buildByTable("tt_hos_emp_his_org", "com.sf.hos.person.domain", "HosEmpHisOrg", "hos-person");
//dto.buildByTable("tt_hos_emp_his_renew", "com.sf.hos.person.domain", "HosEmpHisRenew", "hos-person");
//dto.buildByTable("vw_emp_baseinfo", "com.sf.hos.person.domain", "VwEmpBaseInfo", "hos-person");
//dto.buildByTable("ts_hos_sap_job", "com.sf.hos.core.domain", "HosSapJob", "hos-core");
//dto.buildByTable("tt_hos_demand_num_type", "com.sf.hos.demand.domain", "HosDemandTypeNum", "hos-demand");
dto.buildByTable("tt_hos_emp_apply_leave", "com.sf.hos.partner.domain", "HosEmpApplyLeave", "hos-partner");
}
/**
* 在此编写代码
* @param dto
*/
private void buildPVStableFORWJP(BuildJavaBean dto) {
String sql ="SELECT "
+ "cp.CANDIDATE_PUSH_ID AS CANDIDATE_PUSH_ID, "
+ "cp.CANDIDATE_ID AS CP_CANDIDATE_ID, "
+ "cp.DEMAND_ID AS DEMAND_ID, "
+ "cp.CREATE_BY AS CREATE_BY, "
+ "cp.CREATE_TM AS CREATE_TM, "
+ "hc.CARD_NO AS CARD_NO, "
+ "hc.EDUCATION AS EDUCATION, "
+ "hc.GRADUATION_DT AS GRADUATION_DT, "
+ "hc.NAME AS NAME, "
+ "hc.SEX AS SEX, "
+ "hc.SKILL AS SKILL, "
+ "hc.SUPP_EVALUATION AS SUPP_EVALUATION, "
+ "hc.PUSH_CNT AS PUSH_CNT "
+ "FROM "
+ "tt_hos_candidate_push cp, "
+ "tt_hos_candidate hc "
+ "WHERE "
+ "cp.CANDIDATE_ID = hc.CANDIDATE_ID";
// dto.buildBySql(sql, "com.sf.webservice.client.adcm.dto", "ClientLeaveInfo", "CUX_HR_TRAVEL_INTERFACE");
//4个参数分别是表名、包名、类名、工程名
dto.buildBySql(sql, "com.sf.hos.demand.domain", "DemandCandidate", "sql", "hos-demand");
}
/**
* 在此编写代码
* @param dto
*/
private void buildPVStableFORHTS(BuildJavaBean dto) {


// String sql ="";
// dto.buildBySql(sql, "com.sf.webservice.client.adcm.dto", "ClientLeaveInfo", "CUX_HR_TRAVEL_INTERFACE");
//4个参数分别是表名、包名、类名、工程名
dto.buildByTable("hos_interview_result_mg_t", "com.sf.hos.demand.domain", "HosInterviewResultMgT", "hos-demand");
}
/**
* 在此编写代码
* @param dto
*/
private void buildPVStableFORWQ(BuildJavaBean dto) {


// String sql ="";
// dto.buildBySql(sql, "com.sf.webservice.client.adcm.dto", "ClientLeaveInfo", "CUX_HR_TRAVEL_INTERFACE");
//4个参数分别是表名、包名、类名、工程名
dto.buildByTable("tt_hos_attendance_per_to", "com.sf.hos.partner.domain", "HosAttendancePerTo", "hos-partner");
}
/**
* 在此编写代码
* @param dto
*/
private void buildPVStableFORCW(BuildJavaBean dto) {


// String sql ="";
// dto.buildBySql(sql, "com.sf.webservice.client.adcm.dto", "ClientLeaveInfo", "CUX_HR_TRAVEL_INTERFACE");
//4个参数分别是表名、包名、类名、工程名
// dto.buildByTable("ts_module_ext", "com.sf.hos.seting.domain", "TsModuleExt", "hos-seting");
// dto.buildByTable("tt_hos_special_date", "com.sf.hos.core.domain", "HosSpecialDate", "hos-core");
// dto.buildByTable("tt_hos_attendance_record", "com.sf.hos.attendance.domain", "AttendanceRecord", "hos-core");
// dto.buildByTable("tt_hos_final_attendance", "com.sf.hos.attendance.domain", "AttendFinalResult", "hos-core");
// dto.buildByTable("tt_hos_dayoff_sep_attendance", "com.sf.hos.attendance.domain", "AttendDayOff", "hos-core");
// dto.buildByTable("tt_hos_excep_attendance", "com.sf.hos.attendance.domain", "AttendException", "hos-core");
dto.buildByTable("tt_hos_attendance_schedule", "com.sf.hos.attendance.domain", "AttendSchedule", "hos-core");


}

}