该用户从未签到
|
- package s2.jsp.zhangxiao.dao;1 H/ {( D( p9 z+ b: v8 C* z* i
- import java.sql.PreparedStatement;
- ~( ^7 ^5 k8 V' D - import java.sql.ResultSet;
7 Z7 S+ R/ D; P, G @6 [ - import java.sql.Connection;
0 s+ X! [ V; d/ H - import java.sql.DriverManager;8 c5 a8 [0 a p B/ T0 m: U5 h9 D" ?
- import java.sql.SQLException;
1 Y3 C) h+ K U( T - import java.sql.SQLException;$ D3 ]6 E$ K& X0 {3 w! A- s" @
& z U" r# D! ^6 G4 \ O$ Q; q n
( O! H$ W( ^* Z; y5 G5 ^
0 ^% ^5 ?& T3 ]1 M2 O- /**0 y7 J1 k1 }: t
- * 连接数据库2 \! C7 M6 N* `0 d' }: [! c U
- * @author student1
$ `/ A( Z9 ]! `: D3 c* U, a N - *2 o, `! q# P0 B0 m I
- */
* c H8 P: b2 { - public class BookDao {: S7 B* p% n/ C: K8 Z2 u2 o8 S
- ( l/ z8 x1 T; K# O" A& y
- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";; s9 \9 a6 e* p& k0 ~6 h# F. i, ~
- private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";
7 }1 \6 `* `+ K9 A! w9 f& W - private static final String DBNAME="sa";8 E; Q- P+ G3 P6 d1 o
- private static final String DBPASS="1234"; G+ t& h) o+ p- z% e" y+ ~
- " v- m r9 L& Y2 Q
-
! L; c4 }; D) n& [2 V; [ - public Connection getConnection(){5 J$ r Y! Z+ k7 b# _, N; \1 d* r( D
- Connection con=null;
# o- Y1 |$ J* x3 m" S% u/ C# j - try {8 t+ x# D$ Z0 T# U
- Class.forName(DRIVER);
6 o: t' j# ?( q# F# w! O: ^ - con=DriverManager.getConnection(URL, DBNAME, DBPASS);
! ^) @. L+ z. j - } catch (ClassNotFoundException e) {
7 t2 d& d0 ~2 I4 Y3 \, ~ - // TODO Auto-generated catch block2 K7 `& K% u% H- f
- e.printStackTrace();- a( m& B; w, Y- H3 Y) P9 q7 u
- } catch (SQLException e) {/ {8 S0 R7 t1 P4 Z' ?. ^" Y
- // TODO Auto-generated catch block; _& D! E* O9 }0 l- G
- e.printStackTrace();
" f8 ]2 r; Q, h& D7 n% B: ^ - }. S$ M/ C4 d! K0 q& S
- $ H' j! _9 w. O5 a( `1 Z
- return con;
: f E2 G [+ S) M+ s k; b* ? - 9 c4 w+ w, | O" a% v5 _
- }) x7 Q7 f3 A( q# o
- public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){
: O7 w' C! T3 F) X3 X - try {# t1 M" u$ X7 k" i
- rs.close();# q" m( V5 `* A# Y2 j9 ~: D
- } catch (SQLException e) {
6 ?& J: r7 V( L$ N7 z - // TODO Auto-generated catch block
5 Q% H/ N( Z( _2 ?) y% N - e.printStackTrace();
& u' T8 D" v8 \, J' u3 y- n: c - }; j' |$ e9 E' ]9 ?
- try {. ^$ K9 h' a& T, v
- past.cancel();9 i @, v/ k0 R0 q
- } catch (SQLException e) {
* O/ c/ u/ d7 L' R0 @; ? - // TODO Auto-generated catch block
. G7 S' Y+ }- y# Z" i4 C - e.printStackTrace();
$ z# j/ \( f; e F2 T' P - }
2 \; M/ {7 q1 s/ w( T - try {
}5 m% v: U+ u - con.close();
, s4 e% |8 p& C6 ^; x/ u# Z, O - } catch (SQLException e) {- F+ C0 U6 f% @8 a) D& w+ U
- // TODO Auto-generated catch block
# K- ~* o) d. f5 A - e.printStackTrace();
8 ~+ K# {3 s$ K4 P - }
. e% g8 l" C. G4 ^& ?4 q& B8 y - }) V* [9 K( S4 }; ^) o0 i
- , k4 @; A P! u* ^. G: e2 A' P
- public int update(String sql,String[]getValues){
0 L& V# { U+ w+ ^% r8 e0 L - int i=0;7 t2 z: Z. I! r3 o" T% b
- Connection con=null;( O# V! [8 V# m: R/ N z
- PreparedStatement past =null;6 ^7 W) X9 A$ _" ]/ k4 i
- con=getConnection();; b4 N/ f3 S0 Z v6 x- [/ A. R9 z
- try {
* V0 @1 G8 D: z. i - past=con.prepareStatement(sql);
8 G8 b. b6 D' n! H - if(getValues!=null){
! A4 W" ^+ {4 G3 i - for (int j = 0; j < getValues.length; j++) {
4 T) ?$ R6 E/ i7 o - past.setString(j+1, getValues[j]);
) c6 P1 v5 _8 S; k - }
* j7 k% V5 {. k( p& H - }$ j# h! t# ~' Y
- i=past.executeUpdate();1 y6 W: o! {, {/ l- g4 I
- } catch (SQLException e) {. w3 y$ T& \# j8 r( c' \& u( X
- // TODO Auto-generated catch block
! u$ D- z; _9 Y# D# A - e.printStackTrace();; W* a0 c' j& L# f
- }
- T% g+ O+ M/ z; t0 \) u% C! d1 n3 r+ n -
3 r- @. H& K! v. d8 X7 y$ v - return i;
3 [3 ^$ G9 t, {$ f, J& F* n - 6 p; q d2 J8 t4 n6 O1 G1 T
- }
3 v/ M2 `& Z9 o8 q - }7 M; I4 v t9 D) l$ u8 Z1 i
复制代码
% l+ I% S+ |) X& \+ R: C& G, [! \6 u+ M* P: N9 ~$ y
- package s2.jsp.zhangxiao.dao;) r$ D$ t8 P M. ?# K
' F9 B' E) g4 T( f* Y6 z- import java.sql.Connection;
' ^* R: }4 Y5 J9 A - import java.util.ArrayList;7 O: w; D! ]4 E0 v. H$ @
- import java.util.List; { I$ H/ E* G B) j2 n
- import java.sql.PreparedStatement;
7 S, C$ x9 |" }3 W2 C - import java.sql.ResultSet;, P# M" S8 c9 D
- import java.sql.SQLException;" P4 k9 D- H7 A6 t) e1 k) w( N
- ; c, u' E: U- ^2 q3 Y; z
- import s2.jsp.zhangxiao.entity.Book;
) d" `7 R( ?8 U, B* _+ v$ [ - 2 m' L u3 H! j8 G4 s9 J2 S
- public class BookImpl extends BookDao {
4 O# e, Z* ]5 N B8 m7 T& r5 z
' t% S: e# e" F( t4 k4 l-
$ c9 L* v" U6 [4 u1 @ - public List bookAll(Book book){
$ L2 @4 _( P! Z - List list=new ArrayList();, x7 ]+ I( U, z, Q7 k
- String sql="select * from book where 1=1";. X$ C8 J# \" O3 Z
- Connection con=getConnection();
1 R* r0 _5 f+ s. Y! B# G3 U' H - PreparedStatement past=null;/ ]- r& |: i+ H% S, \
- ResultSet rs=null;
4 z- Y" E8 |3 P1 R$ N( l! o0 D% r - if(book.getBook_name()!=""){
5 ^' [/ N+ N1 m7 z+ k- _+ j9 k& z - sql=sql+"and book_name='"+book.getBook_name()+"'";; S# u- V" V" p( h7 X% J+ T- r
- }+ n6 P, n3 ~0 Y9 O
- if(book.getBook_type()!=""){
9 x& \2 d/ i2 [: R* W2 P; B% x - sql=sql+"and book_type='"+book.getBook_type()+"'";: B: k6 {- A% ?; J3 K
- }, x/ Z% j/ T. X6 v
- if(book.getBook_publish()!=""){
$ `7 S( d0 [) { - sql=sql+"and book_publish='"+book.getBook_publish()+"'";' B* z9 ?- R% C! }( u" s
- }
; S l4 e: ]+ W1 q5 i8 | -
+ [( e) F, C9 ^! k2 G& U* }- a - try {
4 c' b+ h8 v9 Z6 a. ^2 } - past=con.prepareStatement(sql);
* R* |. |/ ~+ a - rs=past.executeQuery();6 z+ a8 w! a' a" g# d, t
- while(rs.next()){% v3 s* Y) b* ?! W8 ~ u C l
- Book books =new Book();
6 E- N* V' Q8 M i, {% n - books.setBook_name(rs.getString("book_name"));' C3 p+ R; O* e8 f6 P' y0 k
- books.setBook_type(rs.getString("book_type"));5 N* D/ U$ R: S' V) V" |5 X
- books.setBook_publish(rs.getString("book_publish"));+ @) L5 c# i) E L4 Z$ T+ [6 b- q
- books.setBook_date(rs.getString("book_date"));
& k+ Y: e5 M/ C! r" l( u - list.add(books);5 c4 d, o( }1 V( n
- }
2 Y9 ^" ^2 T, O) V - } catch (SQLException e) {) L7 ^, p* |% V: c' \! s+ t
- // TODO Auto-generated catch block
5 p6 b5 T! ~1 I - e.printStackTrace();' E2 G' K! H# ?8 b" D' a
- }
# j5 Q, e9 q. _; W- ^1 y - return list;
4 ?4 E0 ]5 d9 Q0 |% r -
. W7 h$ m h6 i - }" }( A2 y# Z* B% D: t: L
- public int bookInsert(Book book){
+ g8 |0 t4 x1 z4 ^ - String sql="insert into book values(?,?,?,?)";$ e7 E, Y/ J: }1 R o7 f
- String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};$ I3 S" m7 p9 p$ L
- return update(sql,getVlaues); 7 l& K9 r! B8 v3 y! B+ W
- }
/ y P. R: J& I% k - public List listtAll(){% j; f/ Y. c4 N! h
- List list=new ArrayList();
$ C2 x F' }! k - String sql="select * from book";. s" j& u: o; A* P8 `/ O
- Connection con=getConnection();. H. A' W+ p7 S
- PreparedStatement past=null;
: @5 a) q9 W; n; Y' O4 B, t0 d7 N - ResultSet rs=null;' h I7 \/ H8 D( S0 c1 _" V/ Z7 X9 w
- try {
2 D g& x$ Q$ ~1 g3 G5 G - past=con.prepareStatement(sql);
# ~2 `6 y+ P/ o. ~4 H/ W2 i - rs=past.executeQuery();
8 L9 Y) q- z$ f; V - while(rs.next()){6 U$ m! ]6 A% c
- Book books =new Book(); r+ a6 w' h2 ~" Z G7 u$ w3 @' |5 T
- books.setBook_name(rs.getString("book_name"));( R; j& I1 @, U& R o, W& D3 t
- books.setBook_type(rs.getString("book_type"));
% c L t/ K. X3 j2 N/ V8 P D4 R( O - books.setBook_publish(rs.getString("book_publish"));- J7 m' t0 f9 r! \; m6 p
- books.setBook_date(rs.getString("book_date"));" h* G* }. U/ m& ]- g4 M: @0 l2 f
- list.add(books);) x; a' U# [# M: S3 j
- }
5 h3 L. X/ R# J - } catch (SQLException e) {
8 S8 w0 F2 B- N t3 D - // TODO Auto-generated catch block
- l% q, A& P3 g6 H* D; i$ m - e.printStackTrace();
- X3 m! s0 K" G U8 J/ E - }
) G* f7 e/ z/ i. l9 P - return list;
9 Z/ Y6 w2 n& t, n" B4 ?$ R6 E g -
9 ]6 d3 | \% U& ^% C+ ~ - }
( S* m& l7 l9 }( s! x - }
( }" z% B- U; w9 m0 `
复制代码
( h! |% _1 W6 z( X- b* x7 M/ F" i* W9 F A
, V- @6 J( ^+ x. b9 i
|
|