proxool+hsqldb

使用hsqldb数据库，开发环境eclipse,jdk8.0

Dsqldb数据库

1、下载包：hsqldb.jar

2、新建项目，复制到项目WebContent -> WEB -> INF -> lib下面，右键选择 Build Path  ->  Add to Build Path

3、在项目中找到Referenced Libraries点击，选择hsqldb.jar -> org.hsqldb.server -> Server.class -> Server 右键 选择 Run as -> 1 JAVA Application 启动项目

4、选择hsqldb.jar -> org.hsqldb.util -> DatabaseManagerSwing.class -> DatabaseManagerSwing 右键 选择 Run as -> JAVA Application 启动数据库

5、之后会弹出窗口，在第二个下拉框中 hsqldb database server ，点击OK登录(其他不需做改变)，这里是指以hsqldb的客户端登录

Proxool

1、下载：官方网址:http://proxool.sourceforge.net/servlets.html (包：proxool-0.9.1.jar下载解压缩，之后会在lib有两个包，在jarjar有两个包，导入到项目lib中(包为：jarjar-0.6.jar、proxool-0.9.1.jar、proxool-cglib.jar、cglib-nodep-2.1_3.jar));

在之后的测试代码中，还需下载commons-dbcp-1.2.2.jar、commons-io-1.3.2.jar、commons-lang-2.4.jar、commons-logging-1.0.4.jar、commons-logging-api-1.1.jar、commons-pool-1.4.jar(commons包)

测试代码：

eclipse连接dsqldb数据库

package com.hsqldb;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;//使用hsqldb数据库连接public class hsqlconfig {  public static void main(String[] args) {    Connection conn = null;    ResultSet rs = null;    try {      //选择dsqldb.jar -> org.hsqldb.jdbc -> JDBCDriver.class -> JDBCDriver右键选择Copy Qualified Name       //粘贴到这里。这里的意思就是告诉eclipse说你去给我加载dsqldb的数据库驱动      Class.forName("org.hsqldb.jdbc.JDBCDriver");       //选择dsqldb.jar -> org.hsqldb.util -> DatabaseManagerSwing.class -> DatabaseManagerSwing右键选择Copy Qualified Name      //之后会弹出dsqldb客户端登录窗体，选择 URL 复制 jdbc:hsqldb:hsql://localhost/      //默认dsqldb账号为sa,密码为空;      conn = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/","SA","");      Statement stmt = conn.createStatement();      rs = stmt.executeQuery("select count(*) as ant from userinfo");      if(rs!=null){        while(rs.next()){          System.out.println(rs.getInt("ant"));        }      }    } catch (ClassNotFoundException e) {      e.printStackTrace();    } catch (SQLException e) {      e.printStackTrace();    }  }}

同上，这里也是放在Src文件下，代码也是通过Src去找

<proxool-config>  <proxool>    <alias>//localhost/</driver-url>    <driver-class>org.hsqldb.jdbc.JDBCDriver</driver-class>    <!-- <statistics>1m,15m,1d</statistics> -->    <driver-properties>     <property name="user" value="SA"/>     <property name="password" value=""/>    </driver-properties>    <maximum-connection-count>10</maximum-connection-count>    <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>  </proxool></proxool-config>

使用Tomcat访问网页，将该数据库的信息加载出来(Tomcat 8.0)

1、新建Servlet，编写代码

package com.proxool.servlet;import java.io.IOException;import java.io.InputStreamReader;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.logicalcobwebs.proxool.ProxoolException;import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;import org.logicalcobwebs.proxool.configuration.PropertyConfigurator;import com.proxool.Properties_Proxool;import com.proxool."/helloproxool")public class helloproxool extends HttpServlet {  private static final long serialVersionUID = 1L;  public helloproxool() {    super();  }  protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {    Connection conn = null;    ResultSet rs = null;    Statement stmt;      try {        Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");        try {          try {            conn = DriverManager.getConnection("proxool.);          } catch (SQLException e) {                        e.printStackTrace();          }        } catch (Exception e) {          e.printStackTrace();        }        try {          stmt = conn.createStatement();          System.out.println(stmt);          rs = stmt.executeQuery("select count(*) as ant from userinfo");          if(rs!=null){            while(rs.next()){              System.out.println(rs.getInt("ant"));            }          }        } catch (SQLException e) {                    e.printStackTrace();        }      } catch (ClassNotFoundException e1) {        e1.printStackTrace();      }    }    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {    // TODO Auto-generated method stub    doGet(request, response);  }}

原标题：proxool+hsqldb

关键词：sql