public String getBoeTypeCode(Passport port, String numberType, String boeTypeCode, String deptCode)
{
String returnString = "";
Connection con = this.getSession().connection();
CallableStatement cstm = null;
try
{
synchronized (this)
{
cstm = con.prepareCall("{call FBP_GENERATION_NUMBER_PKG.get_generation_number(?,?,?,?)}");
cstm.setString(1, numberType);
cstm.setString(2, boeTypeCode);
cstm.setString(3, deptCode);
cstm.registerOutParameter(4, Types.VARCHAR);
cstm.execute();
returnString = cstm.getString(4);
}
}
catch (Exception e)
{
// 从容器中取出的session的生命周期由容器管理,不用手动close掉。
// if(s != null)
// {
// s.close();
// s = null;
// }
e.printStackTrace();
}
finally
{
try
{
if (cstm != null)
{
con.commit();
cstm.close();
con.close();
}
}
catch (Exception e)
{
e.printStackTrace();
}
cstm = null;
con = null;
}
return returnString;
}