该用户从未签到
|
- package s2.jsp.zhangxiao.dao;
+ l1 Q; t$ v* y' P: @1 ~$ x - import java.sql.PreparedStatement;9 E* V' h# D' d1 _7 q7 B" s2 Q
- import java.sql.ResultSet;
4 U8 j4 [, Y3 ]* K - import java.sql.Connection;
2 Z. h7 X$ k5 ^ - import java.sql.DriverManager;
( Y5 s: Z/ h$ n1 l1 z - import java.sql.SQLException;6 Q1 k2 x T8 ?
- import java.sql.SQLException;9 }5 b9 a( e& U4 N
5 b- t& O, a+ I1 b- * n3 ~- Z2 t, _" B: W& y
' M9 s9 @% ?7 z! z3 a0 Q* v- /**5 C3 o9 f# y6 G% Z' V
- * 连接数据库( u2 X6 f9 Q: u6 V" Y8 g
- * @author student1
) @1 l! C. K) ?/ R! Y" k - *3 ~/ e) a+ @6 V7 f& D
- */: M" C9 y: \9 P: P, |. T0 r9 T" X3 _9 R
- public class BookDao {5 k1 v2 D3 B! l5 X# d6 X* J2 I& J
# S) ~2 B' r) b& X4 f1 N1 {$ `% J- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
. S Z; D# ^# m7 I! y - private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";
0 `9 H; ~ v' ?, p( {0 ]3 p - private static final String DBNAME="sa";1 K5 H: g; y+ Q5 S2 B* R, T: b
- private static final String DBPASS="1234";1 C p. ]" x5 U5 }" q" z8 g& U5 I
- 7 e; G8 q6 h' [* n5 ^1 k9 K7 W
-
: T3 E+ R2 {& X - public Connection getConnection(){+ l) {3 \6 I: g; _
- Connection con=null;1 ]9 G& M Z% e d- B- Z
- try {
" s, I q( P9 T" x! q% x/ l - Class.forName(DRIVER);
7 C2 Z( j5 r$ J2 S! `, R - con=DriverManager.getConnection(URL, DBNAME, DBPASS);9 X% }/ F# l& Y
- } catch (ClassNotFoundException e) {
# E9 h0 @/ H, }% Y9 v) ^: Q - // TODO Auto-generated catch block
6 X1 L: E( `* \. x - e.printStackTrace();
5 j5 N4 F- r* l4 G+ t5 B: L) w! p - } catch (SQLException e) {
. N2 n" S* B# R- t# z - // TODO Auto-generated catch block7 g2 w9 K- P$ d& [8 K" `! w
- e.printStackTrace();
; P/ }8 N, Q3 E - }
% B. r( K6 x1 w* T
9 X a, Y0 k1 M1 C1 w% C+ }" P- return con;
' f9 W# t6 K3 L K+ K; y -
; Y- d: ^, g2 U' k0 h: M# k - }
8 O( Y. w' N6 u' E1 ?, ^1 x+ ]/ Z - public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){
& }; F& s9 v7 f# d: [5 P: j' D - try {
# W' c& G" R4 S - rs.close();% P) {1 ~0 p; ^& @+ |+ f
- } catch (SQLException e) {
) X$ X6 q% J9 r) N' A, H# K& S - // TODO Auto-generated catch block
6 J$ ~) T+ O9 g$ D* | - e.printStackTrace();0 M N1 x& s- d. e0 T9 ?
- }
+ P5 D0 d. M' K1 ? - try {
7 U* r b4 `' _- S5 X - past.cancel();3 m( T9 j W+ z+ I+ n
- } catch (SQLException e) {, v, B* o- f! h- q4 O+ I# Q3 W
- // TODO Auto-generated catch block
. k- X. `" k5 ?4 N/ d0 | - e.printStackTrace();* J: |8 @( z5 C
- }+ t9 }# o7 Y/ m( e9 X7 o
- try {" P: K/ h8 X: V! P: `' `
- con.close();
1 h! C' s+ r( l7 a- Y+ ]/ @ - } catch (SQLException e) {3 ~+ x. H9 h5 P
- // TODO Auto-generated catch block$ D8 N: A- a6 z% ^3 ^7 t
- e.printStackTrace();2 Y* }# Z1 ~' p7 V! r" C
- }/ D( N, X0 Z+ w5 \3 v1 K
- }* `5 M* Q; e# ]5 @ C
- 1 ~1 l6 _" L% @0 [$ U
- public int update(String sql,String[]getValues){
. u5 e7 u: u b8 l6 D, Z! x! O5 l" P - int i=0;
6 b& n, ~. B2 K0 x* h$ u8 l) w - Connection con=null;
! _+ _0 h* L4 ~( ^, P; q5 {$ t, B - PreparedStatement past =null;
: F* _% J [1 d3 W3 ]& f) i - con=getConnection();; _$ y* l2 x; q
- try {
5 Y# [" S! P, i" h - past=con.prepareStatement(sql);
6 `5 t& r: z, ]2 |9 c - if(getValues!=null){& f' `. \3 q- r$ a" n+ t
- for (int j = 0; j < getValues.length; j++) {, L! j8 ?2 o" A& `. ~
- past.setString(j+1, getValues[j]);
# E' C% K6 H- R4 X9 v- B$ f - }5 c9 ~7 V! V9 S: s# y# U8 X' c6 h
- }6 _& J0 y5 u6 d( [
- i=past.executeUpdate(); z+ S+ U2 p) m; B
- } catch (SQLException e) {( S; P2 f* d5 d, N
- // TODO Auto-generated catch block
) [% O o L0 ^) [9 X, J - e.printStackTrace();
; Y( U) \, w; A: F' T6 \% \ - }
; C% d: G+ T$ z1 m: ^; \" d/ ? -
7 J0 l7 N- v3 E9 d; t a - return i;3 v: C/ d; Q) ?0 A0 J/ [% ?0 G$ E
-
8 h5 O2 i- G; _ w3 C - }5 }8 U9 S7 B& W- U
- }: s# u! h, P N
复制代码- package s2.jsp.zhangxiao.dao;
- c8 q6 Q1 ~: o3 a0 l
, Z$ L. [, U8 B7 Z( d7 U- import java.sql.Connection;' P4 {9 |* A" F& n' L, I& c) {
- import java.util.ArrayList;% ?% {0 \1 P3 [+ B- ?% a
- import java.util.List;9 {3 X" V; z S; d
- import java.sql.PreparedStatement;
& \8 k* k [: s( k2 G$ A0 L - import java.sql.ResultSet;
2 T0 W% c, ?; V/ C4 p) P0 f - import java.sql.SQLException;
% I+ z0 l% `8 { - # \; w/ N% V ]5 S; \) z
- import s2.jsp.zhangxiao.entity.Book;+ r# O- H( c7 u1 S; Y8 f0 _
& ]' O1 m, d' a( J: R- public class BookImpl extends BookDao {+ \1 C. X4 Z: j) k3 Q9 a! s
- 0 ~4 S0 t! t8 }9 a# c
- * }, I3 j: T k4 v
- public List bookAll(Book book){
8 J) Q, M" e( T; s' v$ O - List list=new ArrayList();" F* _% ?; {8 ^2 j- }* @% R/ B
- String sql="select * from book where 1=1";
* K% n: @8 X3 r - Connection con=getConnection();: T, a5 [+ b$ Q% k4 ?
- PreparedStatement past=null;
9 X" v. R" ]* P6 V - ResultSet rs=null;
! ^( N- Z7 W3 s - if(book.getBook_name()!=""){. h5 E% k7 E& f6 ]; m5 u
- sql=sql+"and book_name='"+book.getBook_name()+"'";- `4 |! \- D5 I5 z- i/ V& K' \
- }
. D: I. y- q6 Y4 Z! _. P - if(book.getBook_type()!=""){& U6 ^7 ]5 y+ Y4 i1 x
- sql=sql+"and book_type='"+book.getBook_type()+"'";! V* v: c6 ^ L' g: u* p) ?
- }* f$ M& }2 U8 D7 j1 |2 [
- if(book.getBook_publish()!=""){1 U/ M4 v1 `5 N6 f5 E @/ Y
- sql=sql+"and book_publish='"+book.getBook_publish()+"'";8 X+ |4 z& z" L+ G w2 T& L$ w
- }$ ~7 u3 k( u3 a) N1 T. w {
- 1 ~# k D& q; ~& j, {
- try {: j4 }: D" w4 s& }
- past=con.prepareStatement(sql);0 a3 o/ A* c& M8 G$ I$ ^% [) J6 j, c3 W
- rs=past.executeQuery();
4 R& O l3 R3 h; \: R$ D3 p - while(rs.next()){% l+ }6 O: E2 B$ a
- Book books =new Book();$ Q u( Z1 z8 j$ k
- books.setBook_name(rs.getString("book_name"));. ~$ X$ r# F4 l- Y7 W
- books.setBook_type(rs.getString("book_type"));
/ c' J; `: g' G W% k& Y3 M - books.setBook_publish(rs.getString("book_publish"));8 R, f0 ^7 G5 Z
- books.setBook_date(rs.getString("book_date"));
+ A( b* @7 W, f3 E1 ? - list.add(books);% P* p# n: M# [
- }
( d( W- p) n; E/ U - } catch (SQLException e) {( ~5 w. M% c- g7 p8 u
- // TODO Auto-generated catch block
' S. }6 a4 d- {4 y - e.printStackTrace();
9 G! i! Z" `1 @5 A- |" j: E - }$ }3 a% h! O, {) d5 r6 ^, F
- return list;: a* K9 k: |+ h8 @: i( V5 Z0 g7 z# Q
- , @5 ^1 s/ j. x: {8 p% D
- }
- Q9 O3 S5 Y* {0 \. b4 u& s - public int bookInsert(Book book){
' \7 y2 }& z: N - String sql="insert into book values(?,?,?,?)";2 a' s& V; T# X$ q2 h5 o3 C
- String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};; i. I: @) m6 O! }
- return update(sql,getVlaues); " B( v# S' `" ]) H7 e0 q0 N
- }
; Z3 k3 Z! a$ T" f: `& C5 l - public List listtAll(){5 J/ s; f2 ?0 z s
- List list=new ArrayList();+ J: J# ?8 x9 {1 u7 x( w# f7 w
- String sql="select * from book";
8 z. S2 T( |* N- g - Connection con=getConnection();
; @0 G; }+ H9 ?& k. c - PreparedStatement past=null;5 M- ?2 p/ W. p
- ResultSet rs=null;
0 ~3 n8 Y5 Q: @) z, q. a - try {/ p* b# @+ b/ t2 ]. I c6 ~
- past=con.prepareStatement(sql);
- M" w$ h' s' l3 c: L2 Y3 n |* ? - rs=past.executeQuery();) A% D% H# ]% l1 \4 V
- while(rs.next()){
3 h! ?0 N; M+ I - Book books =new Book();
U" l( }4 D, ^ - books.setBook_name(rs.getString("book_name"));
v- l/ K9 o7 U! [7 H4 O - books.setBook_type(rs.getString("book_type"));
h+ U5 o! e; o" |9 [. e - books.setBook_publish(rs.getString("book_publish"));6 D9 B5 P% Q8 S% `2 G; @7 U. X
- books.setBook_date(rs.getString("book_date"));
! w' v2 n+ U% d2 N - list.add(books);
|- J9 K6 l5 z+ D2 T8 B - }
& E& V3 A# K/ c - } catch (SQLException e) {
% J% }5 Q8 G' r0 W - // TODO Auto-generated catch block' s, I* r& {- ~+ L8 ]
- e.printStackTrace();
6 R2 b/ ]" Y% Q3 k& b7 \+ g- o8 K$ V - }
* f8 ~* y0 ^- A, [7 B - return list;/ r9 h! q7 X, Q
- 9 ^$ f6 x% l! N/ v
- }
( N3 t# r7 U2 D! R) J3 a# ? - }% N# Q) P% J1 h$ v2 G% R% O
复制代码 源码下载地址:点击下载5 g% m: h; c; Z' h2 H
" _7 d! s; e* v6 @" g) D
& d, L$ p) H2 N7 y; ^$ r% e |
|