package stuman;; g" K/ f$ }2 h$ h' m& L
import java.io.*;
# W' S5 W% o: r c9 J, n, fimport java.sql.*; 0 T) N9 P7 z$ |' w( t
public class sqlBean{///
) r: G6 L0 _7 z/ [" b; Z0 G, i! x8 G+ d% w
public Connection conn=null; , j1 M# b2 m1 ^ G9 _9 `! g& W
4 U& i% s+ c1 M4 C& J* [) Upublic ResultSet rs=null; - E2 F5 p9 w. f9 X0 M" k" U6 z3 p
: d o! k% ]2 aprivate String DatabaseDriver="oracle.jdbc.driver.OracleDriver"; ! x0 U7 m. v5 ]
) ?5 { g M" m7 w' F/ g6 @
private String DatabaseConnStr="jdbc racle:thin 192.168.0.26:1521 rcl,'scott',tiger";% v6 _+ g- c6 E
public void setDatabaseDriver(String Driver){
$ Q& [ _9 R* t9 Wthis.DatabaseDriver=Driver; ' K& P& W1 w( r; ^' W; ]2 o% s
} - m6 b+ H) J& e/ D% m) Y
public String getDatabaseDriver(){
( E- d3 G4 Z$ g. O+ treturn (this.DatabaseDriver);
6 i4 [6 E+ M( ^" Y}
& B C0 n ?& _# R$ }; |6 ?
% z- Z5 F) z9 J3 G8 I4 Lpublic void setDatabaseConnStr(String ConnStr){
/ o& e) W) f; U" f, dthis.DatabaseConnStr=ConnStr;
+ F+ J. z1 K3 G}
$ h! `7 t5 z5 Y" K, \public String getDatabaseConnStr(){ $ S/ x7 r2 j% C+ k6 I1 b
return (this.DatabaseConnStr); 7 P+ b, x# l* b1 U' H. W( m3 n
} : ^1 R0 x; h* L4 C
2 e5 G: E' o, [# n% |! i" Y7 w) mpublic sqlBean(){/////构造函数 ! ~# {' S% M0 M2 r4 ~
try{
; `4 N( H9 H3 F1 n7 l; [8 R7 \4 E6 A
0 E8 u. X0 \' z
0 b1 i6 x' x& k i* T" VClass.forName(DatabaseDriver); % o5 Q6 J$ E8 Y5 o* s! f5 h
}
" z/ S2 q( F6 i/ T% scatch(java.lang.ClassNotFoundException e){
, g# Z: y k# c) ?System.err.println("加载驱动器有错误:"+e.getMessage( ));
, c% G" {# A. ^+ F6 ~4 _' C9 qSystem.out.print("执行插入有错误:"+e.getMessage());//输出到客户端 0 m8 U' q1 t }" I! f
} ' I$ g, B {# k/ d; X( ]* r
}
; ?8 ?+ ]/ E" ~: j8 @! H8 l0 C% h" i. Q% h# R- q4 t
( l# F. k! D# @
public int executeInsert(String sql){ * T$ G' H# E) X2 I5 U5 s: g& i
int num=0;
3 R6 M. U( o/ T$ S7 qtry{ 7 A; X2 x* } H6 D# l, Z4 w
Connection conn = DriverManager.getConnection("jdbc racle:thin 192.168.0.26:1521 rcl", "scott", "tiger");* v, v! h# g+ w- F: q3 D
//conn = DriverManager.getConnection(strcon,"scott","tiger");* Y1 t/ s! \% ] J
4 {2 o3 b7 w3 V* H' {
Statement stmt=conn.createStatement( ); + H" n& S z9 F" p6 E6 |/ [
num=stmt.executeUpdate(sql);
+ y) H6 u1 y j& W5 j6 Z$ l} ! v2 N0 n; ^- ?# v! L
catch(SQLException ex){ 6 Y8 \4 b+ B' T9 Z2 d
System.err.println("执行插入有错误:"+ex.getMessage() ); 6 R; ~3 s: Q5 \. Z! t& {
System.out.print("执行插入有错误:"+ex.getMessage());//输出到客户端 2 a5 U" {& ?; M2 K7 I, u& @
}* _& {+ H I- [% o1 M2 @5 b
1 S4 I% L* l/ J- i8 WCloseDataBase(); d. T. e0 k3 n" _2 {
return num;. a8 v6 o8 F6 I, J+ B
}
' q' Y& R. T. k: a& E% m- ?9 h$ K
0 y4 E2 v+ G1 a- I6 Fpublic ResultSet executeQuery(String sql){
2 S/ M) H3 R/ }9 A( W. ?, n! i0 m2 Yrs=null;
5 P9 P; m; I* E: ~# {$ o) ctry{ 5 H2 w; _( ]; n( \7 Z" f8 \$ H' D
//conn = DriverManager.getConnection("jdbc dbc:ClassDB","limq","123");
1 A/ T6 ] y! ^. s! k& @Connection conn=DriverManager.getConnection("jdbc racle:thin 192.168.0.26:1521 rcl", "scott", "tiger");4 x ^2 r/ I2 x9 R( J% U7 a
4 u3 }& G6 K' E9 m5 s* x# o+ T
Statement stmt=conn.createStatement( ); " {7 D+ v% `. f+ u- p
rs=stmt.executeQuery(sql);& Z7 B* z S1 q( w }
} / V, G3 Z$ O5 G* Z6 \
catch(SQLException ex){
# O1 }' @& ?/ N3 N2 `' ?System.err.println("执行查询有错误:"+ex.getMessage() ); * p n) ^+ o' ]/ E3 \; v. X
System.out.print("执行查询有错误:"+ex.getMessage()); //输出到客户端 / `1 A: @$ f' b- z
} 1 G0 m' N7 R/ T5 d( G
0 ^5 Y6 ]- V1 }8 T& V, K9 ureturn rs;
! J- x2 u5 p. p0 a' w9 N+ U} ; }* v2 E! y/ {$ D
// delete data / q& z# _+ N0 `' d* ~' }
public int executeDelete(String sql){
, O2 m2 G/ J! [8 \8 u8 H6 s Vint num=0;& z z _" e" T
try{ , {0 L V* u5 L3 f
+ z A( N( Z$ u D
//conn = DriverManager.getConnection("jdbc dbc:ClassDB","limq","123");9 i e2 z& F1 n4 [
Connection conn=DriverManager.getConnection("jdbc racle:thin 192.168.0.26:1521 rcl", "scott", "tiger");: G/ ?0 I2 x- A' {5 k, n
# X7 F, \2 m* x0 zStatement stmt=conn.createStatement( ); , J- m2 V2 E# K& m* @
num=stmt.executeUpdate(sql);
( V" h: A' g5 e. y& W- {3 c}
( d* t, A. C8 G' Ccatch(SQLException ex){
# l- Z. Y9 j% V- ?4 CSystem.err.println("执行删除有错误:"+ex.getMessage() ); # D. `6 N5 @' f) L
System.out.print("执行删除有错误:"+ex.getMessage()); //输出到客户端
# i9 \' R" g* ]. W: f- L$ K- {}
( ]4 g; s5 `0 D" K/ ACloseDataBase();, C( T7 Q5 C& L! M$ ^3 m. }2 V
return num;
6 j& I2 e+ w2 j+ q0 N% S( d}
% S" z, H: V2 Zpublic void CloseDataBase(){ ( Q& m' H' D4 W0 Y
try{ - ?+ H7 Q, |) D
conn.close(); 8 b6 |0 W- }3 [$ e4 {3 e) H! D6 L
} " l6 X x9 f. ?7 }$ V8 `
catch(Exception end){ 9 J- f0 c4 l4 K6 o1 t
System.err.println("执行关闭Connection对象有错误:"+end.getMessage( ) ); 2 a, j/ w! Z6 [# V* s
System.out.print("执行执行关闭Connection对象有错误:有错误:"+end.getMessage()); //输出到客户端 3 H$ z( ^6 F5 f- [, k5 |1 u
}
1 f$ y; L. }5 K n" v- }# |} $ F/ h3 @( p. z3 O3 D9 R: g2 U
}
8 C/ B0 P( K' J连接的代码这是。。 |