该用户从未签到
|
- package s2.jsp.zhangxiao.dao;
" L& c6 k$ J1 r - import java.sql.PreparedStatement;
9 ?. L; I, U" y2 C - import java.sql.ResultSet;
: X2 C/ X4 ^& i Q - import java.sql.Connection;2 b/ E; G: V) t+ h/ Y) c% t/ N
- import java.sql.SQLException;& H/ ^ h5 Z9 D1 [& }0 }$ h4 E
- import java.sql.DriverManager;* D5 }0 \" X3 h& J+ s* T8 \4 q
: F1 Z x3 ]" M- /**5 [" X$ I" O/ R3 P6 A+ I
- * 访问数据库
4 a3 h' u: V- }7 y - * @author Administrator% B ?4 d. w# {) d
- *
) v5 r$ ]- _; a) ~$ S5 q, } - */- Z8 q$ j3 g- r8 D
- public class PhoneDao {7 p7 |2 _. O! W# u
- ( l# c9 j2 G% A- E, h) N
- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
* W! W& O- W6 u- d; L8 y/ S - private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=phone";
! B# z# J; e8 H - private static final String DBNAME="sa";! X$ W! J% r( M: ?% ?
- private static final String DBPASS="1234";6 H; l% l' z( }2 d* U/ T9 ?. a& c
- 2 c- J( h0 q, t, j
-
7 X4 k6 U. F$ E' q2 J - public Connection getConnection(){
+ w+ V6 ?- X# P' p/ o! O0 V - Connection con=null;
. O* f/ p) k0 R; |" k# a$ w- F - try {% q2 A- |) C' ?4 a
- Class.forName(DRIVER);) l' B' i% y9 M# J2 c+ } F. B' `
- con=DriverManager.getConnection(URL, DBNAME, DBPASS);
1 p) X) |! f1 J, s$ c$ \6 G, ^6 Q - } catch (ClassNotFoundException e) {
# n! J7 s" c. M9 Y - // TODO Auto-generated catch block
3 ^; `5 r O4 z4 `+ ^* A - e.printStackTrace();
- S% y* j- o& p# P0 q4 y - } catch (SQLException e) {5 V# y2 P1 N3 n% b! I8 y1 m2 {
- // TODO Auto-generated catch block0 _8 @) K1 t4 c* x# N* @# |
- e.printStackTrace();# t2 s! L( u6 L' P$ ]( j3 q, u
- }: I8 U" r5 D/ @" W. l
- 1 k5 S2 {; a" R3 L/ R
- return con;5 a- O/ @* F+ A
- # a- z6 ?4 W, c2 O% P
- }8 Q8 z3 R0 g. P( w. y: @$ X" G' y
- public void closeAll(Connection con,PreparedStatement past,ResultSet rs){' P7 o& Y6 b2 x3 X: v8 I7 x' z
- try {1 R! N5 T! X- ?+ q
- rs.close();4 H# S9 R& B" \
- } catch (SQLException e) {
' E; L+ E/ ?# E0 W - // TODO Auto-generated catch block
$ A p. S6 ?0 W6 C3 C: a - e.printStackTrace();
: \6 _6 {$ U }& w - }9 v% \, k0 K4 t) U
- try {
2 `5 \8 \( r- H' a0 t3 E, S5 I/ G - past.close();
6 K( y4 y7 b- |, S - } catch (SQLException e) {% U. N0 H3 r' B3 F1 l7 w
- // TODO Auto-generated catch block
( G3 a6 J: l3 t% Q+ h1 Y - e.printStackTrace();9 G; X* Y" D* m2 T+ G3 H
- }
5 G# I8 o$ F& n/ @: n% C7 z - try {
% C1 |, K1 v% n- S$ O - con.close();
: Z% Z9 `8 ?" C* f% q - } catch (SQLException e) {, a( N/ I* }6 L6 W) M8 o; {7 L
- // TODO Auto-generated catch block
& j1 ^5 v9 r% C - e.printStackTrace();5 o, H" U+ F- x0 }; ^
- }1 r7 r/ h- c1 q( w& p4 S
- }
a" [* P2 U2 i1 o- f8 ] - % k& ~7 r% T- ]3 H s8 p
- public int update(String sql,String[]getValues){
& m) b) J. ~1 J) b" ~* B - int i=0;; R! F* A$ P7 q$ g6 v
- Connection con=null;: G1 d& s, K2 z- |( M/ R' _
- PreparedStatement past=null;9 G' _4 u+ M* S# r
- con=getConnection();' R* V/ W/ z& R- B4 u7 c! k
- try {
5 Q' L) Q( C. ^$ a0 }. ^$ M - past=con.prepareStatement(sql);# I# A5 s( H# s0 d5 Q# u
- if(getValues!=null){
' G* e$ x2 [2 ^ - for (int j = 0; j < getValues.length; j++) {
5 f. Z+ S% C9 C% V+ f1 v' f" l' y - past.setString(j+1, getValues[j]);
# j ^* \9 ~* q. m - }
* |+ T; X8 J4 b6 q - }; s/ X$ @6 D" @! A0 K( _( P
- i=past.executeUpdate();
0 m* t: ^# h8 a$ r6 Y% _! Y c - } catch (SQLException e) {3 [9 s- S5 [9 K& i; v! O$ Y; L
- // TODO Auto-generated catch block
9 g6 [1 T' G4 o' _8 I6 m - e.printStackTrace();
7 l: T# T5 Z/ s( I - }$ Q. n% x' h1 I0 K( S- l
- return i;. I4 J% _+ F( j& _2 Z. n( z' i
- % V( [3 Z S" b) |$ g! U
- }
% Z0 v$ N# w' B% I6 }- J - }- C* N8 s+ j' a# N' U( Y
复制代码- package s2.jsp.zhangxiao.dao;! P2 _& s2 @/ u2 e
- 1 E# s. k* g2 z4 H0 m% a- y! c
- import java.sql.PreparedStatement;; x, X1 R; V, }1 z( ~1 F- _
- import java.sql.ResultSet;
/ B- Q& p$ x+ \; [: |0 X - import java.sql.Connection;) u) I% G- E) x& P2 m
- import java.sql.SQLException;
; E3 D: ]7 s8 H. D - import java.util.ArrayList;( X) d' M3 l+ [2 d) I6 v! M
- import java.util.List;" H ]5 l. [" F0 Z( w# J
$ k' j$ v6 f8 L- import s2.jsp.zhangxiao.entity.Phone;, k) D; ~+ Q& s: y
- public class PhoneImpl extends PhoneDao {
8 R3 O4 G( C" ]7 w: D- a -
: y4 A' n6 `0 O5 j+ P6 P' n( n. O3 s - public List listAll(){* U2 n+ C$ ]; U
- List list=new ArrayList();
7 v' I( Q7 V1 t4 B, i - Connection con=getConnection();
0 F( k1 }3 x1 V9 G3 b0 u - PreparedStatement past=null;# W6 V7 e0 k5 L. s5 o1 }6 W
- ResultSet rs=null;
& `9 S& S' v& `; I - String sql="select * from phone";
& m7 {: l+ Z" \$ _9 H$ b/ v3 O+ ~ - try {3 `" b0 X& m( s. Y8 g, a8 i
- past=con.prepareStatement(sql);: u" u" ~& b" t% M+ h F" g0 t
- rs=past.executeQuery();7 B5 T+ b* ^+ A4 P0 L
- while(rs.next()){
. [) C% s% h- J0 Z: }0 A4 ^ - // id, type, brand, company, introduction8 S8 m# r% L) s+ ?1 j: K
- Phone phone=new Phone();
% `. t' b' f; b" f# R3 {, \7 A - phone.setId(rs.getInt("id"));
7 l7 D( C( w$ \3 z, O - phone.setType(rs.getString("type"));
+ y$ j% R* J' {/ d - phone.setBrand(rs.getString("brand"));
1 j4 b5 S: j, o, `8 l - phone.setCompany(rs.getString("company"));
5 ^3 N2 G/ n& ~( J4 l8 X4 b5 g - phone.setIntroduction(rs.getString("introduction"));
7 P; j5 r" A) m - list.add(phone);) z2 k3 o% G4 k- B# g+ L/ c
- }
( z) d2 M/ M0 S/ G7 z - } catch (SQLException e) {% x* j- ?6 P, l; @0 B
- // TODO Auto-generated catch block
4 J- c D0 x# W+ d - e.printStackTrace();" D9 K* R" ]% \# C/ a5 Z
- }
: x2 W1 V, ~ i2 Z( S- S - return list;. S x. w6 }! ^& q" w
- }8 m- B/ \0 s" T: n S) h. E, W
- public int deleteId(int id){* S& n1 \$ L8 U T0 S* J0 `0 L5 @
- String sql="delete phone where id="+id;6 ]& S: }( y: c& ^
- return update(sql,null);2 E# J7 ^! B y$ J( @! w: U
- } ~/ [( K) i* r! V
- }$ O6 n: @, Z) _; u
复制代码 2 S# _9 t* F1 p6 t; I
代码案例下载:点击下载1 e( x; f8 J) ~5 r: v/ A3 X8 X' C
4 R' o* q. Q- y0 H1 K2 Z/ t; X |
|