该用户从未签到
|
- package s2.jsp.zhangxiao.dao;' R' z! ~6 t4 p; K* w6 V
- import java.sql.PreparedStatement;
: ^3 u, C7 M4 l% Z! f - import java.sql.ResultSet;
6 y0 `; ^ [) u9 f, e( C - import java.sql.Connection;- v6 U/ ]- E8 b% ]- i
- import java.sql.SQLException;
6 z( w b3 ~: v8 Z - import java.sql.DriverManager;4 r( S" v6 \3 N( Z5 f Y( O4 y
9 t! s1 T4 ?0 e+ L/ c- /**
: U+ _ V. c/ ~. v1 P) a3 I - * 访问数据库
+ c6 Y6 _7 f" B; n0 L3 O - * @author Administrator
$ O6 S& _4 h8 f0 b4 G& C6 ~" Q9 P - *
# v) x# D( n. i( a - */; B' q+ U+ ~* ^& J& o! U
- public class PhoneDao {
+ c! H. w5 \& L1 v8 F: c% ^
[1 @% u$ \8 Q" S ^( t* j- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
8 ~; p9 U# ?! u# ^5 W - private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=phone";. f% _: Y3 T. G1 K9 E$ T A& j( w
- private static final String DBNAME="sa";0 ^( d. {% t7 i
- private static final String DBPASS="1234";- q6 E h' @, ^6 c. u6 s: y
- - M5 I0 B9 T2 S& V8 \0 y9 _) T
-
. H+ Z' L+ D& v Q6 H' \/ V* }$ v - public Connection getConnection(){2 _) x+ G" Z& Z
- Connection con=null;
- q$ B z( u. J2 d% C - try {: I+ _' ?7 \* b3 G( \& S- ?
- Class.forName(DRIVER);
& Y4 l# m- K0 a1 N& N - con=DriverManager.getConnection(URL, DBNAME, DBPASS);
+ G3 G) {/ d* I* s7 C5 c - } catch (ClassNotFoundException e) {$ V& J C4 |7 X0 B
- // TODO Auto-generated catch block- D1 I/ D" A' k( k
- e.printStackTrace();5 h' M& f6 p. T) r% B: O
- } catch (SQLException e) {
8 b! O' A4 v& V1 z; J- y - // TODO Auto-generated catch block
8 B* u+ m1 `2 Z" @: p - e.printStackTrace();
( m+ ~+ s1 }7 L$ [- u! c( t a/ r - }
( S9 z( p1 I; _! ?" [" n9 ^ - 5 _ B6 O& C2 V/ h, Y% ]' O
- return con;
: T# H' P2 \! b) U2 H - $ ^+ ]5 [* o9 h" G J' r
- }
3 |' [2 T& L; N' {4 r4 }; H - public void closeAll(Connection con,PreparedStatement past,ResultSet rs){
$ A, I8 x8 Y% ^ - try {& v; P' P/ z) c2 P* s# m
- rs.close();
$ \0 p6 B2 S; o2 i1 M - } catch (SQLException e) {7 C; h: A0 v+ ~8 ?" {
- // TODO Auto-generated catch block9 z7 W& v9 Y5 }
- e.printStackTrace();
" W& V4 n5 \( |5 g, e - }" U. O7 K1 \; V! J
- try {
' I) e/ d1 n0 `" b7 A0 Q - past.close();
5 f# C' `% \9 M4 Z. Y8 \, k: g - } catch (SQLException e) {2 ^6 d$ j" v" N8 X
- // TODO Auto-generated catch block
9 K' P2 Z/ w6 {* `/ O- A. R, X+ e/ y - e.printStackTrace();
o5 y G7 A" |: ] - }
% T+ b% }" V, v - try {$ ~- x M" h* L$ y0 m3 ?) @( v
- con.close();
% e' j$ A" s9 f1 n) Z - } catch (SQLException e) {8 X9 ~: ]5 y9 I% M+ O/ j
- // TODO Auto-generated catch block, V8 o% [2 A% X: P. q9 p
- e.printStackTrace();) t* R9 ]" }7 q1 D3 v, Y9 G! Q9 `0 D
- }
( X1 L0 l& H2 f ^% b' ] - }) p7 s5 \9 d; X( x' D
- - d+ x" n' e# T' L
- public int update(String sql,String[]getValues){
& D. M* ]8 k4 v" H& | - int i=0;
5 \6 r2 k1 X$ H - Connection con=null;
& b: t$ H4 ^+ V3 Y& ^ - PreparedStatement past=null;: _- Q3 W% K2 v
- con=getConnection();
4 R) G( l- h, e& { - try {
8 U, j5 w* `+ Z5 x - past=con.prepareStatement(sql);
! e" ?* F# x+ e1 F+ z3 \( @3 v9 I - if(getValues!=null){$ x* T5 E9 O! h
- for (int j = 0; j < getValues.length; j++) {4 J2 J! A3 d9 i7 t
- past.setString(j+1, getValues[j]);
- D+ [3 E5 P' j' i0 [ - }
: `" [& v9 _" O5 z - }! {. H I8 \+ _- _; Z3 Z6 F- T
- i=past.executeUpdate();& b+ Z6 i( H0 {/ E% o5 K
- } catch (SQLException e) {
# u/ ~6 o- _& D* | g) X7 Z - // TODO Auto-generated catch block
. F' A' w9 ]8 v s - e.printStackTrace();
) c" }- b6 ?# A4 h# v5 w - }3 X* B/ I8 `- L) K3 Y. @2 i
- return i;
x* q3 d W1 F R6 G, ? -
* s" d$ ~/ i8 W6 |' [: } - }
/ B$ S0 [: v" T/ L+ C4 R, | - }
2 X3 }$ r$ z5 s
复制代码- package s2.jsp.zhangxiao.dao;
2 O2 }: R' C4 n, D" q& ]) H
! ?+ |* p+ k) F0 Q" C* a- import java.sql.PreparedStatement;) P# i5 B6 p: P; e4 S
- import java.sql.ResultSet;
0 }2 ?8 I* j$ T& r) X - import java.sql.Connection;) @& _0 _1 k( J
- import java.sql.SQLException;
. p: j! h- D( h) d2 Q - import java.util.ArrayList;9 O: T( Q7 F& L
- import java.util.List;9 { ]7 E9 ]1 k0 v/ Q( p
( v- Y: ?+ u6 [6 F- import s2.jsp.zhangxiao.entity.Phone;
' N& r) C" _' O8 B+ \ - public class PhoneImpl extends PhoneDao {
, V+ W8 d7 L$ I9 [$ l% t0 d -
7 a4 [$ n' g9 Z3 D - public List listAll(){
7 c! u/ ~4 L; Q: J1 i4 T - List list=new ArrayList();
8 R9 V- {% ]* J( F$ i - Connection con=getConnection();% Z X$ d7 m0 F; @- [
- PreparedStatement past=null;! i2 S+ n+ G- V( {( t( }5 m% ^
- ResultSet rs=null;
. r: j3 P6 r5 A [( B - String sql="select * from phone";
" j2 b; q3 E5 p+ |. Q+ Y - try {
( ~9 q6 H+ B9 R+ Z4 a7 a - past=con.prepareStatement(sql);
+ A2 |+ N/ H, ^2 w - rs=past.executeQuery();9 \& d, Q) r, V4 B! j; e2 ~, P
- while(rs.next()){
/ Q6 W N3 H! O. \ - // id, type, brand, company, introduction" ?5 h( z; s( J* D! K% G) v
- Phone phone=new Phone();! G1 t: e+ A7 E
- phone.setId(rs.getInt("id"));
! i0 s$ M2 L' d - phone.setType(rs.getString("type"));1 R, [6 P$ ^7 O3 B- Q
- phone.setBrand(rs.getString("brand"));. w) q* x f/ O- [
- phone.setCompany(rs.getString("company"));' v& E4 i* M$ J H
- phone.setIntroduction(rs.getString("introduction"));
9 A3 b& p; d. J H) C - list.add(phone);' W; k; D* E0 ^6 n
- }3 h: O0 r! H% c
- } catch (SQLException e) {# Y4 U0 Z3 F/ \- D
- // TODO Auto-generated catch block
7 W9 F9 k' p% y1 J - e.printStackTrace();
& C& J; g; b* w6 c - }6 d8 d0 D4 U8 n
- return list;7 a1 t% J, Y1 b7 D$ l
- }, n" N3 h) q. u$ }1 }
- public int deleteId(int id){( R- v3 J7 ~$ h5 b
- String sql="delete phone where id="+id;* k z+ M# p7 Q& f. j# Y U
- return update(sql,null);
( B+ X, J' k: {4 q# X \ - }. z: P/ p, o0 z8 K
- }! j2 j. x# Q# ?
复制代码
9 d l) `, |2 ?% |" y代码案例下载:点击下载) b! ~5 `6 f6 A8 H5 S# p7 s4 f; l5 s
8 F) ]9 U% E9 S' _
|
|