该用户从未签到
|
- package s2.jsp.zhangxiao.dao;
' H2 Y# e, L. s0 X- J, f - import java.sql.PreparedStatement;
' }9 \+ R9 W9 L X3 H - import java.sql.ResultSet;
. h& H2 Q0 W7 [7 w) U - import java.sql.Connection;/ d( R2 S: m( Q/ h1 ^1 p
- import java.sql.DriverManager;
7 z( |" {3 n C2 K% k - import java.sql.SQLException;/ h; \: G9 U8 }
- import java.sql.SQLException;
g* V2 V& s- j/ J, u- ~% O
' e) B+ h8 V) l- L/ Q- 0 f% w4 e9 }9 _
G7 {2 P: m/ {- /**
- I- L1 y9 a2 i+ L4 L1 K - * 连接数据库
1 M3 e/ S$ G6 z1 q - * @author student1
2 W/ }7 b) K: s& k" ? - *- ~/ J# W9 l$ X9 ?9 |
- */
7 p9 t. N$ X& \- T - public class BookDao {7 P M( s V) a* L8 E/ K. Q+ ?
8 [+ e v7 Q) Y6 L0 ]- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";5 y) q z0 x8 |; `0 Y1 ?
- private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";% C+ c; M1 n6 B! ^
- private static final String DBNAME="sa";. J- e0 j0 `- b& g8 v8 @! B
- private static final String DBPASS="1234";
3 n- R. w! q% E$ T5 P" |" |6 s8 y - 2 |) |! c7 W( s8 Y* v9 j
- 9 K7 s& X5 O, _! i3 L# ~
- public Connection getConnection(){
, y3 n) C1 _5 x# L8 u - Connection con=null;
2 E1 L+ @. {- E5 f - try {' i- w, `2 _; N+ _5 h
- Class.forName(DRIVER);
0 b, ~( t! |& i1 Q, _' b - con=DriverManager.getConnection(URL, DBNAME, DBPASS);* z3 o5 F7 R1 d. w; K
- } catch (ClassNotFoundException e) {
& T0 X; ?$ n$ |7 n - // TODO Auto-generated catch block% K0 v& l& Q* [5 W3 k+ B( r
- e.printStackTrace();3 T$ u9 m% Y7 k9 @3 ^
- } catch (SQLException e) {
: W' S7 f6 ~0 ~7 J; X# l" R - // TODO Auto-generated catch block
% I" T+ Y, k& B; x5 v6 n6 g - e.printStackTrace();
( s+ s5 Y! C4 T' H o- B - }: l+ E$ T7 L4 W( y I: ?
7 C- L) k a' h. H( n0 p- return con;4 m+ Q: o8 O* h" k* c
- : G, v& ~: U" ^4 D7 a8 D6 B& z- _
- }1 z) a: R Z8 U
- public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){
4 a t' k/ X1 F- P - try {
: l; s( l- G7 q1 N - rs.close();
! u8 F$ t( C- ^# t - } catch (SQLException e) {; W5 p9 E3 B/ ^" M& t. ?
- // TODO Auto-generated catch block
6 ^) ^- Y; V- }$ ~( V4 ` - e.printStackTrace();
& g& U* M9 f' L2 z/ ? - }) N2 \# ]- x( D( X; q& f. [
- try {& D2 \8 Y0 d. F: i/ T& {
- past.cancel();
: n- G; U5 t+ D" A - } catch (SQLException e) {$ T- {* Z& P% t2 t2 V9 m7 V
- // TODO Auto-generated catch block
7 `( i- D+ S: h/ u1 G* J' G6 W - e.printStackTrace();( m- r, Y( K8 u) p* v; p3 ~0 p% o% U
- }$ ^4 @, z9 R" ^1 W- c) W! l
- try {+ V& u k3 {# x: C
- con.close();2 v3 c/ d. ?( g2 Q5 l5 m) O
- } catch (SQLException e) {- i, H# q( a7 D1 U* x! \
- // TODO Auto-generated catch block
" P. z( a, v$ ` - e.printStackTrace();6 N7 x6 Z5 {$ |) Y; M% g
- }
# }- x! x+ V- z/ n0 a6 T7 V - }
$ l' N1 x0 `1 w7 H* d, V$ m - % G+ g' w- s) p9 s6 T2 l$ X5 s
- public int update(String sql,String[]getValues){9 y- M( B, A% e: @- f
- int i=0;& |- M* T" S% H6 i0 c' _
- Connection con=null;+ Y4 p3 ~, y O' B( c
- PreparedStatement past =null;
0 F( R! l! p. W( |% c; c - con=getConnection();, V7 k) F% Q- Z$ `" E( u( ~
- try {
4 c9 v5 P# ?, K7 S( Z& y - past=con.prepareStatement(sql);. _* c6 Z1 A% ~3 S2 E' r! d! d& h
- if(getValues!=null){
' [. I7 y# W; F0 b4 B+ [ - for (int j = 0; j < getValues.length; j++) {5 v/ a5 Z& E6 J% ?7 t _6 N! _
- past.setString(j+1, getValues[j]);. O9 V9 @& K6 o" Q
- }7 [5 A$ p X3 P! Q+ Q: O! i; B
- }
- T# U* X, s0 M! S - i=past.executeUpdate();
% N P! H y, o# Y$ {8 W2 P* g - } catch (SQLException e) {
; N7 E1 j6 f- H. t, r/ e0 T! a - // TODO Auto-generated catch block
& J L( v/ a3 B2 g! E O2 A+ P8 } - e.printStackTrace();. V/ ]# ^+ y: M7 ~" |2 z
- }- A' v3 q* e% |3 U0 {' z2 u
-
5 q4 B2 C; s5 ]% X; C - return i;0 t h' s: N, _8 f* }9 _/ N8 u& @4 y
-
6 B$ z0 Y* }' O" D - }
: K$ s# l/ v1 |& x& B7 P& {) v - }
8 Y" j0 S' a# a/ j# S( W/ J
复制代码 9 z+ ]2 ]- b/ m ?
) L! `! M1 W( b% A- package s2.jsp.zhangxiao.dao;' H* N9 V1 |& A( K0 F4 o, S; V+ ]
- 9 N/ W) y. |/ i+ S4 D+ s9 F( m% o
- import java.sql.Connection;/ D2 j v" g/ P3 T
- import java.util.ArrayList;% c! \" a a" \9 Z) L
- import java.util.List;
' M6 ^. Z' k, ?1 k - import java.sql.PreparedStatement;% d# _7 r# v' X* |6 t
- import java.sql.ResultSet;
$ o7 D+ C+ Y- _( x/ q - import java.sql.SQLException; V1 }, {9 V4 B4 B* k# j5 L
; K; `* |, a6 i1 a0 B. F5 @9 }8 _- import s2.jsp.zhangxiao.entity.Book;3 U& M: p1 r! V- Z! W8 z9 k
?# @: g# C. D' I s" U) l( x- public class BookImpl extends BookDao {& F0 o8 N2 Z5 E
- 5 I4 U* v) L$ p% y \( f/ P
- 6 |( O8 S9 J2 t, a5 t" ~1 |
- public List bookAll(Book book){
3 q& T8 P: F! J( T/ Q - List list=new ArrayList();+ e$ L9 P4 @6 R6 U* w7 C( r
- String sql="select * from book where 1=1";
+ o; _: o( ~/ A8 ~) ? - Connection con=getConnection();
' M k) ~" T. I1 W3 W& o5 Y - PreparedStatement past=null;
' h6 x7 ^. w" F l" e - ResultSet rs=null;
$ z. Z& I- x/ e" N3 N - if(book.getBook_name()!=""){
% T: d4 ]2 c" @' P, [) t5 { - sql=sql+"and book_name='"+book.getBook_name()+"'";
" v2 [) n. \% r4 O" H+ w - }! H' E& H, a$ ] e/ _& v
- if(book.getBook_type()!=""){
- V. _& S" G6 Y+ W3 _% O8 s - sql=sql+"and book_type='"+book.getBook_type()+"'";
+ F- U4 F k [ - }
$ }2 [8 k1 d8 h B! C - if(book.getBook_publish()!=""){# ]* j- H% ]# J' U) _
- sql=sql+"and book_publish='"+book.getBook_publish()+"'";
, E3 i) f z4 F7 ~4 N6 ^2 H2 g. f0 `% X - }, ~* x/ p0 [) o, t
- ; y# @% m+ g2 }. z6 ^ M1 f
- try {
0 {# @: l" @. B8 p' {) H - past=con.prepareStatement(sql);& u) w3 a* z6 g _5 K; r
- rs=past.executeQuery();
" P6 q1 x4 W/ t' x4 B - while(rs.next()){
7 r& T: U" m/ @( { - Book books =new Book();! P% B+ T4 r" D" l6 j4 e3 n8 K
- books.setBook_name(rs.getString("book_name"));
6 i0 ]% b2 W# D/ ^- T - books.setBook_type(rs.getString("book_type"));
; r. V4 ?8 |. D2 J, K# s2 ?7 o - books.setBook_publish(rs.getString("book_publish"));: o: @% |: _; X: z6 `
- books.setBook_date(rs.getString("book_date"));
3 E3 }6 P* q% t& m1 z - list.add(books);
: L- N: T: q6 q - }
3 ^; Y; u0 ]9 {' c( f$ l: S - } catch (SQLException e) {+ u- |! n+ X6 q& |) T
- // TODO Auto-generated catch block
: g& W# d/ T5 H' `8 U6 g - e.printStackTrace();
0 `1 m6 o/ V/ _+ P) Q - }
% F2 U" O0 @5 \1 Q2 l - return list;" [8 T. ^) I4 V$ L7 q* z
-
4 R: X5 R$ o" z; \4 b - }* D |& m! v* ]& m6 w. b
- public int bookInsert(Book book){
+ d: z: o' M, {/ O7 b" a2 x - String sql="insert into book values(?,?,?,?)";: x% T# S0 }. I
- String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};7 m- u0 @% e" ^* [, I- y
- return update(sql,getVlaues); 7 f$ g6 S# M) l( U% ~% S, J
- }/ K: z: X7 e6 u3 X5 {+ @
- public List listtAll(){
6 \7 `3 g9 \7 U - List list=new ArrayList();
- J4 N/ I$ w( w7 U - String sql="select * from book";& [6 J# T; O8 T, i" Q+ B6 u
- Connection con=getConnection();* E7 E5 Z; }0 @( H! O4 ~4 ~
- PreparedStatement past=null;+ e- n: t! j: [9 Z& C0 B) W- z4 a. w8 T
- ResultSet rs=null;4 ~- B* W8 ]; A* {( F7 w* E8 @
- try {
" k% R/ y/ H7 k4 ~& f; d - past=con.prepareStatement(sql);" u: G L' W3 i0 J7 \* w
- rs=past.executeQuery();/ z- [: n7 J5 v ^+ T
- while(rs.next()){6 A+ \$ v4 M& C* W- s4 {
- Book books =new Book();
! B# R T, J5 y - books.setBook_name(rs.getString("book_name"));# U' m$ `6 _8 n+ Q! s
- books.setBook_type(rs.getString("book_type"));/ j* U2 L4 a; J9 k% Q1 U; w9 x8 s
- books.setBook_publish(rs.getString("book_publish"));
1 |% ^2 y9 W( [0 {2 }6 K( q0 R - books.setBook_date(rs.getString("book_date"));
0 e: a0 f1 C3 b6 O - list.add(books);: h+ g' a3 u8 Q' s4 H) a* c+ X' g
- }
/ M$ { J6 R0 F7 Q3 q- n - } catch (SQLException e) {" g* D$ i. q c# F
- // TODO Auto-generated catch block) ~' c7 i( P* n6 C k" u2 V7 L
- e.printStackTrace();% t/ C9 o- C8 f) o4 V8 m
- }8 h# ^% w" O1 l' m9 o
- return list;
% K& U3 [0 O" b% Y7 j& }# J - # k! ?' n3 ]* N) j
- }
5 f* s" V- K6 B4 i T - }
% j+ h$ l: J% I( M, l3 E
复制代码 : C; f: B& w' [9 E3 L, P
, V! ~) Z+ ]' r* |' J) A: `3 m6 k0 n: K6 Y' E
|
|