public HashMap getTrfVchnofromDbPkg(String compcode, String unitcode) {
System.out.println("vchno from pkg");
//String sqlproc2 = "{? = call adf_ess_leave_pkg.hdays_bw_dts_new2(?,?,?,?,?,?,?,?)}";
String sqlproc2 = "{? = call pos_vchno_pkg.Get_Transfer_Vchno(?,? ,'XFR',462,19,?)}";
CallableStatement sqlProcStmt2 = this.getDBTransaction().createCallableStatement(sqlproc2, 0);
String v_dt1 = null;
HashMap hm = new HashMap<String, Object>();
try {
sqlProcStmt2.registerOutParameter(1, Types.INTEGER);
sqlProcStmt2.setString(2, compcode);
sqlProcStmt2.setString(3, unitcode);
//sqlProcStmt2.setString(4, vchcode);
//sqlProcStmt2.setBigDecimal(5, vchid);
//sqlProcStmt2.setString(6, finyrcode);
sqlProcStmt2.registerOutParameter(4, java.sql.Types.VARCHAR);
sqlProcStmt2.execute();
Long v_ret_val = sqlProcStmt2.getLong(1);
v_dt1 = sqlProcStmt2.getString(4);
hm.put("VchPrefix", v_dt1);
hm.put("TrfRefNo", v_ret_val);
System.out.println("v_ret_val " + v_ret_val);
//data_x_array[0] = v_ret_val;
//data_x_array[1] = v_dt1;
} catch (SQLException e) {
System.out.println(e.getMessage());
}
return hm;
}
System.out.println("vchno from pkg");
//String sqlproc2 = "{? = call adf_ess_leave_pkg.hdays_bw_dts_new2(?,?,?,?,?,?,?,?)}";
String sqlproc2 = "{? = call pos_vchno_pkg.Get_Transfer_Vchno(?,? ,'XFR',462,19,?)}";
CallableStatement sqlProcStmt2 = this.getDBTransaction().createCallableStatement(sqlproc2, 0);
String v_dt1 = null;
HashMap hm = new HashMap<String, Object>();
try {
sqlProcStmt2.registerOutParameter(1, Types.INTEGER);
sqlProcStmt2.setString(2, compcode);
sqlProcStmt2.setString(3, unitcode);
//sqlProcStmt2.setString(4, vchcode);
//sqlProcStmt2.setBigDecimal(5, vchid);
//sqlProcStmt2.setString(6, finyrcode);
sqlProcStmt2.registerOutParameter(4, java.sql.Types.VARCHAR);
sqlProcStmt2.execute();
Long v_ret_val = sqlProcStmt2.getLong(1);
v_dt1 = sqlProcStmt2.getString(4);
hm.put("VchPrefix", v_dt1);
hm.put("TrfRefNo", v_ret_val);
System.out.println("v_ret_val " + v_ret_val);
//data_x_array[0] = v_ret_val;
//data_x_array[1] = v_dt1;
} catch (SQLException e) {
System.out.println(e.getMessage());
}
return hm;
}
No comments:
Post a Comment