该用户从未签到
|
- package s2.jsp.zhangxiao.dao;+ H7 b& g7 ^, A7 V
- import java.sql.PreparedStatement;, ^ F% P, a% `5 [8 G
- import java.sql.ResultSet;) f- w2 n3 \2 Z# `
- import java.sql.Connection;- m) ^# a& l; E; j
- import java.sql.DriverManager;
1 S( I8 _1 i+ Q( U' q - import java.sql.SQLException;5 K) }9 q! u0 Z; V; M2 R$ w2 g
- import java.sql.SQLException;- T$ e7 N1 q( U- n
# Y8 j: N, p7 U! m. f+ A2 ^
) F# q. E) Q, C; Q; M4 q7 Y& M4 y- ; K- p( X" }" }: Q% a. F
- /**8 v) i4 W2 e% i+ M% C1 X. V, D
- * 连接数据库9 M" g1 h( c+ l4 z7 R- {
- * @author student1
2 [6 D9 L$ p4 n. d - *+ F. |% l7 R! l. v% x
- */
' U2 i4 g) d" e! u4 m4 u8 E - public class BookDao {
. F' v! f. g3 a8 F: \* a4 G" {/ E
' C1 I4 p8 M3 d7 a- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
( H1 _- V& u9 _, T4 { L - private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";
~- f B3 u0 J- X - private static final String DBNAME="sa";' I. K& y2 v5 j9 H) q
- private static final String DBPASS="1234";
4 ^. b8 H# D. Q9 X& q- { - 8 e. E! O% ^; e) u$ N/ Y1 W* O
-
9 }5 a; j8 e* @1 q7 d# O - public Connection getConnection(){
8 n8 S% F9 F" Z+ R; F - Connection con=null;" k9 {; _! U/ d, k. G" g
- try {
) Q1 u9 o1 J2 j2 `) o% P* C - Class.forName(DRIVER);+ v% }) ~ D" s! l; B0 O4 c9 u
- con=DriverManager.getConnection(URL, DBNAME, DBPASS);
! @' j4 F# Z1 z* c: k& `; L - } catch (ClassNotFoundException e) {0 G5 B8 S" V! R2 F% m2 H
- // TODO Auto-generated catch block3 p& D- t, s9 S: U- N5 t# X
- e.printStackTrace();
1 F* n2 `. |( R, c2 e, H( y - } catch (SQLException e) {
: n4 \, r- q! t$ M& q7 ~ - // TODO Auto-generated catch block, c3 d/ t- U( H }/ ?' T
- e.printStackTrace();) R% D5 L# U' P' T
- }
8 \% r4 y/ A7 N: D( m5 V; C - * R7 U2 h$ ?+ u, W8 U" ^
- return con;
% O! |; H/ V# ?$ {# Z5 U -
( w0 I1 ^! ~/ ?& A, Q/ M - }
" s0 r% j3 s. F5 \3 b( t$ v - public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){
% {) i1 r/ U: h- ~# f# t2 z - try {8 [1 I- V; d4 E5 g j1 `) b
- rs.close();# c+ f0 m( u2 y. J
- } catch (SQLException e) {- h# \: U1 H8 u3 G' e+ {
- // TODO Auto-generated catch block, C* v6 l$ Z* X3 T+ g9 q
- e.printStackTrace();
1 Q- g! I: Y- k% ~) z' S' C - }* p% K% E1 Q* Z( m7 F, u& G' P0 f
- try {$ J- O) p1 \6 R \, w
- past.cancel();
! L4 P8 y% k7 R9 E$ c5 v/ b! c - } catch (SQLException e) {
; |' i2 W3 @+ B0 X3 h - // TODO Auto-generated catch block
2 M! D1 W! i; [ Y7 e) P8 { - e.printStackTrace();+ V! b9 l5 L: `( W. `
- }
0 q( g- }4 Y4 T5 H! g% ^ - try {
% G/ _" ]) Q$ F" } - con.close();
3 L4 Y+ i/ `( M( b: N - } catch (SQLException e) {
0 {& x c6 ]/ G x) _" i - // TODO Auto-generated catch block( V8 c5 @% H8 L& N3 I
- e.printStackTrace();7 w* q( ^$ i, \
- }) m" ]2 v8 y; C. d2 U) h
- }
" U2 h+ T6 Z' [ - ( W0 Z; J/ U9 ^; N& W" Q
- public int update(String sql,String[]getValues){3 n9 }8 e6 v9 ^ p% w
- int i=0;+ g7 E$ g# r6 m( q
- Connection con=null;
, ]: X4 z7 \8 D$ _9 U0 X - PreparedStatement past =null;
! r2 ^, s/ k9 }, b3 V! g$ g; j - con=getConnection();
# F* j2 I# _2 d) E/ F( M: N - try {( y0 s% y. @7 ?
- past=con.prepareStatement(sql);+ o# d2 z& F3 q7 D1 k7 M
- if(getValues!=null){
; R4 O# [5 P/ b7 i' e5 [ - for (int j = 0; j < getValues.length; j++) {
7 t: o( L7 H9 q W, A( ?8 f0 _ - past.setString(j+1, getValues[j]);
+ n8 G4 O) u" _% F- W - }7 ?, U; M) E) O
- }2 n( F; F% n6 Y; ]5 g0 e9 X9 s$ h
- i=past.executeUpdate();
, k: d4 A3 u' R4 ` - } catch (SQLException e) {/ g, Y' z$ W; ^8 k- M- O
- // TODO Auto-generated catch block. B( n( z, `- X$ }6 O& p) }
- e.printStackTrace();
5 }0 {& \/ y/ T' M# b - }$ z9 k7 ?/ t$ u; X# b& E& i" G
-
+ [& i: s/ E) O/ O( Q6 l6 s- k8 G - return i;. Y+ H5 }0 s/ u; E1 _2 s
-
7 ^' U+ J) h1 a/ E, S+ K9 l. ` - } f* f& X9 V. x: w
- }8 A0 P2 y5 l* k# H, G' j' p3 e
复制代码
! `% a* o' g, }& `
+ ^' @( Q I0 e- package s2.jsp.zhangxiao.dao;8 }" o2 [9 _7 m G8 Q, v* G. k9 f
a7 |: m3 q V) }3 E7 I; o0 \8 _- import java.sql.Connection;! F( ?" R$ F$ h. r
- import java.util.ArrayList;- Q( q4 n# @, o) Y8 v+ Y4 A
- import java.util.List;
% H! c" D# f3 q5 }7 V9 s! S+ ` - import java.sql.PreparedStatement;. b* @, w! q q$ t0 T- E) E
- import java.sql.ResultSet;
4 t! L, W! T' _% _% X+ z; |$ \ - import java.sql.SQLException;
* Q# N% V9 l+ n2 f2 J e: l/ C. L - 6 t$ c; I8 h/ \# _7 r/ n
- import s2.jsp.zhangxiao.entity.Book;
# Q0 b1 \2 |1 F* T7 g - * D6 B/ L3 H$ N( d- U4 }* \( y
- public class BookImpl extends BookDao {
# V$ B8 R5 @% o( R& M - 9 ~( r2 I/ Z# {' l* | k
-
0 W3 e6 ^* {: R$ ?2 h A" M - public List bookAll(Book book){, z, k1 `; I% J: k; j7 v
- List list=new ArrayList();
8 s# M/ j3 J7 o9 q% E' Z- g1 F - String sql="select * from book where 1=1";7 x& `. i* C6 G2 @9 G% {
- Connection con=getConnection();
: N; X5 P* {+ v* _ - PreparedStatement past=null;/ Z1 Z; \2 I& ~, ?# k8 G
- ResultSet rs=null;+ x, g8 V6 T8 A! e* O: i" v
- if(book.getBook_name()!=""){4 q8 f. [% J6 h/ i
- sql=sql+"and book_name='"+book.getBook_name()+"'";
4 o$ P ] _! M7 a$ B7 \, u+ v - }! v/ L+ C, n6 w0 I% U
- if(book.getBook_type()!=""){, C1 b( L' ^3 s9 D+ v7 n
- sql=sql+"and book_type='"+book.getBook_type()+"'";
3 \2 y1 ~/ w8 ~9 ] - }
( O: w2 t5 }$ i3 m- Z" g4 w - if(book.getBook_publish()!=""){$ |/ j m0 i0 S6 ?
- sql=sql+"and book_publish='"+book.getBook_publish()+"'";$ o. I8 {( E2 X! `
- }; v Q- Z l9 P9 @
- 8 z8 r$ b1 R9 F1 \0 }3 [' N! M
- try {9 H# B* g, P) i! X- t/ f
- past=con.prepareStatement(sql);" c1 [; u8 w! D1 t, O! N
- rs=past.executeQuery();( k4 m- h& R* a: G5 q7 L0 q
- while(rs.next()){' {: g5 U/ w. _
- Book books =new Book();+ R6 ^# C6 f/ \$ {, F
- books.setBook_name(rs.getString("book_name"));
, q9 x9 `' V7 A) | - books.setBook_type(rs.getString("book_type"));
y2 Z) m$ M' q - books.setBook_publish(rs.getString("book_publish"));
5 X2 E) y( j& ? - books.setBook_date(rs.getString("book_date"));" M6 x8 ~; m% {: w" C
- list.add(books);
, B2 u; ]/ K" I. ?0 Y' L7 K! x - }
$ m5 R; c! H+ K - } catch (SQLException e) {% C% a7 ~( @4 f: H( ?9 ]
- // TODO Auto-generated catch block
) H0 y+ h/ ^3 ^7 B - e.printStackTrace();
" c' V9 v: j: J) Y) l - }- @4 j- g- P4 E6 H f/ W
- return list;
1 E- [. Y* z/ C+ a O" y5 c - 7 ^. O2 p) }7 z/ i! N e, t4 k, X* F6 p
- }0 ^, F& P& v a0 I. n+ F- L
- public int bookInsert(Book book){9 n) b& G+ e4 w
- String sql="insert into book values(?,?,?,?)";
' M3 a7 O% E% y7 C j - String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};$ |9 t( N$ o6 P8 k: x5 a
- return update(sql,getVlaues); ; V- V1 O) }. S. }- c! o( h
- }
, x* @2 r& x6 w - public List listtAll(){* O( Q7 S3 W3 A$ w- ]
- List list=new ArrayList();
! o* `2 w' x+ l3 m0 h( |0 z - String sql="select * from book";. \) z2 m! ?0 B0 M
- Connection con=getConnection(); d0 O* M* E0 I) P9 z$ A. s9 {) D& }
- PreparedStatement past=null;
' U" ?# Y, ~$ v7 b/ @/ y - ResultSet rs=null;
" D) g4 b7 K8 y- V/ J \ - try {
R1 ~2 p+ r" D. {+ B* N - past=con.prepareStatement(sql);
* k! e; k5 r' w6 m d' J) Q - rs=past.executeQuery();
+ p6 W, J+ m& i8 P; d7 E0 y - while(rs.next()){
: H6 l% \7 X5 n4 } - Book books =new Book();( B& R P9 g. j
- books.setBook_name(rs.getString("book_name"));
# _$ @9 ]3 e! ~( L" |; J - books.setBook_type(rs.getString("book_type"));
9 z/ b C3 r- [1 F! L( @ - books.setBook_publish(rs.getString("book_publish"));
- F6 l; z4 l; F$ d1 d. X - books.setBook_date(rs.getString("book_date"));" q V- m F1 b9 n0 k9 ^
- list.add(books);
; I- o& u$ N: B - }
$ D* P5 r. v) X" l) w& U S5 \& g4 Q - } catch (SQLException e) {4 P; I, x( N& w% l6 p# W- v v; t
- // TODO Auto-generated catch block2 f. o9 k3 ]( v$ j
- e.printStackTrace();
) ^" K% P% q1 D" ~. n - }, n( D: T+ F/ q t4 }) P6 [' D
- return list;
* q' V$ ?, _# `2 o: F& b -
! L' u; j, C+ v! b4 [ - }2 t* h+ h1 f) {; \% x% h }7 e2 a
- }1 f0 l$ A! L( h8 @
复制代码
! V0 S, k2 D) J9 f( ^; o2 Y7 P! _1 L
7 _! `# n& R* N& b" T. [, m: J9 M4 l. l! | D; F
|
|