该用户从未签到
|
- package s2.jsp.zhangxiao.dao;
O: [0 V% z& k' H$ O4 O - import java.sql.PreparedStatement;
2 ?8 ^6 w$ ^: y3 J$ Q6 b' ? - import java.sql.ResultSet;
+ Q( f7 A9 g. t0 A; O) s - import java.sql.Connection;
: K$ D& [8 _0 y: D+ \- L x4 ] - import java.sql.SQLException;* [% l& C4 |* q1 z
- import java.sql.DriverManager;4 s8 ]) _7 P2 M! ?" W6 a/ ?
5 X/ A( q6 v* B3 T7 w- V7 `- /** n5 M+ i0 |, h; t0 x- s
- * 访问数据库
) j, a% k1 w3 w& F - * @author Administrator1 b2 T v, [! ?1 O
- *2 {, n) J) s7 w! b- x- S9 f
- *// O; q( n' F' O5 M( i
- public class PhoneDao {
) C R ]3 j3 \ - * X! M9 d/ U$ F! k" G J- c* `( z
- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
4 D$ E8 `( s( [ - private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=phone";6 N, \3 G2 m- `" l
- private static final String DBNAME="sa";2 C7 F( ~! I! X! [3 \
- private static final String DBPASS="1234";
* q- P) k9 j: M4 S2 H3 F. B - 7 b E7 N! ^( h4 {
- ) _7 U1 ^# y. b) G
- public Connection getConnection(){- V( _; F& }. Q
- Connection con=null;
/ q4 R; U0 m% D7 T) A7 F. U2 Z# O* G - try {
6 ?# S. I' K1 v+ }, o0 r2 M r- h - Class.forName(DRIVER);
6 D0 C5 @! B! f4 l( S) r: r - con=DriverManager.getConnection(URL, DBNAME, DBPASS);
. X: _+ ?5 p7 u" b3 _ - } catch (ClassNotFoundException e) {5 M% L. Q; ]& p5 P- t# q
- // TODO Auto-generated catch block
/ [! ~0 d- n$ n& {/ m - e.printStackTrace();' B/ f4 `8 K' g% O- l& ~# I
- } catch (SQLException e) {
2 y* _; F6 ^3 z+ g* C3 U - // TODO Auto-generated catch block
9 T8 B& m+ L( @; `; Y( j - e.printStackTrace();
' d& K# ]+ d; J; [( V - }
$ H8 ^( G1 H1 Z" H# r# @1 K4 _, O - ! O1 V7 p. y9 L8 [7 c
- return con;& n7 m8 G% V6 w
-
/ T; c5 W- e4 w* q - }' S! _9 H, [/ ^" V
- public void closeAll(Connection con,PreparedStatement past,ResultSet rs){+ U3 X8 Y. U9 ?$ A+ x2 n! Z
- try {$ z! K4 |0 W: m
- rs.close();
* p& V _1 O5 b& s0 a8 e8 [ - } catch (SQLException e) {
* V$ r( e0 ^. b% m) B- y7 M - // TODO Auto-generated catch block
4 P @9 ^4 K; P+ X! l - e.printStackTrace();1 m. h* t4 I( w. f* j7 t( {* V
- }
; V( Z# i9 o9 T7 p# z8 g3 Q) K - try {: Z( B O8 m1 t' X4 ^! v$ p
- past.close();
' e: a b- U" ^ - } catch (SQLException e) {
9 m! M& ?2 z4 `* W3 _3 N - // TODO Auto-generated catch block
2 H: }/ A5 B1 k& v( o - e.printStackTrace();
/ ^( ]% J) h$ V - }+ [/ ]! O# x8 _; v# x# ^: m
- try {
, T( g d$ N' `+ ` - con.close();
; K: v4 l2 N {) c+ q1 d - } catch (SQLException e) {
; \) B+ b0 k& s - // TODO Auto-generated catch block3 o9 n* [3 h& \/ v2 i
- e.printStackTrace();
1 P( b5 g8 ], a6 } - }
8 _! X+ P. {; h - }
+ Y8 G, ] e- v4 ]& d# {% Y -
. O1 x" }& I9 u% ~+ Z0 G8 H$ j - public int update(String sql,String[]getValues){5 a" X$ m3 j% }4 h* e, A w
- int i=0;1 A9 m' E- `+ R+ T) H9 a
- Connection con=null;2 V' h" i1 t% i$ u! S
- PreparedStatement past=null;+ z6 I" ^" g" \: A) E! d
- con=getConnection();) W9 W$ s4 @9 T, ^/ A
- try { z, \- D3 V9 \7 s
- past=con.prepareStatement(sql);5 _' O# v; _" o
- if(getValues!=null){
8 q! |5 B+ W* ?: o! d" R4 ^% i" o3 n - for (int j = 0; j < getValues.length; j++) {( h e8 ]/ o& c7 q$ A! ^
- past.setString(j+1, getValues[j]);
P, i* P) f q$ ]5 M - }
y3 T! l3 Y/ `, [! v% j - }* o, H& p* `- y
- i=past.executeUpdate();
$ |6 k' m/ D8 N0 [$ B; y3 o - } catch (SQLException e) {2 A ]( C" e& i" Z6 n) T( u
- // TODO Auto-generated catch block- g% B# k9 B/ b7 B' i+ c7 y8 `
- e.printStackTrace();+ W! r, r: [! `; H6 _& h
- }
; y( N# H' T" |2 \0 G% x - return i;
- n8 k0 z7 M: Z) Y# i& D" U5 ? -
5 |; N" P7 s1 H- ` - }, d+ G; K+ Y& x! @8 M
- }
9 `" W$ `0 | O; D( Q3 J
复制代码- package s2.jsp.zhangxiao.dao;
; O. p. O' n' |, M+ L7 U$ P - 1 w; V. y2 ~& O2 u
- import java.sql.PreparedStatement;
% M7 A7 ]7 ]+ G' B2 ~- |# i - import java.sql.ResultSet;8 _4 C7 S+ g5 x9 u% m4 g, [6 v
- import java.sql.Connection;
# E: T; j/ v" q* S5 \( M - import java.sql.SQLException;
6 C& B+ {& @$ n) n L" c, ^ - import java.util.ArrayList;& I& n" g0 W7 A7 u4 {( l
- import java.util.List;8 \& H7 S8 v: j+ z3 Y/ F
- + ?4 p& m3 ?5 d4 ~, K1 H4 r
- import s2.jsp.zhangxiao.entity.Phone;$ B* j1 L- e3 i3 L4 M/ C; N
- public class PhoneImpl extends PhoneDao { [$ @6 L5 u; l0 D. D5 m( X7 v1 P2 A
- : Y, a6 u3 H' d* J# _! m7 y
- public List listAll(){
6 M/ w' Y1 A. q7 }4 [7 t - List list=new ArrayList();
& P( B" q9 b. e7 f" y - Connection con=getConnection();
% G4 U+ l; }+ s, e0 N6 v/ L - PreparedStatement past=null;
: s7 M. h2 f, a9 b8 a - ResultSet rs=null;
* r8 Y7 X7 h; S! s - String sql="select * from phone";
% v: s$ ^. I6 o! ]; ~9 U( k - try {1 j n* e) |9 R( ^6 m! ^
- past=con.prepareStatement(sql);
9 j$ Y' | N4 m" { - rs=past.executeQuery();5 L) ]0 `: _2 u: B
- while(rs.next()){* t- \( F+ u! w K& z3 ?8 D( o4 e
- // id, type, brand, company, introduction; V1 s' O9 m; ?% s7 B% f1 o
- Phone phone=new Phone();; [ A) E7 h/ @2 q1 \3 }
- phone.setId(rs.getInt("id"));0 [ [) D3 X% s) ]1 m3 t
- phone.setType(rs.getString("type"));4 F5 U* R( O7 ?, A6 p- }0 T, q
- phone.setBrand(rs.getString("brand"));
/ M: x* F' H5 z2 ] - phone.setCompany(rs.getString("company"));$ z; U: b% G' X0 w/ D
- phone.setIntroduction(rs.getString("introduction"));
W! L- d1 t+ Q% B7 F! S" p4 Q - list.add(phone); n$ L- A0 ]5 k8 B, h9 k9 O" \8 a
- }$ h7 J" I/ T' @: Y' K
- } catch (SQLException e) {
+ r r' O5 z, L. R0 ^' \ - // TODO Auto-generated catch block* I$ }3 t: h5 E( ]1 l& C3 D: X
- e.printStackTrace();
$ V9 y1 }+ Y* e6 P# U. c4 C - }
- `& \+ B2 @" Y' z) W - return list;
, I- }7 d1 ^! l+ A+ T( |! Z, h. r - }) I! g% ^0 O' t! `: h( i' L, L
- public int deleteId(int id){
* \' l( o. a! ^" r/ ^ - String sql="delete phone where id="+id;: X2 G9 N- ^& i. ~
- return update(sql,null);
. ?! b& s3 t- H- e: S# B4 h' ^ - }
+ u: O' |! {& Z+ D - }( q; v" `( [: K$ x1 c7 v2 Q1 e3 `1 S
复制代码 6 j, W/ D& Y* U% V
代码案例下载:点击下载, ~4 J$ [7 y+ d" h
% R! P% a4 A$ r# g$ T
|
|