该用户从未签到
|
- package s2.jsp.zhangxiao.dao;3 i: V9 ?9 ~& h4 }+ Q9 ?3 A
- import java.sql.PreparedStatement;
2 e9 T1 [: K& ] d3 Q; T - import java.sql.ResultSet;
% D# H. [' n. h& w5 B i0 o5 O( [ - import java.sql.Connection;
: p7 U" t7 ?) Q6 F9 g7 @5 p - import java.sql.DriverManager;' s6 @7 I& g# m8 D
- import java.sql.SQLException;
. [, Y( ]/ f8 X, P - import java.sql.SQLException;
. b& C% C" B2 V% F - - P0 b+ K6 ~# E2 b0 O
- ; v) F3 G) q* Y* N6 R" i
6 M7 Z: C, z2 x) U- /**, ?' ]+ W6 g1 e% X1 y" a- e6 h
- * 连接数据库
* |; S$ [ O5 p) _% Z* l! A - * @author student10 ?4 C$ H6 @1 o9 Q% @ _: }
- *
9 {* j3 C; K9 p" _ - */) a P( M+ K9 P! c' o( t
- public class BookDao {1 @* K# r. [; H+ G6 f& ?
; m, A/ p( D. \% c" l9 ^- x ?+ y- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";* y% n {$ r0 M+ ]
- private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";9 q9 N' s( v; X
- private static final String DBNAME="sa";3 w1 q" X0 N6 ` Z
- private static final String DBPASS="1234";3 ~; @: {) k' r4 N9 Z' R0 D0 ~
- 4 z+ e) `) l% e$ Y0 N
-
3 `9 p: \' T5 w* I, h - public Connection getConnection(){
1 B1 K; E) A# W# T4 \ - Connection con=null;1 B. p& E* w4 t
- try {
* U0 K! E! E4 l) Z( I6 V2 s - Class.forName(DRIVER);
w7 K" |: T8 `# [- X; l0 a - con=DriverManager.getConnection(URL, DBNAME, DBPASS);+ l& I; M, y. T/ Z, ~6 `5 c
- } catch (ClassNotFoundException e) {+ I2 e' q: [8 s8 f9 W8 I W9 R
- // TODO Auto-generated catch block
+ n: e/ G! d0 Z" e6 d5 k5 Y - e.printStackTrace();3 q: i8 Y' v1 \' [6 P, e3 ^
- } catch (SQLException e) {
' s- D& }0 X! B, Z3 e' v: C& j - // TODO Auto-generated catch block
$ V% p' W' o. k( t) d4 ] - e.printStackTrace();# y/ q% T! ~3 H7 L9 T* B
- }/ d, s( b' E# H9 r: X. V
3 H8 [, E3 E9 p, ~2 L X- return con;
* S8 h n1 c7 i$ n4 `; [9 o5 a -
/ h. F W- E* u+ u - }
. K$ h( k6 a$ `' R1 U8 ^ - public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){
! N1 P1 I: K M6 k - try {
; x2 g& p! k5 y7 X6 D6 G - rs.close();
7 U; `8 O" c" y, e6 x" C. D - } catch (SQLException e) {; D/ e6 [8 k9 x( {
- // TODO Auto-generated catch block9 {0 h$ Z4 r! ?3 u! C. {
- e.printStackTrace();: W. Q) u2 T" W1 G
- }
9 b( w- Q! s( p ?. @6 l - try {
% I, F. u$ u4 v7 o- g) `( O - past.cancel();) k6 I* P" y. ]) @$ i
- } catch (SQLException e) {9 ~7 w9 c( {- H" x3 u' Y, h. Y
- // TODO Auto-generated catch block
7 u+ R' H1 Z6 c; M - e.printStackTrace();
3 y M0 Y1 O! J. u7 ` - }1 x: C* v+ r. V9 l8 [# m& \
- try {
$ S+ n% }) C2 p( C8 f' D/ u1 S+ ] - con.close();
4 m/ g& `! ^' s4 V% i/ E( E - } catch (SQLException e) {
/ E$ f0 n, c5 s3 z - // TODO Auto-generated catch block; L2 m3 Q1 O* f" `5 ?0 z
- e.printStackTrace();
5 U% q+ B7 O3 C6 p( c! A9 |0 K - }
6 [4 v" X4 p1 U3 x - }% w1 u, u4 X2 v2 M
- % E& G% O- V1 o0 G
- public int update(String sql,String[]getValues){( k4 ^# \* l( I* G$ t. M* K# ]
- int i=0;2 x+ R) Q* D2 J& s) _
- Connection con=null;3 P9 S% b! i5 b( J8 i! _
- PreparedStatement past =null;$ }! D: S2 R& Q8 s# w
- con=getConnection();
3 B$ g8 d. ~) a1 l% X. F1 U4 L - try {
$ p' @2 t# U$ T2 E - past=con.prepareStatement(sql);, N+ p& w; K* k3 ~8 z3 a$ V7 T
- if(getValues!=null){: E, i$ I6 Z+ l3 \8 v& L8 y7 ?
- for (int j = 0; j < getValues.length; j++) {8 q. G: q7 \3 e
- past.setString(j+1, getValues[j]);4 e8 O! X5 S, U% s; S% j* |
- }
. G# [4 l8 E. }: i; w - }/ k% Q( \; m2 W* O( T3 G T$ J8 H- W# \
- i=past.executeUpdate();2 Z1 g1 V" p# j/ |' Y% m+ t6 l: ]; t
- } catch (SQLException e) {
3 I; l$ Z7 o+ `' ^& i: ? - // TODO Auto-generated catch block+ L* W0 f# Q& D% p" L
- e.printStackTrace();3 W, S. _9 O/ P% m6 R
- }
& ]; G' G7 z8 E; M* c/ Q3 Z8 w3 r# ? -
h' r7 i/ d" H, b/ M! e6 m5 d5 O - return i;
/ M. p( F7 D0 U! V, U -
. ]/ s$ W: }" ^) | c - }9 g. ?9 ]4 b" K. ^! Y
- }
5 n1 D% c* u/ p& D! b6 }$ ~
复制代码 2 h0 C$ n3 t1 M
1 r/ O* ~) P! q3 L6 h! o* r
- package s2.jsp.zhangxiao.dao;0 y5 i. v& K, Q- B, N7 Q
- ( _: e C" V. |8 ?5 o$ s9 n
- import java.sql.Connection;* i9 d5 W M( l/ K# F1 z
- import java.util.ArrayList;8 e' j' G, T0 J! s, [
- import java.util.List;% L5 d, p _# G( N
- import java.sql.PreparedStatement;( u0 m8 K5 f" J+ u
- import java.sql.ResultSet;+ m) t( L1 ^! b& U# ]; [
- import java.sql.SQLException;
) h3 i: a) n2 t: E @ - & D/ @! H# T- j8 Z. s
- import s2.jsp.zhangxiao.entity.Book;
- {4 E [# o* R: p! h3 [
9 h* U8 l0 u: m- public class BookImpl extends BookDao {0 p4 R: M+ i8 c$ T+ e5 T. m
- 5 _1 {7 v4 u; Q) `' x# I
-
/ x- I5 d( l! o( `6 s2 P5 f - public List bookAll(Book book){3 e; Z# ?& K" t1 p
- List list=new ArrayList();! f. o1 ~3 A5 D: I) A* S
- String sql="select * from book where 1=1";" j+ @. e5 D: {& l1 d6 E
- Connection con=getConnection();
' `' y: d$ c; ?/ f0 @ - PreparedStatement past=null;
1 y& y( O; [& Y9 I% }- ]9 j8 f - ResultSet rs=null;# L0 S f1 M, Q7 X2 K& a! x/ R6 {4 r4 I
- if(book.getBook_name()!=""){( i, s3 w) \% Y3 R: t6 A
- sql=sql+"and book_name='"+book.getBook_name()+"'";
, C' a& O" r4 h o" h - }
! z* e% w5 u' v1 | - if(book.getBook_type()!=""){
& @# K3 g3 }% u) G& D \1 t& L - sql=sql+"and book_type='"+book.getBook_type()+"'"; r+ G, ~% r' O- A$ Q0 m8 u
- }/ s6 o7 M9 G# P+ G
- if(book.getBook_publish()!=""){- X7 S! h5 [6 s5 w
- sql=sql+"and book_publish='"+book.getBook_publish()+"'";0 J- O, {5 ?' m( y% }/ }
- }
9 h/ T, \5 P' ?* q2 Q -
, O( g+ r& q4 g2 l - try {. x' i& G( I3 j
- past=con.prepareStatement(sql);
% b+ @) g8 u% M - rs=past.executeQuery();1 z' H1 Z; n7 s1 k
- while(rs.next()){/ O* Y8 `( w6 l" t; y, x
- Book books =new Book();& |1 W: e- l, }( a
- books.setBook_name(rs.getString("book_name"));
4 P7 u) }1 u4 z& `5 K - books.setBook_type(rs.getString("book_type"));
: X9 m. J/ h3 e3 B5 ` - books.setBook_publish(rs.getString("book_publish"));1 g+ ?5 F) {! M! `' a& ^
- books.setBook_date(rs.getString("book_date"));
# G+ L9 `; X/ P! ^# u - list.add(books);
' B( G d0 c( u! g - }9 _& a" o; r3 j# [2 y
- } catch (SQLException e) {; m) c" R/ L3 ?5 I
- // TODO Auto-generated catch block0 B' @: V1 O! Z7 c
- e.printStackTrace();
) Q) A! E) e) W1 n+ Q - }
( Q$ p Q8 J) |* `6 F* ^( S* L - return list;+ _$ d! P4 M1 }: B" p
- 0 s2 k6 _: c: ^6 d5 s) y" h; \
- }
! b, u$ [: E' w# ? - public int bookInsert(Book book){$ n6 z+ B5 }" [7 S# Q7 e1 n2 `
- String sql="insert into book values(?,?,?,?)";/ y- `' U U4 o
- String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};
3 z( q D% G0 g* H, E5 |) P0 f - return update(sql,getVlaues);
# _( f$ z1 M* N+ g# H$ w; k) v - }. [, f: ]6 F' ]* ?. Q) |9 O
- public List listtAll(){
. c2 G. I$ O% Y5 g5 Z - List list=new ArrayList();2 m0 t, M' a; m5 }4 _" a7 c) k. ^
- String sql="select * from book";
' w4 h( a+ V7 q5 @3 T3 l1 w u - Connection con=getConnection();1 C+ R5 Q7 Z8 |1 Y7 f
- PreparedStatement past=null;. Y* \7 a, ~8 b% ~) u9 i C
- ResultSet rs=null;
' R# `: r$ ?7 Q& ^: d( M7 s4 N - try {
6 s/ @: U) d( Q) A6 {1 | - past=con.prepareStatement(sql);
. p6 B! ?) p5 R. G5 _/ c7 z1 n - rs=past.executeQuery();& S& D( o9 d1 b
- while(rs.next()){5 K2 T9 _# ^; @3 [
- Book books =new Book();
, u. b' d6 C; M; O! H5 {. e+ [+ w$ W - books.setBook_name(rs.getString("book_name"));
6 \: y' @* o/ q C4 I! m - books.setBook_type(rs.getString("book_type"));; R" F) U# Y5 Q$ n" ?9 B/ e. r R
- books.setBook_publish(rs.getString("book_publish"));
6 w' H. B% ~0 A1 v - books.setBook_date(rs.getString("book_date"));, W0 ?8 k& l/ u5 L/ Z
- list.add(books);" `0 |1 M/ z( Y
- }
* d' i$ O2 r& G' S& x - } catch (SQLException e) {8 L9 s# w4 G" T% }5 V
- // TODO Auto-generated catch block* ^. m6 M% y5 K+ `% @
- e.printStackTrace();
, r3 @$ I3 I# k" v _6 Z - }
+ L* L, ]# Y4 ~/ ~ - return list;& u' P% N) b" |# g! \) z3 ]
- j0 r5 H6 e9 C
- }5 w3 G! Q2 Q/ g ?7 Q% D
- }% Q4 U) r- N+ ^9 t% X& z9 `1 c1 q$ f
复制代码
3 l; e* h, b+ Y# [+ |4 q. S
& l+ @* o/ F; e4 ?( {- J4 R! D3 k- _0 F1 s
|
|