首页 > 代码库 > proxool+hsqldb
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(); } }}
eclipse连接hsqldb数据库,使用JAVA配置
package com.proxool;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;//直接java编写配置public class JavaProxool { public static void main(String[] args) { //Properties 配置文件,用户存放系统配置信息等 Properties info = new Properties(); info.setProperty("proxool.maximum-connection-count", "20"); info.setProperty("proxool.house-keeping-test-sql", "select CURRENT_DATE"); info.setProperty("user", "sa"); info.setProperty("password", ""); String alias = "test"; String driverClass = "org.hsqldb.jdbc.JDBCDriver"; String driverUrl = "jdbc:hsqldb:hsql://localhost/"; String url = "proxool." + alias + ":" + driverClass + ":" + driverUrl; try { //加载驱动包(proxool的驱动包) Class.forName("org.logicalcobwebs.proxool.ProxoolDriver"); } catch (ClassNotFoundException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } Connection conn = null; ResultSet rs = null; try { //执行连接过程,其中url是完整的路径,info是配置信息 conn = DriverManager.getConnection(url, info); //声明一个可执行sql语句的对象 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 (SQLException e) { e.printStackTrace(); } }}
eclipse使用properties连接hsqldb数据库
package com.proxool;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;//使用proxool透明模式连接数据库public class proxoolconfig { public static void main(String[] args) { Connection conn = null; ResultSet rs = null; try { Class.forName("org.logicalcobwebs.proxool.ProxoolDriver"); //proxool.example 是别名 //org.hsqldb.jdbc.JDBCDriver 是数据库的名称 //jdbc:hsqldb:hsql://localhost/ 是url地址 conn = DriverManager.getConnection("proxool.example:org.hsqldb.jdbc.JDBCDriver:jdbc:hsqldb:hsql://localhost/"); 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(); }finally{ try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } }}
eclipse连接hsqldb数据库,使用properties文件配置
package com.proxool;import java.io.IOException;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 org.logicalcobwebs.proxool.ProxoolException;import org.logicalcobwebs.proxool.configuration.PropertyConfigurator;//使用Properties配置文件信息public class Properties_Proxool { public static void main(String[] args) { Connection conn = null; ResultSet rs = null; Properties info = new Properties(); try { //Properties_Proxool.class.getResourceAsStream是读取Src下的文件信息 info.load(Properties_Proxool.class.getResourceAsStream("/proxool.properties")); //读取使用Java的特性文件编写的配置文件。 PropertyConfigurator.configure(info); } catch (IOException e) { e.printStackTrace(); }catch (ProxoolException e) { e.printStackTrace(); } try { //加载驱动包 Class.forName("org.logicalcobwebs.proxool.ProxoolDriver"); conn = DriverManager.getConnection("proxool.property-test"); 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(); } }}
记住使用properties配置,必须新建properties文件,同时放在准确的地方,这里是放在Src下,同时代码也是通过Src去找这个文件
jdbc-0.proxool.alias=property-testjdbc-0.proxool.driver-url=jdbc:hsqldb:hsql://localhost/jdbc-0.proxool.driver-class=org.hsqldb.jdbc.JDBCDriverjdbc-0.user=sajdbc-0.password=jdbc-0.proxool.maximum-connection-count=10jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
eclipse连接hsqldb数据库,使用XML文件配置
package com.proxool;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.io.FileInputStream;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 org.logicalcobwebs.proxool.ProxoolException;import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;import org.logicalcobwebs.proxool.configuration.PropertyConfigurator;//使用新建xml编写配置public class XmlProxool { public static void main(String[] args) { Connection conn = null; ResultSet rs = null; Statement stmt; try { Class.forName("org.logicalcobwebs.proxool.ProxoolDriver"); try { //InputStreamReader 实例一个读取流 //XmlProxool.class.getResourceAsStream 读取的是src下的文件 //使用XML配置,解析的时候就是用 JAXPConfigurator.configure()解析 //使用Properties配置,解析的时候用 PropertyConfigurator.configure() JAXPConfigurator.configure(new InputStreamReader(XmlProxool.class.getResourceAsStream("/proxool.xml")),false); try { conn = DriverManager.getConnection("proxool.xml-test"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } catch (ProxoolException 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) { // TODO Auto-generated catch block e.printStackTrace(); } } catch (ClassNotFoundException e1) { e1.printStackTrace(); } } }
同上,这里也是放在Src文件下,代码也是通过Src去找XML文件
<proxool-config> <proxool> <alias>xml-test</alias> <driver-url>jdbc:hsqldb:hsql://localhost/</driver-url> <driver-class>org.hsqldb.jdbc.JDBCDriver</driver-class> <!-- <statistics>1m,15m,1d</statistics> --> <driver-properties> <property name="user" value="http://www.mamicode.com/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.XmlProxool;@WebServlet("/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.xml-test"); } 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); }}
2、通过配置Web.xml
<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1"> <display-name>test_hsqldb</display-name> <welcome-file-list> <welcome-file>index.html</welcome-file> <welcome-file>index.htm</welcome-file> <welcome-file>index.jsp</welcome-file> <welcome-file>default.html</welcome-file> <welcome-file>default.htm</welcome-file> <welcome-file>default.jsp</welcome-file> </welcome-file-list> <servlet> <servlet-name>proxool</servlet-name> <!--这是proxool自带的Servlet类 --> <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class> </servlet><servlet-mapping> <servlet-name>proxool</servlet-name> <!--通过访问admin,访问AdminServlet --> <url-pattern>/admin</url-pattern></servlet-mapping><servlet> <servlet-name>ServletConfigurator</servlet-name> <!--解析xml信息 --> <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class> <init-param> <param-name>xmlFile</param-name> <param-value>WEB-INF/proxool.xml</param-value> </init-param> <load-on-startup>1</load-on-startup></servlet> <servlet> <servlet-name>A</servlet-name> <servlet-class>com.proxool.servlet.helloproxool</servlet-class> </servlet> <servlet-mapping> <servlet-name>A</servlet-name> <url-pattern>*.j12</url-pattern> </servlet-mapping></web-app>
3、访问:http://localhost:8080/test_hsqldb/admin.j12,他会先去启动hsqldb数据库
访问http://localhost:8080/test_hsqldb/admin,会出现以下这个,就是可以的!
proxool+hsqldb