该用户从未签到
|
- package s2.jsp.zhangxiao.dao;
% y0 @2 ]9 N6 i* Q. t1 f' A - import java.sql.PreparedStatement;
5 b/ X& k3 S8 H5 a - import java.sql.ResultSet;
4 I; Q- _8 G+ ^5 y- y, { - import java.sql.Connection;' X) n: G4 w4 l
- import java.sql.DriverManager;
% H% b; c* @- b5 w0 L - import java.sql.SQLException;
9 {$ b; z2 P$ a: ]9 C: M4 L# l - import java.sql.SQLException;
# a8 s# ?" o# F* y2 G - : B6 h9 e2 Q' x6 ^
- 1 m, A L. h2 @2 u
0 s8 _/ b9 p/ l0 P9 o# J/ U5 j- /**, K4 ?$ @) H3 z
- * 连接数据库
% z$ Q: C: |+ J - * @author student1, s1 u+ ]! O% j$ a: ?8 S% Z9 D
- *
( b3 F! r$ ?& `$ i- C7 \2 T - */3 u8 i% R3 P- D: V+ W. X' n; X
- public class BookDao {
" u4 \+ e4 d- n& \) G" Q& N: I, r& `3 M - 4 _% b- }1 k. k t
- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
1 a3 \+ O8 I0 f6 G2 b9 p - private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";
J" l( ~' {* v$ q7 R - private static final String DBNAME="sa";3 q3 L' ~( b7 E& n, D7 F# Q
- private static final String DBPASS="1234";1 a" }, |1 C9 f
-
4 y% Y1 P) ^. ?3 T& |7 s - : w' U) E2 x" w/ Y
- public Connection getConnection(){
4 y7 @$ |% M+ y# m0 y - Connection con=null;
5 Q L/ t7 F4 i' O1 R% x - try {, a8 v+ X7 ~8 b) u, ?, }5 @/ P7 S
- Class.forName(DRIVER);
8 S+ l" j. K& Q4 N+ { - con=DriverManager.getConnection(URL, DBNAME, DBPASS);/ p6 L& U7 p! ?0 ^
- } catch (ClassNotFoundException e) {3 M. ]" C# l( P' A
- // TODO Auto-generated catch block
" t' T3 |* Q& t: m1 M. L2 ~ - e.printStackTrace();6 s- \* b; }4 g- ]# W, ~# i' a
- } catch (SQLException e) {
) _$ r# z4 p; G' n _' ?* D8 S. h - // TODO Auto-generated catch block
' {' x2 [ d: i' q6 W - e.printStackTrace();
! D0 q! m2 U8 U" {5 T$ x" f) c - }8 P5 K( W4 W8 [5 [* x9 z
- 7 \$ R, g+ t. A) m. Q- y- ~) n% I3 K
- return con;3 G1 m: i5 L8 D" x; N5 d: n: h
-
# |- ?% m4 ` K& \8 o1 @6 P - }. [6 l4 X0 j4 q* \$ P% o: t
- public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){8 b$ w0 \, Q" H0 b' W8 _" z0 w4 U
- try {# R5 U8 l" ^) p% Z5 z
- rs.close();& G1 D b, d( H8 H- J7 F4 f
- } catch (SQLException e) {
/ O2 c2 R- x% ^9 T5 ~. z; l - // TODO Auto-generated catch block, v/ Z, X* O; y& M" n& S0 l
- e.printStackTrace();# w, o1 ~, L' O) G% A
- }
- Q2 a ?$ U2 Y% n- j - try {
$ I: {' _0 B" ^: Y- v - past.cancel();
3 D, P: s) a# ~3 N! p* x - } catch (SQLException e) {
6 ~% B& u' t/ S u% b - // TODO Auto-generated catch block7 R* R7 B9 P2 U
- e.printStackTrace();
2 W, o2 Y0 ^! f; p2 U) Q" R# d1 k0 ] - } O, s% l3 ~; ]3 _- U
- try {7 O& S# U- s' g; m6 {0 ]/ i
- con.close();
6 ^8 }: K$ X" b# x- z - } catch (SQLException e) {
/ i$ k; k, N- S: Q( w) h$ C8 G5 j - // TODO Auto-generated catch block
# K* p; a# W7 p - e.printStackTrace();/ b; e4 N! z e( g
- }9 M" u! Q( Z& u* s" M/ T: H+ _
- }
( j5 a1 { Z) L7 D( M N* O -
; i: P& ]0 Y$ x8 o2 v9 s - public int update(String sql,String[]getValues){" l+ K$ M: G. h. _& k
- int i=0;+ N5 ?! P! ^: v. Y! R T, O
- Connection con=null; r0 _& ~; T4 y. k1 }
- PreparedStatement past =null;3 O/ h8 b: b. q0 B; P
- con=getConnection();" g3 f8 a0 ^- ~& T" t. D3 ]+ J
- try {6 N$ {, W$ p. ~: [& W
- past=con.prepareStatement(sql);
: I: A8 o% Y# C. {2 z" y" T* L - if(getValues!=null){
+ ?6 {2 v- s6 W - for (int j = 0; j < getValues.length; j++) {2 N/ Q5 y1 t8 B. A
- past.setString(j+1, getValues[j]);
! O" v2 \, H( _3 \ - }
) G9 n. Q+ v t4 M - }/ O1 C3 g. p& r8 P# L0 x
- i=past.executeUpdate();
; n1 G" l( A3 y* i0 A% ^8 X. G - } catch (SQLException e) {8 X5 b. f* F2 p# `+ e6 a1 p
- // TODO Auto-generated catch block
# ?: M" ~ v$ Z# z# |- i) ~! X. k! d - e.printStackTrace();7 N7 }* {/ @3 ]0 _4 E4 Q" q
- }
6 {6 h8 e1 u8 ~( k+ y1 a1 _ - 6 R& S# X7 B8 @7 @% @
- return i; H. X B1 g4 D2 ~5 ^3 H% n
-
9 e W% H* P& x4 {% J J - }
/ j" g- J1 ]/ G4 t6 j: i$ Q - }
. ?5 ?' U3 D. n& y
复制代码 7 }& J1 r- I7 v
; H! r* J1 q \$ s# z* [- package s2.jsp.zhangxiao.dao;, g4 O% w* n6 ?: x0 G: T& F
2 R; o7 B0 v+ P9 p/ }! b/ X- V$ n9 S- import java.sql.Connection;
8 G( b y, d0 @* v$ T! V# T& X - import java.util.ArrayList;
! E( Q" q# G: f. ~: e7 t - import java.util.List;
" W0 G- r1 Y g - import java.sql.PreparedStatement;! q2 ^1 h! o4 x6 A* Q8 }' X
- import java.sql.ResultSet;
8 Z" x; Z Q' ~% {- A: m: ^; @ - import java.sql.SQLException; \* f1 I+ m* u* W0 s' _
3 S% g X0 f+ J: E& j! t2 M- import s2.jsp.zhangxiao.entity.Book;* ~ B0 X y- {& {! K3 S) K
$ _$ N9 G, V' w) U- public class BookImpl extends BookDao {
# s0 G$ c7 i9 M
( t5 S# \7 f3 b) j- 0 j) w7 {. g' Z4 s% A7 W
- public List bookAll(Book book){$ ~ S) |* O" k% k% [6 [
- List list=new ArrayList();/ f5 p$ s9 Z' e$ `- \% a& B
- String sql="select * from book where 1=1";7 d; a) g _9 y# x4 V
- Connection con=getConnection();6 [% a8 g/ \+ v
- PreparedStatement past=null;
9 B/ o( ]" P, p% {6 ` - ResultSet rs=null;9 M+ i6 m/ n) s# \* s
- if(book.getBook_name()!=""){4 U* L4 Y1 `: t$ p+ S
- sql=sql+"and book_name='"+book.getBook_name()+"'";
. j' r4 {5 z% Z6 h7 L+ Q, l4 p9 v0 u) D - }
. | g: r1 j4 L4 e& R, t - if(book.getBook_type()!=""){
. r( S, Q. l1 U1 ?- K. w: n - sql=sql+"and book_type='"+book.getBook_type()+"'";! n- v2 u2 W! n1 x+ {8 B4 K. d, D b
- }, B) J) M, L8 i' T6 ?5 u
- if(book.getBook_publish()!=""){
" x/ F/ A% f& f5 O9 [" l# @1 O - sql=sql+"and book_publish='"+book.getBook_publish()+"'";
& Z8 g s7 b; c7 W2 f - }
/ F8 e( x( h7 W( ] - 4 d( P8 G8 h6 A P
- try {
+ Q$ X) ?& m3 E5 s n! Q - past=con.prepareStatement(sql);
% u, q" v4 a- t5 } - rs=past.executeQuery();
. Q* M- \! U" ]! U - while(rs.next()){
0 G7 J* G( c: A+ {) i9 M - Book books =new Book();/ f( `7 m0 t7 q1 ^% \
- books.setBook_name(rs.getString("book_name"));: \7 Z5 G7 \& P7 {# g) `3 N- r
- books.setBook_type(rs.getString("book_type"));
3 U( _: i- e. e: O3 S8 M - books.setBook_publish(rs.getString("book_publish"));2 ?4 i2 R, P( p& R2 B) j2 S: U
- books.setBook_date(rs.getString("book_date"));! v1 U2 k. b$ f j$ K5 o' }
- list.add(books);/ }! E0 E1 f2 B+ G
- }
, n" w8 E6 \3 f' y4 Q7 G5 g - } catch (SQLException e) {' }9 i _' N8 J% m/ q V
- // TODO Auto-generated catch block
! |3 T7 m5 J$ d7 Q - e.printStackTrace();! L: S% }; c8 k; k. P/ V
- }
# g2 c3 d7 |/ s* f3 S3 V - return list;9 @' E8 m1 S6 L
-
9 p% W* x" v0 Z3 I3 J7 R: @! i5 q - }) H4 |/ P, c) g: t: u2 G$ ?2 {" L
- public int bookInsert(Book book){8 B P/ G1 W/ v K; T* w$ [
- String sql="insert into book values(?,?,?,?)";6 Y7 r, k) f# t6 x4 e5 q& ]
- String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};
5 r) _4 C# X# j2 }* P - return update(sql,getVlaues); R2 X4 h' d% B+ p7 D; D6 q2 h
- }0 m6 B3 s; Z2 R0 g7 P
- public List listtAll(){! P5 z; ]" q+ T9 G% K
- List list=new ArrayList();6 n- W, h2 M' }" Q/ t' z- I
- String sql="select * from book";0 P* R9 c# N8 \# V
- Connection con=getConnection();
; `1 i0 b8 P% _! d4 d9 E7 G: o - PreparedStatement past=null;
! |4 V$ X& k1 K( G2 @( o2 p - ResultSet rs=null;# O0 z# T* h/ X, |" v2 _! [0 @
- try {1 J6 w2 g+ ], ?
- past=con.prepareStatement(sql);
9 i. t# T- }7 K1 f& N2 U8 E8 d8 q - rs=past.executeQuery();2 L/ T( ]; i* q$ {, }
- while(rs.next()){$ @& N: R+ ]0 v: M2 w
- Book books =new Book();
: ?: p- h+ v r0 K* j8 D1 l2 @/ r k - books.setBook_name(rs.getString("book_name"));- c4 @/ P* e8 ^9 U$ \, p0 h8 G
- books.setBook_type(rs.getString("book_type"));2 f0 s' t' x' M: m5 O" i
- books.setBook_publish(rs.getString("book_publish"));
. P: A, G, t* \5 ~6 r - books.setBook_date(rs.getString("book_date"));4 \: V4 S9 ` d- E, H* X
- list.add(books);) ?6 F- k G! ^
- }6 j1 B+ N' d) W# t% M% L, H4 W
- } catch (SQLException e) {
% V; M9 |7 o% X8 t5 Y# z - // TODO Auto-generated catch block7 `4 y7 O" F9 I+ ^' D# M) i9 X
- e.printStackTrace();
3 N! L% u/ o5 ?: J9 L. [! ^4 F/ L8 H - }8 Q3 I# l' ?3 G8 T
- return list;
+ m# c. Q" _% W4 Z -
+ g$ d' A/ M1 N# Y( l& c - }
: |3 w" k' R" I3 ?4 o1 n8 B - }
/ L3 B' \) s: M' ~- A
复制代码
* M9 b/ e1 U$ d: W
9 p6 }) p3 W# w4 M4 Q* _( p$ ]' y' p7 r
|
|