该用户从未签到
|
- package s2.jsp.zhangxiao.dao;* p/ f3 W c$ J& B* w a5 @5 I
- import java.sql.PreparedStatement;
; A0 Z ~; H v9 a g( Q1 m" S - import java.sql.ResultSet;9 M1 \! Y: {* T' D6 L( J
- import java.sql.Connection;
9 ]* f1 e) E" W# Z7 @ - import java.sql.DriverManager;
: A( _/ I+ k! k$ _2 z - import java.sql.SQLException;1 U7 C% K1 y1 G- N
- import java.sql.SQLException;/ [7 C- y# b( w0 H. w) t
7 K: d2 E+ n# P4 ~& ^
0 I! }# h- Z% i; L# U! C; [- # h# _$ ?8 \" v" e' W! b' I
- /**0 K( [& x' S, q
- * 连接数据库
7 Y) N, V; g& r5 D& W$ _2 S - * @author student1
0 K1 {) R( x- O- k/ }+ i/ I2 X - ** k: A9 D- T5 p, W2 W9 D) x- ]9 l
- */2 @+ q1 t3 d- u
- public class BookDao {: ?9 A& ~1 ]2 X$ T& V; @
* j+ F) J" Q7 g7 D' q- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
- p9 v. G! t' l* s# X# |2 U - private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";
# @6 g; n3 i$ j1 i; M3 R9 _0 y/ T - private static final String DBNAME="sa";
* d) ?0 L! ^ H7 C7 j' {- Q3 h - private static final String DBPASS="1234";( D, n( V, x4 B) E; q0 @
-
% @6 u; ]' R& } k! J2 B7 e - ' z, V! d. N5 H1 q ^: B/ x
- public Connection getConnection(){
, v3 G# K7 v' c - Connection con=null;5 C* X7 P. K; Q# C+ I' y% `
- try {
, W& W8 r7 l, D* E. ~1 N - Class.forName(DRIVER);6 o% Z8 T: s/ R/ o) R
- con=DriverManager.getConnection(URL, DBNAME, DBPASS);2 L3 P6 o+ u3 m1 ~( o
- } catch (ClassNotFoundException e) {
9 I* C( E T. M. H% m - // TODO Auto-generated catch block
( P6 m8 h6 |6 O0 b - e.printStackTrace();, L2 ~6 x8 t6 e4 D' ~
- } catch (SQLException e) {
. Y) n* t/ x6 v; R# M - // TODO Auto-generated catch block
U9 W% \. v& o" M+ E- S( ?) V - e.printStackTrace();# O) L3 e6 ?1 h" {
- }" a: F. d7 _+ ^# X& L2 Z5 f+ ^9 ]; `
- 2 h# }! R9 }$ p+ x; i( m0 `
- return con;( l1 a5 C6 J4 v% R
-
" F& ?& Y/ N; U$ b" o8 _& W - }' h) E) x2 q/ x9 y' c: w1 L9 |
- public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){4 z' j' k' A, F. g/ I
- try {- r; {5 y* l) G2 T- R0 U. K2 R
- rs.close();
: x4 u* |+ @: O; R! \ - } catch (SQLException e) {
|0 W+ X0 g0 u - // TODO Auto-generated catch block5 l2 S7 ~4 G4 r
- e.printStackTrace();
) I: q0 d: }$ K% Q# B - } D& o4 e9 I3 t: k
- try {
0 R+ M" f: T# u+ U$ w3 H - past.cancel();9 r8 @2 i, ^* a1 U* f1 L! P: u
- } catch (SQLException e) {7 {+ \- q# n8 R+ r, F
- // TODO Auto-generated catch block- U% N* G& Z4 r
- e.printStackTrace();
" l6 U b1 ?* d' w+ V+ U" V - }4 e" a' R) [: J) O" @8 p
- try {' G7 p( X2 Y& v6 R) Z8 G1 O
- con.close();
8 C' S; v1 u' ?2 x - } catch (SQLException e) {
% c; n" S+ o0 ^0 a7 L - // TODO Auto-generated catch block
: _6 d; F% i* u - e.printStackTrace();: f/ k) z+ R# X2 l
- }& R* x# ?: k) a
- }# Z: n: j+ z5 T5 {5 G
-
3 @6 E" f J3 o& p - public int update(String sql,String[]getValues){1 u6 s5 N, X5 R* S! d
- int i=0;
/ u3 R3 @4 H' N - Connection con=null;5 ~# ?( L* z* G3 Q
- PreparedStatement past =null;
5 C; z, h- ^( F% W" } c0 [$ Q9 g _ - con=getConnection();
4 X8 R# Q) q H& F- g2 s0 I4 g - try {# ^. W7 h6 ]4 K& `3 `. A
- past=con.prepareStatement(sql);
/ b2 n, f* e f* Y9 _) _5 r - if(getValues!=null){, Q& R# j8 o" q6 e3 z3 `
- for (int j = 0; j < getValues.length; j++) {& |; `& ]/ z! e0 P
- past.setString(j+1, getValues[j]);: W1 S8 M/ u! l6 b$ Z9 B
- }
y0 N* p$ K$ C% m - }
& _: J# ?" Q' [7 e' B. F) w% I - i=past.executeUpdate();! ]: x* {" v/ P" Y& p0 H
- } catch (SQLException e) {& g* m! B( n; t; W c2 _
- // TODO Auto-generated catch block. w; a7 m. u0 b$ Y) R+ ~
- e.printStackTrace();% ?' B8 {; n! E) w' ^
- }
, c# S0 A" M. N; R - 8 h( D! s* e( R8 v% b6 t% _
- return i;# f3 T L& v1 h$ {
- " M' Z+ J% H6 W7 q! C( a
- }2 A8 \" _" @% N% l0 \: C
- }" B7 z7 k. C. [0 T) K& \$ o1 P8 p
复制代码 # p$ D0 i+ l$ ]+ I `
9 A& A8 d8 [; Q# |& _* l: e
- package s2.jsp.zhangxiao.dao;5 P, f& j- F8 \0 X
% ^5 l0 U9 ?0 o& R4 N# s- import java.sql.Connection;( |4 u% x$ N: A( k" J& ^3 e
- import java.util.ArrayList;% x& P0 }% M* w* y3 [3 U. K( T
- import java.util.List;# M2 t& \2 `, N- w7 k$ G
- import java.sql.PreparedStatement;
& X3 ]1 f/ Y ?: P. X2 ^7 |6 U - import java.sql.ResultSet;
6 \( Q$ k& r! w6 @; B5 z. P; K - import java.sql.SQLException;+ N9 e$ C& o# {# G
! P9 b- g% k; z$ }- import s2.jsp.zhangxiao.entity.Book; N# Q4 C# K+ O6 N; [; ]# r
% C5 H9 c, o; F# X8 l% U- public class BookImpl extends BookDao {8 l, o! i9 ^1 D& P; m: w9 Y
- ) r0 i) H/ I) e. R' g6 _6 L6 n! V
- 7 ]6 n+ s# V5 o6 \+ `
- public List bookAll(Book book){
% R# p# B; c9 p& z - List list=new ArrayList();9 `! `+ q6 `' c) N$ I3 A/ x5 J0 x
- String sql="select * from book where 1=1";# D" C; n5 W! o; K
- Connection con=getConnection();* G+ A. Y+ Q0 e5 Z& t6 O
- PreparedStatement past=null;
( D# [/ R- c9 ]4 Y - ResultSet rs=null;7 _( A7 d: ]+ G3 @7 {4 X7 r7 ]6 _
- if(book.getBook_name()!=""){
5 ^( j" X" _4 P( m2 Q' u - sql=sql+"and book_name='"+book.getBook_name()+"'";
0 \4 i/ }. v( Q1 v# z/ v - }3 G7 l! R# O' }% o) I3 f7 k& C
- if(book.getBook_type()!=""){
: Y5 E0 r; C: n& E" K - sql=sql+"and book_type='"+book.getBook_type()+"'";& r& q4 n' H& v o7 t1 x! q
- }
. E% d! w/ X9 `8 H4 M. u - if(book.getBook_publish()!=""){1 _/ y" X+ o8 g8 X1 {
- sql=sql+"and book_publish='"+book.getBook_publish()+"'";
4 N# N% ^. C" X - }, M O; C C) g8 I
- % s$ b! t5 l5 r' I0 H( y' `
- try {& \0 J/ N# X9 j# @( l
- past=con.prepareStatement(sql);
0 ]2 ~9 T6 W9 ~: M$ B5 |+ Q0 x - rs=past.executeQuery();
6 B7 h5 z' {' { - while(rs.next()){
% \6 ]# b5 N+ Z$ h0 ~4 y- ? - Book books =new Book();
' O% y: f3 s# ?5 S+ U" i. G - books.setBook_name(rs.getString("book_name"));, {5 p6 \7 L }. H' r1 L N
- books.setBook_type(rs.getString("book_type"));4 Z- U; ]) M+ d% f( X6 W( X
- books.setBook_publish(rs.getString("book_publish"));
7 t- f- v( u& _( e4 R - books.setBook_date(rs.getString("book_date"));
" @6 B: s- z$ m1 E4 G( C( J8 V* ` - list.add(books);
- d( K/ c5 B* c8 b - }" W6 I5 {8 T( ^
- } catch (SQLException e) {
& a6 c2 z" S2 |' c7 h - // TODO Auto-generated catch block" H! T3 r% p' G2 A) P. k
- e.printStackTrace(); a5 D' z5 q$ ~
- }
' l. X$ y o( e6 L! J& M1 I, O - return list;0 J3 K2 d5 S+ p2 y" c: v; y" U. e# a: X
-
1 r: @2 M) O4 f% \4 E+ Z; t - }
/ _4 X4 b+ ^6 c - public int bookInsert(Book book){3 r+ V: o W4 F7 s" |
- String sql="insert into book values(?,?,?,?)";5 o# F6 {1 Q+ r6 }4 ~, O
- String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};
+ n5 A6 M$ z5 G" O - return update(sql,getVlaues); # U2 r; }+ [6 N
- }1 n* c+ F, d- [3 _ |/ S/ f
- public List listtAll(){* P4 P2 Z5 E3 ~& x( I6 u$ M3 g/ w {
- List list=new ArrayList();+ A9 E' s) H" @' ~9 `" J7 t
- String sql="select * from book";; K$ Y- p9 k0 g- Q
- Connection con=getConnection();/ M4 c" w2 ^3 p
- PreparedStatement past=null;/ [3 ]" H2 p$ a" G, E w7 T+ |# [
- ResultSet rs=null;
. r$ y9 S: l0 G( _! I9 u - try {3 X2 W% {/ V* ]+ T' I# \, K
- past=con.prepareStatement(sql);
$ z! N; t. D9 }' Z' x - rs=past.executeQuery();6 l0 ^- Q' }. h7 k: S: a
- while(rs.next()){9 E( e. d6 M# w0 K8 e3 U: H4 l, ~
- Book books =new Book();! D7 g9 S! i8 R* X: n
- books.setBook_name(rs.getString("book_name"));0 U$ y0 V. h* F: G: u. W# T& Y' X- F3 ?
- books.setBook_type(rs.getString("book_type"));
: g: ?% k4 |. g5 Z) | - books.setBook_publish(rs.getString("book_publish"));
5 f; o8 H( H9 b/ r) r$ l - books.setBook_date(rs.getString("book_date"));
& K' V8 D* D5 J- u$ y - list.add(books);
" E" V- n! o" Q B. m3 G( C: f - }
' W1 ]8 z/ a' k3 l9 n - } catch (SQLException e) {
7 U5 Z0 Q% _( G - // TODO Auto-generated catch block
; t; o; {- w& u" L - e.printStackTrace();1 w. t4 W( x7 Y
- }4 }7 r$ S P: d' n5 l: V
- return list;/ X8 E9 T4 u1 ]% c
-
7 p z o2 A7 i, x) {, j W - }
* Z; W0 g) _( t+ ^ - }
* D+ b7 j; z- e
复制代码 3 t' @! c4 v* W# A" ?5 W& u
' {3 O& g$ t& A$ ]8 G7 m: C6 B5 r
) ]2 n$ `9 }' g+ @( M/ R |
|