论坛首页 → 入门讨论版 →

tomcat连接池中得到的连接无法释放

浏览 1172 次
锁定老贴子 主题：tomcat连接池中得到的连接无法释放
该帖已经被评为新手帖
作者 正文
  • daimon
  • 等级: 初级会员
  • 用户头像
  • 性别:
  • 文章: 19
  • 积分: 50
  • 来自: 陕西。西安
最后更新时间：2007-03-08
java 代码
  1. package dao;   
  2.   
  3. import java.sql.CallableStatement;   
  4. import java.sql.Connection;   
  5. import java.sql.PreparedStatement;   
  6. import java.sql.ResultSet;   
  7. import java.sql.SQLException;   
  8. import java.sql.Statement;   
  9. import java.util.ArrayList;   
  10. import java.util.Collection;   
  11. import java.util.Date;   
  12.   
  13. import beans.ErrdataLog;   
  14. import beans.MobileDeliver;   
  15. import beans.MobileDeliverBak;   
  16. import beans.MobileSubmit;   
  17. import beans.MobileSubmitBak;   
  18. import beans.Recbank;   
  19. import beans.RecbankBak;   
  20. import beans.Recbankerror;   
  21. import beans.RecbankerrorBak;   
  22. import beans.RootClass;   
  23. import beans.Sendbank;   
  24. import beans.SendbankBak;   
  25. import beans.UnionDeliver;   
  26. import beans.UnionDeliverBak;   
  27. import beans.UnionSubmit;   
  28. import beans.UnionSubmitBak;   
  29.   
  30. public class searchDAO {   
  31.     ConnectionFactory cf = null;   
  32.        
  33.     public searchDAO(){   
  34.         cf = new ConnectionFactory();   
  35.            
  36.     }   
  37.   
  38.     /**  
  39.      * @param tel  
  40.      * @param startTime  
  41.      * @param endTime  
  42.      * @param table  
  43.      * @return  
  44.      */  
  45.     public Collection search(String tel,String startTime,String endTime,String table){   
  46.         Collection c = new ArrayList();   
  47.         PreparedStatement pstmt = null;   
  48.         ResultSet rs = null;   
  49.         Connection conn = null;   
  50.         try {   
  51.             conn = cf.getConnection();   
  52.             String sql = "call spserverdb.query_all(?,?,?,?)";   
  53.             pstmt = conn.prepareStatement(sql);   
  54.             pstmt.setString(1,tel);   
  55.             pstmt.setString(2,startTime);   
  56.             pstmt.setString(3,endTime);   
  57.             pstmt.setString(4,table);   
  58. //          pstmt.registerOutParameter(5, java.sql.Types.VARCHAR);   
  59.             rs = pstmt.executeQuery();   
  60. //          System.out.println(Integer.valueOf(cstmt.getString(5)));   
  61. //          System.out.println(rs.getFetchSize());   
  62. /**  
  63.  * 对结果集进行遍历  
  64.  */  
  65.             while(rs.next()){   
  66.                 if(table.equals("mobile_deliver")){   
  67.                     MobileDeliver md = new MobileDeliver();   
  68.                     md.setId(rs.getInt(1));   
  69.                     md.setMsgId(rs.getString(2));   
  70.                     md.setRecTime(rs.getString(3));   
  71.                     md.setDestId(rs.getString(4));   
  72.                     md.setServiceId(rs.getString(5));   
  73.                     md.setTpPid(rs.getShort(6));   
  74.                     md.setTpUdhi(rs.getShort(7));   
  75.                     md.setMsgFmt(rs.getShort(8));   
  76.                     md.setSrcTerminalId(rs.getString(9));   
  77.                     md.setMsgLength(rs.getShort(10));   
  78.                     md.setMsgContent(rs.getString(11));   
  79.                     md.setReserved(rs.getString(12));   
  80.                     c.add(md);   
  81.                 }else if(table.equals("mobile_deliver_bak")){   
  82.                     MobileDeliverBak mdb = new MobileDeliverBak();   
  83.                     mdb.setId(rs.getInt(2));   
  84.                     mdb.setMsgId(rs.getString(3));   
  85.                     mdb.setRecTime(rs.getString(4));   
  86.                     mdb.setDestId(rs.getString(5));   
  87.                     mdb.setServiceId(rs.getString(6));   
  88.                     mdb.setTpPid(rs.getShort(7));   
  89.                     mdb.setTpUdhi(rs.getShort(8));   
  90.                     mdb.setMsgFmt(rs.getShort(9));   
  91.                     mdb.setSrcTerminalId(rs.getString(10));   
  92.                     mdb.setMsgLength(rs.getShort(11));   
  93.                     mdb.setMsgContent(rs.getString(12));   
  94.                     mdb.setReserved(rs.getString(13));   
  95.                     c.add(mdb);   
  96.                 }else if(table.equals("mobile_submit")){   
  97.                     MobileSubmit ms = new MobileSubmit();   
  98.                     ms.setId(rs.getInt(1));   
  99.                     ms.setCreateTime(rs.getString(2));   
  100.                     ms.setMsgId(rs.getString(3));   
  101.                     ms.setPkTotal(rs.getShort(4));   
  102.                     ms.setPkNumber(rs.getShort(5));   
  103.                     ms.setRegisteredDelivery(rs.getShort(6));   
  104.                     ms.setMsgLevel(rs.getShort(7));   
  105.                     ms.setServiceId(rs.getString(8));   
  106.                     ms.setNewServiceId(rs.getString(9));   
  107.                     ms.setFeeUserType(rs.getShort(10));   
  108.                     ms.setFeeTerminalId(rs.getString(11));   
  109.                     ms.setTpPId(rs.getShort(12));   
  110.                     ms.setTpUdhi(rs.getShort(13));   
  111.                     ms.setMsgFmt(rs.getShort(14));   
  112.                     ms.setMsgSrc(rs.getString(15));   
  113.                     ms.setFeeType(rs.getString(16));   
  114.                     ms.setFeeCode(rs.getString(17));   
  115.                     ms.setValIdTime(rs.getString(18));   
  116.                     ms.setAtTime(rs.getString(19));   
  117.                     ms.setSrcId(rs.getString(20));   
  118.                     ms.setDestUsrTl(rs.getShort(21));   
  119.                     ms.setDestTerminalId(rs.getString(22));   
  120.                     ms.setMsgLength(rs.getShort(23));   
  121.                     ms.setMsgContent(rs.getString(24));   
  122.                     ms.setReserve(rs.getString(25));   
  123.                     ms.setSubmitCount(rs.getShort(26));   
  124.                     ms.setSubmitFirstTime(rs.getString(27));   
  125.                     ms.setSubmitLastTime(rs.getString(28));   
  126.                     ms.setSubmitFlag(rs.getShort(29));   
  127.                     ms.setSubmitError(rs.getString(30));   
  128.                     ms.setRecReportTime(rs.getString(31));   
  129.                     ms.setReportStat(rs.getString(32));   
  130.                     ms.setSendCount(rs.getShort(33));   
  131.                     c.add(ms);   
  132.                 }else if(table.equals("mobile_submit_bak")){   
  133.                     MobileSubmitBak msb = new MobileSubmitBak();   
  134.                     msb.setId(rs.getInt(2));   
  135.                     msb.setCreateTime(rs.getString(3));   
  136.                     msb.setMsgId(rs.getString(4));   
  137.                     msb.setPkTotal(rs.getShort(5));   
  138.                     msb.setPkNumber(rs.getShort(6));   
  139.                     msb.setRegisteredDelivery(rs.getShort(7));   
  140.                     msb.setMsgLevel(rs.getShort(8));   
  141.                     msb.setServiceId(rs.getString(9));   
  142.                     msb.setNewServiceId(rs.getString(10));   
  143.                     msb.setFeeUserType(rs.getShort(11));   
  144.                     msb.setFeeTerminalId(rs.getString(12));   
  145.                     msb.setTpPId(rs.getShort(13));   
  146.                     msb.setTpUdhi(rs.getShort(14));   
  147.                     msb.setMsgFmt(rs.getShort(15));   
  148.                     msb.setMsgSrc(rs.getString(16));   
  149.                     msb.setFeeType(rs.getString(17));   
  150.                     msb.setFeeCode(rs.getString(18));   
  151.                     msb.setValIdTime(rs.getString(19));   
  152.                     msb.setAtTime(rs.getString(20));   
  153.                     msb.setSrcId(rs.getString(21));   
  154.                     msb.setDestUsrTl(rs.getShort(22));   
  155.                     msb.setDestTerminalId(rs.getString(23));   
  156.                     msb.setMsgLength(rs.getShort(24));   
  157.                     msb.setMsgContent(rs.getString(25));   
  158.                     msb.setReserve(rs.getString(26));   
  159.                     msb.setSubmitCount(rs.getShort(27));   
  160.                     msb.setSubmitFirstTime(rs.getString(28));   
  161.                     msb.setSubmitLastTime(rs.getString(29));   
  162.                     msb.setSubmitFlag(rs.getShort(30));   
  163.                     msb.setSubmitError(rs.getString(31));   
  164.                     msb.setRecReportTime(rs.getString(32));   
  165.                     msb.setReportStat(rs.getString(33));   
  166.                     msb.setSendCount(rs.getShort(34));   
  167.                     c.add(msb);   
  168.                 }else if(table.equals("recbank")){   
  169.                     Recbank rb = new Recbank();   
  170.                     rb.setId(rs.getInt(1));   
  171.                     rb.setBandId(rs.getString(2));   
  172.                     rb.setServiceId(rs.getString(3));   
  173.                     rb.setFeeType(rs.getString(4));   
  174.                     rb.setFeeCode(rs.getString(5));   
  175.                     rb.setAttchCode(rs.getString(6));   
  176.                     rb.setDestUsrTotal(rs.getString(7));   
  177.                     rb.setDestUserId(rs.getString(8));   
  178.                     rb.setMsgTotal(rs.getString(9));   
  179.                     rb.setMsgContent(rs.getString(10));   
  180.                     rb.setLinkId(rs.getString(11));   
  181.                     rb.setReserve(rs.getString(12));   
  182.                     rb.setRecTime(rs.getString(13));   
  183.                     c.add(rb);   
  184.                 }else if(table.equals("recbank_bak")){   
  185.                     RecbankBak rbb = new RecbankBak();   
  186.                     rbb.setId(rs.getInt(2));   
  187.                     rbb.setBandId(rs.getString(3));   
  188.                     rbb.setServiceId(rs.getString(4));   
  189.                     rbb.setFeeType(rs.getString(5));   
  190.                     rbb.setFeeCode(rs.getString(6));   
  191.                     rbb.setAttchCode(rs.getString(7));   
  192.                     rbb.setDestUsrTotal(rs.getString(8));   
  193.                     rbb.setDestUserId(rs.getString(9));   
  194.                     rbb.setMsgTotal(rs.getString(10));   
  195.                     rbb.setMsgContent(rs.getString(11));   
  196.                     rbb.setLinkId(rs.getString(12));   
  197.                     rbb.setReserve(rs.getString(13));   
  198.                     rbb.setRecTime(rs.getString(14));   
  199.                     c.add(rbb);   
  200.                 }else if(table.equals("recbankerror")){   
  201.                     Recbankerror rbr = new Recbankerror();   
  202.                     rbr.setId(rs.getInt(1));   
  203.                     rbr.setDataContent(rs.getString(2));   
  204.                     rbr.setRecTime(rs.getString(3));   
  205.                     rbr.setErrorType(rs.getString(4));   
  206.                     c.add(rbr);   
  207.                 }else if(table.equals("recbankerror_bak")){   
  208.                     RecbankerrorBak rbkb = new RecbankerrorBak();   
  209.                     rbkb.setId(rs.getInt(2));   
  210.                     rbkb.setDataContent(rs.getString(3));   
  211.                     rbkb.setRecTime(rs.getString(3));   
  212.                     rbkb.setErrorType(rs.getString(4));   
  213.                     c.add(rbkb);   
  214.                 }else if(table.equals("sendbank")){   
  215.                     Sendbank sb = new Sendbank();   
  216.                     sb.setId(rs.getInt(1));   
  217.                     sb.setCreateTime(rs.getString(2));   
  218.                     sb.setBandId(rs.getString(3));   
  219.                     sb.setServiceId(rs.getString(4));   
  220.                     sb.setAttchCode(rs.getString(5));   
  221.                     sb.setSrcterminalId(rs.getString(6));   
  222.                     sb.setNone1(rs.getString(7));   
  223.                     sb.setNone2(rs.getString(8));   
  224.                     sb.setMsgContent(rs.getString(9));   
  225.                     sb.setSendCount(rs.getInt(10));   
  226.                     sb.setSucceedFlag(rs.getShort(11));   
  227.                     sb.setSendTime(rs.getString(12));   
  228.                     c.add(sb);   
  229.                 }else if(table.equals("sendbank_bak")){   
  230.                     SendbankBak sbb = new SendbankBak();   
  231.                     sbb.setId(rs.getInt(2));   
  232.                     sbb.setCreateTime(rs.getString(3));   
  233.                     sbb.setBandId(rs.getString(4));   
  234.                     sbb.setServiceId(rs.getString(5));   
  235.                     sbb.setAttchCode(rs.getString(6));   
  236.                     sbb.setSrcterminalId(rs.getString(7));   
  237.                     sbb.setNone1(rs.getString(8));   
  238.                     sbb.setNone2(rs.getString(9));   
  239.                     sbb.setMsgContent(rs.getString(10));   
  240.                     sbb.setSendCount(rs.getInt(11));   
  241.                     sbb.setSucceedFlag(rs.getShort(12));   
  242.                     sbb.setSendTime(rs.getString(13));   
  243.                     c.add(sbb);   
  244.                 }else if(table.equals("union_deliver")){   
  245.                     UnionDeliver ud = new UnionDeliver();   
  246.                     ud.setId(rs.getInt(1));   
  247.                     ud.setMsgId(rs.getString(2));   
  248.                     ud.setRecTime(rs.getString(3));   
  249.                     ud.setUserNumber(rs.getString(4));   
  250.                     ud.setSpnumber(rs.getString(5));   
  251.                     ud.setTpPid(rs.getShort(6));   
  252.                     ud.setTpUdhi(rs.getShort(7));   
  253.                     ud.setMessageCoding(rs.getShort(8));   
  254.                     ud.setMessageLength(rs.getShort(9));   
  255.                     ud.setReserve(rs.getString(10));   
  256.                     ud.setMsgContent(rs.getString(11));   
  257.                     c.add(ud);   
  258.                 }else if(table.equals("union_deliver_bak")){   
  259.                     UnionDeliverBak udb = new UnionDeliverBak();   
  260.                     udb.setId(rs.getInt(2));   
  261.                     udb.setMsgId(rs.getString(3));   
  262.                     udb.setRecTime(rs.getString(4));   
  263.                     udb.setUserNumber(rs.getString(5));   
  264.                     udb.setSpnumber(rs.getString(6));   
  265.                     udb.setTpPid(rs.getShort(7));   
  266.                     udb.setTpUdhi(rs.getShort(8));   
  267.                     udb.setMessageCoding(rs.getShort(9));   
  268.                     udb.setMessageLength(rs.getShort(10));   
  269.                     udb.setReserve(rs.getString(11));   
  270.                     udb.setMsgContent(rs.getString(12));   
  271.                     c.add(udb);   
  272.                 }else if(table.equals("union_submit")){   
  273.                     UnionSubmit us = new UnionSubmit();   
  274.                     us.setId(rs.getInt(1));   
  275.                     us.setCreateTime(rs.getString(2));   
  276.                     us.setMsgId(rs.getString(3));   
  277.                     us.setSpnumber(rs.getString(4));   
  278.                     us.setChargeNumber(rs.getString(5));   
  279.                     us.setUserCount(rs.getShort(6));   
  280.                     us.setUserNumber(rs.getString(7));   
  281.                     us.setCorpId(rs.getString(8));   
  282.                     us.setServiceType(rs.getString(9));   
  283.                     us.setNewServiceType(rs.getString(10));   
  284.                     us.setFeeType(rs.getShort(11));   
  285.                     us.setFeeValue(rs.getString(12));   
  286.                     us.setGivenValue(rs.getString(13));   
  287.                     us.setAgentFlag(rs.getShort(14));   
  288.                     us.setMorelatetoMtflag(rs.getShort(15));   
  289.                     us.setPriority(rs.getShort(16));   
  290.                     us.setExpireTime(rs.getString(17));   
  291.                     us.setScheduleTime(rs.getString(18));   
  292.                     us.setReportFlag(rs.getShort(19));   
  293.                     us.setTpPid(rs.getShort(
返回顶楼
   
  • Lucas Lee
  • 等级: 二钻会员
  • 用户头像
  • 性别:
  • 文章: 1036
  • 积分: 1263
  • 来自: 上海
最后更新时间：2007-03-08
这是什么代码阿，长得都被截断了？
返回顶楼
   
0 请登录后投票
  • tangyuanjian2007
  • 等级: 初级会员
  • 用户头像
  • 文章: 13
  • 积分: 0
最后更新时间：2007-03-08
你是解决了问题,还是提问题啊
返回顶楼
   
0 请登录后投票
论坛首页 → 入门讨论版

跳转论坛:
JavaEye推荐