该用户从未签到
|
- package s2.jsp.zhangxiao.dao;
7 j) C0 q4 y* o9 J: b& J/ P* U& G7 A - import java.sql.PreparedStatement;
4 B& a/ o+ j5 J2 p% K+ f: G% V - import java.sql.ResultSet;$ x* A& \' o% q& L% T0 M
- import java.sql.Connection;9 F3 W5 P- Y8 I, v5 [" @' s6 e
- import java.sql.DriverManager;& U8 g0 v. t5 G3 y
- import java.sql.SQLException;$ H) ^8 \( }# V
- import java.sql.SQLException;
5 S# n& e/ P" [8 R9 ^ - . v4 c7 T w8 P) u# l/ h* g! e( h
3 t, H" x9 ]# f* q; h6 \4 L- }# U, X5 ?4 E! W" U
- /**
* v7 E4 h. H4 e* l! p - * 连接数据库
! k. K% L- K) O( Z# h- c: e - * @author student1" L6 R$ B6 d9 M3 a) _5 a; }
- */ X7 y8 P: }# Y
- */
6 w& ~7 a7 H' a# M& \, I) n - public class BookDao {
8 u2 T- Q$ [% H& R8 T - 1 S6 q U/ }% l3 v5 F; P( e
- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";3 L9 K' i( L8 S: M0 [+ H) p
- private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";
, u+ A. Q9 C! Z4 \ - private static final String DBNAME="sa";
% p! B$ \$ P, y( c - private static final String DBPASS="1234";# k( ?8 W& q: z' C: E
- / {% X' I" ?3 P' i2 p, q* b5 y
-
; F! f6 C$ p1 _* K& f! _6 w4 o - public Connection getConnection(){
% b' J3 ?' }: o6 x i - Connection con=null;/ G$ U$ I! }7 X6 d; @& f
- try {' ^6 O: e% s( q0 m: W1 h6 }
- Class.forName(DRIVER);. M: M6 w& O) q( m
- con=DriverManager.getConnection(URL, DBNAME, DBPASS);
+ p3 z5 v6 b! `- a - } catch (ClassNotFoundException e) {) J) _( p+ s0 I
- // TODO Auto-generated catch block
6 f f) ^8 x% w - e.printStackTrace();7 _, h8 ?2 C2 D- S9 g
- } catch (SQLException e) {% f- j! H( q1 O. L3 ]9 ~
- // TODO Auto-generated catch block# @0 }& P- J5 G3 Q
- e.printStackTrace();; c/ Q. {; |2 {$ Y
- }7 q7 i0 ]! }4 u9 O
- G& j- T' [- b3 i# ^8 @
- return con;
7 Y7 P, \* V2 w, e, n9 W -
1 s+ N& j3 Z# A3 R$ {' b - }
; |! i- X% t. @ - public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){
9 q o0 x$ i" Y. [/ D+ k# ]9 A - try {+ \# A7 {& _ y4 M; B0 U/ K
- rs.close();% u3 j7 b6 h/ g" _* ~
- } catch (SQLException e) {1 ]) |8 X0 b& v* {; H& T
- // TODO Auto-generated catch block7 K. d& C' Q b
- e.printStackTrace();: k1 A" k! q2 {1 b6 w
- }* F: E: ^3 x: l: ~
- try {
: D; R/ p2 E& _4 J* [ - past.cancel();* a$ {% Q* R* M' M
- } catch (SQLException e) {- V! [/ @* h* a' D! n5 s' ~# i
- // TODO Auto-generated catch block
! J* g1 G! L7 D" H4 Y5 o - e.printStackTrace();
5 M; [! N: @' X9 Z - }* s( S1 [: T0 x# S- E+ ^# s. e
- try {4 x- T8 O( l+ h2 H+ l
- con.close();
5 x+ j9 A) z; J$ Q- b1 G - } catch (SQLException e) {
* Z0 a7 n; f6 y* P+ f2 E - // TODO Auto-generated catch block/ N9 w2 h6 {) Z( r8 D5 w; k' R" ~
- e.printStackTrace(); W1 E9 B/ l$ Z8 N9 H- E; [. \
- }: S! h4 z4 P: b4 i
- }/ b5 K* A/ B8 e4 Y/ i
- 7 @. X& X) H/ y. }( f4 G1 O
- public int update(String sql,String[]getValues){1 ?$ Z6 H) A+ s2 c/ s4 W
- int i=0;
% o% c0 } `% H' _9 |6 z/ }- d - Connection con=null;
! ~) [$ m$ F/ W m9 c - PreparedStatement past =null;
& }* E- ~( c( B- o - con=getConnection();
% |5 `/ l5 C: g' j, o5 `& U - try {
" h+ o# x6 ?1 p3 y6 [ - past=con.prepareStatement(sql);
/ S8 G) `! p; s8 P2 C - if(getValues!=null){
. a/ B5 \! \3 d1 l+ x - for (int j = 0; j < getValues.length; j++) {
6 p9 C% K* F# Z* x - past.setString(j+1, getValues[j]);
+ L7 J6 M3 z* d' p0 ] - }! y' B( T6 z2 ~* F- g
- }
- z3 o* w7 e3 g2 L1 @( z. G% x - i=past.executeUpdate();
7 O4 A& q5 ~& o% j. N3 D/ A9 B7 W9 D8 [ - } catch (SQLException e) {
) g! ~. w5 j6 W3 n3 d& ]7 a8 y - // TODO Auto-generated catch block7 u" L6 B0 v, V) w& l
- e.printStackTrace();/ `1 C* ]6 W* s2 r; e
- }
+ Y( S4 o: B6 U - , G+ n: b7 k2 J! p6 d7 ]! O% U( n
- return i;7 L, c2 [ O8 y) S+ P. u
- ' x7 K, [1 d7 q9 N# Z& r
- }
5 d$ Z. ~' }4 [2 S/ {+ E - }
. _! Q, {/ I8 v9 ?4 p7 @* T' G! p& T* ~
复制代码
7 }5 X' u5 C i6 H8 m1 z
1 l6 Z) K; j6 n5 e- K1 ^- package s2.jsp.zhangxiao.dao;* h' z* d" I3 O& {
- - P) O3 G* Z6 D b# [' E4 S
- import java.sql.Connection;. i) x5 b9 |) n3 O8 ^! Y( @
- import java.util.ArrayList;- E% Q5 j( D& Y! \8 W& I
- import java.util.List;
) n# z: Z4 i0 M' l - import java.sql.PreparedStatement;
8 @4 a3 h0 i7 o* @% i; m1 | - import java.sql.ResultSet;
3 v5 @1 `0 p0 k* G1 |2 y - import java.sql.SQLException;. j S, j$ F# L$ T& v) t
- 2 l* o9 B% L; `1 \$ u0 C
- import s2.jsp.zhangxiao.entity.Book;0 L, ^. ?5 T+ y+ E% o
- ) ]# X7 a8 t( V
- public class BookImpl extends BookDao {; \. ~3 k" t) o: Z& ]4 K" v. h
- 4 m) w3 @1 K" C; E# M
-
9 ~2 W `9 m# t6 K0 s% [% r! s - public List bookAll(Book book){
& y; N" J* K' B I- [% g3 } U( @; K* u - List list=new ArrayList();
7 t: R5 v( o. {# ^- D - String sql="select * from book where 1=1";
, d5 {0 X3 _% Y$ L - Connection con=getConnection();
7 m6 n. g# g. ]0 u0 M; f - PreparedStatement past=null;1 w( `# v" I+ ~/ t- M
- ResultSet rs=null;
4 f6 I5 _4 { ~+ Q7 J6 s - if(book.getBook_name()!=""){
3 w8 K( F* z+ e6 m) P2 ? - sql=sql+"and book_name='"+book.getBook_name()+"'";! u. }7 g# h0 D7 j$ b$ S3 g$ j
- }
$ J. Z! h. [0 ?. |$ B" k! E - if(book.getBook_type()!=""){1 `8 r3 g* }7 z; T' a
- sql=sql+"and book_type='"+book.getBook_type()+"'";3 w3 q' L, q# q! Z |2 H1 v% B
- }
, R6 R, C( p8 V6 L - if(book.getBook_publish()!=""){/ c! d# h+ G" h" T' j: Q6 j
- sql=sql+"and book_publish='"+book.getBook_publish()+"'";+ ]5 B) l/ ^' S. {2 P: }, n
- }% t. N- Y; W$ c3 ~# h
- + X2 ~2 e5 }! t. U3 Z5 R- N; o
- try {
t1 X+ F1 _. I N) R; n! } - past=con.prepareStatement(sql);
/ ]' R1 O! }- D5 _. Y - rs=past.executeQuery();8 |( t9 x$ }1 Q/ Y
- while(rs.next()){2 G1 {; I& b6 ?! d* `
- Book books =new Book();
* s; N: } o& {$ D- [ - books.setBook_name(rs.getString("book_name"));. J3 u; r+ I3 N( M6 l
- books.setBook_type(rs.getString("book_type"));
, R; n; {" M; v. x, U8 ]1 y2 h - books.setBook_publish(rs.getString("book_publish"));
& I& j1 p! H1 f9 H - books.setBook_date(rs.getString("book_date"));# y" w* {# W$ n
- list.add(books);+ _% J- x _ }* [! h& ?2 v3 c
- }! B6 u$ w8 ]+ ]) W* b2 O1 j4 R
- } catch (SQLException e) {
0 l8 m4 u0 T" _4 p( j- F# s$ m - // TODO Auto-generated catch block
/ S) R' _( T0 a$ m* m0 o. ^$ ^ - e.printStackTrace();' ^3 Z$ j. ~1 Y) P8 Z1 v
- }1 A. W) \- b& z0 S% H
- return list;
: ^* S5 Z3 M L0 `- G5 v& Y B$ } -
6 f( @% R0 K; G2 T# k1 S. B - }
9 f( m. |& u7 t5 M - public int bookInsert(Book book){1 k% c; w) K& s5 I" C$ b
- String sql="insert into book values(?,?,?,?)";$ b) t' L2 c; k2 `; R3 r) j
- String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};
$ I1 R0 o! [+ r& e& ^. t - return update(sql,getVlaues);
# \1 u: [7 v$ K: j - }
, G& Q) m, Z% @+ M c - public List listtAll(){
4 t% [3 S5 |8 D: O9 b( M - List list=new ArrayList();
2 y1 Q+ j" s: P0 A+ g) Z. \" ] - String sql="select * from book";, _& \/ v$ i* Q+ X1 |. x' U
- Connection con=getConnection();
I0 p6 ?% a5 e - PreparedStatement past=null;7 Y1 I, l8 `$ P" u# V
- ResultSet rs=null;
* s# U3 ?0 Y2 r0 r7 U - try {
6 n, U, A. G, V: H+ ]% d0 Y! e" r - past=con.prepareStatement(sql);3 P' v! ^3 }5 e) C8 C
- rs=past.executeQuery();
# ~4 l& v+ E6 K; A6 L - while(rs.next()){
, e# z# H. I% J7 _7 K/ E0 o - Book books =new Book();
+ O0 Z* X7 o" h& I r% V - books.setBook_name(rs.getString("book_name"));' Y: V/ V& p( y* @8 K
- books.setBook_type(rs.getString("book_type"));( N) d, d& O0 T) Q2 V8 S( Q
- books.setBook_publish(rs.getString("book_publish"));
+ p: r7 V. i# Q2 F$ m3 F* s: v6 w - books.setBook_date(rs.getString("book_date"));1 `# B' Q% S) P# ?! d2 W% L
- list.add(books);
* O( u( H- b9 S- W) ~% u - }
2 R, s- g. |4 D8 L' r- {* ~ - } catch (SQLException e) {
0 _9 ~$ e2 i& p7 `0 r. e9 S - // TODO Auto-generated catch block" t# z# L" A" P) l9 O" o1 a4 w" [( i2 y
- e.printStackTrace();
( P; y3 A! l4 M- U9 n - }
' S6 l$ w/ x0 h. h% }" L o) w - return list;
$ \3 x3 f' |" t8 S6 r; i - 1 l' n6 T |+ w4 H9 Z
- }
b1 z9 d6 G0 `" r+ j4 E0 D1 } - }
$ t! }) ^) A4 g0 C2 C
复制代码
6 [7 H0 ~! E7 d3 w
1 p( W# B% S2 J; t, x7 C& P* ~+ h9 V( m( U$ K+ } _
|
|