该用户从未签到
|
- package s2.jsp.zhangxiao.dao;9 F4 R4 \ ]- W0 {" R$ D3 A
- import java.sql.PreparedStatement;2 i# ^1 E* `" B( D
- import java.sql.ResultSet;
' i9 s; v0 U- A: B' W) {+ L: j7 R - import java.sql.Connection;8 ^& z. o& C; h
- import java.sql.DriverManager;
9 Z: W* e2 U6 w; u - import java.sql.SQLException;) Z4 |$ ^8 J/ S- R
- import java.sql.SQLException;
, \3 P N, ~# U( ~$ D- M2 Q - * `3 f9 B: o% F8 L- Q& t# m
- 1 b9 o2 j. L* R& Q, m2 ]
# g2 e7 b$ r5 E8 X. |0 L- /**5 y) w$ T4 X# r; Q) F
- * 连接数据库
8 M# J9 S7 Z$ ?! `/ p - * @author student1
3 L1 S( `8 y! w' W6 D8 w- X - *
- s' ]6 p% q5 }3 } - */! |' m8 }% v, Q( ~3 ^& Z
- public class BookDao {
$ y7 n* Q9 }: `* P - ' U+ i7 b% z% g+ v
- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";' V$ \4 z. n% I
- private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";
' @' p# Z% j7 `1 {( v - private static final String DBNAME="sa";
9 G- {8 ?7 K4 V6 u: ? - private static final String DBPASS="1234";
' r6 D' a4 T! t9 l% J+ T8 W; o -
1 p7 Y& o4 l" T& Q1 _6 G* E9 T: x - 3 b# A X2 q) F& l+ I$ `1 f0 R8 c5 `2 v
- public Connection getConnection(){
( u- _$ e/ h' c2 S; ? - Connection con=null;! h) N' h* }; N/ [
- try {( x- d* V+ u8 E3 T* E
- Class.forName(DRIVER);
0 m: Y1 ^3 W' R - con=DriverManager.getConnection(URL, DBNAME, DBPASS);4 w7 q4 \8 {) V3 b1 b0 ~* V
- } catch (ClassNotFoundException e) {
" w# N% E. ~" W/ M6 Y& H - // TODO Auto-generated catch block
/ Z k5 r/ o8 [1 F# _ - e.printStackTrace();1 z/ F! K: q6 _5 \' V; J
- } catch (SQLException e) {% f% K" ]0 z# W N
- // TODO Auto-generated catch block3 v6 n% m# A7 ]6 @
- e.printStackTrace();/ j8 ]0 P ?- g( I) j3 L5 P
- }
. {0 b0 w9 W* o7 d: Y; Q - 5 g: U) C F& v. b
- return con;- u5 Y/ Q4 e* z& {
-
! ~* p5 Y: o+ D J0 {9 b. b - } V, L# }# O& ^8 d2 Z8 I7 Q K
- public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){
" W7 O% x0 U& | - try {
" B$ a2 L3 `5 i# |! [% C - rs.close();! w2 n, n3 q1 c* m' A
- } catch (SQLException e) {. }9 H. X7 _# w1 H
- // TODO Auto-generated catch block
! `3 H/ t# ~ J3 m [4 k% s( G& J - e.printStackTrace();
; q: U5 ~; c; h" l. M& V; k( p - }5 B; D ]- Z1 i4 Q1 J2 B
- try {
; m' X& H- p8 U' x7 O2 ^ - past.cancel();
9 W* J8 E+ u4 N+ x, ^$ A- [! {3 p - } catch (SQLException e) {
) O' b5 d+ O; O+ ^( j - // TODO Auto-generated catch block1 {) m! ?# v. C0 \. }' t5 R
- e.printStackTrace();, y: M2 G1 }" V( I- N! g1 t: i
- }3 }- O& a7 S% J- T T, ^+ ]
- try {6 s$ F+ A3 Q5 N( |/ }/ |+ H" j, ?
- con.close();
- K! z0 j* K; F. @4 V - } catch (SQLException e) {
8 P: N" N: q( S7 L/ X; O7 H* U4 i - // TODO Auto-generated catch block
8 p* R6 \* r7 F0 }1 J! z5 J8 G - e.printStackTrace();# y, |. Y" S: G, F6 ?$ p
- }
3 a, o% e* L; T- M - }
: Q5 d# Y/ Z1 S' p - $ T! w- H0 o; G5 x
- public int update(String sql,String[]getValues){
" ?" ^" {% S4 B* Y8 i# H& @ - int i=0;
: _9 L1 `( L' z' x! m3 g' n8 d - Connection con=null;
( s. M. t2 m' w, n2 H0 F/ Q - PreparedStatement past =null;- \$ W: ?2 M7 {9 y( v
- con=getConnection();
; ^) r! o7 n9 Z1 S5 }8 r - try {
) _9 H/ c" f1 ]/ | - past=con.prepareStatement(sql);
% f( C/ |* ~3 s, X( m - if(getValues!=null){
9 T0 [% b- C3 f- | - for (int j = 0; j < getValues.length; j++) {* O: D! x* h2 o# f
- past.setString(j+1, getValues[j]);: ^, w) B: j6 X1 W+ Y
- }! d% |5 c: p8 O
- }4 D/ D/ X& S' r |
- i=past.executeUpdate();
+ i1 [" i. m% v - } catch (SQLException e) {
1 M, B* }+ z& t( n' e - // TODO Auto-generated catch block& ?3 U% G- V% m9 F$ n3 `: g3 J- J
- e.printStackTrace();# i( W& t; j$ \- U7 n7 b
- }
8 s! C+ A. h7 [, T$ Z, s - 3 @; Q {) Y2 a. |* q
- return i;
5 i- t: z D% f$ y4 z1 X* J# n -
. p/ @, s8 C& k - }
% [! J0 e, l: N' X6 @ E% ]. D+ D% x - }
7 y+ Y. Y6 ]6 @; G
复制代码
! O' u; u6 g2 S
$ D+ S2 e: t3 K- package s2.jsp.zhangxiao.dao;
' p; _) `- X3 s, R( S - , F1 A9 |0 i; l/ ]+ f
- import java.sql.Connection;
4 s5 t4 r& u5 Q! W: w! \ - import java.util.ArrayList; N# t: y2 b# v
- import java.util.List;
; p& v" i# l5 H7 Q, J7 e - import java.sql.PreparedStatement;
0 f( W* G$ D2 d" n6 D. | - import java.sql.ResultSet;
J3 \. O8 v# ]' u - import java.sql.SQLException;
& r4 h: i# Z+ Q/ ?4 z: G) K
4 F+ n! h2 s1 ^6 ~3 f9 Z" ~- import s2.jsp.zhangxiao.entity.Book;
2 p' O0 T4 x7 H! k8 n) G- v) f1 E - " f4 y8 Q' m0 y( l4 w9 i
- public class BookImpl extends BookDao {
" G z* [: E. M% S7 z - / |8 b; c/ v8 U9 Y8 z4 j4 l+ S
-
! r" ]4 j, l! v/ k1 A$ P. b - public List bookAll(Book book){
+ h9 p/ W* y$ ?+ W( P - List list=new ArrayList();
& u) e& v9 `9 s F( Y - String sql="select * from book where 1=1";
2 ]5 b% j2 N1 w! O - Connection con=getConnection();" t4 n6 }" v @5 v3 ~
- PreparedStatement past=null;
& E3 Z7 M9 {8 K P5 _ - ResultSet rs=null;0 U/ i V% r' Y1 N6 w
- if(book.getBook_name()!=""){
7 q5 z3 A: j0 D* X x# E5 M - sql=sql+"and book_name='"+book.getBook_name()+"'";
- z( t4 `- k' t- [1 _ - }9 {; C3 P! l2 ~9 D( o% I# [
- if(book.getBook_type()!=""){; w: A9 v% a7 b! D
- sql=sql+"and book_type='"+book.getBook_type()+"'";/ a6 f& Y3 T& p U: e
- }6 c* b K+ ^, M3 W y
- if(book.getBook_publish()!=""){
. C& `$ `3 W2 X/ l& e$ B$ s - sql=sql+"and book_publish='"+book.getBook_publish()+"'";
! v' ~/ G/ B7 u - }6 c5 r2 t& u$ c5 K- q# N+ u
-
y9 _# {/ i0 ]; o - try {
: B# Q8 O+ t6 l* s - past=con.prepareStatement(sql);, n# X9 ?: P/ ?/ g: J, z3 H
- rs=past.executeQuery();! l/ z7 z: ]* V+ {1 }0 T# C
- while(rs.next()){
+ B0 N' z& k. v9 @& S. J - Book books =new Book();+ v% d! `$ j8 N2 O0 U7 W
- books.setBook_name(rs.getString("book_name"));8 l; Z. N. U' }( ^( r. L4 C7 V
- books.setBook_type(rs.getString("book_type"));4 Y' t4 P1 ~5 N2 A: i( X' G' T
- books.setBook_publish(rs.getString("book_publish"));
. H3 y0 A$ O2 _8 \# i3 l" i0 o - books.setBook_date(rs.getString("book_date"));
, ?& I4 I, u9 D7 q, t: n' A - list.add(books);% X* e1 N( ^" O+ ~2 L$ K
- }
* \) `( T) f% \! W1 z! [ { - } catch (SQLException e) {0 I& B$ |' t3 x2 }0 V- K# q' ~ g
- // TODO Auto-generated catch block
- V0 k% A. c$ e2 u - e.printStackTrace();
8 O7 s/ ~' g" z4 g - }
& H1 o; r4 T2 Y8 A$ [1 i+ n# u - return list;
8 s9 {8 |2 T# R: A8 C - 6 W0 d6 b' k% @! D1 g# ^
- }4 e( [. l; l/ ?& `. c+ w1 Y1 N
- public int bookInsert(Book book){
5 @1 D. C- ]1 x+ ] - String sql="insert into book values(?,?,?,?)";5 d0 y4 j. ]2 @7 j' t" b- L; H
- String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};
, a$ J, f3 @8 ~ - return update(sql,getVlaues); r2 y* l# U3 |. y* [, V
- }
0 q2 g' @, v0 C; I% ~) D - public List listtAll(){ P. ]9 `8 w% p. f& v0 y" X5 G6 A4 j
- List list=new ArrayList();
9 f C( b) b" U9 D& L: m4 P( Z - String sql="select * from book";
; ?$ p" ^: Y/ ~5 l - Connection con=getConnection(); \) E6 h9 H4 D# d3 _4 b; h
- PreparedStatement past=null;
" D2 F1 _% @7 q - ResultSet rs=null;
, W+ v( U" l J9 d) i - try {) I( |7 ]& t; Q% c3 J8 M0 X% m
- past=con.prepareStatement(sql);
5 x: l9 q/ r( g) A+ x- C& i - rs=past.executeQuery();, a2 u3 }; h9 L) @: V0 K1 U6 |# s
- while(rs.next()){! @1 C/ P# l: o/ q- `
- Book books =new Book();
6 E- u! T% Q- X! x3 S1 x - books.setBook_name(rs.getString("book_name"));
O! K% A( c: T( Y - books.setBook_type(rs.getString("book_type"));
/ D; Z( N# `* H* x2 w- O$ F - books.setBook_publish(rs.getString("book_publish"));2 q2 H: \1 f8 @& q
- books.setBook_date(rs.getString("book_date"));
* u6 b# r m! @ - list.add(books);
) n6 A' d! ?/ p5 t" Z) i7 c/ x - }# L! O& {/ E( Y/ e E
- } catch (SQLException e) {
& n( |! e6 b& |7 @4 H - // TODO Auto-generated catch block
5 u% f4 H5 C' j3 h- w& t: N! Q - e.printStackTrace();; }+ t$ U$ C) x- b, Z% V7 {
- }) k+ `$ W# Z- J: f" c$ W
- return list;# B' v3 j1 v9 c5 f) J8 H
- 4 _: Y# K- P' x- x p" t
- }7 ]- w8 n% h! Z* n E. X
- } T' t8 O% B/ v: h* [
复制代码 : H$ l8 E O: p7 x+ z3 [) O7 D* l
0 N; |& S0 U# Q, d! M( l9 [. [
& }$ a' u$ _! `3 P
|
|