该用户从未签到
|
- package s2.jsp.zhangxiao.dao;: f5 T8 T: A! k! ^
- import java.sql.PreparedStatement;7 K4 P$ K) ]( ?3 ]
- import java.sql.ResultSet;
, d ?; H4 D9 U' U - import java.sql.Connection;' i) P9 v2 L" h3 E# `( j3 Y3 b
- import java.sql.DriverManager;
+ @8 q1 d, c" f6 F1 |; t8 O: ~ - import java.sql.SQLException;( [% a8 n& H9 P# [1 A- t* ]
- import java.sql.SQLException;# c8 J5 z) f8 t
- $ P R, K* @9 X7 p! S5 V5 u" R
- 3 K |! o! S# X9 X- G
/ {7 W4 c0 m3 Q0 g* Z1 A- /**7 h p @; k z% v) ~9 y
- * 连接数据库 h: F; l1 R- p- E; u( V
- * @author student14 K, z+ `# w- Q3 M9 S2 x
- *& I" [( b2 ?5 ~
- */
% y L) m8 T' i( d$ T1 Q. {0 d - public class BookDao {$ q a* x/ d9 I
9 @) S! U4 r+ D" k' P. @- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";; l% ?$ J9 y( y L! P! H, n
- private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";3 [# n6 n- x) T, C, ^
- private static final String DBNAME="sa";
0 L- m7 q2 b6 [( J5 S; e" P% V - private static final String DBPASS="1234";, L( |7 C3 c" [- p
- ' D- W- ]. l9 K, j" I; w3 I3 f
-
+ S% J4 _7 }; i/ s" } - public Connection getConnection(){' V7 C" {6 `- P. Q( a' j
- Connection con=null;
6 n6 |2 K4 ~/ I) w' }8 e$ G! W - try {" k% P( q, Y* t8 c# @- b" E3 |% J
- Class.forName(DRIVER);
& e* ?9 H" b8 n$ s8 [ - con=DriverManager.getConnection(URL, DBNAME, DBPASS);: o5 r# P( _1 A" S. r
- } catch (ClassNotFoundException e) {' K( B N2 G8 X( `
- // TODO Auto-generated catch block
8 w+ f7 Z3 u5 J( P; D - e.printStackTrace();7 W' J+ X1 M) ?( }1 r
- } catch (SQLException e) {
9 T9 L) {9 [. k( W - // TODO Auto-generated catch block! ]: n, c7 M) K0 A1 p
- e.printStackTrace();! k/ c `! V/ b
- }) R' j& R0 R& i- f. i% r. V2 S
4 j) L) w# g! Y1 N3 s+ E( t2 [- return con;' v4 j$ P% o" u9 M
-
7 x G3 L0 t4 M! b' E - }
; B# o1 R- Z1 v t - public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){% p, g2 |: f7 E7 m6 ?* q* R8 a7 D8 z
- try {. }7 ]1 |* e- v5 S0 h m: i* I
- rs.close();
; g2 j* a" ^, H; Y [ - } catch (SQLException e) {
, G! w! U$ q& z; j+ g+ ~ - // TODO Auto-generated catch block6 A2 ]6 ]2 A! j3 Z, [
- e.printStackTrace();0 P5 a% U5 A0 t. R7 o5 Y( n: q
- }
6 @, {( j# r6 Q) _' \ t( l8 ` - try {/ k( i8 o! W3 I/ W' n- Y4 E5 }
- past.cancel();
& w7 t# l' y( _ - } catch (SQLException e) {
9 e3 A+ [* g9 P% \" ~% l - // TODO Auto-generated catch block
. a1 N$ s/ ]# j: K0 p1 H - e.printStackTrace();
+ E/ y7 T* m9 P4 i5 V% G5 y7 r - }% u$ _9 i- h, W2 z7 X: Z3 H$ @2 u
- try {# {$ v9 c4 k, ?, K: I
- con.close();
. }4 K# a( x4 R& K% S/ G1 Q - } catch (SQLException e) {
$ Y; W! e% m3 H- J- y) t' B2 `: T - // TODO Auto-generated catch block3 g% K+ @6 e' u, k
- e.printStackTrace();
. m; l! Z" A6 v7 R4 _- e - }
9 d! O8 t( E+ z. ^5 W1 i/ ~ - }
6 N+ B, M0 O' r - - f5 f7 v# H% |; S1 m6 |$ E
- public int update(String sql,String[]getValues){1 P+ R% r0 z: V" V
- int i=0;
" r+ A5 G: k# V9 u - Connection con=null;
3 G+ w* q( a/ a& w1 z4 c1 C) R - PreparedStatement past =null;
/ a5 \8 P2 T( @; S( r - con=getConnection();
. Y) E ]2 G g - try {4 z* O' {. \* X h) U$ ]0 x
- past=con.prepareStatement(sql);% s) G# j, y8 L9 {# U
- if(getValues!=null){ v7 {$ l8 |2 i
- for (int j = 0; j < getValues.length; j++) {2 N8 Q% H7 `7 ?1 D$ n
- past.setString(j+1, getValues[j]);
; Q/ T$ Y& |. x( x2 x- f, ^$ v0 r - }
% [: \& [" I. Y/ S& p% g - }2 t) M; X4 C( x- W/ A- p3 F
- i=past.executeUpdate();
j" |4 o( h$ k/ K- l - } catch (SQLException e) {
! R) _' E/ c/ a8 l; ?. P% c0 W - // TODO Auto-generated catch block
2 M; U) q# U& @4 w( ?2 B) e - e.printStackTrace();
7 n+ }; b4 R$ d3 t2 ]7 { - }' U. f# a+ z- D9 R5 b/ i7 t/ z
- 3 P6 X- k8 b- r; c( r, H
- return i;4 Z" M# Q3 j- A( x3 \6 l0 W h
- 9 r3 F4 i, K. L# g+ q
- }
7 J" Q/ y6 `& |8 t/ v( S3 n$ | - }
1 U9 x; o9 L" f( ?! U9 l0 r5 [+ Z
复制代码- package s2.jsp.zhangxiao.dao;
* Z* d+ j% c3 K8 z9 x7 f9 J' |
% ~2 j$ H5 O7 {9 H1 N- import java.sql.Connection;
9 m ]+ h2 H6 U6 X - import java.util.ArrayList;
d$ J* k4 @) b) E& g; m - import java.util.List;
j1 F9 \! i3 ]+ p; S3 c+ @ - import java.sql.PreparedStatement;
* c+ D# h& t6 X2 w4 | - import java.sql.ResultSet;- n1 N( c$ R" d/ {+ T) }
- import java.sql.SQLException;* o, X/ f/ a& @. E+ u; A
- : P3 D& m4 [' S1 L/ c
- import s2.jsp.zhangxiao.entity.Book;
: F/ {6 Z' u3 Q! W r7 x- r
( y, V/ h; ]# b+ {. Z" H- public class BookImpl extends BookDao {
5 V- K7 o! E* S8 x$ ?+ E7 e - 8 r) {% v: K. u
- % @5 c8 X* c% h1 L8 n" z
- public List bookAll(Book book){- C2 `& T0 s' B+ @3 U3 T
- List list=new ArrayList();
1 p7 u& j: Y$ P - String sql="select * from book where 1=1";
4 L* @5 u8 g' @: b$ { - Connection con=getConnection();) E# {' |, [' K3 h
- PreparedStatement past=null;
2 ?4 P% ]! ^; c. b L - ResultSet rs=null;
+ C4 P. w6 o" p7 | - if(book.getBook_name()!=""){+ c1 I, U3 k! I: H
- sql=sql+"and book_name='"+book.getBook_name()+"'";
3 K4 n5 X4 [) c- h" g8 d4 S! e - }, G S- j% t' R- a/ w
- if(book.getBook_type()!=""){6 ]0 T& D T3 m. {5 q5 x
- sql=sql+"and book_type='"+book.getBook_type()+"'";
0 ^ Z- J; m, H: D- ~- ^ - }7 g6 ?) r- h, T1 q: B
- if(book.getBook_publish()!=""){
" U5 ]9 g& {6 ^' q/ B- L; C4 t - sql=sql+"and book_publish='"+book.getBook_publish()+"'";+ c7 b* W; ]% D) g2 t+ F% F
- }
# @8 r( ], ?, ]. U - # V9 W* G3 s& {& E2 A7 Q0 Z1 Q0 ]
- try {
2 K3 k5 S$ D; X5 ^ o - past=con.prepareStatement(sql);% \& r, s& Y* L
- rs=past.executeQuery();
' @2 R T. {& C x - while(rs.next()){% y. R) g/ d- m( \# R, \0 f
- Book books =new Book();
7 @* g' n# f& K2 v - books.setBook_name(rs.getString("book_name"));
% g, [ \; W+ g3 A$ w% _( n - books.setBook_type(rs.getString("book_type"));6 @! I Y0 Q( F# H+ b& i' ^+ {7 M
- books.setBook_publish(rs.getString("book_publish"));
' y7 P, G) h$ z& M; ~ - books.setBook_date(rs.getString("book_date"));
5 g; h+ U, c, ], `# M1 A - list.add(books);
' ]2 D! w8 [4 _- C( D- b - }
3 z& m- c- x. u7 g - } catch (SQLException e) {% a9 \' u* r) C0 l' S2 m
- // TODO Auto-generated catch block2 a5 z0 v9 F* b M" q
- e.printStackTrace();
; y! `0 x4 F/ @ n5 a2 J! b - }8 S' p2 L- v1 L6 \
- return list;
3 Z: g0 V5 b9 O -
' Y& v( H( M; u% F% H8 P - }
P+ h; f7 V) n# i - public int bookInsert(Book book){* s3 i. \9 U' ~+ u2 s+ @
- String sql="insert into book values(?,?,?,?)";
0 f2 }6 ]% _# ?( l - String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};
6 K7 ?! i; v. Y - return update(sql,getVlaues);
( ?$ Q, A9 `5 `& x7 e - }
6 d1 M9 e! m) f: p9 `+ q7 K - public List listtAll(){( O$ t4 N, ]; O0 f7 n4 G
- List list=new ArrayList();9 e/ S2 U" r- p/ ]& v
- String sql="select * from book";
; V, u+ y: u6 O5 b) m - Connection con=getConnection();) D* R- E q. h: H5 Q& m6 g
- PreparedStatement past=null;
* E& i, T6 z. Q6 V7 `9 O - ResultSet rs=null;
' d3 K$ q! H0 ^; P) P4 X - try {- h* [6 W, ~# z, A* _$ k
- past=con.prepareStatement(sql);. s, i; M6 H1 F* @ V( Y) I
- rs=past.executeQuery();1 z# p8 A3 ~' E2 x$ C
- while(rs.next()){6 I4 v) i' W/ \0 n7 S) |" \
- Book books =new Book();4 F ~: X& B( G
- books.setBook_name(rs.getString("book_name")); h0 A n) k6 m5 w; z: Y
- books.setBook_type(rs.getString("book_type"));
; ]5 T0 @7 Y! l& I2 \ - books.setBook_publish(rs.getString("book_publish"));- I; i# h- `: e6 N% J' [9 e
- books.setBook_date(rs.getString("book_date"));
! o- r$ W8 U% ]" s/ i3 H - list.add(books);7 L8 f7 ?4 H2 T6 }- d3 Y7 z+ \
- }& _, u( ]4 r3 R- v! q
- } catch (SQLException e) {
# @5 ^ t$ e1 Y: m - // TODO Auto-generated catch block7 F; z. T7 `5 k1 t( J* F# d9 F; a4 Q
- e.printStackTrace();
8 P. [3 Z3 z- V# \6 n5 S - }' d; ]0 G E: w! L8 Z
- return list;, j; w3 `* o/ g
-
- d2 } p! w2 c5 T4 T - }) `0 g! Y: B1 g4 y
- }' A/ J& b3 V# p4 Y) K: M, H2 y
复制代码 源码下载地址:点击下载
1 C. @ H1 q8 V4 H* \! Q" u0 ~: M& T, T" K
7 {" N) e4 \9 }, ^( }8 `/ c% v3 ~
|
|