该用户从未签到
|
- package s2.jsp.zhangxiao.dao;9 X& t! ?! e* ]3 g9 }! ?& C
- import java.sql.PreparedStatement;9 ?( [2 y7 f& x
- import java.sql.ResultSet;
# O9 \0 f- G( r4 { - import java.sql.Connection;
+ d) F: x# G0 A3 u - import java.sql.DriverManager;( B2 D2 k/ q8 q* O; l
- import java.sql.SQLException;
J4 N7 j9 s; S3 `) j- Z - import java.sql.SQLException;8 l+ S7 i" X- ?4 o( U
- 3 C5 H( H9 n6 i- ?8 G9 C# M
- 5 d9 q; S f8 r* `6 |/ B
0 _( p3 E5 K, O( V& V- /**. w8 v$ }% s* |' A+ y
- * 连接数据库; w) i g! L* I- ^, Z0 [
- * @author student1
2 f, ?; U1 g9 l2 k% X6 s8 U, _! d* S - *
+ e, e1 p& y/ K6 n1 _0 J$ [$ | - */
; U9 ?; _5 t$ C3 V/ @( A - public class BookDao {
9 s ?( I8 N. ~+ K! q8 A
7 e4 ?- {( k8 f3 V* `2 {- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
% w& H: J# }! {. G/ ]5 j I - private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=book";
1 k1 R/ y4 z/ A+ }$ G. N/ p - private static final String DBNAME="sa";
, Y0 p& r+ v, q+ w. P3 ^4 ~1 V$ \ - private static final String DBPASS="1234";
7 v/ O( W! L P$ T8 I! m -
2 c! L& A0 J1 y y - y7 M- N! D9 G% K
- public Connection getConnection(){, f9 m, v, `( H
- Connection con=null;
3 A3 N, ?* R, }/ u3 d- r) K/ }$ R& t - try {
' ]1 G9 y2 i6 r+ s - Class.forName(DRIVER);
% Y. z, D7 c! @$ b& k; V - con=DriverManager.getConnection(URL, DBNAME, DBPASS);- R% `( j- `8 x: ~2 Z) m
- } catch (ClassNotFoundException e) {
# m6 t* S; C' o, n - // TODO Auto-generated catch block
# c7 T3 Z ?* J ?" k - e.printStackTrace();2 d' [. h8 R$ {. ^- f
- } catch (SQLException e) {0 |6 O/ \, N5 g1 v. D
- // TODO Auto-generated catch block
& d5 C! t _+ n+ [! }7 f - e.printStackTrace();
6 C2 `# D6 W- C$ M" w/ [ - }/ |" d; Q9 n" k, ]# C
, O9 n# W+ c$ T7 h! [ @- return con;6 q" @5 ^+ G# S4 R, p
-
5 c0 }1 L/ {; Q0 ^ - }5 u3 a' o* |+ u: M3 l* s# z
- public void closeAll(Connection con ,PreparedStatement past,ResultSet rs){
; e- b$ |, y/ `. y0 v: m5 Z9 K/ [. C - try {3 L* m! G, L0 r& V. G
- rs.close();
6 Q* |; E: m4 g `1 g - } catch (SQLException e) {+ y# h& X7 _7 @3 l8 b3 Y
- // TODO Auto-generated catch block1 ~! P. M6 u6 {9 {5 Q
- e.printStackTrace();
& U& i% Z! T( X - }* E, m" C1 O: F% n
- try {; g. b2 n: S" V2 \4 b* w) V v
- past.cancel();+ ?: F O! C5 T8 q7 r5 K) _
- } catch (SQLException e) {
# P) o. z. P/ y: N8 @! D! _ - // TODO Auto-generated catch block
& X5 S6 l& q9 `) v - e.printStackTrace();2 L+ }* b T+ N
- }" t0 G' F1 i+ }" e- y" r
- try {7 P( _" }! @" I. \3 a0 t
- con.close();
- l3 |. j# g' ]+ l - } catch (SQLException e) {: t5 q* _& r1 Y, q
- // TODO Auto-generated catch block
7 `" l. I1 `( b9 I* H" Q5 j- Y4 }4 t - e.printStackTrace();
; h, Z! u) ^5 Y - }
- H: q& m J0 Q6 \2 X - }) h# X( R0 j/ h/ ?/ o& m
-
# \/ z: _& S& U& d6 H. Z; h6 G - public int update(String sql,String[]getValues){2 `/ P2 N! I8 ~5 p1 \- n
- int i=0;
# z8 k8 @0 L5 G" h* j" l3 N - Connection con=null;! J0 @% \' z; `( h
- PreparedStatement past =null;
( }1 l) z* b) X: c, z - con=getConnection();( f- n$ g& ` Z: y
- try {
1 Z* F/ B! G2 H3 O - past=con.prepareStatement(sql);- E' m- y- O- d
- if(getValues!=null){9 Y, z" k6 _! ]
- for (int j = 0; j < getValues.length; j++) {
; }' I" E6 s" D7 L3 y6 d; ^, U - past.setString(j+1, getValues[j]);
0 I# M. U( w# R+ f0 m - }' ~( i7 Z: W1 u. i( W
- } e# F5 Z q3 A: v) z
- i=past.executeUpdate();6 {. t9 ^' B. d
- } catch (SQLException e) {( R" ~# U/ N$ y/ @/ g z5 a
- // TODO Auto-generated catch block
5 r9 C- Y8 r+ J) |1 z2 ^ - e.printStackTrace();
; ^: m0 V8 W8 d - }' u9 I6 ]1 m+ Q+ ?$ j4 | B
-
: ~5 Q2 R" r% d - return i;+ v- ^) J G3 p$ k" A* s7 [# D5 A3 ]
-
" O/ p) }0 V: `% h& s4 ?5 m - }, q. x; n+ ^' L6 q$ F2 q
- }
7 z9 D5 e7 r* i' O% p
复制代码 8 V) U6 g* {8 [
' g! v. H# t7 d4 |5 i3 u& r
- package s2.jsp.zhangxiao.dao;" s1 c, z( X6 e9 I: b+ ~# F
- ' F8 ]& `9 v a% ~, J3 Y) Q
- import java.sql.Connection;
2 u! g) B; J+ ~/ d% m# s - import java.util.ArrayList;
7 b( c( M" t+ i5 P8 M( k# J - import java.util.List;2 P4 v$ }: j2 g* C, w
- import java.sql.PreparedStatement;
# W5 g9 K8 A% } - import java.sql.ResultSet;
) y6 n* k, }& Y. {! D2 U9 G - import java.sql.SQLException;; z$ w# }3 i# [9 X# f; P
- / `3 D# h8 ?6 @4 H2 G
- import s2.jsp.zhangxiao.entity.Book;
9 ]. X3 T" X- `7 c8 t& }4 E; o
8 A4 U2 s3 J1 a; P' Q' v9 r- public class BookImpl extends BookDao {
6 R! ^* H/ `- ~3 u - $ z' R$ D) U5 o
- ) L3 ~, b0 j$ w: H( c
- public List bookAll(Book book){
5 r! D, B6 f" M - List list=new ArrayList();
- b5 O$ Y4 N7 q4 R. a( c8 ^9 H$ r - String sql="select * from book where 1=1";
! ?9 J& P4 X. W# {' ` - Connection con=getConnection();
& {0 G: d8 y1 x - PreparedStatement past=null;5 n; ]4 K+ [6 b5 ~7 [: C5 W, Y
- ResultSet rs=null;, o5 v" i" J, m+ o( W' W" [
- if(book.getBook_name()!=""){
: }0 _1 O% _9 @9 O z - sql=sql+"and book_name='"+book.getBook_name()+"'";
/ u6 z4 C9 I. g" u" O8 U - }
9 k9 n6 S0 q4 d1 o4 _* ^' u - if(book.getBook_type()!=""){
( e& r2 Q6 Q1 o - sql=sql+"and book_type='"+book.getBook_type()+"'";
8 N1 O8 {. Q1 N8 M$ F - }# @# l; d1 n0 o0 e9 l, J) y) z
- if(book.getBook_publish()!=""){
- B- W) R* F' Y# } - sql=sql+"and book_publish='"+book.getBook_publish()+"'";- C: ?: Y$ e% _% N8 @: _' {, n: I
- }4 U5 \7 b! g) X# t @' |
- 3 p3 k$ V0 L9 w3 J3 `
- try {
) p7 V% [! v# e4 N& \* h! S - past=con.prepareStatement(sql);
* I3 a2 U5 A6 T* ~2 i, g: O/ ^" M - rs=past.executeQuery();
, J, F+ e) T$ v+ n* } - while(rs.next()){* y( ^& ^2 ^- G2 q7 {- e+ ` h
- Book books =new Book();
5 k6 J# @! n4 r+ B* F: c - books.setBook_name(rs.getString("book_name"));! {7 L5 h- }0 C* Y. ^+ a: j
- books.setBook_type(rs.getString("book_type")); O" P _0 |9 H$ I( v b
- books.setBook_publish(rs.getString("book_publish"));. J. c- Z! M& M1 L5 ~3 p9 g
- books.setBook_date(rs.getString("book_date"));
( V/ c( f3 ]( |3 A: }1 o$ M - list.add(books);, g2 m( T% ?" E1 u2 Y! L3 d$ O0 r0 P
- }
1 ?9 v7 k( f" r* y9 T - } catch (SQLException e) {
# a6 n, V9 O; ] L X - // TODO Auto-generated catch block
& ?3 X- |/ U" {$ F$ I - e.printStackTrace();1 ]! B, Y x7 I% _4 e5 U0 x
- }
0 Q# D. | g# C+ E7 w - return list;% a/ }" Y9 x7 U) j8 h4 S) K" {
-
' P- Z6 j, V% n3 g. q - }" H/ u6 E" S5 E" O
- public int bookInsert(Book book){
0 A7 a v; r% ? - String sql="insert into book values(?,?,?,?)";7 f: d% `+ u7 U0 F/ [
- String[]getVlaues={book.getBook_name(),book.getBook_type(),book.getBook_publish(),book.getBook_date()};
% O) v2 D2 J" x, A - return update(sql,getVlaues); . ?. c! n z3 j! e
- }0 K; ^/ F1 s5 I: ` |3 ~! s; U& P
- public List listtAll(){
( l2 O; Y) X4 F! b* f H - List list=new ArrayList();
1 l/ Z h: l- f( Y - String sql="select * from book";6 ?" ~* H( W5 ]! L$ x- g
- Connection con=getConnection();6 G5 f* {' ~4 G; v6 g% j$ g
- PreparedStatement past=null;; S5 [4 s- X5 S9 F: i$ p
- ResultSet rs=null;# t0 d' P. w% z
- try {
0 Y0 P& s M' B1 q5 y* t - past=con.prepareStatement(sql);
7 X6 ^. t, |" N - rs=past.executeQuery();
g5 L! e l4 p( [+ }8 C - while(rs.next()){% A4 N+ A+ Y/ g S: Q' c8 a9 Z7 k$ O
- Book books =new Book();. T& U' w. S+ g+ J- X1 G6 p( c
- books.setBook_name(rs.getString("book_name"));& q! S/ m0 J. S4 C, E
- books.setBook_type(rs.getString("book_type"));
" E8 x7 `; `7 L A v9 [1 p( b - books.setBook_publish(rs.getString("book_publish"));
& L0 ~2 h) ?6 O4 w - books.setBook_date(rs.getString("book_date"));
" L# F- j& G6 V- q7 G8 v+ J3 k) _ - list.add(books);0 l6 ?6 d0 C& e. Z- K; B, X$ ~
- }1 p. i; S- P+ ]3 {
- } catch (SQLException e) {
/ s$ r1 F9 F5 z: u - // TODO Auto-generated catch block
2 ]4 z$ ]% @7 o ?# D3 s - e.printStackTrace();- E9 {8 F# j7 x+ A/ Q0 {( H* Q3 Q
- }( o3 ?& M& v% u: v; i( \4 I
- return list;2 n7 q: l3 u8 ]. R7 s
-
5 {1 a: L4 B* m3 x4 H. A - }* n6 Z/ S# z- [: r+ a
- }8 G5 U) Z& R5 V. }" W- x
复制代码
4 y4 U8 ?# I7 L( N" s; w& p; }0 p+ d! q3 |) J! g2 I- x7 D
' Z: K4 D/ v" @, U4 w- E' p# U
|
|