该用户从未签到
|
- package s2.jsp.zhangxiao.dao;: k$ h6 k L% S4 H
4 f7 Y6 i3 R% D: Z2 O: t- import java.util.List;. k6 i, d( m* g( C( x Y
8 ]0 q3 F7 z8 `, K1 j J7 s* r- import s2.jsp.zhangxiao.entity.Photo;
# I, b+ o8 i7 x0 W - 9 V9 J4 I& V2 E3 }
- /**
$ [/ x/ y/ X+ x4 i - * 照片信息的操作所需要的接口
/ h) w1 | r8 W - * @author Administrator* f" v0 R8 t) Y+ E- I* p8 a/ T) o Y
- *0 o( |- r3 h* K
- */
4 B# L( s) L& c3 x* f - public interface PhotoInfo {
) M9 K( p. g* W7 D- c% ~- C - //增加照片信息
3 j9 F. n L3 Q - public int photoInfoAdd(Photo photo);0 e" _: t& B! ^+ A& E8 e9 R
- //查询所有照片信息: w. I" P# |, B/ r
- public List photoListAll();$ [& h7 e1 y5 B1 X) u
- }2 O2 ?& Y9 ^. s2 J, }# c5 k8 w
复制代码- package s2.jsp.zhangxiao.dao;2 I$ _, R: p( P. f
- import java.sql.ResultSet;
7 K) V% v! l6 I6 G - import java.sql.PreparedStatement;4 S( }5 e; b( [( V3 }5 u
- import java.sql.DriverManager;$ x r3 Q% ~! ~) ?5 V k( m
- import java.sql.SQLException;+ @$ Y4 c5 g8 A$ n& M& l+ \
- import java.sql.Connection;
* F3 o3 g/ L4 r- Y$ W
4 P5 P- G0 B8 F1 ?1 Y, ]5 [- F: D- " `# s, g' f! T: M5 B6 |, V
- /**+ H9 p1 b! q% e$ j- u/ l0 X2 r
- * 连接数据库
0 I- S( K* Q1 C' q# Q0 Y- Q - * @author Administrator
" z* H7 R, H0 }' ?. n. U - *$ v4 O6 p* ~3 }8 |" v2 z
- */
) b" o4 } t& k5 r) j3 U - public class PhotoInfoBase {
4 y8 v6 _) }; q1 i3 | - //链接数据库
3 f, \6 _2 X, H* V% A - private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";9 z. Y: t& C$ L, g# e2 K
- private static final String URL="jdbc:sqlserver://localhost:1433;DataBaseName=pictureDB";/ c0 j# g! o; ?
- private static final String DBNAME="sa";
9 h4 n. t e1 s8 C1 n' a* ~+ L& P - private static final String DBPASS="1234";% C- j0 M; g3 e# U r. S7 V+ M
- /**
1 z. k* s/ b: [% E - * 打开数据库连接
$ }1 }9 H: Z4 z. W) e7 I, U# j! L - * @return) y; i9 d, V' H, M, U
- */
% x! A# K" Q+ e( w6 i$ M - public static Connection GetConnection()
/ t3 p7 i$ F: T- T2 { - {2 b& Y+ V8 a0 J, C F) g
- 2 E8 b9 O7 h4 g+ n. \+ {
- Connection con=null;, m6 j- T9 M6 x6 F
- try {; w% A; k I2 o! _& o/ W
- Class.forName(DRIVER);
" ^9 U( i% P' j. C+ I - con=DriverManager.getConnection(URL, DBNAME, DBPASS);1 W& O; S4 j7 c7 w+ A
- } catch (ClassNotFoundException e) {
3 R8 P" S; Q* B6 W) s' n, l7 m9 e - System.out.println("加载驱动出现异常");
- Q; K2 L# {% l3 w* c - e.printStackTrace();
& M7 s% X+ \1 X% x" w - } catch (SQLException e) {" c( _5 f: F, C+ \9 m7 |
- System.out.println("数据库连接出现异常");/ f' u+ M* Q; c* F3 z7 f4 d5 a
- e.printStackTrace();
' L/ _0 S, R+ q0 v+ [* W1 u - }* b* j0 }' V% P
- return con; t' }8 V$ w% ~' P
- : [) ?6 D) e( I+ R, B# @
- }6 g/ R1 E4 T; f0 T
- /**
3 G' ~+ i- q( f3 ]8 K6 I - * 关闭数据库% ]' |2 c$ E4 U9 ^ T! m, M
- * @param con/ T) P, Z3 u x' z5 Q- K/ N
- * @param past4 v/ D) G7 k* \2 M
- * @param res
$ Z- K. R$ b4 y! | - */
& @0 [6 |/ O; T9 ?& t* K, n( k, k - public static void CloseAll(Connection con,PreparedStatement past,ResultSet rs)
# [. [9 W! [4 n$ a1 T9 K - {
2 |* d3 D, v2 ~4 o/ N" d* p - if (rs!=null) {# n9 K" Y4 p1 C, h# w/ x
- try { i. m9 L3 |1 V: g. y5 Y
- rs.close();7 }$ |2 q2 g) i3 b: ^+ A: c J- A
- } catch (SQLException e) {6 y% H1 B( } m6 p. N
- System.out.println("rs 关闭出现异常");
. K1 E3 Q, Y3 U - e.printStackTrace();
; p1 V& @' e* C" \# ? - }
& M* C5 m8 P: |' D$ ^% G - if (past!=null) {
" ^! W7 }1 I6 v! A* A - try {
: C i( k% O* I2 N- _3 C" p& X% a - past.close();
2 a( |: E% p$ p4 C( @; e% ]# w - } catch (SQLException e) {
/ x6 D4 M5 l# N# y# F9 @( H - System.out.println("past 关闭出现异常");' T; R \7 a" h/ C1 H$ e0 c
- e.printStackTrace();" R7 S! T- z# P2 I) s
- }# O) O. N, f6 U# F
- } @2 }8 G- s. [1 S) _) {. U
- if (con!=null) {
) T) y2 L. X2 ]( z - try {$ V9 ~7 b" _* B% m9 ^" M# a3 B
- con.close();
& L9 u5 K9 d6 g5 n - } catch (SQLException e) {
* i# U& l0 j* O1 k - System.out.println("con 关闭出现异常");
) W+ a* T' ~0 s+ e' p - e.printStackTrace();
+ m- b) v( L/ M6 V! |0 @& V5 S - }. x# v. w" }: }! y. p! z& o7 v5 |
- }/ w! |9 j6 u' V7 Y6 n& [( c( r4 J
- }' W2 R, H. Q G$ O( ]
- }; N4 v) F4 Z7 D2 C+ \, i. v1 V0 Q
- /**
, f/ h5 ]5 @5 `) C) B) Y+ ~! A5 [ - * 数据的增删改. F, ^3 a4 g x2 l+ a: x( F& s$ \
- * @return5 y# M7 g, r3 T0 U; e
- */- i' o. Y9 y) S/ |) N( k
- public static int ExecuteUpdate(String sql,String[] getValues) ?4 o. U7 Q$ v( I+ j' o
- {8 `6 i6 g4 N' b; F, c( ~: o
- int i=0;
$ w E# S- `: Y0 ~" k - PreparedStatement past=null;/ p+ P( i* y' G7 D
- Connection con=null;
: U: B! U1 k ~& D9 h# ~5 G! P - //连接数据库! P! I5 ]0 t, G: ?( K( G2 L
- con=GetConnection();
6 [& N- Q5 L# Z - try {3 N4 t# W% g2 u# g4 z
- past=con.prepareStatement(sql);+ v' b9 U7 q2 }4 `
- if (getValues!=null) {
9 s( l! ?+ R$ g( c$ g0 J6 [/ Y - for (int j = 0; j < getValues.length; j++) {$ C4 c9 S/ W* u% X" N5 _% w% B7 b* d
- past.setString(j+1, getValues[j]);
, d j. {% X9 D+ G: m& M# E# r - }
; |7 k( P0 h1 X. ]* |- | - }4 T. C1 g. T0 y* }( K& [5 a7 Y+ F
- i=past.executeUpdate();9 p- ?, _. o7 p7 m; Y' h
- } catch (SQLException e) {6 @5 K/ N" V' d/ Q8 J5 n& s% J, K
- System.out.println("执行增删改语句发生异常");
* h1 X& z2 P; @* R) J* F - e.printStackTrace();0 {0 G2 z5 W! L8 Q
- }finally{/ I6 S2 z# o% t; E8 N+ Q
- CloseAll(con,past,null);
4 t s# j' A. u, C% Y5 d - }. ], |( h' a4 ^8 M
- return i;0 X5 Z; v) `* A# r, a! w
-
8 I( O) W3 ~: @- p* v7 X! R# [ - }
. b; [. z8 ]+ m4 j$ `. p6 N3 T+ j - /**
- F% V9 e3 {$ T: ^' [# m - * 测试数据库连接1 c; r" e; j' _) W8 I
- * @param args
+ x: |0 y# c) P l- a2 S - */0 e2 Q. [' [# D% r) {2 R. M
- /**6 H# G! Y# \( t) K& v, s
- * 测试连接
1 T y$ @+ U. A; @7 p5 y/ I5 d - * @param args3 n' R% ` F& b6 Y1 W. ]! m4 n* C# h
- */
% Z3 U/ K' `6 X2 g/ `/ l M9 j - public static void main(String[] args) {
0 {3 ]" J& C+ ] d - Connection conn=GetConnection();
: `/ u1 [* i- @0 E5 e" h$ q - if(conn!=null){
8 ]+ Y4 d$ P( X8 s) ` - System.out.println("连接成功");
6 y8 r6 ^% x6 J1 ~& a - }else{
2 V& r& E7 a' G" h - System.out.println("连接失败");
' {! s8 L6 v4 r/ ?* b% S( E! S - }) [7 O" e& p2 p" D
- }
- m1 a; B7 `. S) [3 y+ I) a -
X: E0 N2 [: [/ g' f T - }
% g" Z' Z+ J/ y
复制代码 源码下载地址: 点击下载 提取码 ; o3 N! q3 t# U4 u
/ Z: E# u$ {0 y1 k5 g( g( [: C' Q$ G0 [# h
|
|