<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    Terry.Li-彬

    虛其心,可解天下之問;專其心,可治天下之學;靜其心,可悟天下之理;恒其心,可成天下之業(yè)。

      BlogJava :: 首頁 :: 新隨筆 :: 聯(lián)系 :: 聚合  :: 管理 ::
      143 隨筆 :: 344 文章 :: 130 評論 :: 0 Trackbacks
    導入jar包:proxool-0.9.1.jar 和 proxool-cglib.jar

    一、使用硬編碼方式
    package?com.proxool.test;

    import?java.sql.Connection;
    import?java.sql.DriverManager;
    import?java.sql.SQLException;

    import?org.apache.commons.logging.Log;
    import?org.apache.commons.logging.LogFactory;

    public?class?Test1?{
    ????
    private?static?final?Log?LOG?=?LogFactory.getLog(Test1.class);
    ????
    /**
    ?????*?
    @param?args
    ?????
    */
    ????
    public?static?void?main(String[]?args)?{
    ????????
    //?TODO?Auto-generated?method?stub
    ????????Connection?connection?=?null;
    ?????????
    try?{
    //???????????Class.forName("com.mysql.jdbc.Driver");
    ?????????????Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
    ???????????
    try?{
    //?????????????connection?=?DriverManager.getConnection("jdbc:mysql://172.16.220.154:3306/sipityprofile?autoReconnect=true&useUnicode=true&characterEncoding=utf8&user=root&password=12345678");
    ???????????????connection?=?DriverManager.getConnection("proxool.example:com.mysql.jdbc.Driver:jdbc:mysql://172.16.220.154:3306/sipityprofile?user=root&password=12345678");
    //???????????????connection?=?DriverManager.getConnection("proxool.example");
    ???????????}?catch?(SQLException?e)?{
    ?????????????LOG.error(
    "Problem?getting?connection",?e);
    ???????????}
    ???????????
    ??????????
    if?(connection?!=?null)?{
    ????????????LOG.info(
    "Got?connection?:)");
    ??????????}?
    else?{
    ????????????LOG.error(
    "Didn't?get?connection,?which?probably?means?that?no?Driver?accepted?the?URL");
    ??????????}
    ??????????
    ????????}?
    catch?(ClassNotFoundException?e)?{
    ??????????LOG.error(
    "Couldn't?find?driver",?e);
    ????????}?
    finally?{
    ??????????
    try?{
    ????????????
    //?Check?to?see?we?actually?got?a?connection?before?we
    ????????????
    //?attempt?to?close?it.
    ????????????if?(connection?!=?null)?{
    ??????????????connection.close();
    ????????????}
    ??????????}?
    catch?(SQLException?e)?{
    ????????????LOG.error(
    "Problem?closing?connection",?e);
    ??????????}
    ????????}?
    ????}

    }

    二、使用 xml 配置文件
    package?com.proxool.test;

    import?java.sql.Connection;
    import?java.sql.DriverManager;
    import?java.sql.ResultSet;
    import?java.sql.SQLException;
    import?java.sql.Statement;

    import?org.apache.commons.logging.Log;
    import?org.apache.commons.logging.LogFactory;
    import?org.logicalcobwebs.proxool.ProxoolException;
    import?org.logicalcobwebs.proxool.configuration.JAXPConfigurator;

    public?class?Test2ByXml?{
    ????
    ????
    private?static?final?Log?LOG?=?LogFactory.getLog(Test2ByXml.class);

    ????
    /**
    ?????*?
    @param?args
    ?????
    */
    ????
    public?static?void?main(String[]?args)?{
    ????????
    //?TODO?Auto-generated?method?stub
    ????????try?{
    ????????????JAXPConfigurator.configure(
    "src/proxool.xml",?false);
    ????????????Connection?connection?
    =?DriverManager.getConnection("proxool.proxool-sipity");
    ????????????
    if?(null?==?connection)?{
    ????????????????LOG.info(
    "connection?is?null");
    ????????????}
    else?{
    ????????????????LOG.info(
    "connection?successfull");
    ????????????????Statement?statement?
    =?connection.createStatement();
    ????????????????ResultSet?resultSet?
    =?statement.executeQuery("select?*?from?event");
    ????????????????
    while?(resultSet.next())?{
    ????????????????????LOG.info(resultSet.getInt(
    1)+"????"+resultSet.getString(2));
    ????????????????}
    ????????????}
    ????????}?
    catch?(ProxoolException?e)?{
    ????????????
    //?TODO?Auto-generated?catch?block
    ????????????e.printStackTrace();
    ????????}?
    catch?(SQLException?e)?{
    ????????????
    //?TODO?Auto-generated?catch?block
    ????????????e.printStackTrace();
    ????????}
    ????}

    }

    <?xml?version="1.0"?encoding="ISO-8859-1"?>
    <something-else-entirely>
    ????
    <proxool>
    ????????
    <alias>proxool-sipity</alias>
    ????????
    <driver-url>jdbc:mysql://172.16.220.154:3306/sipityprofile</driver-url>
    ????????
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    ????????
    <driver-properties>
    ????????????
    <property?name="user"?value="root"?/>
    ????????????
    <property?name="password"?value="12345678"?/>
    ????????
    </driver-properties>
    ????????
    <maximum-connection-count>10</maximum-connection-count>
    ????????
    <house-keeping-test-sql>select?1</house-keeping-test-sql>
    ????
    </proxool>
    </something-else-entirely>



    三、使用 properties 方式
    package?com.proxool.test;

    import?java.sql.Connection;
    import?java.sql.DriverManager;
    import?java.sql.ResultSet;
    import?java.sql.SQLException;
    import?java.sql.Statement;

    import?org.apache.commons.logging.Log;
    import?org.apache.commons.logging.LogFactory;
    import?org.logicalcobwebs.proxool.ProxoolException;
    import?org.logicalcobwebs.proxool.configuration.PropertyConfigurator;

    public?class?Test3ByProp?{
    ????
    private?static?final?Log?LOG?=?LogFactory.getLog(Test3ByProp.class);
    ????
    ????
    static{
    ????????
    try?{
    ????????????PropertyConfigurator.configure(
    "src/proxool.properties");
    ????????}?
    catch?(ProxoolException?e)?{
    ????????????
    //?TODO?Auto-generated?catch?block
    ????????????e.printStackTrace();
    ????????}
    ????}
    ????
    /**
    ?????*?
    @param?args
    ?????
    */
    ????
    public?static?void?main(String[]?args)?{
    ????????
    //?TODO?Auto-generated?method?stub
    ????????testConnection();
    ????????testConnection();
    ????}
    ????
    private?static?void?testConnection()?{
    ????????Connection?connection?
    =?null;
    ????????
    try?{
    ????????????
    ????????????connection?
    =?DriverManager.getConnection("proxool.proxool-sipity");
    ????????????
    if?(null?==?connection)?{
    ????????????????LOG.info(
    "connection?is?null");
    ????????????}
    else?{
    ????????????????LOG.info(
    "connection?successfull");
    ????????????????Statement?statement?
    =?connection.createStatement();
    ????????????????ResultSet?resultSet?
    =?statement.executeQuery("select?*?from?event");
    ????????????????
    while?(resultSet.next())?{
    ????????????????????
    //LOG.info(resultSet.getInt(1)+"????"+resultSet.getString(2));
    ????????????????}
    ????????????}
    ????????}?
    catch?(SQLException?e)?{
    ????????????
    //?TODO?Auto-generated?catch?block
    ????????????e.printStackTrace();
    ????????}?
    finally?{
    ????????????
    try?{
    ????????????????connection.close();
    ????????????}?
    catch?(SQLException?e)?{
    ????????????????
    //?TODO?Auto-generated?catch?block
    ????????????????e.printStackTrace();
    ????????????}
    ????????}
    ????}

    }

    jdbc-0.proxool.alias=proxool-sipity
    jdbc
    -0.proxool.driver-url=jdbc:mysql://172.16.220.154:3306/sipityprofile
    jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver
    jdbc
    -0.user=root
    jdbc
    -0.password=12345678
    jdbc
    -0.proxool.maximum-connection-count=10
    jdbc
    -0.proxool.house-keeping-test-sql=select?1

    posted on 2009-09-09 17:09 禮物 閱讀(890) 評論(0)  編輯  收藏 所屬分類: java
    主站蜘蛛池模板: 一级做a爰黑人又硬又粗免费看51社区国产精品视 | 亚洲毛片免费视频| 成人在线视频免费| 色婷婷综合缴情综免费观看 | 亚洲高清毛片一区二区| 国产亚洲精品看片在线观看 | 最近的免费中文字幕视频| 成年免费a级毛片| 亚洲午夜国产精品无卡| 亚洲AV日韩精品一区二区三区| 香蕉成人免费看片视频app下载| 91亚洲性爱在线视频| 亚洲国产成人久久笫一页| 四虎国产精品永久免费网址 | 24小时日本在线www免费的| 国产男女爽爽爽免费视频| 亚洲国产精品成人久久久| 国产成人亚洲综合| 国产高清免费视频| 二区久久国产乱子伦免费精品| 中文字幕 亚洲 有码 在线| 亚洲综合图色40p| 暖暖在线日本免费中文| 一级毛片免费视频| 一级大黄美女免费播放| 亚洲а∨天堂久久精品9966| 国产亚洲成AV人片在线观黄桃 | 亚洲国产韩国一区二区| 激情97综合亚洲色婷婷五 | 亚洲二区在线视频| 亚洲成a人片在线观看无码| 免费h成人黄漫画嘿咻破解版| 亚洲国产精品免费在线观看| 一个人看的免费观看日本视频www| 亚洲av专区无码观看精品天堂| 国产亚洲精品福利在线无卡一| 最近的中文字幕大全免费版| 美女视频黄的免费视频网页| 日韩大片在线永久免费观看网站| 亚洲人成电影网站| 内射干少妇亚洲69XXX|