Connection conn = this.getHibernateDAO().getConnection();
try{
CallableStatement ps = conn.prepareCall("call STD_STRUCTURE_STANDARD_P.STRUCTRUE_STANDARD_IMPORT_P(?,?,?,?,?)");
ps.setString(1, stdStructrueId);
ps.setString(2, stdSystemId);
ps.registerOutParameter(3, java.sql.Types.INTEGER);
ps.registerOutParameter(4, java.sql.Types.VARCHAR);
ps.execute();
Double num=(Double)ps.getObject(3);
String message=(String)ps.getObject(4);
return message;
}catch (Exception e) {
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
try{
CallableStatement ps = conn.prepareCall("call STD_STRUCTURE_STANDARD_P.STRUCTRUE_STANDARD_IMPORT_P(?,?,?,?,?)");
ps.setString(1, stdStructrueId);
ps.setString(2, stdSystemId);
ps.registerOutParameter(3, java.sql.Types.INTEGER);
ps.registerOutParameter(4, java.sql.Types.VARCHAR);
ps.execute();
Double num=(Double)ps.getObject(3);
String message=(String)ps.getObject(4);
return message;
}catch (Exception e) {
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}