该用户从未签到
|
- package s2.jsp.zhangxiao.dao;) o n+ I9 E* E4 m% p. H$ }4 l
- import java.sql.PreparedStatement;$ a" N/ U# y3 d0 g# K" n
- import java.sql.ResultSet;
1 y2 x n, C2 x7 l5 K' T1 X) ` - import java.sql.Connection;
- w2 Q' [6 O# d; E; L - import java.sql.SQLException;. _) k3 I* h* n' T8 o; A
- import java.sql.DriverManager;
6 \1 i0 Z5 C5 a+ e9 ~0 V - 8 W# G0 [/ G+ p& |. j
- /**' `6 y( i# q/ \) T7 z
- * 访问数据库' P8 _8 t, m2 A; b) ^( I. y) q* Z
- * @author Administrator1 i7 V5 V2 v& _4 P. Z
- *
1 O5 C0 q1 [# h6 h4 Q7 ~( } - */
' m- N. [6 y4 `% c8 C! d8 h$ e- x - public class PhoneDao {
2 x& j i! w! b4 F
) M$ j& D, s X1 Q" A- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";* [* Z& }, S; t. t; \ \
- private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=phone";. ?4 k% [# h8 ?( U
- private static final String DBNAME="sa";; Y1 |5 B4 r& @; H% l* K
- private static final String DBPASS="1234"; Q' D0 M! s& k3 {
- 1 U I8 F. @3 c6 b% ]4 A7 z
-
8 @% C4 p" ]6 n: X - public Connection getConnection(){- {2 G; Z* _- q( K
- Connection con=null;
2 g B4 K3 C* M K# R2 d - try {
b) F( w! f2 w3 ? - Class.forName(DRIVER);7 j0 z" ]3 X3 V D
- con=DriverManager.getConnection(URL, DBNAME, DBPASS);/ |6 g$ J* j" j0 o
- } catch (ClassNotFoundException e) {
3 u/ i" }' D1 N8 l7 x - // TODO Auto-generated catch block+ p% F8 G# F# a+ f0 {
- e.printStackTrace();% S& C7 _+ d; f# I- F* P' F& Z
- } catch (SQLException e) {- l5 C: W; @( b- {' @6 m/ F
- // TODO Auto-generated catch block6 M8 `: a' O, \! A0 v
- e.printStackTrace();
1 e, K2 E. F! l5 s - }
, K2 o# K& F, b" L- l$ B -
! [- K- c% [- b! d* W. e, a+ G; \ - return con;5 K6 z$ ~; @# Z4 P8 F) Y; Z# w. [
- , A; e4 j' Z i
- }. [4 k. \4 m, b1 x" W7 E4 U
- public void closeAll(Connection con,PreparedStatement past,ResultSet rs){
2 A0 E: h, ^3 @2 n# A1 Y - try {
* X7 Y9 t+ a- ?* Y O ? - rs.close();+ O. Y2 @" j: |, W3 Z
- } catch (SQLException e) {
+ U: | I9 R3 Y6 `( ^: U5 T# q" T - // TODO Auto-generated catch block
1 c" F* W% O, h, \2 s8 ^( B: r ]& y& P - e.printStackTrace();
; h' R' z0 f0 I \& R! l8 b - }1 J8 _/ U( d; z3 a
- try {0 y+ y9 N( M! `' @0 c' e Y
- past.close();
: |* V5 C# P' p5 f- y! M* h - } catch (SQLException e) {
, x h$ x; Y5 |7 o z1 h/ F$ m. i5 n - // TODO Auto-generated catch block8 w6 s6 h0 V. B" _0 w. m
- e.printStackTrace();
$ Y) ^% t! p( @- s - }
M3 _( ` ^$ p' s* C, |1 s - try {- m$ a/ z% K( q9 X2 _, N" j
- con.close();4 ^" u- A7 T* G# O
- } catch (SQLException e) {
2 ~: q% e- D. |/ X4 I& K' o( S - // TODO Auto-generated catch block
3 i+ ~, ~+ i Z9 r - e.printStackTrace();, M! P8 ^ I; n, `4 m
- }
" k6 F* T' l$ S2 r/ Y0 {/ A1 s# ] - }1 ~( B; t5 B5 t( y& d8 L
- * s5 B' H3 @ }: y/ k0 @" O
- public int update(String sql,String[]getValues){' J' p8 D4 a3 F
- int i=0;5 R7 S5 D. s# q4 Q: i! Q- Q+ y4 ?
- Connection con=null;/ x, f3 Y ?2 B* f8 q& C3 j
- PreparedStatement past=null;
7 }3 [! D$ b- L/ d( F1 e) |9 \ - con=getConnection();
/ R! H9 L. j/ m: |9 i2 s - try {
; e4 a* \# g, S - past=con.prepareStatement(sql);
- K, | b/ {3 T e. `9 \- F( E - if(getValues!=null){' q$ b- d9 b: P' F, K' K& m' d2 t5 Q
- for (int j = 0; j < getValues.length; j++) {
" n4 H$ E! O% d% ~% F3 ]8 R5 X - past.setString(j+1, getValues[j]);
4 f# q, A0 I2 d t a7 s - }# A2 M2 K' M. A9 K
- }
8 Q9 l5 [* Q$ }" H7 [& ~% ? - i=past.executeUpdate();
1 H! t% e; l9 t1 v- S7 d1 z - } catch (SQLException e) {- v% k" b1 O5 Q
- // TODO Auto-generated catch block
! T+ U/ C- v9 F) D, _* i2 U - e.printStackTrace();
7 ~; [" g! N3 J$ L - }; M' m- P, R* @
- return i;
; P) S/ J6 U& g M -
k: D6 Z1 ]9 { - }2 v2 m8 }$ h6 J; P( G
- }4 |% a3 a D/ h8 s( p. u
复制代码- package s2.jsp.zhangxiao.dao;' e7 F% y* F: J8 `6 p, ~7 n) m O
- 0 F5 r; W, }8 `% j# p1 K; B
- import java.sql.PreparedStatement;' W+ p# E. {" n; g5 b% }% F
- import java.sql.ResultSet;' p. A6 ~6 N+ j4 s3 ^8 J
- import java.sql.Connection;9 {- {; O+ G" k5 S% W8 ?% O
- import java.sql.SQLException;4 I5 ?; l. K f7 M4 \' E+ U
- import java.util.ArrayList;
6 u* }1 j( C# J- O; o% E! H% Q - import java.util.List;
9 I2 U( m# v. u9 d, H- R
& G% L) V+ [+ ~7 ^% l- import s2.jsp.zhangxiao.entity.Phone;
5 M3 \6 f* h$ [: C - public class PhoneImpl extends PhoneDao {% g0 m0 C+ l+ `; k
-
+ y2 a H$ i! t0 \& z - public List listAll(){
1 \" A- ^' b$ E# p( v! ]# u' d% j - List list=new ArrayList();2 O# m9 U4 Q: T2 g8 T$ f1 C9 ]
- Connection con=getConnection();
" A/ ~2 M. L+ n2 a1 e4 Z6 i - PreparedStatement past=null;/ U _5 Q/ l8 |+ C P- N
- ResultSet rs=null;
0 q8 A6 ?) L- w% x5 c - String sql="select * from phone";1 c \. S9 U( ^1 T' H' A9 V# p' J% U% r
- try {
7 B. J- I. y# d+ F2 R6 Z% @ - past=con.prepareStatement(sql);' X# a9 v7 r6 \, ^6 Y3 I
- rs=past.executeQuery();
& O5 w% V5 | C1 A8 _ - while(rs.next()){
# ]1 O/ R2 q( S* Y/ D# g( x1 ?* m - // id, type, brand, company, introduction
/ z3 u% A3 |$ g: q" c0 }. B, R6 F - Phone phone=new Phone();
) N$ {+ E' T; q# i [ - phone.setId(rs.getInt("id"));
, n; Q2 k+ D: C7 y# ^& g - phone.setType(rs.getString("type"));
+ X/ I, F9 t& m - phone.setBrand(rs.getString("brand"));
! E! z! ?1 m. N- H' a - phone.setCompany(rs.getString("company"));
" d. q2 K' u/ `) V8 l5 K( U) W - phone.setIntroduction(rs.getString("introduction"));" Q7 ?, B' r; {* H
- list.add(phone);
/ c1 H4 c I6 n3 q% e. i# ~ - }
2 g8 ]6 C( f$ K! n2 X1 v - } catch (SQLException e) {5 Z: m0 n& ]+ U! }! a% [
- // TODO Auto-generated catch block
% R9 _7 }5 G! R$ {0 M" |( B+ } - e.printStackTrace();, K( h9 ?6 Z7 i8 o( v6 b
- }' {/ H6 a# E' r2 \7 N& |6 J$ s* c
- return list;3 R6 N6 i/ k1 I! v J
- }- N( p& [; U+ X
- public int deleteId(int id){
) m( e0 C B) o - String sql="delete phone where id="+id;; \. K q- Z0 W! C5 B& X; s
- return update(sql,null);
% B/ ~$ s- K9 s- z - }
) Z$ I) U" {8 [% @ - }0 D1 m/ I" t, e% u5 H" ?. g4 r0 g
复制代码
2 [6 L" V1 |) N9 m代码案例下载:点击下载
2 T- y+ |1 v+ M" ]
6 X$ w3 g7 W1 P6 J# |4 T7 V |
|