该用户从未签到
|
- package s2.jsp.zhangxiao.dao;
, K d$ F- y0 Y9 w( ?2 J3 y - import java.sql.PreparedStatement;4 ^7 s0 l! |- b4 R
- import java.sql.ResultSet;0 P+ x* B8 f: K: d6 M7 ^* V
- import java.sql.Connection;
t, e* b4 F4 u- C, | - import java.sql.DriverManager;
/ d5 q2 g/ ^ O: Z8 N- A+ N/ L0 A - import java.sql.SQLException;" D& A3 w9 j7 y; c% F; [
- import java.sql.SQLException;
* ^8 C$ b5 x' `% \
( |6 g8 o/ x% D2 I- % ]- }2 L/ S/ [3 K
- 1 ?. I4 U- w$ _& r5 P2 O) j4 g, r
- /**
' P# S) O+ m- }9 w5 ` - * 连接数据库
/ L. ^5 y& m# ]2 W% S: T - * @author student1) i) l0 y4 M1 o: J2 v
- *4 `4 E1 K2 l2 R" l% v& H: F% [
- */
$ Y q2 J( w) s/ L. S7 x/ u- R9 b( b - public class BookDao {
: X8 b1 T4 M8 h- z/ [. H$ A
0 e( d O% Z& I- h6 z: Q% Q- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
! H" D3 U. }# \ - private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";
8 H) G4 U0 b+ ~+ J - private static final String DBNAME="sa";
5 Z8 w- m) O* }' i4 T* Z - private static final String DBPASS="1234";
& t. `7 I S/ U: j' i - 9 f2 g, j. C7 j! \- T8 H
-
' E* x1 D7 v$ d6 K - public Connection getConnection(){1 P" I8 u9 X& G0 L
- Connection con=null; y7 P7 |/ a& S1 }1 X
- try {8 W$ x: ^: P6 t6 G+ U/ Z1 d# s( T
- Class.forName(DRIVER);
) j/ ~& i: q6 l1 f! J - con=DriverManager.getConnection(URL, DBNAME, DBPASS);0 ^' h1 A+ O1 ]2 I) {
- } catch (ClassNotFoundException e) {
' b' F* ?( C# }) C5 J1 V3 b# G - // TODO Auto-generated catch block
* O% }7 J. `% `$ ^1 M1 o4 X - e.printStackTrace();& t: S; F$ b0 e. F
- } catch (SQLException e) {. B. `7 i; J6 G$ K* [" ^
- // TODO Auto-generated catch block8 P2 S1 F3 ?% N/ @3 w; S% D' u9 M) ?) ]
- e.printStackTrace();
' `1 \% W) T( M: O# \- Y. k - }
2 C5 B$ F5 Z/ l8 ?* P# c p/ _8 z - {+ i1 y# k, N5 J: m
- return con;9 |# C: P5 S9 O, @- m1 ]' R" @
-
* q( f* L( I2 i* k$ L: k3 g - }" T( K+ y% {7 }, X
- public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){
4 ?/ c1 x1 r; n M - try {
Q% X5 l0 }' S1 }+ P! g - rs.close();
; e6 G ^) z# H5 }; Y+ B: C+ Q - } catch (SQLException e) {
! ^( v- `8 I. o1 G - // TODO Auto-generated catch block
" X& S. l* a) r/ r$ n. _1 M' d - e.printStackTrace();
( R; F1 n) {# `" j0 K6 Y( A - }. h, p% x2 t1 B" \" S% K
- try {* a6 ?& S! W$ c2 b& y+ S
- past.cancel();
3 h! b0 _- {5 I7 r5 ]% K* H - } catch (SQLException e) { [5 g2 K$ |' o9 z& N
- // TODO Auto-generated catch block/ \; h% E5 d% H. c' I" T
- e.printStackTrace();
0 h! d7 D& C: W* ^9 k3 Q - }- a* M ^! g, K+ i$ V1 e% w) i2 b
- try {
, ^5 ~7 \4 b/ L9 v6 {, G' ~1 V - con.close();$ Q# G; Q& I% J+ u9 F D7 j
- } catch (SQLException e) {
4 S" o, J/ G% p - // TODO Auto-generated catch block; s& j, a8 J0 Q. ]* y
- e.printStackTrace();
8 U- y5 ~( z& X: ^3 n - }- h2 [- ~1 F+ T/ _8 T2 D7 ]
- }8 e. X# X+ i% ]
- 1 b) w! Q+ s, j; ~
- public int update(String sql,String[]getValues){
4 S: V. }# U% u& W2 d" e - int i=0;
1 ~! i% \$ U0 ~9 n - Connection con=null;
* r- J$ l6 j6 f6 q' [ - PreparedStatement past =null;
' x" E- U9 Y/ y9 W4 T2 l5 T& ^7 S - con=getConnection();
( {5 z) o b; C - try {
4 v' P1 k6 G P! f; x( J6 f8 k - past=con.prepareStatement(sql);* m7 k9 A7 W8 f4 `$ q
- if(getValues!=null){
8 w/ b$ X2 y, n& u9 h9 e - for (int j = 0; j < getValues.length; j++) {
" [6 A2 I. s* k% `2 R6 `6 ^: e, @- M - past.setString(j+1, getValues[j]);
. l! m4 n# D( O8 p, I - }
6 i9 U, e6 ~& Y Z8 H: c - }
; `# ]/ s! D6 g' x& H - i=past.executeUpdate();
: C0 W& b$ m$ \9 P* [* \' k( F - } catch (SQLException e) {- D$ z; P7 L7 R4 o7 p
- // TODO Auto-generated catch block
( Y+ [% p1 m; `% _; H" U* a - e.printStackTrace();% _1 {4 n" O2 U }$ S/ O3 B
- }4 Q" c0 z. R) m6 L$ k9 e3 a( p
- + v/ e& a4 c t0 e5 ^# V
- return i;2 F) B- l7 L8 N! h* ]
-
4 q9 s: E7 c# `: J7 x3 e/ J - }
0 l. p% E" I4 U+ n5 H% b - }
N9 R/ H, U- g5 [8 P' Z6 K
复制代码 * s/ u6 t) u1 y8 N) {" ^
4 c7 t7 _; f- G. P- h; |
- package s2.jsp.zhangxiao.dao;( ?8 i" v* b5 m# ~4 h0 C' H
7 H3 |' [. W, [8 y/ E4 L' h- import java.sql.Connection;
% `% U9 A# v" S; P9 t4 N - import java.util.ArrayList;
3 m" |4 P! U/ S/ a( B3 Q - import java.util.List;
' S: V$ _! K: f. @) P - import java.sql.PreparedStatement;! [/ g: P4 z1 h1 c0 z
- import java.sql.ResultSet;3 o# V3 [* B( r- {
- import java.sql.SQLException;
2 c3 e2 R( p* }! ^. n; b - ) a& C! ?- k8 F) Z( H
- import s2.jsp.zhangxiao.entity.Book;3 @+ z, l( d' ]7 U
- ! \! F" V" q* l% ^
- public class BookImpl extends BookDao {3 N4 N- S* Y# X* m }. l
- ! C1 z# D3 k" |/ F3 Y- e% o; C
- - w/ Q$ K% _) T
- public List bookAll(Book book){
" C: ^ u+ O9 Q( w* h$ M& i) }6 J - List list=new ArrayList();" ~1 O% D+ C" `- p$ X9 ]" W% a
- String sql="select * from book where 1=1";/ Z6 _1 m. R/ O; C6 }; O
- Connection con=getConnection();3 c8 _: T- K& B" p* x9 c
- PreparedStatement past=null;7 f3 U, q8 V6 q# j# v
- ResultSet rs=null;
) Z, i0 a0 k. o9 {, p; ^2 [+ Y - if(book.getBook_name()!=""){5 p2 i6 k v& V$ \: Z9 v) J( M( ]
- sql=sql+"and book_name='"+book.getBook_name()+"'";* l+ p: n" R1 g* ^1 f* b6 T3 F
- }
( {. e4 F" S0 { - if(book.getBook_type()!=""){
9 h4 V/ T& J$ { - sql=sql+"and book_type='"+book.getBook_type()+"'";/ r: n! R+ v$ J2 t. S# W
- }
% M8 _ [; T; t6 ]4 e - if(book.getBook_publish()!=""){& M. J: w( L7 |3 o; b
- sql=sql+"and book_publish='"+book.getBook_publish()+"'";
G7 L) d, u, N, u$ k# ^" L; [ - }
# [- S, _) t6 b; J -
- j8 e5 D* p% d4 V4 P$ B4 P b - try {
1 C: J, J( W) k P& w7 C! h- J - past=con.prepareStatement(sql);
& f- z8 U5 S" E- X/ Q$ E - rs=past.executeQuery();
" y3 {' ?8 l7 j* I4 F9 ~' p - while(rs.next()){
7 A0 e- h. K+ u$ b; l - Book books =new Book();
% _" Q9 Z; v/ e# G8 n/ v3 X - books.setBook_name(rs.getString("book_name"));2 h, O u( \# ]6 ~- Q% H, X+ u
- books.setBook_type(rs.getString("book_type"));
% U0 D/ o8 p5 N. R0 | - books.setBook_publish(rs.getString("book_publish"));$ a" Y' R' T( n
- books.setBook_date(rs.getString("book_date"));6 d% T+ m8 c8 O6 L' z2 g& t- O
- list.add(books);
' z* [4 G. E! X/ Y* e) F1 c Q' h - }
6 ^3 a/ f# }/ y - } catch (SQLException e) {* L4 i. J4 m% h3 B9 ], Y
- // TODO Auto-generated catch block5 m$ h C" ?8 q$ W2 S% _* b
- e.printStackTrace();
/ `( Y* ?/ g0 d1 ^8 R. b - }
$ \ x* R9 y; p" `& d9 `7 Y0 Q - return list;
' }; r3 X( S% l - / G( U' L% U# u
- }
* j5 S/ @, b. e$ I2 J - public int bookInsert(Book book){: k% f) @& w+ \/ f
- String sql="insert into book values(?,?,?,?)";# x9 ~% t' d4 y9 {
- String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};
/ i( t& g2 S+ p- u! Q - return update(sql,getVlaues); " B: c1 `; K# b+ P0 D+ q; w' y+ v
- }
* n5 K; y& i5 ^/ h w( S( o - public List listtAll(){
9 g) r+ p( [0 ^9 O+ K - List list=new ArrayList();
0 @( O' F) t# l+ z0 X - String sql="select * from book";
|& [ l! W- Y4 C+ T; U - Connection con=getConnection();
( K8 `; J$ W- {, q - PreparedStatement past=null;3 D! O# e9 y- l1 e6 ?1 B7 r
- ResultSet rs=null;" |# x- s; ]4 i; h# P
- try {' u i' E |! L' P1 |$ @9 g
- past=con.prepareStatement(sql);3 `- E8 G/ t0 z2 r$ ~" z* g7 ^3 X
- rs=past.executeQuery();
/ z7 g# M7 W/ f# q2 ~1 A - while(rs.next()){
0 ^# d& m+ f5 K4 e/ N' k; Q" s - Book books =new Book();
R+ ], {8 [9 x; F7 m7 s - books.setBook_name(rs.getString("book_name"));
" m- N' \- _$ f Z - books.setBook_type(rs.getString("book_type"));
: w- Z, K U' i7 A& u! N1 \5 v - books.setBook_publish(rs.getString("book_publish"));3 ?1 W" D) c+ ^$ f. H, e; S6 a
- books.setBook_date(rs.getString("book_date"));& Z* {# w: B$ M% k& f& u
- list.add(books);0 t0 V( J6 z/ w( R3 n+ O6 x8 _
- }
' |5 ? M) K- f8 o+ Z8 y/ o' r - } catch (SQLException e) {
) o5 W/ ]; o1 n$ q+ a: ] - // TODO Auto-generated catch block+ T$ ^( M' {9 {; Q) H4 L
- e.printStackTrace();9 c* w+ Z# v4 c: f ~2 C
- }, o& s! j2 K/ \/ w2 T3 o
- return list;
7 m, x8 k8 J' b: n -
' ^$ ?% X6 t+ C# ? - }
; c$ G; r* w8 W' F+ E - }% P2 G. Z% {! z& y
复制代码 ; ~9 Q- `- v! ^7 P5 b" c4 m8 T3 A3 f
' }2 k% [5 z) c" { B+ R2 N W" y, K* p/ i2 V s& A8 K( u& _
|
|