proxool mysql 乱码_Proxool来连接mysql介绍

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;

public class TestProxool {

public static String dburl = "jdbc:mysql://localhost:3306/dma";

public static String user = "root";

public static String password = "888888";

public static void test1() throws Exception {

String testsql = "select * from user where userID = 13";

//1：注册驱动类

Class.forName("com.mysql.jdbc.Driver");

//2：创建数据库连接

Connection conn = DriverManager.getConnection(dburl, user, password);

//3：创建执行SQL的对象

Statement stmt = conn.createStatement();

//4：执行SQL，并获取返回结果

ResultSet rs = stmt.executeQuery(testsql);

//5：处理返回结果，此处打印查询结果

while (rs.next()) {

System.out.print(rs.getInt("userID") + "/t");

System.out.print(rs.getString("sourceIP") + "/t");

System.out.println();

}

//6：关闭数据库连接

conn.close();

}

/**

* proxool方式测试

*

* @throws Exception

*/

public static void test2() throws Exception {

//加载配置文件,配置文件可以是相对路径，也可以是绝对路径

JAXPConfigurator.configure("proxool.xml", false);

// System.out.println("You have already load the xml file");

String testsql = "select * from user where userID = 13";

//1：注册驱动类，是Proxool专用的驱动

Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");

//2：创建数据库连接，这个参数是一个字符串，是数据源的别名，在配置文件中配置的dma，参数格式为：proxool.数据源的别名

Connection conn = DriverManager.getConnection("proxool.dma");

//3：创建执行SQL的对象

Statement stmt = conn.createStatement();

//4：执行SQL，并获取返回结果

ResultSet rs = stmt.executeQuery(testsql);

//5：处理返回结果，此处打印查询结果

while (rs.next()) {

System.out.print(rs.getLong("userID") + "/t");

System.out.print(rs.getString("sourceIP") + "/t");

System.out.println();

}

//6：关闭数据库连接

conn.close();

}

public static void main(String[] args) throws Exception {

// TODO Auto-generated method stub

test1();

test2();

}

}