Slide 15
Slide 15 text
7 public
8 DataPair[] getHotelInformation(String lang, String hotelId, String informationId)
9 {
10
11 String key = "_HOINF_"+lng+"_"+hotelId+"_"+informationId;
12 DataPair[] tbl = (DataPair[])csh.getObject(key);
13 if(tbl!=null) return tbl;
14
15 Connection cn = null;
16 OracleCallableStatement cs = null;
17 try {
18 String qry = " begin HotelServices.getHotelInfo(?, ?, ?, ?, ?); end; ";
19 logger . debug("---"+qry+" "+hotelId+" "+informationId);
20 cn = DriverManager.getConnection("jdbc:weblogic:pool:oraclePool",null);
21 cs = (OracleCallableStatement)cn.prepareCall(qry);
22 cs . registerOutParameter(1,java.sql.Types.INTEGER);
24 cs . setString(3,hotelId);
27 cs . execute();
28 int sta = cs.getInt(1);
29 if(sta!=0) throw new Exception("status not zero sta="+sta);
30 ResultSet rs = cs.getResultSet(2);
31 tbl = getDataPairArray(rs);
32 logger . debug("sta="+sta+" key="+key+" cn="+cn);
33 csh . put(key,tbl);
34 }
35 catch(Exception e)
36 {
37 logger . debug("!!! "+e.toString()+" "+key);
38 }
39 finally
40 {
41 try {
42 if(cs!=null) cs . close();
44 }
45 catch(Exception x)
46 {
47 logger . debug("!!! "+x.toString()+" "+key);
49 }
50 }
51 return tbl;
52 }