|
该用户从未签到
|
板凳
发表于 2014-04-07 17:50:10
|只看该作者
- package s2.jsp.zhangxiao.daoImpl;
% n5 U, ^: P) F, {. I" W - ) G) E8 W7 j2 ]; U7 i
- import java.sql.Connection;
" u6 S) u5 c' r% k9 k4 }( Q) Z - import java.sql.PreparedStatement;
- w4 P% [0 ]( e2 W1 [6 b1 V - import java.sql.ResultSet;* u) z! L' u/ R5 X
- import java.sql.SQLException;
" V- w' K" }6 ^) m5 [$ _ - import java.util.ArrayList;/ G3 R6 F# A& S% G5 T! D. `# F/ D
- import java.util.List;: s3 X( I. H: {* E. Z+ k1 H) F o
- ; i: X8 J5 z* p1 u1 m4 R
- import s2.jsp.zhangxiao.dao.GameBase;
- U. }' _0 Q1 {' x# \9 v - import s2.jsp.zhangxiao.dao.GameDao;
" i3 |4 U& c5 t4 k - import s2.jsp.zhangxiao.entity.Game;9 H4 K: H) R H- { y: l
. O; ?* {+ A% e- $ S+ e4 {. X! v( [- l6 Y
- public class GameImpl implements GameDao {
2 H' J, n2 i6 N/ V: u( U7 N -
, h& q6 w: I' d G0 R' Q - Connection con=null; //数据库连接$ n0 S5 E" T* r3 g5 F
- PreparedStatement past=null; //执行sql语句, E. |2 U: K. y! A7 x
- ResultSet rs=null; //结果集
1 E f8 L0 k! m, S1 j8 }" \! o - List list=new ArrayList(); //list 添加信息9 b+ v; P! I# V+ X! k7 x% ~
- Game game=null; //声明Game类& W) o \; w( a5 L i* }- U
- / v# g! z; [3 z4 g1 N+ G8 @5 u1 {
- /**
7 K+ R& ~( Q4 ]- C: ] - * 实现增加方法; J: i$ W+ {) D
- * @author Administrator) c8 ]. e' o$ s% M/ B7 w, {5 i
- *
+ B) k |' C* K; j/ ^! r+ r6 p' s - */" x5 j8 y1 e; a# R" O4 Y/ X& \4 m
- public int GameInsert(Game game) {
$ o1 b1 q; E2 v0 I* B/ J) ` - //sql 语句/ U1 S2 d, z7 ]7 _( I$ u4 {' C
- String sql="insert into game values(?,?,?,?)";; A8 U' V. s$ m Y4 ]* b1 _
- //添加信息
3 Y8 i6 M* l+ x# @0 s, A* g5 H R6 Z - String [] getValues={game.getGame_name(),game.getGame_type(),game.getGame_company(),game.getGame_year()+""};
$ b2 f: u% o* ~5 T - //调用数据库连接方法
+ z4 \2 e7 d, _- @ - return GameBase.executeUpdate(sql, getValues);
0 p, h# i: X' L+ s - }. G2 Y b0 G5 G/ e$ n- P0 o
- /**
& g" |4 D- [7 N, d - * 查询所有游戏信息
: N$ r7 n; l! Q* p# j - */
: r* l& c }) u0 F6 v% w3 U* l - public List GameCount() {
6 a5 `2 Z: ?- Q3 `0 `. Q3 H - String sql="select * from game";/ W1 p6 S8 C: C" d' T- n& D0 n5 A0 v
- //连接数据库、
( E2 X/ O5 a5 B0 Q - con=GameBase.GetConnection();
+ l3 N, r" p+ r2 j C& H8 u - //传入sql 语句
$ \" Y: ~- q" M- o - try {
X4 }; A5 }* j% R$ I - past=con.prepareStatement(sql);
. Y# l8 o3 ~/ A V - rs=past.executeQuery();
$ V& w6 P9 r$ C/ o6 g" a8 w* p - //读取信息5 L9 L3 B2 ?$ k0 E6 D1 e
- while(rs.next())
2 k: O. o$ t: o1 A6 p. ~! N' m - {0 A1 K: c. m1 G
- int id=rs.getInt("game_id");4 N8 u7 `" `8 L, _7 i- V
- //游戏名称
) V0 D& U6 a0 M0 _ - String name=rs.getString("game_name");9 `. U' o' R% |
- //游戏类型
' x) e. W9 s* ^9 k5 l4 x2 O4 K+ t - String type=rs.getString("game_type");
4 R7 @' X( w4 k - //游戏发行公司( d- B5 q% [" C( X* J# i
- String company=rs.getString("game_company");
" B- S' U5 G1 x0 T$ A3 l5 |: r - //游戏发行时间
( d' j7 c5 s7 Q$ {5 @# i - int year=rs.getInt("game_year");7 A; \4 `% p+ U
- //添加到构造函数里3 E; v; Z4 e6 V* D
- Game game=new Game(id,name,type,company,year);8 U$ v) r7 x4 T
- //添加到list集合) h- l0 v4 }) B! ~3 v' f
- list.add(game);* W4 F* R+ X1 j' U) D: K/ u
- }
6 o" p6 g! [6 z+ S1 ~# U d - } catch (SQLException e) {
! _# q3 h$ a: q7 J - System.out.println("GameCount 方法出现异常");" J5 ^6 P4 s v2 B+ C1 p# b
- e.printStackTrace();
' R* R! o) f! m/ z( w5 X: _5 c - }finally% s0 E+ J9 q2 t; I( a2 M7 ~) c
- {
" H3 D7 {9 O& u/ i$ F - GameBase.colseAll(con, past, rs);
6 x- K; Z! y# O r7 m- [) u - }% e! ]5 s# w& @- s# u
- return list;
! h1 W1 a1 r* D1 ] - }; V0 P4 U9 C/ {. }# p1 z) I6 ]
- 9 r2 l, E+ Y- r, |: n1 G) V
- /**
) Q, i9 r* J& B$ m - * 多条件查询: k8 g% y1 ^4 {) k: v: R
- */
7 Y+ B N5 O& u" y' } - public List SelectGame(Game game) {$ `- g% v( X e3 h1 |# e% |
- List list=new ArrayList(); //list 添加信息$ e' c% P& v. o, E1 h @+ j$ _
- //sql 语句
" ]6 o4 t5 i2 Z4 p - String sql="select * from game where 1=1";
, Z( a3 W% v% V$ @- C6 l: a - //连接数据库: P1 M7 A. ~) I
- con=GameBase.GetConnection();
z0 l0 T5 @% b- R) P - try {
; a% J4 J5 j5 _' l# g - ( m- ]. O- ~! k* v. e4 |4 x9 ]% j, w
- //根据名称查询时5 s- x; T7 b, `' m
- if(game.getGame_name()!=""){
5 o: x0 v% ^8 Y6 ~8 [- M - sql=sql+"and game_name='"+game.getGame_name()+"'";
6 ^( U0 t, E* t' I - # s' ?7 R" v ]+ S
- }8 _& s. n( e, K: f/ w# Y% i6 E
- //根据类型查询时4 A1 W m4 _6 F4 o
- if (game.getGame_type()!="") {
% k. J' M1 _9 c7 s- Z" Q - sql=sql+"and game_type='"+game.getGame_type()+"'"; t K( K2 n/ `+ l; A8 l% c+ s
- }( d/ f0 v& t4 E% I: S! J+ O- m# G0 g: u8 b
- //根据公司名称查询时4 V' l- Y7 A% h! X: w
- if (game.getGame_company()!="") {
- n+ F2 q' A( o/ E0 N - sql=sql+"and game_company='"+game.getGame_company()+"'";# B* E& q Z# K3 C M* W
- }; R2 w& a# _- u' _8 ]6 G
- //根据年份查询时
) D, I3 C+ R3 a7 T1 f - if (game.getGame_year()!=0) {8 w0 q; Y7 L0 t6 R
- sql=sql+"and game_year="+game.getGame_year(); p. f, u0 I5 }9 L; i' M+ P
- }
" I; b% r* ~2 h+ }1 Y/ s$ Z - //传入sql
; }- I( U g* ]# S' E) W$ c - past=con.prepareStatement(sql);7 k' P" `$ O; L R# x6 `3 ?9 `; h
- //执行sql
( ?! ]4 u$ K' \5 [ - rs=past.executeQuery();
9 J# r9 ^, |: O& T9 y - //读取信息6 s4 I( f; u1 s) C) g; }% d/ o) y7 o
- while(rs.next()){* z( @$ X- I$ K; Y8 W
- int id=rs.getInt("game_id");5 e q' I1 l$ q: \; t1 W0 I
- //游戏名称
+ R( M2 }0 U5 w! I* K |6 L - String name=rs.getString("game_name");
) b1 O7 o$ A! t4 D - //游戏类型 C8 n# {3 ]% |8 H( z; d- b" y) i- [& j
- String type=rs.getString("game_type");/ z2 j; x' v# U: o1 D" }$ ]
- //游戏发行公司
; I2 G1 T- n$ |; | - String company=rs.getString("game_company");$ @9 N7 }. m$ n/ T# A( J. @
- //游戏发行时间 ]# J2 h: s/ G9 ]% D: z
- int year=rs.getInt("game_year");. K" A) l; K1 ?2 S! P3 d
- //添加到构造函数里
$ @7 q& K p4 x- F3 j. s% p - Game games=new Game(id,name,type,company,year);- _8 ~5 g& H' `: \1 ]1 C
- //添加到list集合
! I) |5 w3 o3 x - list.add(games);
; ]$ V1 g( a- B- G/ [) h; w -
4 ^# M4 D* Y: j/ G4 I - }3 x x2 K$ w3 h/ G3 d9 S2 y
- } catch (SQLException e) {7 e% z4 p7 E& i* o
- System.out.println("SelectGame 方法出现异常");
- O. U) H0 ]$ Q. g - e.printStackTrace();7 e( H' A) I$ W+ K" V
- }finally{
+ M" p! H: q2 p - GameBase.colseAll(con, past, rs);
/ y0 w! {# N, f: q, p - }
$ @; ?# l" T! |1 ^" l4 p/ s5 Y - return list;
6 r5 V3 [6 M9 I, j; c1 b5 {1 g. X - }
# ]$ B6 ? s& o' Z! }, b6 { - }
1 C4 j! O+ k0 r9 @
复制代码- package s2.jsp.zhangxiao.entity;7 Y% V7 D% C4 f4 D" X3 a3 o, L/ P; f7 ~8 T
- 0 J' Z1 S: u5 X R
- /**
6 R7 Q9 a" o; t& R2 H8 a) a& V - * 游戏类6 Y. s3 N4 l* C: B
- * @author Administrator
! O: x4 \2 N9 i7 \! E( U( I7 L - *
! Z _7 {8 j; x& N - */4 p5 e) R/ v6 s. A- O) K
- public class Game {
" A) c+ e- e [3 A8 k -
' U2 m. k& [0 I% M3 q9 g - private int game_id;
) U# x& a2 M2 I1 [" }3 M. a - private String game_name;
; a! L7 Y0 [7 L& G - private String game_type;
. q, C5 I0 n' A) u1 V( y, J: [ - private String game_company;2 Z0 @, V1 ]( \
- private int game_year;
x2 T- O* F- V1 V1 ?6 p - /**
* r( I+ G7 L9 e2 m+ h; y, f: Y: @! A - * 有参构造函数
0 }3 [, E7 A" X. N# p2 N; g. V - * @param game_company
' J. s0 W0 b0 G7 {" n: X0 V5 ? - * @param game_id
% o* }4 O- Y% E# P - * @param game_name
) o0 ^) ~1 E' M( t) l5 D# ~ - * @param game_type' m5 u( T6 U0 j
- * @param game_year- x# K' y8 N4 U( p0 g
- */
8 s4 i! T) X, g3 N/ n - public Game( int game_id, String game_name,; H( y, w2 X+ v
- String game_type,String game_company, int game_year) {
c1 E' `: d) }, R" ] - super();: A G1 R; I& T
- this.game_company = game_company;$ i% X+ u" U) W( q
- this.game_id = game_id;
: f* R. U5 n- n; f- A - this.game_name = game_name;2 I" ~- n% h+ ]; c' O$ y. j1 G
- this.game_type = game_type;: L3 U1 R* j. ^: w* x
- this.game_year = game_year;
' Q% o# i+ o) X2 D# D B& u - }
& ~" w4 N) D: j# N" h) ^ - /**: p8 z4 d7 [. O
- * 无惨构造函数: v1 d6 m6 c" s
- */
6 ? E* f& _( k+ _ - public Game() z" Z- K& B; G7 ^, D" [7 m5 ?
- {" @1 Q( \& `+ A$ z2 ^
-
* @& ]' {. q5 R3 ^, o - }
! v5 f4 G) E2 W - /**6 d: Y! L# s$ v; f! V
- * 游戏编号# c# Z/ z4 ?# ~5 t# P
- * @return
1 Q$ i; F2 r4 J6 j6 _+ _5 Z+ { - */7 m, _8 L! a, I" ]( W) x2 w3 r& B
- public int getGame_id() {8 ^7 m( @- {0 F$ B5 [ o
- return game_id;5 q5 Q# p. E" t
- }
6 X) S4 X: m' ~( _/ d0 u - /**( K/ J! V7 H0 }5 ]4 V& U7 a1 F. L
- * 游戏编号6 u9 Z: C. v6 J1 R( a0 C; M# j4 D
- * @return
& H- s! {8 u6 m - */
R" a* j3 a+ p, V, }2 c4 Q( l - public void setGame_id(int game_id) {
3 ~( V' g' _/ F- o" E( j - this.game_id = game_id;5 N5 c7 T2 g1 ?. b
- }6 p' h* O8 Y7 P' }
- /**
( b7 i0 Y6 o/ f A, ?2 m - * 游戏名称
' k% C2 u% _. n8 O2 L# n - * @return2 X' M2 [) R. A+ }' P4 a
- */# \8 S# E- y6 |5 w7 p; [
- public String getGame_name() {
% u' d6 h# z3 V% b H4 @ - return game_name;& l. N9 E8 p6 f0 T/ K
- }
! K0 G9 g8 X% d$ H, w* U/ R: ~# c - /**# x$ _, Q6 A" @1 n$ i& }$ Z
- * 游戏名称
1 B& Z0 H! |9 d/ { - * @return5 J& ^! l+ `5 g7 ]3 ^- C
- */
. R8 ~; j |6 S' A - public void setGame_name(String game_name) {
: f; P1 [' B' ]/ O: R - this.game_name = game_name;
K6 ]4 p4 f! l' x5 q8 T" @$ h - }
5 K% N, X) g+ z" p - /**
( d4 B- g1 K& B - * 游戏类型
. k5 [/ j$ Y g/ B - * @return1 }! g. r4 t1 f; @. s1 J8 t4 n
- */5 l* P3 `7 l, g5 A7 ]0 P
- public String getGame_type() {) i" @; N, P1 L! @
- return game_type;
f5 _5 L3 H# g ?, d - }. f2 Q* y: p$ n/ W9 F
- /**1 V/ w: W& A8 ~! Q1 V5 D( {' f) ?2 X
- * 游戏类型% O3 M3 W3 @. m
- * @return- r, X# i3 p5 O' c6 L! D
- */% I$ ~, a+ u6 D1 n* W
- public void setGame_type(String game_type) {
6 _9 m7 N# r0 y# g4 i. c4 ^- ^ - this.game_type = game_type;
$ |- S4 K& u* p) H - }! t6 X! Z: j8 |. A: C3 I
- /**
' S, L* D, T! B0 I F- I( I - * 发行公司1 C+ Q! c8 C `8 q; @/ f
- * @return" f8 d. n2 N6 O" |) R% g
- */
3 [& D G3 t$ ~ - public String getGame_company() {
) F. R U6 D0 [, _. m) u - return game_company;* R, K/ Y; r, v1 G
- }
8 `" L$ M! Q5 ^+ J0 [/ ]! Q - /**; {, s! Q( H6 r1 l, B4 V4 k8 H
- * 发行公司
; n" c0 z. i8 a6 Q - * @return
+ o+ M& P, T1 c - */! j) s8 ~/ w# ~- j& L4 W' C8 P1 }
- public void setGame_company(String game_company) {
r1 b; x# n5 Q7 Z - this.game_company = game_company;$ i8 J7 ~% e+ f/ v/ q
- }) H. T) j3 z- h" |
- /**
' w$ \: N) ?* X. R. h - * 发行年份
/ N0 ?- P- \" T4 m6 r) ?' m) ? - * @return
' Z+ x1 O/ L- ]. I( F' o/ Z - */) c0 {) T% ?& U
- public int getGame_year() {) n8 _. _- ~# Q- T' r) D5 D$ m" j
- return game_year;
! u7 ^. L7 b& w3 l - }
( W6 c: q- g1 ?; Q - /**6 M5 O* @& F+ Q
- * 发行年份
8 \4 W! X& r! j0 T5 s - * @return# Y8 w. Y1 A) r1 P+ s
- */
: l2 S$ K: L$ ^1 k9 i5 `' d5 r - public void setGame_year(int game_year) {
( W- d1 \8 Z% k7 G- t2 D+ O - this.game_year = game_year;
+ h4 i# t8 _. F, W9 d4 g. g1 N - }& s7 D7 P/ a' E, e+ o/ m- V
- }5 ~1 }1 L. @7 P2 r
复制代码
# Z+ W6 [" y" \' @! F0 L( d+ l+ i
8 P/ q5 T" q! l- _6 g. q ^) k& V( `- U" ^) k
|
|