</p> 2、写测试类
* n7 e5 h4 k, {+ l7 Z3 y import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;
, R, {8 s8 v7 H) t' D& A import java.sql.Connection;" N) Y9 F. p* [& d
import java.sql.DriverManager;& h3 A# y% _" k/ C) B
import java.sql.ResultSet;- e, x3 e; d: b$ Z
import java.sql.Statement;
+ W: `4 n; [3 H' a+ { /**
0 S& [5 h3 o( k * Created by IntelliJ IDEA.
8 Y$ o2 _2 N) |- h: y public class TestProxool {
$ C' i9 ] ~" S$ F1 e public static String dburl = "jdbc:oracle:thin:@192.168.104.192:1521:tim";( v- S, P- W, h3 u$ v9 Z( A/ s" l
public static String user = "tim";
, X4 [9 d% b U4 x public static String password = "tim_8968888";8 g" C6 H: I$ G# k3 U
/**
0 I5 O" t- |; b( {, C$ Q/ u * JDBC体例测试9 D! V4 W5 I6 w0 F
*& N( U5 L6 k9 F. J' D
* @throws Exception
6 U S/ X8 ^5 G$ P" H */
8 k4 s& g& i3 ~- v- G% J! }; O public static void test1() throws Exception {, d Z' Q! ^9 X) R/ H7 S" y
String testsql = "select * from village t where lastid = 346";* u7 j4 u, D6 m9 F+ G" X8 J
//1:注册驱动类( b1 U0 ~6 P: t( G
Class.forName("oracle.jdbc.driver.OracleDriver");
0 R4 } H4 c' b //2:建树数据库毗连8 B, [4 [: k7 @& t9 D& y' y9 W d+ T
Connection conn = DriverManager.getConnection(dburl, user, password);
9 L, ^5 o9 m! }6 ^: l- g //3:建树执行SQL的对象
" x# h; B$ ?1 p0 e Statement stmt = conn.createStatement();3 A l9 u6 c! h6 q- B; |- W/ r1 z- ~
//4:执行SQL,并获取返回结不美观/ ]; f2 G% ?8 l( K+ @
ResultSet rs = stmt.executeQuery(testsql);& m2 D, F. E1 `
//5:措置返回结不美观,此处打印发芽结不美观. C) u* G% ]2 R
while (rs.next()) {
5 T! s6 N) U2 _2 w" ^/ F" M/ H System.out.print(rs.getLong("id") + "t");+ W! @; ^; d) I6 I* K
System.out.print(rs.getString("name") + "t");
+ |. u5 N- O$ d& I System.out.println();
- _$ J, b' b# f0 d" q {0 | }2 M; G" d3 y9 Q6 N' e
W; ]! P7 Y" I$ E) s //6:封锁数据库毗连
- B3 Y9 v3 i/ O% o conn.close();
% ?1 v7 u& }3 K4 e$ W2 L. S+ S2 G9 b }1 @2 c1 ~6 a) H3 |
/**
& a! T3 z7 _. ?$ N A * proxool体例测试
6 O" T. l6 R0 C1 t" m3 l5 E7 U *
/ x& i; h A7 a9 r' \6 K. f1 l * @throws Exception5 x" f$ {- R. a0 `/ c. _
*/
) p& r, J) r; i. z public static void test2() throws Exception {
4 L" ^3 O" q3 F* H$ E* h* J //Java应用中先要加载设置装备摆设文件,否则谁知道你设置装备摆设给谁用的
0 o& ^2 e. W! r, Y JAXPConfigurator.configure("F:\_test\synorg\src\proxool.xml", false);
! o& [* d8 ~; D* q7 m String testsql = "select * from village t where lastid = 346";2 z' n1 @" W& t* w `: P+ P
//1:注册驱动类,此次这个驱动已经不是Oracle的驱动了,是Proxool专用的驱动2 L# _. r2 j4 g
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
4 {5 r5 @+ b, f7 V //2:建树数据库毗连,这个参数是一个字符串,是数据源的别号,在设置装备摆设文件中设置装备摆设的timalias,参数名目为:proxool.数据源的别号
4 m9 ]1 e7 E3 I& v* \* ^9 P Connection conn = DriverManager.getConnection("proxool.timalias");
0 J, |, T. [+ g4 `# ? //3:建树执行SQL的对象0 p* T/ U$ @+ P/ a
Statement stmt = conn.createStatement();6 a- h0 h6 C! w" v9 I
//4:执行SQL,并获取返回结不美观3 ^2 B/ K1 i% F
ResultSet rs = stmt.executeQuery(testsql);/ R i+ f1 |! Y% C) L, I
//5:措置返回结不美观,此处打印发芽结不美观
6 S, [( H6 w' D1 C5 ^5 m- T while (rs.next()) {8 f' o& J. J* n
System.out.print(rs.getLong("id") + "t");
7 R3 n( ]* U1 B9 r3 x System.out.print(rs.getString("name") + "t");
) o, c# f1 X* v/ Y9 ^4 c System.out.println();
) [8 H& ^; w' K2 F. e- c ~ }7 \4 `- q2 ]6 y" ]( h
//6:封锁数据库毗连
7 C1 L- r1 q) A$ n1 J ] conn.close();
3 m4 \ D; x% Z$ {5 B6 i }
8 B1 `6 V; y7 r7 p public static void main(String[] args) throws Exception {
" Q A" n8 y+ i5 q$ k- |3 f test2();
( G M$ f; N8 S. F4 b }' L. r# r# D/ e/ A }) V
} |