Connection conn = null;
CallableStatement proc = null;
try {
conn = ConnectionFactory.getConnection();
proc = conn.prepareCall("{ call WSSP.PROC_SELECT_DM_slh(?,?,?,?) }");
proc.setString(1, fqsqForm.getNsrsbh());
proc.setString(2, fqsqForm.getSpxl());
proc.setString(3,"1");
proc.registerOutParameter(4, Types.VARCHAR);
proc.execute();
slh = proc.getString(4);
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (null != proc) {
proc.close();
}
if (null != conn) {
conn.close();
}
} catch (Exception e) {
logger.info(e.toString());
}
}
CallableStatement proc = null;
try {
conn = ConnectionFactory.getConnection();
proc = conn.prepareCall("{ call WSSP.PROC_SELECT_DM_slh(?,?,?,?) }");
proc.setString(1, fqsqForm.getNsrsbh());
proc.setString(2, fqsqForm.getSpxl());
proc.setString(3,"1");
proc.registerOutParameter(4, Types.VARCHAR);
proc.execute();
slh = proc.getString(4);
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (null != proc) {
proc.close();
}
if (null != conn) {
conn.close();
}
} catch (Exception e) {
logger.info(e.toString());
}
}