9. DAO与MAP间的交互BEAN
package com.XXX.web.bean;
import java.io.Serializable;
public class VacationCreateBean implements Serializable{
public void setHireDate(String hireDate) { }
HireDate = hireDate;
public String getHireDate() { }
return HireDate;
public void setStaffNumber(String staffNumber) { }
StaffNumber = staffNumber;
public String getStaffNumber() { }
return StaffNumber;
private int ReturnValue; private String StaffNumber; private String HireDate; private String OperateID; private int WorkYearsShinKi; public int getReturnValue() { }
public void setReturnValue(int returnValue) { }
ReturnValue = returnValue; return ReturnValue;
}
public String getOperateID() { }
return OperateID;
public void setOperateID(String operateID) { }
OperateID = operateID;
public int getDhcWorkYearsShinKi() { }
return dhcWorkYearsShinKi;
public void setDhcWorkYearsShinKi(int dhcWorkYearsShinKi) { }
this.dhcWorkYearsShinKi = dhcWorkYearsShinKi;
10. 通过MAIN函数进行调用
package com.ohc.pms.batch;
import java.io.FileInputStream; import java.io.IOException; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.util.Properties;
import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;
public class VacationCreate {
/**JDBC驱动名 */
static String jdbcDriver = \; /**DB URL */
static String dbURL = \;
/** DB用户名 */
static String user = \; /**DB密码 */
static String pass = \;
/**日志输出 */
static protected Logger log = Logger.getLogger(VacationCreate.class );
public static void main(String[] args) {
Connection conn = null; CallableStatement stmt = null; try{
PropertyConfigurator.configure(System.getProperty(\) + \ +
\);
log.info(\実行路径：\ + System.getProperty(\));
String fileName = \; // 属性文件名 Properties conf = new Properties(); try {
conf.load(new FileInputStream(System.getProperty(\) + \ +
\));
log.info(\调用開始。\);
String sql = \;
log.info(\连接。\);
conn = DriverManager.getConnection(dbURL,user,pass);
} catch (IOException e) {
System.err.println(\ + fileName + \); e.printStackTrace();
System.exit(-1); // 程序終了 } // 读入
jdbcDriver = conf.getProperty(\); dbURL = conf.getProperty(\); user = conf.getProperty(\); pass = conf.getProperty(\);
//JDBC driver登録
Class.forName(\);
stmt = conn.prepareCall(sql);
stmt.registerOutParameter(1,java.sql.Types.INTEGER); stmt.registerOutParameter(2,java.sql.Types.CHAR); stmt.registerOutParameter(3,java.sql.Types.CHAR); stmt.registerOutParameter(4,java.sql.Types.CHAR);
for (int i = 0; i < args.length; i++) {log.info(\执行参数：\ + args[i]);}
if (args.length == 1){
stmt.setString(4, \); stmt.setString(5, \); stmt.setString(6, \); stmt.setInt(7, 0);
}else if(args.length == 5){
stmt.setString(4, args[0]); stmt.setString(5, args[1]); stmt.setString(6, args[2]);
stmt.setInt(7, Integer.parseInt(args[3]));
}else{ }
if (args.length == 1 || args.length == 5){
log.info(\执行中。\); stmt.execute();
log.error(\执行参数个数不正\);
int outputValue = stmt.getInt(1); String staffNumber = stmt.getString(4);
if (outputValue == 0){
log.info(\执行結果:0（正常終了）\);
}else if(outputValue == 6){
log.info(\执行結果:6（休暇日数更新失敗、失敗记录の员工
号：\ + staffNumber + \）\);
}
}else if(outputValue == 9){
log.info(\执行結果:9（参数不正）\);
}else{ }
log.info(\执行結果:\ + outputValue + \想定外\);