package stuman;! G7 Y* e# }. [" Z
import java.io.*;
3 h2 [8 M. r8 Z3 L+ R! I# j% @import java.sql.*; 2 Y* R" Z- D% K! |7 [
public class sqlBean{/// " e# W: K5 y l9 s* Z/ S
8 h2 q, V* W8 ^, [8 gpublic Connection conn=null;
6 v% V3 D: s( X' _, @7 |& ]7 _- A8 J% z( R h: r. `7 v; s
public ResultSet rs=null; ! w! A$ a) U3 U7 H& s: G; ~
+ d4 g! U) y( B2 Q1 z+ r
private String DatabaseDriver="oracle.jdbc.driver.OracleDriver"; 5 I& `' j4 \& X' W6 E5 h
9 i4 D8 J- j- _% U) _+ [( l# Q
private String DatabaseConnStr="jdbc racle:thin 192.168.0.26:1521 rcl,'scott',tiger";
3 \% }( _2 Y5 ?- spublic void setDatabaseDriver(String Driver){
; {% T8 M4 l( C* F0 Zthis.DatabaseDriver=Driver;
; Z+ M# ^$ Q7 U8 ?) i" p} X/ t: l5 P% W4 r
public String getDatabaseDriver(){ 9 R( N+ @" P0 T3 A% b/ M
return (this.DatabaseDriver);
" j3 l/ |9 z* G}
8 y! y, o& t+ _: m G/ G, U7 W( {! X' U0 h: l
public void setDatabaseConnStr(String ConnStr){ + t$ ^+ K6 S4 k9 F' n
this.DatabaseConnStr=ConnStr; * C# X' D+ E3 _" @5 `2 g
}
4 n( p3 C3 L. j2 ?2 lpublic String getDatabaseConnStr(){
9 S3 i. f4 z8 d$ u; N Lreturn (this.DatabaseConnStr);
7 U) B. Q/ a9 Q4 ?) u3 e* R} 2 [; s r/ y7 U) n
& ^: C9 X! j0 Rpublic sqlBean(){/////构造函数 " U w7 v, _5 X" ]4 y' }- S
try{ ' e1 I% J3 `. r$ |2 P/ Z6 q, ^
; m8 g; @& q9 C) j& _" b
8 T3 p/ g( s5 r4 Y2 aClass.forName(DatabaseDriver);
8 B$ n* v8 X- b; G& o: J; Z} + z& a2 ?7 p' I8 l: c# U9 t
catch(java.lang.ClassNotFoundException e){
+ R3 C. P0 |/ [. C! hSystem.err.println("加载驱动器有错误:"+e.getMessage( ));
% `3 D: N; I5 M9 mSystem.out.print("执行插入有错误:"+e.getMessage());//输出到客户端 7 p# E* ? b( ?# C
}
6 \1 o2 j4 X6 Z; H} 8 y4 B: R6 A4 p" g; G, Y
. f+ b7 v) r6 I( u! \! i
; Z: q ^. F+ d, t! r: `% Tpublic int executeInsert(String sql){
6 [2 u- C- a) O+ s" k5 M3 S5 mint num=0;
+ [0 H) D7 G& d* N9 t% j- @try{ j9 |; B3 c' x1 T( @
Connection conn = DriverManager.getConnection("jdbc racle:thin 192.168.0.26:1521 rcl", "scott", "tiger");) M$ z; A. g x4 I7 m
//conn = DriverManager.getConnection(strcon,"scott","tiger");/ l- G! X/ u, a' v" f' P
3 M1 E. _5 N* D, D: FStatement stmt=conn.createStatement( );
( a* a: c* y1 A# j# Inum=stmt.executeUpdate(sql);
% G6 f) c; H6 }} s9 Q: G6 C+ M7 i# W. l: F
catch(SQLException ex){
- z- u/ M8 }- G+ ASystem.err.println("执行插入有错误:"+ex.getMessage() );
2 z1 O: V: n- N3 [7 LSystem.out.print("执行插入有错误:"+ex.getMessage());//输出到客户端
: w+ Q" I; q. N}
2 t, w" S4 Z6 l' T9 x# j$ N7 B# o! u1 e" E
CloseDataBase();" v/ |( W K$ A& c5 ^$ P* y' K9 ^+ n/ X
return num;* n9 a( w3 j# j! E! Q8 }2 c0 C
} - N3 O8 `9 h, C# {
" L" G' g5 n1 y3 o+ Ipublic ResultSet executeQuery(String sql){
9 c0 k* X- }0 _rs=null;
3 H7 X. O) A8 B7 [try{ ! |8 f7 J; ^' Q* [( }4 R, a
//conn = DriverManager.getConnection("jdbc dbc:ClassDB","limq","123");+ q% F" _9 ^( `) ^) L
Connection conn=DriverManager.getConnection("jdbc racle:thin 192.168.0.26:1521 rcl", "scott", "tiger");
1 `, K3 r& t- m \
' d* \) M8 w3 }4 pStatement stmt=conn.createStatement( );
8 v' F& Y% m0 lrs=stmt.executeQuery(sql);4 b3 R* E* s$ w
} 9 S7 |/ I2 @, o: f7 f( \2 d) {
catch(SQLException ex){
) i0 W# w6 t* `5 TSystem.err.println("执行查询有错误:"+ex.getMessage() );
) _8 b2 y) P3 U/ KSystem.out.print("执行查询有错误:"+ex.getMessage()); //输出到客户端 / N- a0 _4 O2 Y. A" b) f: _- Q
}
, b( [9 `% S; v0 w: \4 s
- c8 h! M Q2 T3 {" ireturn rs;
% c9 Z' {/ G2 ^# e. b, [% A}
5 t# m6 e6 |6 L) w* \" t) H: w. G& G// delete data
3 `; @) Q& N' L* a/ F2 Upublic int executeDelete(String sql){
/ T- k- I. p6 Fint num=0;) |5 i0 D1 m4 h1 h; V& i6 h
try{ 0 y. S: l, A# a; Q J+ r
1 ]5 P8 ~( ]$ n6 B
//conn = DriverManager.getConnection("jdbc dbc:ClassDB","limq","123");; l" _: f; v8 O7 d
Connection conn=DriverManager.getConnection("jdbc racle:thin 192.168.0.26:1521 rcl", "scott", "tiger");1 e4 A n3 B/ S% y# G
2 e# ^% `8 r h O* t0 E- L* {Statement stmt=conn.createStatement( );
1 s) {. \+ C3 Y" m" K+ v8 l9 ?8 Xnum=stmt.executeUpdate(sql);
8 s P! e% B8 E% M- O6 r} & @' ]4 i5 M0 W& F5 j3 u8 `* k1 x
catch(SQLException ex){
7 ~( z4 B$ c5 c( W1 D/ L# OSystem.err.println("执行删除有错误:"+ex.getMessage() ); ' _8 }/ Z8 a7 H7 v; P
System.out.print("执行删除有错误:"+ex.getMessage()); //输出到客户端 ' D* f; \6 C( ^$ W7 S1 N
} $ \, ]& L. s/ Q) Y8 B( r
CloseDataBase();
5 a. C: W8 g$ D6 F ^return num;; `1 i: c2 E, i
} 4 C4 N Q5 J0 S8 S# V7 i) r$ G
public void CloseDataBase(){
9 d+ ~2 g0 `" F) r' L8 C( t7 Itry{
" k# A) q/ K" w# g4 S. {- iconn.close(); 9 J6 E% C( V% G, `6 C9 d& n
} # q& e& \- q0 o s! n. |
catch(Exception end){ ; H+ \$ Y+ t F* d. F% I+ L ?
System.err.println("执行关闭Connection对象有错误:"+end.getMessage( ) );
" j5 c6 k( d( VSystem.out.print("执行执行关闭Connection对象有错误:有错误:"+end.getMessage()); //输出到客户端 f& F8 f0 N/ o. K
}
/ P0 ~7 l8 K0 n* R} ) N1 T6 ^4 d0 ]) v, U2 n- c
}
) {- U: I% m9 N+ {/ F9 K, D连接的代码这是。。 |