该用户从未签到
|
- package s2.jsp.zhangxiao.dao;1 S) h! j) E$ I# u! x3 p3 r4 X* V
- import java.sql.PreparedStatement;- s0 I1 E6 A. i
- import java.sql.ResultSet;
# j/ x" r- m/ a, F: t6 Q6 j( z/ b - import java.sql.Connection;
' h% r, \3 M+ u3 \5 ^, E3 S - import java.sql.SQLException;
' {. k+ o" F# d5 b. Q - import java.sql.DriverManager;- O1 _4 z6 D" ?8 j3 J
" m3 C' n* i) ?8 X$ j, v7 z- /**+ [2 Z0 M( {! {
- * 访问数据库
* Z# z b D& w2 w( } - * @author Administrator, G# m! D, z0 b* t% y( {
- *- t$ I! Q) i& W2 ~& ?# v
- */
+ }3 r: |; f4 ]2 D1 V - public class PhoneDao {3 x& b3 a/ e, b; u' {/ s
- : O% t% E3 }6 n1 ?) K/ C
- private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";6 [- N: |6 ~) X$ ]' x' o
- private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=phone";: @# H& {7 i+ J: ?" V
- private static final String DBNAME="sa";
5 S+ b" k9 v, r, ` - private static final String DBPASS="1234";: _9 S3 `& O) D( `5 F0 O4 F: V
- 8 [3 h" Q; d, ]7 B, n& p
- + E' D' I: F$ g, Y
- public Connection getConnection(){3 k8 b; Q; D# v3 K, i3 C8 h2 {
- Connection con=null;5 n# L3 X0 t) U7 x/ d, c% P
- try {
' R' v7 c% c/ E; m/ k; m - Class.forName(DRIVER);
' D0 Z! C2 ^( G6 n0 H+ ]- _ - con=DriverManager.getConnection(URL, DBNAME, DBPASS);7 G( X9 ~2 Y4 f& N( T
- } catch (ClassNotFoundException e) {9 W+ {- u; _6 v; e, z
- // TODO Auto-generated catch block& I+ {, ~; B6 j0 W/ u' H* @% ^9 d1 U8 g
- e.printStackTrace();# L/ y) U! g! H
- } catch (SQLException e) {
# d& \5 [5 ?1 h9 S$ R - // TODO Auto-generated catch block3 \2 K0 E5 }6 M6 X6 M3 i# Z
- e.printStackTrace();
, w6 e/ R) y/ c% z h. a - }( p- }4 m) h; V0 b/ S
-
/ U# [; A5 x6 M( P/ g9 h+ m - return con;
+ f$ x4 W, X9 Q( u K$ ~( n - " s: j; u3 ]! Q; P
- }3 } R: U# J) E2 y3 ^* q# k: Y
- public void closeAll(Connection con,PreparedStatement past,ResultSet rs){
" l+ v6 G3 w: }" Z4 C2 o* d: { - try {
/ L. G% J1 L+ i9 g - rs.close();* {9 h) G }' T. G
- } catch (SQLException e) {
8 U! C6 |% J8 w2 f+ \- U$ y - // TODO Auto-generated catch block% B9 z& \( j0 d- p3 F$ w
- e.printStackTrace();. F& U! l, j" `' l1 p3 X! B
- } N* \. K: t& \: w
- try {
& J. ~1 L" h" O; G; j - past.close();- P6 N9 }) ^, Y& i! j. v
- } catch (SQLException e) {3 T$ `* `# N7 H+ M
- // TODO Auto-generated catch block
L" Z" Y+ N: T6 t1 ?- r- ^5 ~5 Q - e.printStackTrace();5 b* v+ a9 V( d0 k; w9 y d
- }
. k- e! W# @2 S8 ^5 f2 G" C2 {5 M2 v) Z - try {
( X5 o2 |( G j" D/ ]8 j) N# d - con.close();( p& A6 M8 K1 ` M
- } catch (SQLException e) {) ]" ^# X& t. I( X. z: b
- // TODO Auto-generated catch block
: Z2 k9 ?! I- q4 X5 ~. M8 a - e.printStackTrace();+ {6 [" m3 P* p: C5 z$ Y
- }
2 {4 l4 e2 j X* U4 ~; y8 J! _ - }
3 t" N% E# f9 v- U - 7 a8 \, u. P/ C+ c. y
- public int update(String sql,String[]getValues){
$ C# x1 t# i0 o, `/ A - int i=0;
b9 s% m: |8 a. X% j. X. O - Connection con=null;. q/ R2 | C' \8 R) \4 ?
- PreparedStatement past=null;
4 ] @4 D: x% h9 Q% ~2 m- P% A8 ^6 q. G0 u - con=getConnection();0 M) \$ D% D/ N
- try {2 O& }6 {' |: X
- past=con.prepareStatement(sql);
& y) d+ i8 l3 V: ^, Y# P - if(getValues!=null){4 {- O b2 G0 }
- for (int j = 0; j < getValues.length; j++) {' _' p7 s7 X# k3 f+ X, k
- past.setString(j+1, getValues[j]);7 a: Z6 ?, g. B% y" b4 Y' n
- }( ]' @7 g$ r0 N$ Z) ^
- }
% m' W* ]5 ^6 Y/ d8 k6 | - i=past.executeUpdate();
% e2 a4 K# M" j: j B$ W - } catch (SQLException e) {/ s, I! z& z$ i" ?6 e' U6 a7 I
- // TODO Auto-generated catch block J! e+ |; ^$ J( I
- e.printStackTrace();
3 C/ J6 p9 j7 l - }2 e/ E& w3 V( e9 A" [+ z' t4 W
- return i;
5 M; A b5 B% q0 d -
$ B' t* V; l) x - }
+ E8 Z$ `2 f; o/ J1 @ - }
% `' C: Q6 e7 O8 v
复制代码- package s2.jsp.zhangxiao.dao;
$ q/ }# d: e& F& c0 F; Y* U - 5 N5 _$ L7 r2 C& j
- import java.sql.PreparedStatement;8 [" g1 F7 P7 K" x* }& l9 x
- import java.sql.ResultSet;- Z3 P! s% m9 O6 L' c0 t. M
- import java.sql.Connection;. a5 Q# A+ n; K
- import java.sql.SQLException;
0 \) Y2 p u5 K/ k3 [ - import java.util.ArrayList;
0 `$ e* F Q- u - import java.util.List;& o. j- l2 f/ \
, M+ l$ d* ~8 |$ c! ~$ g# E6 x- import s2.jsp.zhangxiao.entity.Phone;
) k2 d p D/ z( V G; ] - public class PhoneImpl extends PhoneDao {
' A" y; A; @& I y - 7 Y M0 ^2 B- z
- public List listAll(){
' Z; q- B6 b* Z* f. l! x - List list=new ArrayList();' `2 [0 g; v# a* C" C
- Connection con=getConnection();' m/ k# t" }; F8 y3 q3 l
- PreparedStatement past=null;2 x+ ~% b; x6 Q7 @% `3 T
- ResultSet rs=null;* E! H5 ~- H$ _( g
- String sql="select * from phone";
! ^3 A8 G% d+ w: P' c) v9 h - try {
# W# ~; E7 I: L9 [ D5 j4 [, k - past=con.prepareStatement(sql);
# P+ b0 `+ v) D4 e$ x9 c+ E2 G - rs=past.executeQuery();7 f& L0 O, h: D& L2 F3 b; e7 d+ [$ y
- while(rs.next()){
5 m, C0 {4 ]: { - // id, type, brand, company, introduction* n6 J! i) P! A6 J( @, F
- Phone phone=new Phone();
: B8 j% G2 b* ?* R5 {, r1 n - phone.setId(rs.getInt("id"));5 d$ A6 t! N+ {& b7 I/ q7 X
- phone.setType(rs.getString("type"));
9 t/ |& s+ J- m# J - phone.setBrand(rs.getString("brand"));
( |5 m$ ^! |4 S0 M( `# Y - phone.setCompany(rs.getString("company"));, r8 m; L0 m2 }/ l
- phone.setIntroduction(rs.getString("introduction"));
, Z# N* u* \ d( a - list.add(phone);
7 Z1 L8 z; N' Y1 `8 c5 w - }
& r3 w s9 l* H- q( | - } catch (SQLException e) {" x2 Y4 F2 b, X+ k
- // TODO Auto-generated catch block) W: n5 ^( f9 ~: ^% o3 B' i
- e.printStackTrace();( z* @$ w) @. G( g7 u
- }
6 q+ h+ |$ j5 G) d8 F3 { - return list;$ `8 e" o. l& N# u5 W/ D3 U
- }. q+ \6 e( I8 _$ ?3 ? M1 \3 M
- public int deleteId(int id){
" e$ O. I4 C8 ?/ m$ N - String sql="delete phone where id="+id;
1 k4 E! @2 b" P - return update(sql,null);
7 k# l7 f, G0 q, q0 x - }. b8 Y8 q) r" i
- }4 ^# f k7 `( x3 S, g
复制代码 $ q' s3 c; i; T1 V7 t3 a! Y3 ^: J
代码案例下载:点击下载
* x8 S8 F0 v8 U3 Y M- ?
& | d' V5 U5 | _! N4 B5 x |
|