该用户从未签到
|
板凳
发表于 2014-04-07 17:50:10
|只看该作者
- package s2.jsp.zhangxiao.daoImpl;
" i8 Z5 }# A/ t7 k, `% A8 s - ( Q% [( V* F$ \9 @2 i; v- e
- import java.sql.Connection;
# S: k5 D3 ^% p. y9 Q$ j - import java.sql.PreparedStatement;" z; \. k' V' {; U
- import java.sql.ResultSet; G- k0 t, ]' P# n) E% d5 ]7 c+ X
- import java.sql.SQLException;
& c9 @$ [: Z) }# s. Z - import java.util.ArrayList;
# _ E) U5 i/ {8 Q8 z. x - import java.util.List;6 a/ Z8 j1 _& b6 X" E% C
- & D* T( V' v8 H: H# q
- import s2.jsp.zhangxiao.dao.GameBase;
& t3 J5 D% [0 g9 ~0 m - import s2.jsp.zhangxiao.dao.GameDao;2 u' H0 {/ E) h" e; }
- import s2.jsp.zhangxiao.entity.Game;
; ]; d" ~% h+ S5 S4 g
2 w! t0 s0 ]( D/ U" f2 Z3 s+ n
8 J b* Y" p& ~! n/ o. ?- public class GameImpl implements GameDao {
1 W# a+ E( w' r# f* z - 6 E: W6 j; j/ G8 @: n D4 e
- Connection con=null; //数据库连接
/ i9 v% M N, d0 f - PreparedStatement past=null; //执行sql语句
8 y7 _# L1 }+ g0 d8 D% a) d - ResultSet rs=null; //结果集
/ l' }1 E' d L; O - List list=new ArrayList(); //list 添加信息
7 A# b3 i+ q. ]0 R9 b( T3 H - Game game=null; //声明Game类
0 I" N$ }- ]5 y2 H2 w - - C. j. _2 i8 j) J
- /**
; z- j" z. Q' `; ?* M9 m! r - * 实现增加方法
m- J( i9 o" b5 w - * @author Administrator: a2 F$ L; Q& D* `1 Y' H
- *# |$ M( d1 ^' b9 F5 |8 o
- */
: a0 Z$ u6 B1 ~* I1 P3 u7 [1 u - public int GameInsert(Game game) {
* Y' g" d* I* a/ q9 w5 D - //sql 语句
1 A1 G7 u- ^2 |( D - String sql="insert into game values(?,?,?,?)";
% y- @: M( T- ~, V* m' H# e9 X - //添加信息; N, Y9 k" A* N3 ^ O2 N
- String [] getValues={game.getGame_name(),game.getGame_type(),game.getGame_company(),game.getGame_year()+""};
' K* {& a5 ]; r e6 d* d - //调用数据库连接方法
_ {( ~) e+ Y9 K - return GameBase.executeUpdate(sql, getValues);
. i( t4 y8 t! t( h' f' j - }
1 n# t+ T7 @2 O/ k7 O - /**
) P4 r. O! s4 ~' B# o2 Y g - * 查询所有游戏信息
4 ~* P# c6 `0 w+ m5 x" I( o - */# u$ G p. v1 ^( O3 U
- public List GameCount() {9 W$ K" Q& a1 F9 j, n3 T
- String sql="select * from game";
2 y4 M% A! v( T8 W - //连接数据库、
* ~- m$ s) F8 w& _+ ^ - con=GameBase.GetConnection();
+ D* ?% p5 |3 |- ^ - //传入sql 语句
$ F3 _! i% G2 C3 [ - try {
6 P& W% T) L! P4 B0 V - past=con.prepareStatement(sql);
9 d) `3 d2 k1 @3 r* m5 K* _3 | - rs=past.executeQuery();! W" k6 l0 E: b5 T, q4 \! T
- //读取信息
- j1 c1 C: R% Z3 Q k - while(rs.next()), @2 _6 Z$ u2 `( {8 \# a* D0 _
- {
3 W; s5 U% `' b t, o1 Z7 l$ o - int id=rs.getInt("game_id");0 b4 W4 {8 a" e2 R: g
- //游戏名称 N. A7 H3 H# I! F R* ]! U8 x
- String name=rs.getString("game_name");( L+ D" u! r1 i+ Y( d
- //游戏类型
4 E/ m- u1 y Q* T( v - String type=rs.getString("game_type");
~9 ^* p% U4 K2 B- Z5 ` - //游戏发行公司, G3 M6 F: p6 B: g
- String company=rs.getString("game_company");
, X0 ]1 R' B: r0 T9 Y6 j" h - //游戏发行时间
3 i' }: P* t. a* n) D4 R - int year=rs.getInt("game_year");
" S9 S9 F. N. |+ d - //添加到构造函数里
# e# n, V+ r' s( [ - Game game=new Game(id,name,type,company,year);
: g+ [! n1 A6 ^+ s. G4 p - //添加到list集合2 K6 f. H u* W
- list.add(game);; t5 c% Q" s3 L+ K
- }5 W! h; J/ U+ x3 G' O
- } catch (SQLException e) {
, W, p7 C: y' R& P0 D/ \& a - System.out.println("GameCount 方法出现异常");
+ N7 U& m0 q( C- _: z1 I3 M7 C - e.printStackTrace();* Z2 j0 m; ~2 K3 j% e* h% D. R
- }finally
6 Y0 Z# ~6 F$ P- f- |/ R6 O - {
' ~' n L0 y& Q/ h4 [% C; E" V - GameBase.colseAll(con, past, rs);2 l3 l( w3 W4 {
- }
4 I8 k3 e' G* H+ t* |! r& k - return list;
* R0 v# z+ M" X0 D6 j - }% j4 H# r0 Z& I& K0 A
5 _ T% a% x; X& j! N7 p8 R- /**
, ^ p* z1 B0 X, l1 |* U* j - * 多条件查询: m" [5 \$ M; g5 ^0 J" \
- */* }4 @4 L- L) I, O/ |8 ~7 U, ~
- public List SelectGame(Game game) {
& c6 \6 c! K' ] h* n. ^9 Z - List list=new ArrayList(); //list 添加信息- a$ |3 H( \8 U" y3 w# f: G
- //sql 语句7 X: A% B8 X1 p/ T p7 }
- String sql="select * from game where 1=1";
x0 Y3 T8 R5 z1 r8 T& I! [ - //连接数据库
4 K/ W: o) u* |3 M9 J, N# V - con=GameBase.GetConnection();3 H9 s A, {( w% J
- try {
* Q. R9 u3 u3 p1 l - ! z+ H, s; O0 |3 m
- //根据名称查询时) q& @7 R6 Z8 u. [! ^2 [9 |$ G' E
- if(game.getGame_name()!=""){
, F, h' h* k. |5 i9 y - sql=sql+"and game_name='"+game.getGame_name()+"'";
. t0 t, M- y8 e -
6 u9 {5 g7 Y/ m& q9 [ - }8 j) l+ e9 r6 l: u3 |5 R8 O' i5 z
- //根据类型查询时 U3 Y# t9 o8 o# X; F2 c$ Z
- if (game.getGame_type()!="") {/ m& c+ Y; ^- M
- sql=sql+"and game_type='"+game.getGame_type()+"'";8 r7 p, ]* `% L
- }4 E/ i8 G% i9 ^
- //根据公司名称查询时
- [' Q$ ] N; }/ w, U& S5 T r - if (game.getGame_company()!="") {9 {* ^3 u! z$ `$ q' k
- sql=sql+"and game_company='"+game.getGame_company()+"'";
* p2 H! i4 ~) W - }+ m2 s7 A. {% u( p5 I* V
- //根据年份查询时2 h8 B7 x) F* J6 f% a
- if (game.getGame_year()!=0) {
6 L4 a8 E$ z& k% S5 p - sql=sql+"and game_year="+game.getGame_year();
# Z' r5 @) }/ o- S+ J7 Q - }
7 C+ O4 b3 X/ v, I, ]2 X - //传入sql
' |& Z3 ^# q0 d" v1 J. Z1 |4 Y5 m - past=con.prepareStatement(sql);
) [' D0 `& b, j! R' @ - //执行sql
4 v$ }- J; b3 }7 d1 _& q - rs=past.executeQuery();
% E! p$ Z- {) c3 D - //读取信息
! R6 Q# f$ B& r6 D - while(rs.next()){
; ^ N) ^; ~1 q8 F5 N& v, W - int id=rs.getInt("game_id");0 v+ ~9 U G8 n9 Q
- //游戏名称% J, `/ S4 D; P$ z8 [* I; { [. }* G, {; s
- String name=rs.getString("game_name");& t! ?/ Q+ F' y+ i5 d! ?6 K
- //游戏类型
6 g# f1 e1 i7 Y - String type=rs.getString("game_type");
/ t0 n7 t/ t, r - //游戏发行公司
4 e) ~, ]* E1 I6 k5 r7 j+ k - String company=rs.getString("game_company");
6 L, N7 e' }2 F8 M9 P4 ~( B7 M - //游戏发行时间6 l) Z4 N3 G, X4 c+ i2 E
- int year=rs.getInt("game_year");
* V( I" K* f: P* Y - //添加到构造函数里8 R- a1 E; [3 `8 S# y6 G
- Game games=new Game(id,name,type,company,year);
' R1 b9 e/ w3 N" [ - //添加到list集合. q5 i* m( u# W: I7 [
- list.add(games);6 p. K0 K5 P( I# | P' E+ g$ T, o
-
5 m( _/ [4 _: m- y: Z9 a' Z" A# a1 u - }: O* W T/ Z# ?
- } catch (SQLException e) {
! T, ]" V0 j, g - System.out.println("SelectGame 方法出现异常");" x! Q' s P* ]) Z" h
- e.printStackTrace();
3 X7 {# g* K) S m! i - }finally{1 \" ]2 f" I3 J5 K Q- i- ~* K
- GameBase.colseAll(con, past, rs);7 @+ w2 V3 c7 U( h+ L+ Q
- }8 `7 w' p# s. |* I. |7 Y% n
- return list;- M: t, Z1 I8 l! P% Q+ a
- }6 e9 v+ B2 a! y4 F/ ?- r
- }
/ F/ ^! S0 J4 J0 q) H
复制代码- package s2.jsp.zhangxiao.entity;$ C3 K3 \8 g. A* @3 G# |. p
], A. Y: m8 f0 b- /**- n5 D. v3 p3 e+ {1 l, l' c1 m
- * 游戏类2 q) i6 {/ V& q4 @4 o* A ~
- * @author Administrator
# l: }$ y' P$ L. f( d6 d- J - *: {" Q. @0 E; E5 F h
- */
7 ~: |3 e: q, ?* t0 |& u2 X - public class Game {
' M% K# d# C" y I+ a1 K1 q, L: ? - / B! F+ B0 [' q9 m3 u( E8 P
- private int game_id;
, c5 q9 G$ e: c1 x( D" w( f4 [ - private String game_name;
$ {# u% z# {) L9 \7 v! G - private String game_type;- }: E( k, [5 r2 W7 K5 q* X
- private String game_company;( M7 b2 A. o1 m# N. H8 y( }
- private int game_year;
$ y; x9 |/ ^0 z2 g9 C4 W0 O - /**+ s0 `6 X. s( {9 H3 q
- * 有参构造函数
3 @: i( F0 a! w3 U- K - * @param game_company
) z) f2 k$ s2 @5 q - * @param game_id0 x' G( N, B$ i; o4 N9 t6 s
- * @param game_name# E! M- R P. O9 _: _5 M
- * @param game_type
6 r, N0 \0 }( F1 U/ J - * @param game_year
' y; u: z- ~% U" C1 x8 s3 L' q9 K - */
0 |. r5 T7 k& m n% T- g) T - public Game( int game_id, String game_name,
8 _: E! r, N, ?; E - String game_type,String game_company, int game_year) {
7 Y% b8 f2 V. S2 R v3 r2 q - super();) W; o/ n) _6 `4 X; E. a# u
- this.game_company = game_company;
7 M9 Z! f7 A$ |. F% h - this.game_id = game_id;
9 m' a; h: u5 t: f - this.game_name = game_name; L3 g# M/ S+ X+ J" m# s9 q$ n
- this.game_type = game_type;- ~# M _4 c, H3 [+ i& h! O- r
- this.game_year = game_year;
( p. B6 L( ^% i - }
+ ^2 v/ F' E+ u' ^* p$ } - /**
1 g* i7 f% L- J: [2 X8 Q# ]' | - * 无惨构造函数# a, c2 O! m1 S$ ?# S' a9 H* z
- */
" S. S9 h1 y9 [% Y; ^8 J! @ - public Game()
% J G( s! Q* }8 o - {
9 W& e7 Z7 P: d" z5 I -
" E$ o! M6 e+ e% J3 K4 e8 ~ - }3 @' L j' v8 n4 _, o3 R2 w
- /**
9 p% Y9 f* Y+ x9 A2 R+ t8 `9 p+ Y2 y( U - * 游戏编号
# q; X1 C# X& ?9 F4 F6 H - * @return
4 k S7 P' `9 r m - */
# m9 n- J# F/ d* [ - public int getGame_id() {" L0 G/ ^- {2 ?" O- C9 h
- return game_id;7 r) I: k- d1 }( b! U7 Z
- }3 u i, A. b( q9 [" N. ^/ s# M& h
- /**
" @' B& ]8 K9 a& q! S$ B: P9 y - * 游戏编号
' O2 ^7 c/ o. {9 k# F) {+ { - * @return
; G0 F; g3 s) S+ `- ` - */
7 T/ [/ A0 @7 \ - public void setGame_id(int game_id) {; V# g! q5 @9 c/ ~& v: ~
- this.game_id = game_id;
: g: L8 f+ f# y - }
3 [7 N( h0 e. l2 k - /**
0 E) r# e c% ?$ ~ - * 游戏名称& Q# { L2 t. [& l# z! m
- * @return
L7 M3 Q4 d+ H" A - */
4 r/ ~4 S$ z! {2 X; v% K - public String getGame_name() {
' k! `7 `( u/ A - return game_name;
$ H' p* P: } K - }
q& P6 n. R: u - /*** O+ z: y L1 ^* q% ?. e( u' E
- * 游戏名称' e: \8 ]# B, M1 [+ {. Q
- * @return, q$ E5 k$ J1 G$ T9 J$ s# L
- */
4 X$ q8 f( C; g6 l8 I - public void setGame_name(String game_name) {
8 {) `- X! P& N) m- M. \7 l1 V - this.game_name = game_name;4 \6 ]! M* l# I/ \# F1 B
- }
0 R( }; R& G/ o9 I% C! _ - /**: D' U: p4 M" p' |% M& n
- * 游戏类型
9 s) {2 g$ ^/ L - * @return* j3 m; L7 i! Y) I2 [7 p; D. @
- */
( q) _3 \5 c4 r6 y+ F# [) f" O - public String getGame_type() {
! J# t) t2 z* g0 R! U' C - return game_type;5 u. E9 D7 ~9 r5 d- j
- }, {& W) {4 u7 |" R
- /**2 ?6 i& V/ Q* l) T5 _) h( v
- * 游戏类型' z3 k( L$ G- [/ P1 S# J. k
- * @return
7 C2 D& ]- ^. _* ]' K - */4 i- v; ~5 j' |7 b. C, f
- public void setGame_type(String game_type) {+ }' m0 X) R% ?) l s( Y
- this.game_type = game_type;; D3 ]6 p4 Q, I* Q1 i3 Z6 z
- }
, C8 `8 Y- V6 \ - /**
6 J5 D* ~& m2 u5 n P - * 发行公司
% [ S. }* I' a. O - * @return( P* r6 n3 x6 B% G* G% ^& S
- */
, p8 X1 z3 A# _4 q! O& A1 m - public String getGame_company() {7 Y+ N) c: t R% z/ t
- return game_company;, c; Z5 B \& v d, P6 d u* R# r: q
- }6 ?$ J; V- q/ r8 a7 Y0 C
- /**$ N4 w% Z0 g% q( V% B
- * 发行公司" _6 S+ ]: n5 k9 T& g8 p
- * @return' P2 K9 u& I# O5 H6 F
- */
% d4 _- O6 Y2 }) U' ` - public void setGame_company(String game_company) {8 B7 x8 M9 ?/ l' b
- this.game_company = game_company;2 G; \* ~! o9 @. s% M6 v/ c2 ?
- }3 T: X3 N: J: H" Q' [
- /**6 M+ U W: v. x& S) \6 ?# l
- * 发行年份
- z" ~9 d9 r0 ^/ B - * @return+ V0 s0 s* f t+ P( o$ y _, Z
- */' F# w Q% \0 R
- public int getGame_year() {8 S; y) {" q/ R
- return game_year;& h( A* {) Y7 _+ R/ W2 i
- }1 K/ l1 M% i7 }
- /**
$ r4 g) A5 Q5 T6 | s5 y9 T+ m$ M# x+ E - * 发行年份5 k. h# D8 l; o' H% ?9 r& d+ E
- * @return
6 G/ H4 y& d/ M( P% ] - */
- S$ J A2 f" O6 A - public void setGame_year(int game_year) {
+ G( j% e4 N' F" m% a# @5 g/ G - this.game_year = game_year;
4 ^3 m. u. b2 N' o: s4 H - }; d$ t6 T( T& y
- }+ l2 U8 N- D- g) v) H/ C, V
复制代码 9 p* b" o, _3 [
% o& h3 E( w# y8 J( ~! v* v! k5 b
3 _8 b4 F4 s$ v; U |
|