该用户从未签到
|
- package s2.jsp.zhangxiao.dao;* y, C: T" X! a
- import java.sql.PreparedStatement;
( Q: `6 }" A4 z% ~0 s. i - import java.sql.ResultSet;
; f* u( T, k2 b" J& h - import java.sql.Connection;
- [8 W4 t, g4 S/ h% n - import java.sql.DriverManager;5 D+ J. G7 v% l2 U2 C( t5 i
- import java.sql.SQLException;
' S7 C; J- I1 [- f - import java.sql.SQLException;
4 w7 B' {% S& z8 p, ^ - % z1 }5 v% ^7 Q, k" u
* F0 |, i1 x4 x7 X2 [( }! c- / }9 k% ~' x2 z" L3 _
- /**
) {& M' J9 U) n0 w. H) G+ _ - * 连接数据库
% x. `1 [. F* a, j9 e - * @author student1
8 c# m( S; j J# h* p' h+ ` - *
, N) r, @& V7 s) o8 V' z - */
/ `" J0 p$ L9 w1 m7 `5 h* J4 E - public class BookDao {) x: V+ j- N0 H
^4 y0 ^0 X0 }2 ?- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";8 m) F* [$ A, @, r- _
- private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";
. V) T: ]1 ]# ]2 `9 T: X - private static final String DBNAME="sa";# N6 e _) b2 V0 C4 ?3 h
- private static final String DBPASS="1234";2 G& i, }& }& t: @5 b/ L, C
-
$ X4 V, z3 b, Y+ o' r -
" e% C0 z- [$ I( {' A1 W - public Connection getConnection(){
6 K% t0 A8 u: I- o- c4 _ - Connection con=null;; e3 n3 r' \% P# W
- try {
4 w. w8 w- w x; v7 L - Class.forName(DRIVER);3 k; M- d# O% u+ v
- con=DriverManager.getConnection(URL, DBNAME, DBPASS);
5 Q% H; |) l% g7 {2 Q: V - } catch (ClassNotFoundException e) {
7 `& b6 {2 G. c3 ? - // TODO Auto-generated catch block
2 B5 Y5 y. j' \3 ?2 l* ~# U4 t( i - e.printStackTrace();4 j6 ?. Y. f& a; ]# Q
- } catch (SQLException e) {# ?1 c, \* O( y9 d
- // TODO Auto-generated catch block
) v! {( Y: ]2 L- b4 B0 C; x e - e.printStackTrace();
: B! \. k j) [; w' P0 Z - }" g; W' m# k% A; S+ `6 a- e3 c
* I% z. u4 n; c2 M/ m( r/ E1 Y- return con;
; M4 o- B4 u2 ~ -
: l; M5 N( `1 f' s1 }! D, j - }' D- b! F1 g; { H' C; k
- public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){* d% Z* X7 } _0 A& }* P0 F5 d
- try {& d5 Q5 c6 C! ]9 s! h. Z9 o7 N
- rs.close();
/ Z# d, x8 t3 v' S8 ]: _ - } catch (SQLException e) {
5 P$ S6 Y( L1 O6 E% o5 R8 o6 b( \ - // TODO Auto-generated catch block9 @9 I; G3 o* u' x
- e.printStackTrace();3 N6 M" K- M; F0 j; i7 u
- }
7 I0 t3 k# K5 I& o3 K- l, ?3 b - try {
- e, n7 P+ R1 v. f( i: d% {9 M" { - past.cancel();
) G# D: o! e- ] - } catch (SQLException e) {
" D0 r1 F* }5 s! S/ M. A7 \1 T! d2 P5 | - // TODO Auto-generated catch block
3 f! U7 ]* s/ j/ I; e - e.printStackTrace();! D$ a! ]6 y$ @0 u
- }4 t ]$ u( l0 K, W8 A
- try {
! G+ X# L& n: Y. @( E( W# G - con.close();
' c% ^- ~. L' @; f/ F4 R6 i3 i - } catch (SQLException e) {
# e) H7 ~. S, y( Q' W" t - // TODO Auto-generated catch block
% K+ F' h1 X) Y& ^: Z1 ` - e.printStackTrace();$ g1 t* i& H) v3 n4 @
- }
, X }. F5 k2 x9 v - }
8 p: b- ~. D- T' q% H e - 1 c4 m2 d7 i3 T. {4 k6 s, {1 F
- public int update(String sql,String[]getValues){* M6 B4 b2 k8 f( x- P) a8 k8 V" Y
- int i=0;5 L% ~9 p' A' m& x3 {
- Connection con=null;
9 K1 I6 \* K* W6 u - PreparedStatement past =null;8 [0 v, l3 h2 S
- con=getConnection();
9 U: B9 D; ~% ?7 c: I* o2 P+ G - try {
8 y2 X9 T( v# _ f4 h - past=con.prepareStatement(sql);
0 B9 e- R: t0 @1 ~- U7 m8 }) H - if(getValues!=null){
}! U h8 D f, ]2 Q; H8 _8 Z5 h - for (int j = 0; j < getValues.length; j++) {
+ Q# ~4 L! z" a - past.setString(j+1, getValues[j]);" ?& M* B2 c6 m$ V
- }
. |/ n/ z3 {4 _ - }* ?9 F- B8 n" O- B" D, k+ ]" P
- i=past.executeUpdate();! H6 r2 [+ [( X/ L6 F
- } catch (SQLException e) {
1 d7 Q0 m$ p: L O" } - // TODO Auto-generated catch block4 _" u: I; ?1 f; w
- e.printStackTrace();
" }" p/ y1 s$ }" e$ { - }
. t2 `1 K2 W% Q# Q8 K - / {7 G( T; S6 O* @0 }. V w
- return i;
- x. p" z: k" |& w$ I6 Q - 9 N) B. E( @7 G4 J9 o! y
- }. i+ z' \0 S% H( `, f, S' x' A& e/ `
- }/ [! F. z% W( r: x# h
复制代码- package s2.jsp.zhangxiao.dao;
# P" A5 q9 N6 P. y - - o s6 H# V* X2 ?- V$ w
- import java.sql.Connection;
4 m' Q1 I9 q9 E+ W T* n - import java.util.ArrayList;' P1 H8 ~2 E5 x
- import java.util.List;7 ]% b. S, r1 V6 M# K
- import java.sql.PreparedStatement;
! Q1 g# H% i, o, e* v$ |; ~ |: b - import java.sql.ResultSet;
" b8 M% D% @, k! O. i! i0 r6 ]& u - import java.sql.SQLException;8 j% q7 e' g) J9 ~' g6 S1 s7 q
- - N. u2 a# ~3 y
- import s2.jsp.zhangxiao.entity.Book;
* i5 Y# N& j/ M. M- i - " z. I5 i+ _: U4 D+ ^
- public class BookImpl extends BookDao {. ~2 _& _6 }, W0 y
8 {/ f/ W& V0 j9 R$ Z. q-
+ @, b& I+ `6 s5 [5 l) O - public List bookAll(Book book){, m6 w. a9 k/ ] q" A
- List list=new ArrayList();
2 w- K# ^0 ]) ], p7 n - String sql="select * from book where 1=1";
" M% G4 x& f% h( P! G/ ?# j - Connection con=getConnection();
+ h% X; u, D& M7 o - PreparedStatement past=null;* [2 n, y# H, f0 R6 @2 i
- ResultSet rs=null;
& b$ ^, X2 c Q0 G( _ - if(book.getBook_name()!=""){
6 n! I, Q! ?( I" ]& _. g! G - sql=sql+"and book_name='"+book.getBook_name()+"'";) k' G# B. ~* i% a8 B
- }
* W. q+ N4 K) ?# W6 _( E8 J# e - if(book.getBook_type()!=""){/ c9 R0 r6 F% c) g) v2 C
- sql=sql+"and book_type='"+book.getBook_type()+"'";- c" b2 G4 M. y7 g! A
- }
0 O( ]5 a# ~5 d) g - if(book.getBook_publish()!=""){
0 d# X) |, R C9 E9 ]! r - sql=sql+"and book_publish='"+book.getBook_publish()+"'";
- D2 F3 E6 R4 K/ Q - }
; R3 B4 ]% R9 G -
3 r) Q& f2 |1 L, u1 |0 g: w0 ~ - try {, N, X& w" [0 S. S; K' H6 q# v0 s
- past=con.prepareStatement(sql);
+ e6 P9 C- J; ?) S8 c: e3 J: G - rs=past.executeQuery();9 Z1 l- I' R. N) I1 C
- while(rs.next()){
1 G, l+ X! [! p" ^! v/ q% L' b - Book books =new Book();
: P8 S) L) T% e) A$ F/ { - books.setBook_name(rs.getString("book_name"));9 X; I! l0 P# i1 \
- books.setBook_type(rs.getString("book_type"));
, d5 P/ ~1 B1 D. \' W$ u - books.setBook_publish(rs.getString("book_publish"));3 z p0 U W& E+ n' q$ ~% X( u( x
- books.setBook_date(rs.getString("book_date"));
' g) d0 K7 J, \9 R W. J5 _ - list.add(books);
! R \% D( i" I7 I+ T% X6 D - }
7 R: @; |& o# K1 { S6 O - } catch (SQLException e) {
- h1 J0 o9 d; r- A0 V - // TODO Auto-generated catch block
1 [, @: _9 h0 E% f" W - e.printStackTrace();
8 z2 I# J8 F i4 E( f8 I" I - }
8 O# R6 s+ r6 D$ A' I" E6 z - return list;
3 o! \4 W. [, R8 G* D; f) x8 d -
$ d; G P" j, {( f/ A - }- k0 W5 x5 }+ i, U7 e
- public int bookInsert(Book book){
! A% n7 ?. H! I9 ?# l- ^ - String sql="insert into book values(?,?,?,?)";
# i# u+ Q, i3 x1 p" j' W - String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};
- g9 G" [1 K% ?& ?, [$ P" t; V% B - return update(sql,getVlaues); 3 a3 h$ C/ w7 m. Z& `, L
- }
B% f# J: Q# g& e - public List listtAll(){
/ t9 r' X: N' K$ ]4 s! M - List list=new ArrayList();' F' N8 g$ q3 l( K6 G3 V
- String sql="select * from book";
4 l' X, x6 I' ]- d4 w, \ - Connection con=getConnection();$ V7 c5 T9 Z' R% e V9 `
- PreparedStatement past=null;
7 A" f) A" v% z. ^. L; j - ResultSet rs=null;" C: T# b1 N k0 u
- try {
Z* v; P, i; a. `: Q - past=con.prepareStatement(sql);
7 y+ L) J9 ~: S# f' C - rs=past.executeQuery();
( H1 i5 U1 x: u, A - while(rs.next()){
7 _2 v6 |' K: S" T, P- r - Book books =new Book();/ B; i: H$ ?$ k9 U" f3 E T
- books.setBook_name(rs.getString("book_name"));8 }. M5 g" ]$ f& `8 d9 ]
- books.setBook_type(rs.getString("book_type"));
" G) a7 x5 p8 M - books.setBook_publish(rs.getString("book_publish"));- ]8 P$ L& \! `, W4 n# Y" |3 k- Z
- books.setBook_date(rs.getString("book_date"));
- g- r/ q8 y/ b! e' ^ - list.add(books);
# y0 w! Z. J% S3 o# h) p( J - }
1 S/ A6 q2 i; }6 u' ^, ? - } catch (SQLException e) {
4 V1 D: n" ]% ?8 [# i- U, _ - // TODO Auto-generated catch block
, z: I3 h6 A$ v+ c) _6 ^ y8 u# o - e.printStackTrace();
) Y* C$ Y" D- v - }
' k! }5 F/ e; I: A - return list;
4 a3 Y. I* A( L" R* { -
: `' _" V1 b6 F9 a% ^ - }
/ r+ n7 M# q$ q6 d0 D' x - }
) N6 e7 l1 D% h
复制代码 源码下载地址:点击下载
. Q( g7 e9 `* z0 C1 R
/ }* A0 s. ?: \6 |9 f4 v7 {" M/ p, O
|
|