该用户从未签到
|
- package s2.jsp.zhangxiao.dao;
( b$ L' l/ X1 i - import java.sql.PreparedStatement;
3 P, p# j. }! f( e3 G% v6 n& Y - import java.sql.ResultSet;
( {( ]$ ?6 f8 M3 K7 K1 d - import java.sql.Connection;
- l7 v# x6 R& {5 ` - import java.sql.SQLException;
& ?% ^+ R; I3 Z8 ~* d/ K6 p8 d - import java.sql.DriverManager;, Z. }! o9 Q$ _# L3 L4 n
- 9 J7 y) H$ e& J, U
- /**( M3 A9 z& F: z* v0 i
- * 访问数据库
' a; O0 N* B1 a4 k. [9 w9 x- A& v - * @author Administrator
+ h7 C4 y) G3 K* @: v B) e. i; ^ - *
% h% D! E P" A7 C$ D - */+ L! R" H4 c0 n& w1 R
- public class PhoneDao {
9 n) l' n/ v( v1 C6 C, O - ' X p5 j6 \, j$ @$ n' v5 h: Z
- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";; H4 S& ~0 P% w; ~9 _& Z
- private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=phone";9 N% @; U1 y( n
- private static final String DBNAME="sa";: {1 {6 |& h+ f6 @5 n9 g; N7 l, m
- private static final String DBPASS="1234";
0 N& c" @. S9 e3 D& d - 4 b5 x+ B p2 r/ J: [1 e" a3 B
-
" [) U' V; a7 f. _) {" B$ v - public Connection getConnection(){8 k' T/ J. d" Q* ?* `# `2 w
- Connection con=null;
. n3 m* D( W" o c8 W; q- y0 W0 g - try {! U! X+ a: R& ]2 k2 n0 ^! ?' b
- Class.forName(DRIVER); |- Q! O- L3 w8 o( _$ a
- con=DriverManager.getConnection(URL, DBNAME, DBPASS); b+ E' g' m2 X P5 n
- } catch (ClassNotFoundException e) {
4 m- W& [6 t% k+ c! ]! e0 s: E; F0 {. P3 Q - // TODO Auto-generated catch block
) f' j$ f# L! B- O - e.printStackTrace();% F2 m6 x& y6 E$ W3 }; @3 w
- } catch (SQLException e) {
0 [ E- F2 B; z0 [) d - // TODO Auto-generated catch block
8 K9 R$ R% V& j+ U/ U' S6 y- ]) ] - e.printStackTrace();3 Q1 V( d) A" \. z' E$ I
- }- W( q) B% J, G3 b3 S1 i* u
- 7 j# W1 e; e. _$ |
- return con;
7 F6 C; N! D9 k -
4 { ^9 L! f, P& P9 k9 H - }
! t5 ~$ e+ {. w* S2 X& W( S% h( I - public void closeAll(Connection con,PreparedStatement past,ResultSet rs){
' ]$ V5 n' ?5 P) H, L o/ C# p - try {
) N8 _, V! O$ m8 g% O; h - rs.close(); o4 [4 ~$ p) \/ T8 R3 S$ V
- } catch (SQLException e) {
- q2 N& U5 E7 f+ G' I - // TODO Auto-generated catch block/ G+ C4 S/ s6 C; w. F, a
- e.printStackTrace(); C1 W9 j( B; K
- }5 Z* d0 \7 @1 G" j2 x
- try {6 ] H8 z. `3 ]1 k
- past.close();
: ?" `0 k3 f: { - } catch (SQLException e) {
, x5 Y% p# {: x" w5 _ - // TODO Auto-generated catch block
# j& ?, ?, A9 q" N% r - e.printStackTrace();5 D3 i# i1 Q# v4 ^: e
- }
+ e+ y5 G4 n0 S9 ^. z - try {
. P9 ^! @. w, i H# T - con.close();5 b3 m7 J/ d3 ]' o7 Z5 U, {/ P
- } catch (SQLException e) {
, K* Q5 g! r3 ?0 D' z' {- M! y# d+ s - // TODO Auto-generated catch block
% c$ c) V6 j; ~0 M- W! P! h - e.printStackTrace();
- b( j' U. H9 y: J7 q! |/ b0 I - }
8 i9 i% Y# s6 R g( d - }
. m# r9 H+ l: g! R -
$ C- Q2 G2 j6 \! b, Z - public int update(String sql,String[]getValues){' q# _& i' |$ u, F! w7 K% v
- int i=0;. e: q1 y+ T* s" _( W$ b0 w
- Connection con=null;
+ x8 I7 |6 y0 W1 D- r3 G* g - PreparedStatement past=null;
7 \5 L; k2 m5 \" _$ {8 k - con=getConnection();
8 d' _, u* A2 j - try {# M2 N" p3 a( F, I' D# X
- past=con.prepareStatement(sql);& q& ~% l% d8 a; t
- if(getValues!=null){* Q0 X. D' t' U, c% k
- for (int j = 0; j < getValues.length; j++) {( ~3 {5 S/ \7 [( d: F% a) K2 [6 Y/ C
- past.setString(j+1, getValues[j]);
* I; i0 o' i' q# S# a8 y - }# k4 R9 a) r8 f# _: l
- }
4 M! _6 M/ I0 |: y6 h - i=past.executeUpdate();/ v# d0 S0 e. h2 z0 h/ {8 P1 q
- } catch (SQLException e) {7 t* ?1 w2 L) D& u/ [$ t3 }
- // TODO Auto-generated catch block9 ]/ [- R7 L2 c
- e.printStackTrace();
/ H) m3 H7 g7 h+ g3 q8 ? - }
* u! g' [" A& a* U - return i;
! ^; m6 E* \2 M6 h" q' E9 j -
, |( e% B! \( w, X: h |1 u - }
3 v6 Z1 p/ H! V7 m o' w: E - }; l7 a: x, W& a- ?2 p+ w. C9 \* f
复制代码- package s2.jsp.zhangxiao.dao;
1 i) c4 x5 n/ s" R - + g7 _/ h3 Q6 s! ?4 W
- import java.sql.PreparedStatement;7 \% c1 R7 q7 E# f* ?" _6 X+ q- }
- import java.sql.ResultSet;' V, j/ r4 Z$ b
- import java.sql.Connection;8 w* p1 I3 S. [8 {! R8 B
- import java.sql.SQLException;4 e% h) H+ z8 L8 j0 b# t i
- import java.util.ArrayList;' O T' j9 q! W+ }4 |6 u3 d
- import java.util.List;% l( x! @& ~" K1 ]1 l8 T9 l' l
- 9 z6 ?! \2 {5 L& I- }, d; K S; I
- import s2.jsp.zhangxiao.entity.Phone;
, c9 L7 c' e5 i8 h7 k* @ - public class PhoneImpl extends PhoneDao {
- k f/ B3 k: s1 M, S( ~; h% r6 f - . b/ j5 O$ K) _+ ]+ b% V& C
- public List listAll(){
. I/ h3 V8 u- p7 { - List list=new ArrayList();
) A7 f, P* S6 Q) y9 m3 Z - Connection con=getConnection();2 e& f7 Q7 E5 O4 a9 Y& G( ]# y( x; K
- PreparedStatement past=null;
1 T* d& y+ v1 z; Y' R - ResultSet rs=null;- Z& C+ B* Q6 o5 N& |
- String sql="select * from phone";" G0 R) }) X( r: ~9 }& w6 |
- try {0 Y% n; M% V9 z$ k' A( p) y w
- past=con.prepareStatement(sql);
; C0 S* q+ I% R0 e5 [% x( V* ~+ y - rs=past.executeQuery();
+ Q3 U& z) z: h1 k7 C" [ - while(rs.next()){9 }# ?" y9 O5 U+ a; v' m+ g5 V
- // id, type, brand, company, introduction6 c9 }* t: }/ a3 G) v' U2 C0 T
- Phone phone=new Phone();
, h1 ?" }" y) n6 z4 i - phone.setId(rs.getInt("id"));
/ F- _6 Z9 m8 n0 q3 G - phone.setType(rs.getString("type"));6 A: s# y" X( G! }( n* ?6 s
- phone.setBrand(rs.getString("brand"));
1 ]" c; ?1 r! z2 ~5 b* Q; h; _ - phone.setCompany(rs.getString("company"));
4 A2 n+ a' d" E7 M4 b - phone.setIntroduction(rs.getString("introduction"));
" u# y/ {6 R$ z+ _ - list.add(phone);: I' R7 |8 r' N& ?4 n/ t
- }8 V- }! C6 u [; |* C
- } catch (SQLException e) {
/ G/ ~8 I6 \- o& N- R - // TODO Auto-generated catch block
/ o. m( k+ L. P - e.printStackTrace();
' ^; G% y! F* C) {& H" z( E - }" E. O! m' ?: H3 g/ q
- return list;; E u' Y# u+ ^
- }9 V2 t7 l: T0 i- w% @/ _) W) Z5 S
- public int deleteId(int id){- F% o! P7 E7 [
- String sql="delete phone where id="+id;" q' a* \) t v, H
- return update(sql,null);
1 C$ x+ ], H% _, c8 y% k4 ` - }3 y* _, G$ p; R
- }
- I z* ]) z" W6 [7 n; I9 V: v- {
复制代码 8 ]: W9 U$ C: B3 @
代码案例下载:点击下载8 `2 w, O' ]/ G" j, v. v
- R. o( G( Q; }
|
|