[color=red]1.使用OracleCallableStatement对象[/color]
开发的代码如下:
public ArrayList<MeterChangehdAll> creatitems(HashMap paraMap)
throws DaoException {
Connection conn = DBConn.getConnection1();
ArrayList arr = new ArrayList();
String result = "";
try {
OracleCallableStatement ps = (OracleCallableStatement) conn
.prepareCall("call pg_metertrans.SearchCycChange(?,?,?,?,?,?,?,?,?)");
String temp="cicode";//用户号
if(("mcdmbfid,mcdmrorder").equals(paraMap.get("ordername"))){//抄表号
temp="mibfid,mirorder";
}
else if(("mcdmadr").equals(paraMap.get("ordername"))){//装表地址
temp="miadr";
}
ps.setString(1, (String) paraMap.get("p_smfid"));
ps.setString(2, (String) paraMap.get("p_sdate"));
ps.setString(3, (String) paraMap.get("p_edate"));
ps.setString(4, (String) paraMap.get("p_scaliber"));
ps.setString(5, (String) paraMap.get("p_ecalibe"));
ps.setString(6, (String) paraMap.get("p_sbfid"));
ps.setString(7, (String) paraMap.get("p_ebfid"));
ps.setString(8, temp);
ps.registerOutParameter(9, OracleTypes.CURSOR);
ps.execute();
System.out.println("执行完存储过程,开始转存"+new Date());
ResultSet rs = (ResultSet) ps.getObject(9);
while (rs.next()) {
MeterChangehdAll ndto = new MeterChangehdAll();
ndto.setMcdccode(rs.getString("mcdccode"));
ndto.setMcdmlabelno(rs.getString("mcdmlabelno"));
ndto.setMcdcname(rs.getString("mcdcname"));
ndto.setMcdcadr(rs.getString("mcdcadr"));
ndto.setMcdmadr(rs.getString("mcdmadr"));
ndto.setMcdmrorder(rs.getString("mcdmrorder"));
ndto.setMcdcid(rs.getString("mcdcid"));
ndto.setMcdmid(rs.getString("mcdmid"));
ndto.setMcdinsdate(rs.getDate("mcdinsdate"));
ndto.setMcdcyc(rs.getString("mcdcyc"));
ndto.setMchsource("1");
ndto.setMchlb("C");
arr.add(ndto);
}
System.out.println("数据循环转存结束"+new Date()+" 数据长度:"+arr.size());
ps.close();
} catch (Exception e) {
result = e.getMessage();
e.printStackTrace();
}
finally {
try {
if (conn != null) {
DBConn.close(conn);
}
return arr;
} catch (Exception e) {
System.out.println("发生不能关闭JDBC链接的异常,请检查!");
e.printStackTrace();
}
}
return arr;
}
[color=red]2.还可以直接使用PreparedStatement对象来调用存储过程[/color]
开发代码如下:
public String ApproveBill(HashMap paraMap) throws DaoException {
Connection conn = DBConn.getConnection1();
String result = "";
try {
PreparedStatement ps = conn.prepareStatement("BEGIN pg_metertrans.ApproveBill(?,?,?,?,?); END;");
ps.setString(1, (String) paraMap.get("p_billid"));
ps.setString(2, (String) paraMap.get("p_billno"));
ps.setString(3, (String) paraMap.get("p_djlb"));
ps.setString(4, (String) paraMap.get("p_person"));
ps.setInt(5, Integer.valueOf(paraMap.get("p_wfid").toString()));
ps.execute();
ps.close();
} catch (Exception e) {
result = e.getMessage();
e.printStackTrace();
} finally {
try {
if (conn != null) {
DBConn.close(conn);
}
return result;
} catch (Exception e) {
System.out.println("发生不能关闭JDBC链接的异常,请检查!");
e.printStackTrace();
}
}
return result;
}
以上代码为正式开发代码,可以做参考使用.
开发的代码如下:
public ArrayList<MeterChangehdAll> creatitems(HashMap paraMap)
throws DaoException {
Connection conn = DBConn.getConnection1();
ArrayList arr = new ArrayList();
String result = "";
try {
OracleCallableStatement ps = (OracleCallableStatement) conn
.prepareCall("call pg_metertrans.SearchCycChange(?,?,?,?,?,?,?,?,?)");
String temp="cicode";//用户号
if(("mcdmbfid,mcdmrorder").equals(paraMap.get("ordername"))){//抄表号
temp="mibfid,mirorder";
}
else if(("mcdmadr").equals(paraMap.get("ordername"))){//装表地址
temp="miadr";
}
ps.setString(1, (String) paraMap.get("p_smfid"));
ps.setString(2, (String) paraMap.get("p_sdate"));
ps.setString(3, (String) paraMap.get("p_edate"));
ps.setString(4, (String) paraMap.get("p_scaliber"));
ps.setString(5, (String) paraMap.get("p_ecalibe"));
ps.setString(6, (String) paraMap.get("p_sbfid"));
ps.setString(7, (String) paraMap.get("p_ebfid"));
ps.setString(8, temp);
ps.registerOutParameter(9, OracleTypes.CURSOR);
ps.execute();
System.out.println("执行完存储过程,开始转存"+new Date());
ResultSet rs = (ResultSet) ps.getObject(9);
while (rs.next()) {
MeterChangehdAll ndto = new MeterChangehdAll();
ndto.setMcdccode(rs.getString("mcdccode"));
ndto.setMcdmlabelno(rs.getString("mcdmlabelno"));
ndto.setMcdcname(rs.getString("mcdcname"));
ndto.setMcdcadr(rs.getString("mcdcadr"));
ndto.setMcdmadr(rs.getString("mcdmadr"));
ndto.setMcdmrorder(rs.getString("mcdmrorder"));
ndto.setMcdcid(rs.getString("mcdcid"));
ndto.setMcdmid(rs.getString("mcdmid"));
ndto.setMcdinsdate(rs.getDate("mcdinsdate"));
ndto.setMcdcyc(rs.getString("mcdcyc"));
ndto.setMchsource("1");
ndto.setMchlb("C");
arr.add(ndto);
}
System.out.println("数据循环转存结束"+new Date()+" 数据长度:"+arr.size());
ps.close();
} catch (Exception e) {
result = e.getMessage();
e.printStackTrace();
}
finally {
try {
if (conn != null) {
DBConn.close(conn);
}
return arr;
} catch (Exception e) {
System.out.println("发生不能关闭JDBC链接的异常,请检查!");
e.printStackTrace();
}
}
return arr;
}
[color=red]2.还可以直接使用PreparedStatement对象来调用存储过程[/color]
开发代码如下:
public String ApproveBill(HashMap paraMap) throws DaoException {
Connection conn = DBConn.getConnection1();
String result = "";
try {
PreparedStatement ps = conn.prepareStatement("BEGIN pg_metertrans.ApproveBill(?,?,?,?,?); END;");
ps.setString(1, (String) paraMap.get("p_billid"));
ps.setString(2, (String) paraMap.get("p_billno"));
ps.setString(3, (String) paraMap.get("p_djlb"));
ps.setString(4, (String) paraMap.get("p_person"));
ps.setInt(5, Integer.valueOf(paraMap.get("p_wfid").toString()));
ps.execute();
ps.close();
} catch (Exception e) {
result = e.getMessage();
e.printStackTrace();
} finally {
try {
if (conn != null) {
DBConn.close(conn);
}
return result;
} catch (Exception e) {
System.out.println("发生不能关闭JDBC链接的异常,请检查!");
e.printStackTrace();
}
}
return result;
}
以上代码为正式开发代码,可以做参考使用.