package stuman;
/ i# O/ [) k v- }2 e; _% @import java.io.*; # e$ U* J' z% Q y# U, H: r
import java.sql.*;
4 O' j6 @) q8 {8 @# K2 Gpublic class sqlBean{/// 1 z0 w! C. P4 s/ s9 D: `
5 `" m: _ ]6 |$ q, cpublic Connection conn=null; , S2 H& R+ L, ^
- m) n( D# x; y5 `2 Xpublic ResultSet rs=null;
6 U1 D- n3 f' c& T$ p& r
; W5 i/ C4 I7 D1 k3 @private String DatabaseDriver="oracle.jdbc.driver.OracleDriver"; @! `! C X: v/ p8 o" E
$ m' ?+ }' b5 ?. g& v& \
private String DatabaseConnStr="jdbc racle:thin 192.168.0.26:1521 rcl,'scott',tiger";
2 Z; ?7 k S. n% Mpublic void setDatabaseDriver(String Driver){
- R3 P4 E3 c O( I+ Z- S$ Ithis.DatabaseDriver=Driver;
4 p8 m) ^7 \, v+ \7 R} 9 g f) T4 G+ z: O& g1 x; J
public String getDatabaseDriver(){
+ y6 I& R: u" v. O4 {return (this.DatabaseDriver); 3 i# C. T) {; p2 f: U( b/ S
}
! w- i6 G+ N- a- }6 r& J& K7 ^8 Q2 R* x8 }0 m/ ?3 w
public void setDatabaseConnStr(String ConnStr){
! C0 v. ^2 K" o2 ~this.DatabaseConnStr=ConnStr; ! R; y& G" Y6 j6 `
} 9 A$ Q: \0 i4 F" u4 e2 H. P. q
public String getDatabaseConnStr(){
6 s9 v0 h/ i# x% x/ h& A1 rreturn (this.DatabaseConnStr); 7 d9 t' u/ C* M8 T4 U1 h) s6 |' R
}
9 g8 E& t2 f' C( f/ X3 f8 W9 w9 V* P' J4 K; K w
public sqlBean(){/////构造函数
+ _ m& A c, v+ x9 x6 ytry{ # q5 e+ F2 u" P: k( S" U
6 r4 z) ?2 r8 p/ l# \" U
' \; i; r! P6 V. Y( j8 cClass.forName(DatabaseDriver); 3 d4 ]9 a7 A* E8 H5 o
} 6 M; y- D- N; ]' v8 b' a2 P
catch(java.lang.ClassNotFoundException e){
9 Q L2 j4 ]9 ~) ~System.err.println("加载驱动器有错误:"+e.getMessage( )); ! \$ L% e# X% M- X6 `% z6 Y$ C% q
System.out.print("执行插入有错误:"+e.getMessage());//输出到客户端
) |1 n& x; B2 e& L; d( o} + R# s4 A1 b8 I- p! H4 @
}
' ~1 F, N3 k r
, H/ }! @5 l9 M; e! K( ^ $ m* l3 V! @8 D: P1 J' M0 i2 N
public int executeInsert(String sql){
5 Y% c3 q/ z, X/ Q0 S# gint num=0;
9 |; P- E1 n- b6 Etry{
1 |* B' A" L |' KConnection conn = DriverManager.getConnection("jdbc racle:thin 192.168.0.26:1521 rcl", "scott", "tiger");
% d5 e0 M: r& |. @/ x5 |0 V//conn = DriverManager.getConnection(strcon,"scott","tiger");8 w% Q) ~ W" R- z( k; P. d; V$ |5 V
" ^5 c9 w" W6 v' e: N0 d; n
Statement stmt=conn.createStatement( ); * x) J. p" X# S2 n. q& c
num=stmt.executeUpdate(sql);
9 m. k, D9 @6 Y. f5 Y" U* P} 2 l) m; w A# B# b' L
catch(SQLException ex){
& n" t; c1 J1 oSystem.err.println("执行插入有错误:"+ex.getMessage() ); 0 N7 Z9 h0 R8 l) U# `
System.out.print("执行插入有错误:"+ex.getMessage());//输出到客户端 ' ~+ d* z1 f2 Q8 g5 \
}
9 [2 K1 ]( z1 [' P0 _5 E
$ M7 U% L ~0 K$ aCloseDataBase();
2 I9 Q. k) H" Nreturn num;
/ y# A, Z, B, M+ J7 M2 G- M}
$ N# T8 C6 ]3 Q, i4 y1 X/ C6 L: ~2 X
public ResultSet executeQuery(String sql){ 2 p1 Z) h" e, y) U# {! i
rs=null;
6 g# w: D; M+ v! I! B( stry{
) v1 k0 l6 G& a//conn = DriverManager.getConnection("jdbc dbc:ClassDB","limq","123");
4 p, M, T1 U6 ^' |/ n3 e* KConnection conn=DriverManager.getConnection("jdbc racle:thin 192.168.0.26:1521 rcl", "scott", "tiger");7 l: x2 S; a* y p+ ~; B+ N) b: i
9 }" R( }* c& K8 z Z9 y% J
Statement stmt=conn.createStatement( ); + D6 Q6 b: J. z& }6 T+ d" A! i
rs=stmt.executeQuery(sql);) F/ J7 L9 ?% T1 J0 V5 b4 y
}
. [1 Z2 y$ s" Z; B" ]9 dcatch(SQLException ex){ & T+ G# U/ b: L" M* w, S- v( D
System.err.println("执行查询有错误:"+ex.getMessage() ); 2 u6 x5 D; k4 V2 Z
System.out.print("执行查询有错误:"+ex.getMessage()); //输出到客户端
, ?& D* b4 K2 `; y6 ]}
' ^3 N* `( ~* h" p) n5 v% u8 @$ j& J- L* S
return rs; : r$ D0 I6 b6 \4 X! c( j
} , V0 R0 }- H( P( y- o. g
// delete data
# M$ q9 `$ P6 X \) opublic int executeDelete(String sql){ : z% n* {/ J1 y- Q/ C! o1 v1 W# ]( r
int num=0;
0 H r5 n( W* j9 W! ttry{
# p& E) i0 c9 }8 o' \! X8 r' _( H, q& I5 j' g5 l
//conn = DriverManager.getConnection("jdbc dbc:ClassDB","limq","123");' Y( B7 K: I: i6 c% L+ g9 F
Connection conn=DriverManager.getConnection("jdbc racle:thin 192.168.0.26:1521 rcl", "scott", "tiger");
9 h, K+ _8 `0 J! m/ G& P* S
! j5 M( o' ], e5 FStatement stmt=conn.createStatement( ); + u& n; L8 d- M3 s% W0 W
num=stmt.executeUpdate(sql);
1 H/ ?& E5 d! `} A# \( _% \/ ~& P9 u: r$ Q
catch(SQLException ex){
/ w& J* w3 s2 @$ b& |) f2 |System.err.println("执行删除有错误:"+ex.getMessage() ); 8 J( E6 w# @/ q) S2 p2 W
System.out.print("执行删除有错误:"+ex.getMessage()); //输出到客户端 1 a Z1 i5 ?$ [6 w/ B; n* S
}
& y0 g5 R3 m. CCloseDataBase();9 N4 J! @) \. e6 i7 w" x. t/ _
return num;
/ B! S& ^8 x9 U1 F( q! G}
; r" S/ Z' d* S" Q+ k" Upublic void CloseDataBase(){
1 g, W6 K/ K) P7 {try{
: E! J/ e9 c2 @5 Oconn.close();
/ m" `* ?* Z# Z0 {; d$ j% f1 p, K7 P}
) ~8 V, p) o$ Q+ `catch(Exception end){
) q1 _( G+ Q* c# P# ?) _System.err.println("执行关闭Connection对象有错误:"+end.getMessage( ) );
/ E0 }: g3 ?/ {2 k4 A* d a* Y6 Z ~System.out.print("执行执行关闭Connection对象有错误:有错误:"+end.getMessage()); //输出到客户端 : z1 X2 n! n3 e* [% |5 n
}
7 q, x0 f# W, h& g. J} / s9 U1 w2 n: J" {' h& x
} ( T- m& {9 n8 ^
连接的代码这是。。 |