该用户从未签到
|
- package s2.jsp.zhangxiao.dao;
6 i% h( ]# O. N" z- A+ O0 [ - import java.sql.PreparedStatement;$ T! {- l [- i3 F
- import java.sql.ResultSet;! w$ M6 n0 ?3 x
- import java.sql.Connection;
. y& [8 A) E3 Z5 b, l Q( o2 ^3 q - import java.sql.DriverManager;
4 \$ B5 g. F% J& j$ t: M/ g8 L - import java.sql.SQLException;6 s" G' h0 r" ?; s
- import java.sql.SQLException;
( M) R! }0 k5 G. M `9 T
; e9 y& x, K& x5 t- / t$ R2 n a! j2 ~# C- j
- ! _7 g9 Y: h# z
- /**
9 F% O0 r' v$ B0 O+ M1 i- B6 L8 E - * 连接数据库
3 T! U) U# y1 }' ] - * @author student18 g" g% x% F, w
- *
" ~4 \5 N' @. @" n2 b) R0 \ - */, s+ ]' _+ o& f6 e+ v
- public class BookDao {
; [: i1 G2 Z+ R) J; p0 [% J5 c - 9 y/ C7 m, j5 L+ z* J& U
- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";0 M+ j# l2 J, C0 O- K1 ]
- private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";
* V: h% I8 r" h$ _+ k i% s - private static final String DBNAME="sa";- v/ j8 q* N4 G0 j
- private static final String DBPASS="1234";7 Y- ~7 u, J$ r. q
-
/ f; `0 a7 s! |; D -
" a: \$ {3 \8 u& l+ e# k - public Connection getConnection(){# I- y6 C+ x- p& K: Q+ |
- Connection con=null;6 \# E! j, S5 }3 A$ K
- try {; R& G& H, h: \, j" W
- Class.forName(DRIVER);
4 v# l9 r& l% S1 K0 Z' Q& ?2 ~ - con=DriverManager.getConnection(URL, DBNAME, DBPASS);
8 a+ n) O' q6 j - } catch (ClassNotFoundException e) {4 \; b p9 c( \
- // TODO Auto-generated catch block
& `) w* f2 i' Q* c0 O/ C' N' p# ` - e.printStackTrace();
4 X w9 _: d+ c6 b+ q+ ?& Z* ? - } catch (SQLException e) {; X4 t# s* u; N( q z
- // TODO Auto-generated catch block8 N8 {# d- f! J" u% l s
- e.printStackTrace();. T. P' h: r- b
- }
$ _8 B7 Y' q, o- s - ( p1 N5 @( I f' ^
- return con;' ~5 [5 J1 Z( ~0 ^4 V. \ v
- 7 X! K9 r! X2 D9 t2 ]9 B4 l2 e) v
- }
4 ]+ j, k' H( b% n: u O - public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){9 r/ b* r$ I2 S3 R6 }5 x
- try {2 p. P+ w* Y2 |) B. P
- rs.close();
! K8 z( B. a$ S1 I - } catch (SQLException e) {( ?2 B% z, ?& P3 u+ {8 t# Y
- // TODO Auto-generated catch block
4 k( x; X. a- ~6 |( ]/ k - e.printStackTrace();
4 {, w2 Y: F$ s4 D ^ - }3 D0 h2 ]* }8 Z& T5 w
- try {! B# X! B0 c9 C6 S
- past.cancel();
2 E0 O/ \# ?0 ^' q - } catch (SQLException e) {' d2 @6 T1 }9 [6 _: @
- // TODO Auto-generated catch block4 V* o! ^8 b& o6 k1 y
- e.printStackTrace();! o" z$ S: V" B; F
- }
/ T3 V, i' E* s' w" A - try {" f4 v" `: ]& H4 U! j
- con.close();; e: T) @& X% y6 w) |: C; N/ o
- } catch (SQLException e) {
}- B6 E+ ]* ` - // TODO Auto-generated catch block. `: e% L9 w/ L; b- J$ _
- e.printStackTrace();# W4 k' \; x5 i/ n" B
- }+ ?; R! A' F% V; @
- }
/ O- M2 U" ]5 D) G6 w4 B% F! [ -
, q( g2 c- e; b' S - public int update(String sql,String[]getValues){
- J$ D, Y# `$ T. ` - int i=0;8 ^& p) u1 ]8 I( c0 ^" h6 n" J! r1 N
- Connection con=null;
2 r' }: R8 R% ? - PreparedStatement past =null;
* s6 u* v: N( X. E8 ? - con=getConnection();
5 S: v6 y5 N2 A T5 d" U e - try {
: p) X( V0 I7 N1 m, c( ~( m6 T* } - past=con.prepareStatement(sql);: I2 ]; g$ j& b+ |, ^
- if(getValues!=null){
1 L0 @5 L9 U7 m- u4 D- G - for (int j = 0; j < getValues.length; j++) {* I; G. F i, W$ A4 u" Y2 X
- past.setString(j+1, getValues[j]);
* u# v A( I v9 ^5 b; t) Q' Q4 i - }5 L0 ]# R. @) E3 ]- F/ l4 t$ x/ A
- }
5 `. Z# U) J# m, M - i=past.executeUpdate();$ p- b g, {7 P# n) ?' s' M) w3 V7 Z
- } catch (SQLException e) {
f3 O7 v6 e# ] - // TODO Auto-generated catch block
7 R+ [# P2 v9 q% Y1 |. H - e.printStackTrace();
5 x' o2 @4 r/ G4 z - }
5 B" W2 C7 y* Q1 D' H; b% h) j) E; K - % F- s/ {* m+ w+ W7 p
- return i;
/ Z4 a9 w* \( G( ^% k -
/ T) S h. M* ^; \$ B7 n& z# J - }, w! G( k& L; C
- }$ K0 r/ G# E1 a: I
复制代码 : c% {# R* t/ A: V2 I* ^3 Q
% j) x* P6 e# H5 l% p- package s2.jsp.zhangxiao.dao;
3 ~/ b* j% H S u; ?
$ C, [* f) f+ G' H5 f' @3 d3 S: u- import java.sql.Connection;
. W. s9 h( B1 d2 U - import java.util.ArrayList;
) h* {3 K- r& ^& _, z- } - import java.util.List;
3 X' p6 N9 S* j/ O( P' U: c - import java.sql.PreparedStatement;$ X0 {5 N: h. ~- b
- import java.sql.ResultSet;5 c( m8 T9 X$ w1 `
- import java.sql.SQLException;, L# _6 e: }6 x4 l8 K
3 Q$ V# N1 k) E/ a- import s2.jsp.zhangxiao.entity.Book;: I1 t& _$ l0 ^7 j" y
- * D4 U( h" @- T% ?4 _
- public class BookImpl extends BookDao {5 ~8 h7 t- H$ E" F. o; y
/ B3 ?$ f" y! R3 p( r5 v-
9 k4 G9 W3 E7 r; E8 T - public List bookAll(Book book){
4 _ m2 a9 l& [# l! O, N _ - List list=new ArrayList();
( _' d0 Q$ c& j) j3 f/ B7 Z. @ - String sql="select * from book where 1=1";. ?# F/ I8 l: @! n7 ]/ ~7 w
- Connection con=getConnection();" d) r3 `( C0 n3 A' ~ S/ K/ i) A
- PreparedStatement past=null;4 k( f( D i1 H. s+ ?
- ResultSet rs=null;0 u6 W/ x4 z* X' v9 f
- if(book.getBook_name()!=""){) t% Z: O* G$ A# R. @
- sql=sql+"and book_name='"+book.getBook_name()+"'";
4 l1 L' | F4 e" l$ D' c; I$ ~ - }
1 \4 q7 o: s" z" O. a - if(book.getBook_type()!=""){
, }+ ^. @ Y$ w4 q/ A - sql=sql+"and book_type='"+book.getBook_type()+"'";
8 E) c5 {+ a+ {; \4 F$ p - }2 R( a: i/ i0 {5 b; j# {9 R
- if(book.getBook_publish()!=""){4 @2 u; w# i- D8 D/ f' ^
- sql=sql+"and book_publish='"+book.getBook_publish()+"'";
- O! d, D7 e% W1 g# L" z% g$ _& } - }' t7 x# R( ^- G) [! @) _
- $ e6 o9 ] g4 G$ `
- try {
% ^) r' x: J( O. P: G - past=con.prepareStatement(sql);5 O3 i* H- i! Q
- rs=past.executeQuery();
- u' m& L2 P; N! e1 } - while(rs.next()){8 T; Z( Y; O7 p& E @- v& q
- Book books =new Book();- o3 |3 `3 p3 c
- books.setBook_name(rs.getString("book_name"));
3 o' Z: v3 w; `$ C& d' ?* p - books.setBook_type(rs.getString("book_type"));8 ~' K7 F. J0 O; y
- books.setBook_publish(rs.getString("book_publish"));. W q1 i# i5 t& s8 |& c
- books.setBook_date(rs.getString("book_date"));
7 ]6 P( U& D* A3 @& {+ Q$ H7 O/ Z4 M - list.add(books);
2 E v% N9 c4 U: b' B0 r - }8 x* o. ?, k2 `5 T6 w
- } catch (SQLException e) {7 X3 K0 B: v% O) Y
- // TODO Auto-generated catch block
; n7 O" q) C2 v$ U$ o - e.printStackTrace();
4 u. W: `" }, C; ~9 g5 E - }
9 Y, H( ^: e' x3 [) C, n - return list;4 [$ G# s# C/ U. F" j$ Y0 M
-
, M: i2 M! P# d: d( _8 F8 E; `; @; m - }3 V U- y. z# W6 `) v7 O0 ^
- public int bookInsert(Book book){0 u% q5 ?- m' ?9 N+ U
- String sql="insert into book values(?,?,?,?)";" @& P7 `, w; F: }; l, t2 C9 J
- String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};
: _ U) y) m* e2 w, Z - return update(sql,getVlaues); 9 N! X2 O; k2 U( [) _: o
- }7 y$ c+ X2 f$ I6 I5 k: y* m% e) u' P
- public List listtAll(){
R6 v& }( ^, ]' V0 r1 U2 K" b - List list=new ArrayList();/ q6 m2 Z" {1 i( e. @4 I* S
- String sql="select * from book";! z4 d. b% n! A7 f: h, i. @
- Connection con=getConnection();; C2 y6 x Q5 i5 K$ Z; b$ F
- PreparedStatement past=null;" x2 @! L- h9 z( T- h M
- ResultSet rs=null;
, d4 E7 X( Y. g3 f) l - try {
3 G5 G- ~1 E1 G - past=con.prepareStatement(sql);
& u( e% W c+ v, g$ c P - rs=past.executeQuery();$ N9 A' i6 ~( z5 n6 G; Q+ M
- while(rs.next()){
/ h- r9 u& n) Q8 p4 h! p! Y - Book books =new Book();
- h; M# x: r, j - books.setBook_name(rs.getString("book_name"));
0 X5 O# l$ U1 P" W3 Z - books.setBook_type(rs.getString("book_type"));
; V4 B* Z' J) A) ~) G - books.setBook_publish(rs.getString("book_publish"));6 r2 a; f; F! W& ?+ `7 `4 E" p; C: g
- books.setBook_date(rs.getString("book_date"));" n; u' d9 _5 w) X
- list.add(books);
5 K: g9 H" M3 N, i; a - }
6 }3 F) k1 ^8 ~0 m1 f+ ] - } catch (SQLException e) {
/ [$ Q _5 \, X. F& b' Z3 \ - // TODO Auto-generated catch block# \+ T- [, w5 v9 K, _
- e.printStackTrace();
* b( u& x$ L% X9 z' j$ y9 N - }1 x0 Z: X2 i4 I) b/ c3 o# x
- return list;
* R& n* f. w4 y& ]; R -
3 X4 q0 q& {% B# d( E$ p+ B - }7 S1 ?! f# j1 \
- }, d3 [! ^5 E9 j9 y
复制代码 3 w% ~' q+ t' I F( q* c
' X* `) }' Y8 t+ W
' c; r+ V* N: P7 T% O% F8 Y |
|