package stuman;
0 W. v2 F3 c+ _, g! Nimport java.io.*;
. y' y' g8 g. X2 r& [5 kimport java.sql.*; , K- F3 p9 q/ D; V
public class sqlBean{///
" U( U$ `, S2 H( c$ T$ y+ T2 s: b8 D, b) a
public Connection conn=null; : c; X0 E, n* d8 P. i6 u" B/ ]0 f
9 z ~$ `2 x, Q4 T5 u, e) q
public ResultSet rs=null; 8 n6 G& D( B/ G( v0 _* H
/ C ]2 T" Q! U% m2 X& d9 N4 ~; Y8 y' E
private String DatabaseDriver="oracle.jdbc.driver.OracleDriver"; a0 B& P: ~% u7 U/ B8 v
* I0 W$ @. _( b$ p/ `% X+ wprivate String DatabaseConnStr="jdbc racle:thin 192.168.0.26:1521 rcl,'scott',tiger"; c1 C7 V3 c" r
public void setDatabaseDriver(String Driver){ + J! m" K2 a% G% g y0 v, U$ n
this.DatabaseDriver=Driver;
! h" c$ y0 T0 x4 L3 S' y}
% F. B5 q# ~( v; l- k( s- O7 rpublic String getDatabaseDriver(){ ' y2 x! E- t" |! I
return (this.DatabaseDriver);
8 t, T) [5 L" @5 D}
: ^& Q6 I$ t$ i
1 V2 g3 k0 n+ y' A) C: `9 H6 P. {public void setDatabaseConnStr(String ConnStr){ 3 ?) Y: j; F; S2 H. l* s) `
this.DatabaseConnStr=ConnStr;
6 t/ f# T: `- v; q2 b( t4 X" m} . ?* l7 s* l% ]; H) h4 N
public String getDatabaseConnStr(){ * e" e! y0 l. h# n
return (this.DatabaseConnStr); # u1 {* w1 n4 U+ ^, |- b7 {
}
2 i" p% ]5 [; w$ j2 V
5 K+ C: v8 n2 v9 u, `3 y8 p$ kpublic sqlBean(){/////构造函数 1 m9 Y1 @7 I" D! a
try{ & D( j6 Z) |8 L! k2 ^) ?
6 H* w9 u5 u, j5 L8 D( y( Z% O4 O- b. `6 ~
Class.forName(DatabaseDriver);
6 S) q+ O3 D9 B" Z- h) d. d; L} / [ k% D& \- G: m
catch(java.lang.ClassNotFoundException e){
! y/ J6 V$ q# n, J3 HSystem.err.println("加载驱动器有错误:"+e.getMessage( )); : u: M) ~" C5 D# x8 w) z2 V, E
System.out.print("执行插入有错误:"+e.getMessage());//输出到客户端 8 N8 ?4 P) W- F4 R8 C5 E3 H
}
& W" U9 h4 I3 m5 Y2 b# F}
: J" {( V# H# b) @
" ~! b- R1 k! c* f0 Z- u+ ^ ( u0 E5 X- m2 S$ T/ d/ h" m/ g
public int executeInsert(String sql){ - M# _7 e9 d# `! x/ d% l
int num=0;
+ I& U$ P4 G0 T! {6 ?2 L: x! E5 ?try{ $ V2 U4 g! \- D W
Connection conn = DriverManager.getConnection("jdbc racle:thin 192.168.0.26:1521 rcl", "scott", "tiger"); ]4 T/ q1 b8 ]* \) q
//conn = DriverManager.getConnection(strcon,"scott","tiger");9 o' Z0 ` n; s1 G/ C4 w
. j! k% W0 r( B
Statement stmt=conn.createStatement( );
& ?. [$ P8 ]/ U+ Y! lnum=stmt.executeUpdate(sql);
- P+ b4 T; `* I: ?4 W/ H8 L- `* l) o! [} E* p; P$ |+ W3 X2 T
catch(SQLException ex){
6 A7 l |# d; o( L2 @7 sSystem.err.println("执行插入有错误:"+ex.getMessage() );
9 F9 q/ R+ F/ D, x1 mSystem.out.print("执行插入有错误:"+ex.getMessage());//输出到客户端
+ z: ~& t: g7 `: d8 c}" n* V) x( {/ H7 e1 l
& V3 @# p/ W8 ~2 O7 X0 @# ~7 VCloseDataBase();: C* o6 @$ L1 i8 O# O
return num;
5 j8 f6 r, E: V: K* i} " F: v9 Y6 I3 E% p
+ t7 C5 K/ U1 E0 Q, X" i
public ResultSet executeQuery(String sql){ ' Y9 W# _. e7 f9 o( M: S* A0 U2 ?
rs=null;
9 l) O% X# B5 Y& W/ i2 }, Ctry{
( r1 i) K6 ^* d9 D, E+ S7 S/ Q2 j; t//conn = DriverManager.getConnection("jdbc dbc:ClassDB","limq","123");% d% w3 R0 p. K
Connection conn=DriverManager.getConnection("jdbc racle:thin 192.168.0.26:1521 rcl", "scott", "tiger");+ A, _ \. u# m/ H
- h. w7 n2 b( i
Statement stmt=conn.createStatement( );
# x* V4 X3 S1 M; t4 n1 ?rs=stmt.executeQuery(sql);
, q I0 @' t( p3 a8 V+ F} 9 ]+ e7 Z! R- U4 ] ~3 O- Z
catch(SQLException ex){
4 H5 ~' w; _1 y% E. pSystem.err.println("执行查询有错误:"+ex.getMessage() ); ' J- Y4 |& y* {0 Q. e6 R" s w
System.out.print("执行查询有错误:"+ex.getMessage()); //输出到客户端
. T# f0 n1 d; B' D1 L}
7 M- T! [. u$ E: Q4 e' h% W$ E5 q6 p+ x: r" }, A6 A3 b) @
return rs;
6 k( J. d9 V1 b- t8 e5 R} / y4 v$ L6 P( T! N3 n0 ^+ A9 ~9 ~! q
// delete data ) F6 X0 @8 T, Q O6 F
public int executeDelete(String sql){
% [. K; I9 h6 V$ Z5 s2 T Qint num=0;0 {: K& K; B/ _5 \0 P) E0 n
try{ $ u" x P6 t% g" a: J. Q
: k! q9 o/ ^( T- j2 G
//conn = DriverManager.getConnection("jdbc dbc:ClassDB","limq","123");
6 {# f6 U$ q4 r: X8 ^% g8 @- Z* RConnection conn=DriverManager.getConnection("jdbc racle:thin 192.168.0.26:1521 rcl", "scott", "tiger");
1 [1 k8 C$ V, I4 }1 k1 I4 D2 g* @& J$ u- E( h- S! v
Statement stmt=conn.createStatement( );
6 X( ^, ~& K" g& @- F$ g4 {num=stmt.executeUpdate(sql); ( R; q( n7 o6 W3 j/ E- i3 S
} % g* W9 \, ^& |( F
catch(SQLException ex){
. Z G: K5 j. T7 n& }% U, r, @System.err.println("执行删除有错误:"+ex.getMessage() ); # n& H0 |6 J6 N o2 {# l
System.out.print("执行删除有错误:"+ex.getMessage()); //输出到客户端
$ A" g8 e# J& W( W} & E( {- z! s) x! {0 V( |) K0 a) `9 l, Z
CloseDataBase();
6 f$ k/ X1 X6 { B+ O) oreturn num;
) Q/ n/ P( S* @# {0 I5 b} ; \3 u0 Z' Y4 j( N
public void CloseDataBase(){
' F1 _' ?. F+ `: s' Y. @1 N% n% atry{
, O4 R5 L; m+ t& \* N! Z! aconn.close();
) l, U# D" ~6 b$ K}
/ O( O# e& z2 Jcatch(Exception end){ 8 b Q8 d- V$ W1 n Z5 I! V( }
System.err.println("执行关闭Connection对象有错误:"+end.getMessage( ) );
$ _* N2 a$ F5 Y$ K, j+ I9 zSystem.out.print("执行执行关闭Connection对象有错误:有错误:"+end.getMessage()); //输出到客户端
* ~% k) m& c7 O. l7 f. S5 H} + F1 k0 a1 F; [- l
} + C# M% c$ Z$ S0 I
} % n. G I2 { V5 v
连接的代码这是。。 |