该用户从未签到
|
- package s2.jsp.zhangxiao.dao;
/ ^$ _& p( s0 z2 a3 S4 S1 w9 a - import java.sql.PreparedStatement;
, Y! ~8 ^4 X! a- S1 z" F3 j - import java.sql.ResultSet;
; V, `" z% U N8 g. J$ f - import java.sql.Connection;
9 U! K' ~$ I" w; e7 } - import java.sql.DriverManager;
5 D5 Y3 R; s) s - import java.sql.SQLException;& G9 H. `" Z8 ]- _# s
- import java.sql.SQLException;
3 v' d. V8 F$ }+ u# z% }1 q; G" M
t' |5 N- X! ~' R6 `8 D- % m+ D' s/ @& {$ t
8 f' k# O" D7 L, k1 e2 J) g- /**$ f9 N8 O! J* v
- * 连接数据库
1 R- ^$ u6 l1 H; e2 F/ J7 O - * @author student1, k$ G3 { g/ r% z- J9 G3 }
- *6 N% q& }$ O8 O7 E. E7 l
- */
0 S2 l3 c j8 _ - public class BookDao {9 m/ i8 p9 F# B$ z
- c C0 K# K8 ] R9 @- B! ]
- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
% s o6 A" N3 t) M+ \! _ - private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";3 i/ R. o3 X1 h. x& s* P
- private static final String DBNAME="sa";
( W [5 D# a) H" L' \' i$ D - private static final String DBPASS="1234";
5 @& e8 f b4 q4 ^3 l9 Q$ _ - 2 A# T$ x4 M) h5 a. K2 s: A
-
+ U F; ~+ m, G. ?. i: F$ e } - public Connection getConnection(){
* h7 J- ?) R8 Y) x8 C ?" ~. _/ u - Connection con=null;1 M6 Z$ r5 j% I2 p7 B' R2 L- p
- try {
5 |* O* z* v! i9 j) K4 s - Class.forName(DRIVER);7 \% v7 m9 w/ j8 R
- con=DriverManager.getConnection(URL, DBNAME, DBPASS);
3 N" @4 C, i5 T, ~ ^, N, m - } catch (ClassNotFoundException e) {, @- `# A% {7 q- e, f1 Y- {
- // TODO Auto-generated catch block+ Q, I5 l! ]! P+ y
- e.printStackTrace();/ p) @0 g' V6 O6 ?" \ E+ X
- } catch (SQLException e) {
8 `8 C# n& D9 ` - // TODO Auto-generated catch block
2 N) B0 p4 [' y' @) \- v - e.printStackTrace();
- Q/ _! K" M$ g* D; e, j O6 p - }
+ y8 L/ {4 D8 Z. G: ~* K* C2 j
6 [: \0 D( h- R% T* @5 V0 r- return con;
6 X/ A7 f2 I6 R9 A6 I7 m& \2 f -
: S6 ], ]* n2 R: O5 |$ e - }- y+ w' f9 V& X p1 d5 q: @
- public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){: E% s9 ~) P9 y2 w0 Q6 ]5 @
- try {0 F6 C! i6 ^0 c7 D' j
- rs.close();0 r6 D$ A9 x/ M8 ]
- } catch (SQLException e) {
6 I5 H3 q5 R# T0 X* \ - // TODO Auto-generated catch block
; i' D' ~; V, \* h) m - e.printStackTrace();
8 ~ b) }: d8 u" F+ n+ G - }
8 F8 D, p* E) u; h: j0 z - try {9 F$ `; O* [" u( W, m) T: w
- past.cancel();
$ z% X& P) v# a9 ]! C' P# u - } catch (SQLException e) {2 m A8 f' X$ M3 c5 X
- // TODO Auto-generated catch block: g$ e8 t) }8 B \7 o |7 ^
- e.printStackTrace();; ]: g% P4 d' }% R
- }/ G/ W2 @! p' C# F( ], M
- try {
- Y. k) L, k" e: \- B. ` - con.close();# H; O" @# F+ }5 N7 b4 w+ u8 [$ x2 a% r' U
- } catch (SQLException e) {
, }% b* b- W- ~ e - // TODO Auto-generated catch block$ u. D. D0 o) O/ j+ r
- e.printStackTrace();8 b. p; @" ^( i2 Z
- }
* y3 S4 I% s4 { - }, ]9 R5 \' m0 k3 D
- , L. [( }5 c1 @
- public int update(String sql,String[]getValues){7 E2 V! }- v* R0 X% P
- int i=0;. I8 l, _* V3 m( e3 i
- Connection con=null;* z0 I8 H: R. x% p# h H
- PreparedStatement past =null;6 l2 I+ V4 I4 w3 E) ]4 v: l* l
- con=getConnection(); D! m7 E1 ` _, a0 G! D) d5 X
- try {, Y+ v! k. D4 g5 |) s( a
- past=con.prepareStatement(sql);
9 K0 k: m- l9 k! ` - if(getValues!=null){0 C- U9 R; K; d) G* P2 T' M! _) J/ O6 S
- for (int j = 0; j < getValues.length; j++) {
$ c' A+ i" N' f7 `; i - past.setString(j+1, getValues[j]);
4 ^ o/ Q; V, T) ?, T3 \+ P' c - }4 B. ]" w; T; S0 S
- }
7 h9 X$ [: f( ~4 q! `) X# t - i=past.executeUpdate();3 b, i S9 I, E$ \% M9 e
- } catch (SQLException e) {$ n% V6 [6 x8 L
- // TODO Auto-generated catch block
4 s, ?+ F* r) t; k - e.printStackTrace();
. f3 K* ^ S& ~& L/ { - }6 j0 [9 ~$ `6 N T+ ^2 B
- . q( J. P5 L7 U/ T3 u: m
- return i;0 r9 M8 W- \1 H( k+ u2 y& w
-
& @: `: \) r% q - }! Y6 Y- ^6 K& u" G' |9 r
- }
% n. u, q1 o5 o% \5 u
复制代码- package s2.jsp.zhangxiao.dao;
) W" t' [# E, C9 z* L4 V
- ~* E1 R+ B) _7 Z7 |2 ^- import java.sql.Connection;
/ W8 ^; X( B! }& q; c/ `( W - import java.util.ArrayList;
1 \& ~- ^; k2 j1 b% I* Z# _. R - import java.util.List;' r% r% n& S" m# _6 D( I+ o( ]
- import java.sql.PreparedStatement;
: _# S8 ?/ p- v/ |+ X - import java.sql.ResultSet;
' b( ^9 C4 x+ i/ O! r% c6 y - import java.sql.SQLException;- y3 w; }$ ~# y; ]% ]! l
9 y7 ?. ?5 v1 Z6 t7 V; f- import s2.jsp.zhangxiao.entity.Book;' N, I1 ^" [9 y0 m9 f2 \7 }
, y" i" w4 n0 e" d/ H- public class BookImpl extends BookDao {
; j, E2 Q/ n" V - * o$ v+ |$ \& c0 f$ l8 ?
- ) S: G1 h, K& r# c; G
- public List bookAll(Book book){# `7 a- X& ^' @& Y. A# Q7 C( k
- List list=new ArrayList();
2 X/ G. _* ?% t - String sql="select * from book where 1=1";
8 p- z; v: W2 K& J- I, H - Connection con=getConnection();
+ j3 E" d/ v3 l' \5 G; G2 [ - PreparedStatement past=null;
3 D6 r. Q) c$ _+ _ - ResultSet rs=null;
8 ~* G4 C f) r: E - if(book.getBook_name()!=""){
1 T& P; c. u L% ~1 R - sql=sql+"and book_name='"+book.getBook_name()+"'";
8 c L8 h& L7 L" ^# N# S - }
9 Y ^; E' Q2 n: @, r6 f/ f& d! ] - if(book.getBook_type()!=""){
8 C* G5 ~" [' a6 m, {7 g8 e U - sql=sql+"and book_type='"+book.getBook_type()+"'";
( q* t1 k0 z7 g, s5 e$ B! `- ~ - }3 w5 A3 U& D% l# Q
- if(book.getBook_publish()!=""){: E h( O' N! l7 `
- sql=sql+"and book_publish='"+book.getBook_publish()+"'";
5 G/ g! f* p; `' t! {3 h! Y - }2 e3 j D5 i8 t# M( d% ]1 x e
- ) t0 y5 c9 b' {5 E
- try {
! ~* i* Q7 P% j2 H! h- X9 ]* i - past=con.prepareStatement(sql);
0 R7 a9 `+ s5 V2 t$ i) R - rs=past.executeQuery();
4 X0 A6 e6 N- Y; } - while(rs.next()){
+ ?% s( H. R- l/ R& q; t1 S! I. p - Book books =new Book();( L6 e- G( _" i3 x
- books.setBook_name(rs.getString("book_name"));0 @/ _% C! v+ @! ~2 q4 @7 o" a
- books.setBook_type(rs.getString("book_type"));
/ b8 z* q; b( [) }6 P4 A4 Z/ r5 y0 e - books.setBook_publish(rs.getString("book_publish"));) ]3 L) r3 H# x# ~
- books.setBook_date(rs.getString("book_date"));
8 b! k+ B ~/ ~; a. M4 p - list.add(books);6 B& W) _9 l' F! A, L" ?) n
- }
+ R' g2 _/ J- `+ b" ]/ g/ |6 m% L - } catch (SQLException e) {% F/ Z: e% v, ?$ }
- // TODO Auto-generated catch block$ ~- N" R S- T7 q% Q! n: l q, B' W
- e.printStackTrace();* j5 Z" s4 n, E4 Y7 _
- }) E2 Z) G5 Y+ H4 B% U
- return list;
6 m {4 D+ ~! L e3 I D' d -
: m; H; d- y% u p$ v - }
( P1 d, V, }; h/ w7 G - public int bookInsert(Book book){
0 ^0 }8 E, d5 n" l: i0 i - String sql="insert into book values(?,?,?,?)";
* T0 [% e ^& G2 C B. g - String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};
7 \$ B# n5 a' t3 z" j - return update(sql,getVlaues);
# q2 I5 [5 g1 i0 M6 L' [ - }
& q$ ~$ Q, Y- h3 F - public List listtAll(){2 u. r) g9 }1 @6 R a
- List list=new ArrayList();
4 f* p( w# O: d( [ - String sql="select * from book";1 }% r+ L! Y( ^" V0 b4 U+ ^! N! w
- Connection con=getConnection();! m( N" l1 a. O! j- [( x
- PreparedStatement past=null;( v5 p, A: d4 E" P0 o9 s: g2 l
- ResultSet rs=null;
" r" H& F, T0 R' \9 r! f - try {
& Z8 Y0 T: t5 b# n; H v* X - past=con.prepareStatement(sql);
+ {6 U9 V* |5 F3 G& e - rs=past.executeQuery();) s' k4 h% i7 X
- while(rs.next()){" C3 D' A) V ~4 r2 ?7 V* F( ]
- Book books =new Book();
& ~, k. b/ L5 a r% d" M# @ - books.setBook_name(rs.getString("book_name"));$ C9 R+ p: Y5 R0 G8 g* y% e
- books.setBook_type(rs.getString("book_type"));& J+ ^# J. c7 ^# u( S. L4 K
- books.setBook_publish(rs.getString("book_publish"));
6 s4 c' U5 e( Z - books.setBook_date(rs.getString("book_date"));7 {& H$ `+ i$ Z7 y" R( ]
- list.add(books);# P) p7 }' n/ `, Q+ o' d/ G6 b
- }( k" g0 t' w& h9 p. ^
- } catch (SQLException e) {
- d8 A& D+ `! o% U2 J - // TODO Auto-generated catch block
! D; ]/ M3 C/ j+ M - e.printStackTrace();
$ l9 c, S h6 N n - }
& T$ ^& U& k4 V; p2 p" ]7 W8 @ - return list; K$ W+ `2 W4 C
- : n4 e% O: d; p; H& s0 |
- }
, F) n+ x0 J# k: H* a0 p - }
+ i6 F- l+ c* \
复制代码 源码下载地址:点击下载
8 F" `9 j/ O( ] i5 S- T% G0 K7 w. N' o0 f# Q R
- j4 R6 r4 s& f, w0 x1 e' o |
|