该用户从未签到
|
- package s2.jsp.zhangxiao.dao;
$ s9 H: I$ g; u% E) U - import java.sql.PreparedStatement;
{2 b' E6 \3 V' ?& I0 d7 i - import java.sql.ResultSet;
# z7 y" {: z. [% p/ o" I0 X+ ] - import java.sql.Connection;
( L8 j& B9 U/ h0 ] - import java.sql.SQLException;
& Z) }. ?& n8 c8 y" d7 x - import java.sql.DriverManager;
+ v& p, G3 D+ F" i" @; C8 J
; g: l. t" ~. k4 k, S" n' P% _" B- /**
3 w% P- b5 v$ D7 w' P6 p" I - * 访问数据库$ `: L, ]/ Y: |7 O3 W5 h
- * @author Administrator
" t" o: S, `9 a6 @$ [9 k - *+ q, j. L9 `/ N/ `8 s
- */ |4 H! t8 [- N: b! a2 @
- public class PhoneDao {/ c8 v6 }8 D1 E$ j8 [
0 E Q! Y' f6 [1 Q1 z- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
! s0 Y' i' l# r - private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=phone";8 M0 X) r9 M2 m2 F, M! q! |- f# L
- private static final String DBNAME="sa";/ p/ W! \+ W2 {6 B# Z0 s0 Y
- private static final String DBPASS="1234";. i* g% G9 o: ?+ S: A1 f
-
8 o/ V" x+ Q. W3 P7 o - 5 L$ O' X: r6 X
- public Connection getConnection(){7 D e8 q7 `; H# N& G
- Connection con=null;
0 m; ] |9 E. M2 `; Z% \3 I - try {5 ~3 w9 `( L1 k! M# y
- Class.forName(DRIVER);- D; g3 a1 U+ o4 A
- con=DriverManager.getConnection(URL, DBNAME, DBPASS);4 E& w7 {* u8 p: t6 V
- } catch (ClassNotFoundException e) {4 N; r7 K- M: z- i: X
- // TODO Auto-generated catch block
, V0 ~! o* M9 w. _/ I+ L% t; Y% ], _ - e.printStackTrace();7 N. h8 r A& S9 q
- } catch (SQLException e) {
0 U0 u$ I$ x4 L5 [) _( @ - // TODO Auto-generated catch block9 S7 W; w' f( r' N O
- e.printStackTrace();
6 [7 W( J! u9 |3 ]8 @& X - }
: q6 I8 K4 C1 u+ K# m1 P4 A -
; p- q" G4 _: A0 Q9 G/ c6 R - return con;
; G% s8 t2 P$ d - 2 c) G, c; T& k' K2 l
- }
4 u- T! X+ N* U7 z - public void closeAll(Connection con,PreparedStatement past,ResultSet rs){
3 S9 N* P+ @/ J" L: K0 O! ?( b - try {
, Q2 `/ W; d5 ?' Z, D - rs.close();" {- A2 w/ W8 l) ?+ H
- } catch (SQLException e) {4 r9 |) m4 l% B$ {7 K* ~
- // TODO Auto-generated catch block
' c) l4 `( b, {; A/ ]+ _" u - e.printStackTrace();* y4 f& ^2 R' g0 x C8 j# j- K1 A% w# N
- }( u* N4 W0 J6 D
- try {$ U f8 @0 ~, \# S# R' @9 D4 G
- past.close();$ \( ]/ f( A1 [' r# _. f
- } catch (SQLException e) {- R4 { F4 b2 a8 Y2 N, @
- // TODO Auto-generated catch block3 t' b6 X% s: ^2 L
- e.printStackTrace();* a8 R3 Q4 w0 f+ b% X3 X# z. n
- }
; P4 ^/ r7 Z. Y7 B - try {
# ?( f" Z9 u; }* A0 ~, |/ p - con.close();
3 B# ~! Q* e2 Q0 I1 `' ]' q$ l6 a3 N - } catch (SQLException e) {
# D( s) ^% ` S! S# D1 ]" _ - // TODO Auto-generated catch block1 n* r5 I! T9 f4 z p# z4 ^
- e.printStackTrace();
) i; K5 P1 X S j6 U' b0 Q9 y( t - }
" d, @. ~' h9 W - }' u2 x3 S. E9 \
- 5 z% n f2 f9 t( A" S6 j6 j
- public int update(String sql,String[]getValues){ |( o! c z) s' y9 H, S
- int i=0;1 \1 J+ ?( W: w7 y! Y
- Connection con=null;
) a# \3 e/ B5 u& g) A% |. c' B - PreparedStatement past=null;
Z2 a1 c8 |- R+ M - con=getConnection();
& M$ N7 q) D# Y' l0 \ - try {4 V+ f1 h, f0 @3 V7 p5 f2 V3 ]% V
- past=con.prepareStatement(sql);
# `+ S' d% _* t' k& Y5 H/ y' ~ - if(getValues!=null){" C& v9 ?7 `: G
- for (int j = 0; j < getValues.length; j++) {
% c; {/ i3 L& C - past.setString(j+1, getValues[j]);% N( C- z# p5 z, Q8 f' Z
- }
3 v) V' w& @, ~. F" F- v8 Y - }: k% p% M8 _8 ?7 G# h9 q
- i=past.executeUpdate();& L) S7 F0 I/ d2 k0 }
- } catch (SQLException e) {
& {, ^" s7 Z: { - // TODO Auto-generated catch block' p/ F/ P4 N# Q$ v1 J" N. m
- e.printStackTrace();9 z6 @$ E) R- q2 z9 {, v+ m
- }* B' N+ A, b* J( u$ g" h' a/ J: q
- return i;& J' j1 M b3 h9 b, C
-
: C v/ x; c4 p. z( m - }
4 G$ m* q# y0 g& Y - } x, z" E5 M1 G3 g. k9 `! h
复制代码- package s2.jsp.zhangxiao.dao;" W7 v" s' X+ q2 @
- ( @+ X3 T3 N1 j- `1 y& m- N
- import java.sql.PreparedStatement;) G# O9 h/ A2 t7 @& k
- import java.sql.ResultSet; y# b5 T$ E/ \6 E& E7 C* T
- import java.sql.Connection;
& [# p3 ^4 e/ D+ {( t: n - import java.sql.SQLException;
4 W- _/ t) ]7 ^- P# y7 n - import java.util.ArrayList;
$ k: K; C! z% z9 B - import java.util.List;4 {# V# L* h/ j5 y7 a) t/ k* U7 {
6 V4 e% o" w% V- u9 ~/ T2 F$ T3 n- K- import s2.jsp.zhangxiao.entity.Phone;
4 I- S; w3 j4 Y5 X/ [! a - public class PhoneImpl extends PhoneDao {; {) s4 V( Q) c% M2 v% D! g8 o
-
/ r2 I5 C' V( n! ~3 z& N - public List listAll(){9 R9 ?% @" I* R1 V
- List list=new ArrayList();. S: T( ^* N, c( H
- Connection con=getConnection();% d$ w( p# @+ B
- PreparedStatement past=null; l( W# v3 I! M# I3 e; ], I
- ResultSet rs=null;: P0 @# k1 }5 N
- String sql="select * from phone";
) T+ A* U1 U# f" r. T - try {& x$ T `: z0 ^! a
- past=con.prepareStatement(sql);' z! | V. L; c, X1 I
- rs=past.executeQuery();
& k) T3 v; q' _! ]& n - while(rs.next()){$ k2 w$ C: _: a W
- // id, type, brand, company, introduction9 q' C% v" _/ ?
- Phone phone=new Phone();
4 h1 s l0 o5 Y! w- R - phone.setId(rs.getInt("id"));
& j2 D6 q6 W, e$ ` - phone.setType(rs.getString("type"));
% X7 B2 V' m U# T; x! M, r x - phone.setBrand(rs.getString("brand"));0 W/ N) d7 D0 k% W+ N
- phone.setCompany(rs.getString("company"));9 b# L4 K4 q* D( N( L2 ~9 Y* |4 k
- phone.setIntroduction(rs.getString("introduction"));* z2 P! q1 ?/ J. h' ~' ?, P
- list.add(phone);* X# d6 F5 s! D
- }5 k& y3 e* T4 ^
- } catch (SQLException e) {, n9 `. v0 ^8 u# a
- // TODO Auto-generated catch block6 ]$ ^& R/ ` P# X/ J# a# [6 U
- e.printStackTrace();
8 Z" A2 C+ U: [% B" p) a! Z9 ~ - }
2 T2 M0 ~+ {& E# ]7 E% Q: G - return list;4 c- E$ _- s0 d$ J
- }
" C4 H' F i) v" Z# C8 v - public int deleteId(int id){
7 K' E `/ q6 E5 o1 J* b8 x; J( J - String sql="delete phone where id="+id;
0 p. ~0 C2 F- n+ f - return update(sql,null);
9 L1 C6 E. s7 |4 U! E# _1 l - }
: g, Z+ P: ]5 V5 |" t3 b - }
! ^& o' c- u& x% w$ Y
复制代码 3 R% G0 T6 L1 {- @ b4 V# f3 k
代码案例下载:点击下载6 v- K" F) |& N# {4 d$ }: @
# w0 k# Z+ h8 K3 O+ _
|
|