该用户从未签到
|
- package s2.jsp.zhangxiao.dao;& `+ f8 c( O- W* O- k
- import java.sql.PreparedStatement;; F# ?- e6 b! G, m& |2 X
- import java.sql.ResultSet;
! n4 Q$ L7 I+ u/ Q) v4 n - import java.sql.Connection;1 p( [& [9 ^/ E/ w, u
- import java.sql.SQLException;. |# E4 M% d+ T* ~& ]1 i
- import java.sql.DriverManager;, h. Y1 n1 t& w; a
( `. {% X5 m+ N( |. Q+ ^1 G2 {- /**: F, k" G* u+ H0 g& i( k' x/ z
- * 访问数据库4 `$ t; L# i# z
- * @author Administrator6 i% L* B. r8 a n1 q, t: F
- *
! Q3 ?. _4 x9 T N+ b: {# _4 |, O+ Z - */
2 I5 D3 N$ \* u - public class PhoneDao {
* p$ L" n& h( O1 n4 p - 9 `3 ^# u! ?: L% O
- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
. A* H* `4 h/ ~1 i( t* u* \; [2 f: m - private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=phone";
9 N6 v2 V" v* Q/ a+ t6 c5 E( s - private static final String DBNAME="sa";; Y7 |+ d7 S9 T a% C+ }
- private static final String DBPASS="1234";
; V1 ^$ K+ b0 g9 o3 U9 b8 b - $ M; E3 g0 q9 m l" S' Y5 h
-
( l7 K7 I' }: j& {8 O2 p6 ~ - public Connection getConnection(){# B5 h% }0 y: J3 |, U
- Connection con=null;& a; j6 X/ E/ H5 g( J9 u' f
- try {
& l/ ~5 `/ u0 F+ N$ Z% n' Q. x1 M. l - Class.forName(DRIVER);0 l9 Z1 [8 ]% c. T: ?3 i
- con=DriverManager.getConnection(URL, DBNAME, DBPASS);8 o7 m- o' b7 o0 n
- } catch (ClassNotFoundException e) {# g9 f6 Y- R$ w( Z5 s
- // TODO Auto-generated catch block
& P n7 ?6 v6 d$ \% V3 _: A - e.printStackTrace();
2 {9 @9 |9 m. c- [ - } catch (SQLException e) {* ^- d& Q' [) P
- // TODO Auto-generated catch block4 @6 ]1 T$ e% ? _- t
- e.printStackTrace();7 R7 ?# x2 b- p+ R: O2 ~6 c/ Y
- }+ R- v) Q6 h1 h) n- {- H0 M
- 0 O8 f! Q' K% _- e
- return con;( B" S- R: P: l
- / g3 |0 x( V0 B1 @- E! y
- }
1 Q1 X, I+ y: V2 d1 I9 n - public void closeAll(Connection con,PreparedStatement past,ResultSet rs){
/ l- K5 D N* k: f( s8 R - try {# [- v' h: S a" ]2 x% E" N6 r7 e
- rs.close();. v9 q1 q, x% m/ k
- } catch (SQLException e) {3 }" s% t1 Q" [% I3 \3 f" ?( K
- // TODO Auto-generated catch block0 o0 P" Q4 Z* R3 c5 ^
- e.printStackTrace();& _0 y, ]4 n' W; }1 I' x
- }
+ T- F! O0 n. c- ]; `& d" n - try {1 g0 L) n7 B; [) }
- past.close();. b% p0 }) r- J3 C+ {1 [
- } catch (SQLException e) {# o' A( C9 x* b8 r' G3 H5 i
- // TODO Auto-generated catch block# Q- a- Q* B1 p4 x3 R
- e.printStackTrace();
# |+ c+ Z/ `9 o! _4 L - }. I/ a8 \) k& ~; [! q
- try {6 s( I; C. Z7 u" [/ x/ I* o8 [* h" S
- con.close();) t' L6 p9 |. y+ r6 e, z: w# a' c
- } catch (SQLException e) {
0 N0 @1 _0 X! G( g5 o8 Y4 ` - // TODO Auto-generated catch block- ]( a% N: b2 I6 X" z, W# o) E
- e.printStackTrace();% j2 ?! z: f# l. N0 n6 H- s) K0 ?
- }; G. N1 i! d4 h2 n. [( z
- }" l. w; [; Z" _" f
-
, f# y: E$ c8 `3 I ~# b - public int update(String sql,String[]getValues){
, M* I @5 v0 v! \) p - int i=0;6 p+ I3 Q4 }# y' e# P5 u9 U
- Connection con=null;
; o- E- x4 K, U$ s$ i. S) L - PreparedStatement past=null;& m7 X& n( w* W K
- con=getConnection();
4 Q% V9 j7 r/ _0 W: a9 F s - try {6 @- C# Z; u( Q Z
- past=con.prepareStatement(sql);! ]7 U5 F4 j0 ?, j
- if(getValues!=null){
2 f ~! U% G9 z' I+ p% C$ ?! ^ - for (int j = 0; j < getValues.length; j++) {; C" j6 ] F4 y& I l- T' j
- past.setString(j+1, getValues[j]);
, n R; M" W% n. K& V/ [0 v/ C - }
+ }$ q5 F2 H1 i, X6 A3 d* | - }4 C/ N8 ]% I" a6 ] v: F' [6 W O
- i=past.executeUpdate();
|7 a- B2 l1 X: `2 A& X" ^ - } catch (SQLException e) {
, m4 Z: T( [8 G5 C1 h7 [ - // TODO Auto-generated catch block* X T, l q0 }2 Z9 a2 V) T4 y+ L
- e.printStackTrace();3 i6 Q+ Q+ o* u' x/ }
- }
! l4 t9 i: m- O6 r- {% y- m5 q - return i;6 `# B, B- z# p, N& p# x
- 6 ?- t6 M7 |4 C/ C/ J" ?1 \* d! h
- }4 U, U. H Y; K, v+ j; G$ h
- }
- {% @0 `( z" @7 p- K: O
复制代码- package s2.jsp.zhangxiao.dao;
Q/ \$ V* k; h$ w, z - % P0 n5 { O; d- M3 c
- import java.sql.PreparedStatement;
+ ^4 n' b/ |0 B0 F - import java.sql.ResultSet;
# c6 X8 o' Y% T, @4 j9 r: K& q ]" u - import java.sql.Connection;
& F0 W2 ] J# j9 H# q - import java.sql.SQLException;' V; y l* n _+ h. F: n1 ^
- import java.util.ArrayList;
8 V4 I! I/ t+ `8 y - import java.util.List;
+ a1 p$ J5 g6 ?# g* l) r
4 c. P+ ?# z8 X- import s2.jsp.zhangxiao.entity.Phone;' O( C& P( W% L1 S# e! V
- public class PhoneImpl extends PhoneDao {
- _6 c6 O& s" T/ g& |9 o; d; \ - $ h8 r& F; t5 e" R6 ?
- public List listAll(){
& u! ^" v k B - List list=new ArrayList();; {$ m+ I( H0 B: _, k' P4 D
- Connection con=getConnection();. Y% v5 ^* C( p& }) Q
- PreparedStatement past=null;4 W J5 p, E2 m
- ResultSet rs=null;" `9 A5 {- [3 ^) l' y/ r
- String sql="select * from phone";
% N) A% R: Q [( R- |7 k' p6 U - try {, @8 z# z% S+ {2 `2 y
- past=con.prepareStatement(sql);
8 J1 |% z; Y' [% M - rs=past.executeQuery();7 i9 P1 N- g9 P2 J, ], x+ n
- while(rs.next()){" [; H# U+ N; ]) D, _7 b- i# i/ k
- // id, type, brand, company, introduction8 d. y( E' _# A* J/ J! ^+ H8 s9 P
- Phone phone=new Phone();) {6 Q! f& Y) t. _+ n, U
- phone.setId(rs.getInt("id"));5 [9 T4 [9 K7 m6 n5 F
- phone.setType(rs.getString("type"));' g+ w/ g0 h* w+ N- N" _8 x
- phone.setBrand(rs.getString("brand"));
. m1 V' m6 G3 J7 \ ]0 i - phone.setCompany(rs.getString("company"));
3 k9 ^! A1 j& `) R7 H - phone.setIntroduction(rs.getString("introduction"));# m! o% P" t5 g( V; v& Z
- list.add(phone);* w4 t( G5 U* o+ l1 |7 L5 p) }
- }
$ Q5 |% A1 I% N - } catch (SQLException e) {
; ~* p# c" |( M - // TODO Auto-generated catch block) L6 y3 ]' k! \$ e) ~
- e.printStackTrace();
" M2 }+ c8 Z( T" p! | x - }" d; c4 \0 c2 r4 b* M$ k3 ]/ B
- return list;
' T& P# k7 K' ~; z2 t - }
+ t5 G# r+ N/ S; ]2 F* F - public int deleteId(int id){5 `/ H' A' U" z$ y* @
- String sql="delete phone where id="+id;
8 V8 q8 N/ y5 G% y! ^: d, Z9 m - return update(sql,null);
7 B" }* C* `5 z - }
0 g) v6 V8 h& C5 D# G% ] - }# L* W; l1 D. ?4 I4 l
复制代码 8 J; `6 }; G3 {" o1 L
代码案例下载:点击下载
) ]0 G1 ]( E" i- ]0 o$ y) i- Z% r$ |/ b. c; C" I/ y
|
|