|
该用户从未签到
|
板凳
发表于 2014-04-07 17:50:10
|只看该作者
- package s2.jsp.zhangxiao.daoImpl;
+ |. d9 m& q: {: F' i/ ]
& t1 e1 @' G7 k i! R, O# J- import java.sql.Connection;5 o# P2 \* W- j! }+ }6 S
- import java.sql.PreparedStatement;8 o" R% l% S8 d
- import java.sql.ResultSet;
# b) y) w4 l6 ^( r5 N) U) x( `& U - import java.sql.SQLException;
: O6 p6 m4 b- j+ k$ p4 B& E. l - import java.util.ArrayList;
9 L; c( ?( l) W8 [8 y9 Z! a - import java.util.List;4 X0 `' F# m9 L, W8 V. Q
- / @! u+ l% G' n& U0 H
- import s2.jsp.zhangxiao.dao.GameBase;
/ z9 q: `! ~; R% d; x - import s2.jsp.zhangxiao.dao.GameDao;
' K* \; c: V5 H6 v - import s2.jsp.zhangxiao.entity.Game;
3 Y. e/ [. \# F2 Y6 N - + ?1 u: `4 q7 }, L9 D& L& K* g
- 3 P, ~5 j$ K7 }& u- I5 v
- public class GameImpl implements GameDao {
4 `3 `- u3 w) N" r1 D - - P8 Y8 s7 S% C/ F9 `1 x2 t
- Connection con=null; //数据库连接
y8 I, T9 s- p0 b$ {3 l* L - PreparedStatement past=null; //执行sql语句
& g; L( \: z @+ k1 ^( G - ResultSet rs=null; //结果集
4 g8 e" H! Z& G2 z$ J( W - List list=new ArrayList(); //list 添加信息, x3 C0 [; N) n" }% D, m+ W& |
- Game game=null; //声明Game类( c# s t6 K1 P3 O& J
-
8 ~9 n( s L3 S r3 r/ ? - /**8 e0 t: G0 H5 d9 l: _
- * 实现增加方法
' I0 Q0 B& F" ~3 z' O' y - * @author Administrator0 I; I1 i$ Y1 x
- *3 s3 p o4 B0 l$ f3 w, `' |
- */
$ h3 b5 N% b# d" S - public int GameInsert(Game game) {
9 c( m" i9 w; R" e$ k1 z - //sql 语句+ i1 b+ k9 X* h* p% D9 x- d
- String sql="insert into game values(?,?,?,?)";% O3 ~1 S9 g f5 H# b/ j5 J
- //添加信息 ]( X( p8 N2 u- k* P- y A- z9 i
- String [] getValues={game.getGame_name(),game.getGame_type(),game.getGame_company(),game.getGame_year()+""};+ B' W4 V d5 x% G2 X& x) k; b
- //调用数据库连接方法
) {+ w- w( [+ O9 q1 n; q5 r" y - return GameBase.executeUpdate(sql, getValues);/ E n2 P. @4 V8 s
- }
, g L5 p3 P5 f. e& n( ~3 Q' S - /**# g% G9 v9 m j
- * 查询所有游戏信息
9 w. c8 Q( b$ {; y z) @ - */
* b2 q, X' B% N- X' S x - public List GameCount() {. m0 B6 f% }! V, T
- String sql="select * from game";
6 h0 ~4 ^& G( X - //连接数据库、
+ E% Z0 H' ?: q$ Q: Y - con=GameBase.GetConnection();
5 w& c# B+ o2 R& U5 [/ R* t I - //传入sql 语句
+ F# \$ [7 l. s& R. L - try {$ q3 V" @; c4 D, R- L! n( `& |
- past=con.prepareStatement(sql);' i8 p( Z- g W+ ]
- rs=past.executeQuery();5 d! ~! s/ U" @$ S3 {
- //读取信息
/ X: v2 A7 L8 `, A: b; `8 A1 Q( n - while(rs.next())( e; [& ~# g% f
- {3 v+ B6 ]# D; H3 e, |$ ~' ]# i
- int id=rs.getInt("game_id");3 g. @1 D' `4 S" |
- //游戏名称
! V* z4 f/ ^" y+ S - String name=rs.getString("game_name");: L; `; |- O9 ]7 n% _, T( w
- //游戏类型
- F$ c1 I: P; [6 G2 \4 g2 Y" `% P - String type=rs.getString("game_type");
. G! \1 H4 [ b$ R( ? - //游戏发行公司' {6 b& z$ @+ e! \
- String company=rs.getString("game_company");
. P# b% i, [; D' X! d# u6 o* e - //游戏发行时间) ?' Q( q! Q5 K. k F8 E' R
- int year=rs.getInt("game_year");
# ~! w* |* O. Q+ I- M) Z - //添加到构造函数里- i' C6 h6 w! G2 `, p+ S
- Game game=new Game(id,name,type,company,year);
0 P3 S% D5 {5 b' H5 t - //添加到list集合
; D0 O' Y- ^+ C0 ~ - list.add(game);
7 s8 f h6 H) O - }
. W7 h8 X! _! P3 ? - } catch (SQLException e) {* V0 d6 z4 x# [+ {( N: Z% U5 E
- System.out.println("GameCount 方法出现异常");3 h2 ^, X' u" j7 i& E
- e.printStackTrace();! a1 E* X0 D# @2 r6 z9 j- d
- }finally
: E, K! c4 e% _8 C3 m, v - {
& j$ j! }; `5 o E0 a - GameBase.colseAll(con, past, rs);
4 G# a* T) H4 \ - }
7 s+ s& _0 L) D* r/ t - return list;
2 j J. s# m- I - }7 I. `" p: N+ n0 }) N" K: d
* ~% j1 b- d8 G- /**% k, s; t7 e& Z$ i* I* _
- * 多条件查询
6 w6 {% l% h% C+ @ - */2 r5 I8 i3 B& q! y
- public List SelectGame(Game game) {9 B3 [+ L4 J5 Q& Y
- List list=new ArrayList(); //list 添加信息
& V, T" P) d d1 m - //sql 语句/ M5 u+ Y2 @+ b3 G' |/ U6 J
- String sql="select * from game where 1=1";1 J1 \& ]( W( X5 N" i+ b% A
- //连接数据库
4 z0 o! n( c7 B% q' w; Z8 b; T - con=GameBase.GetConnection();* Z& s; f9 Q: P" F( ~! E# ^" x
- try {1 @- O* A. y" ?7 Y
- ; [( q; }$ W' k. j
- //根据名称查询时/ A4 i0 G" b, T6 C* Y2 K
- if(game.getGame_name()!=""){
- r$ }* b0 v) ?2 w9 o' z: L - sql=sql+"and game_name='"+game.getGame_name()+"'";
% J% K) @. _; ] -
' j4 Q* c8 b- j2 i7 _ - }/ f5 r: L$ L0 [$ l8 I
- //根据类型查询时( C: w, J; {/ t+ z4 X
- if (game.getGame_type()!="") {& }( ]5 d& \9 a; ?9 m8 v3 p
- sql=sql+"and game_type='"+game.getGame_type()+"'";
1 A* t% O& X3 r) k% n. w* M# x - }3 h* t% X3 f! T. E
- //根据公司名称查询时
: \9 c5 ~& z0 B; V# r - if (game.getGame_company()!="") {
3 q9 T% v4 ]( K. ?# t. N9 I& s5 q - sql=sql+"and game_company='"+game.getGame_company()+"'";) s: G3 Y% D& ]. t8 a
- }3 f- p, G2 a. s% L& Q7 S
- //根据年份查询时" p! i/ T, W3 s
- if (game.getGame_year()!=0) {1 G( }" O! g9 {- \. ~( X" o4 f- h
- sql=sql+"and game_year="+game.getGame_year();
( f5 {# _7 u% g3 ` - }! y+ ~, i: \1 U% _4 g7 G g
- //传入sql& c& s; @2 f4 N6 g [1 O
- past=con.prepareStatement(sql);8 l6 y1 E1 P* _3 N
- //执行sql
4 S% L1 R8 z: n, `4 f - rs=past.executeQuery();. K9 K% Y# a2 v1 f: S( p
- //读取信息
% J& Q+ M8 ]$ l3 {- S - while(rs.next()){5 U4 g1 Y: D2 w7 F
- int id=rs.getInt("game_id");
0 s5 E4 t ^5 _) K+ U - //游戏名称+ V& `" }6 G! m
- String name=rs.getString("game_name");
2 p+ B- C7 P! t, k+ J' U - //游戏类型 N- O/ o5 H! G7 \( S
- String type=rs.getString("game_type");+ m9 l9 t0 C" d y% e @+ {
- //游戏发行公司
% @9 |; e8 t$ Z - String company=rs.getString("game_company");& i* B. R" [3 v) e# F4 j
- //游戏发行时间4 C1 `% P, l4 R/ r3 a! S
- int year=rs.getInt("game_year");2 F2 J; C& S% a. I
- //添加到构造函数里
% |: \8 ]# Y2 X! C - Game games=new Game(id,name,type,company,year);% m% t! ]6 P+ J5 i
- //添加到list集合
$ @, f/ [" N+ D# `1 q - list.add(games);8 i6 S. @! M, O- M
-
7 o7 X: K9 R. ?3 `2 Z - }
6 U. p6 [1 |2 d - } catch (SQLException e) {
7 [, ~1 m( ~. o3 ] - System.out.println("SelectGame 方法出现异常");
, H0 S$ k! A! M" b# ?+ P - e.printStackTrace();% H" \9 J" \2 Y+ x- O6 s m: e
- }finally{
' D+ {6 Y0 q& L - GameBase.colseAll(con, past, rs);
# p- j# {4 m9 n! r$ h - }5 r9 x0 \" n n; a5 ^# Y0 p! w
- return list;
( g% r; B# Z+ k; ]9 m! l' W - }
2 P5 m5 j* p& w- h# T - }: B4 Q; N' t ~- b: l: p4 q
复制代码- package s2.jsp.zhangxiao.entity;
G" M0 v1 u: f% A - ! @# x# s& a$ y
- /**1 z3 o& G0 r3 }" I
- * 游戏类
- V& e) u" s" L! i9 p2 o - * @author Administrator6 ]7 ]( c4 ~. F3 j& K4 @2 r- R4 p
- *4 ?; z; w" W# o2 Y" m2 k) A
- */
7 ]: }8 c' ?2 r) } - public class Game {$ N" q# O" S" A) m. m, M! V& N& D5 L. G
- 3 t8 D% A% p+ ]* x( O k" h# R
- private int game_id;" j$ ]! g ?8 o3 l: v& d5 x7 Q0 _, g5 V
- private String game_name;% d% d2 U$ I+ l/ {2 N) n: [
- private String game_type;, ~+ s$ c+ h, n4 ]) N# I8 ?
- private String game_company;* w) R' X1 S6 B3 Y, o* u
- private int game_year;
) d2 H" [7 ~1 T2 _, j) K - /**
+ Y6 P4 d+ N R {6 A k - * 有参构造函数
/ V6 ]6 K0 ~) c% {& j4 [ - * @param game_company
! a+ S. @& r- k) U9 U* \ - * @param game_id: y4 N, m8 t) A0 y$ @
- * @param game_name. L# @$ F% l9 q
- * @param game_type
# F% c; }4 y. |$ ~ - * @param game_year
- W h( y7 T, D& _3 ~/ y7 ?$ J - */( d5 j3 G+ C A% q5 V* H
- public Game( int game_id, String game_name,
! `1 L2 r7 n r9 ~. { - String game_type,String game_company, int game_year) {; ^( u8 \' U1 @' E; m) r
- super();1 d( M$ d3 t0 |8 g; F# X4 M! S% d
- this.game_company = game_company;
! S5 @8 d {% G8 N - this.game_id = game_id;3 `2 W$ k* N' n- b) E0 w3 {
- this.game_name = game_name;
6 R: z' b8 N N, Y6 r x - this.game_type = game_type;
/ R$ ]) h$ d0 u0 p p9 j# g5 O - this.game_year = game_year;
; \# R: F( f+ n - }
# Z5 I" W! m9 ?3 [ - /**
" ~0 `3 |; g8 A) ^, M+ ? k - * 无惨构造函数7 {6 q. L4 t% N4 ]. N
- */
5 x/ `' c+ y- O! n& B; U" D4 A - public Game()/ @1 Y, Q0 k, U/ H/ R
- {1 c& E% t: _, c2 _+ C5 W. E. `
-
; |0 G& q# h9 j; i% G - }4 H4 e& |3 ^% W
- /**
4 q* v' g& K& g0 P0 c* u& } - * 游戏编号
/ _% a5 \$ \, |4 c8 s, W1 S a5 E7 i - * @return
9 F; i# V6 [2 a8 k0 ^* y - *// y' x5 v- e* I
- public int getGame_id() {+ e5 L7 c Z9 T# i0 D: g$ t
- return game_id;( }2 p N7 F( x6 W- Q
- }: b' P' o& b" e! b/ ^
- /**
. @; p. _6 H% o' J8 x5 e/ W% P - * 游戏编号
( h: d' A% [- D; H - * @return% U, g& }/ Y/ S' d
- */
, q, g# V, u7 E - public void setGame_id(int game_id) {
* ?$ H1 F/ w/ V+ ] - this.game_id = game_id;
6 V6 n- m. {7 N) S6 H - }
6 Q2 s5 C# ?2 a' K# p - /**
! P/ s7 g, ?; g+ u. Y - * 游戏名称
) {% p1 ^" k8 h+ X% j( B& i - * @return' Z$ T; H. _3 i d
- */$ x! W% d! ~$ I4 h- e2 U7 c4 o
- public String getGame_name() {9 C. G1 R$ n) G. V4 m) J
- return game_name;
8 j* y' P* Z8 c# P6 `# I - }/ d% W7 @! C& C0 s8 C& ~" H
- /**
3 K" X4 T* q: T - * 游戏名称. k1 e I6 s3 C# i5 l! ~
- * @return3 C( M! o/ U& w4 W9 }7 h
- */
: q e2 z, {" R# n9 Y9 O/ y( W - public void setGame_name(String game_name) {
# s! r9 Z5 g( F - this.game_name = game_name;
1 n. t9 N+ Q' g2 ?+ j9 Z7 h' V5 y - }
4 y2 {7 p& J2 } - /**
" ]% l; U1 ^$ a. b# M - * 游戏类型
" \* {1 P) x, z% I! q e - * @return
0 o+ ?1 h0 O1 X' v9 p* h$ \# [ - */( I1 |( n7 X2 t- i3 @
- public String getGame_type() {: |; R; K) S& x' h) U( J6 ]9 P
- return game_type;
) t2 s% M( l0 x1 h - }
, V( F: c; A3 n8 L - /**8 T5 k( F) L+ }6 X' h7 v# n
- * 游戏类型' G# F) a% j2 _5 ]2 R
- * @return. m+ v D; [$ Z @$ u( s7 Q3 b
- */* O3 Z# R5 d" O: O5 U0 Y {
- public void setGame_type(String game_type) {( v2 p4 v8 T# U- v* w
- this.game_type = game_type;- X) q/ U! a* _# z4 N. m
- }4 T+ W/ k' n* I8 X' j
- /**: U! Q& }9 I* f* I) r2 I7 R
- * 发行公司
9 Q' H6 S+ {7 R$ m- u# ?7 k' T - * @return
& X2 N, h# L* ?3 `, a - */
4 L' `' D7 a, l! c1 k& B - public String getGame_company() {4 t0 q. X; X3 h! p Q
- return game_company;7 ~6 z" i9 ]! E
- }
1 z1 d8 P5 n1 [8 l; z* q; q/ f - /**' x+ p5 K' L5 n- o& E) E o
- * 发行公司
9 ~1 F! m% {5 U- ^/ x5 \! g - * @return
" Y8 Q6 |( j s* o8 I - */: c" u6 _/ e1 F ~8 N7 _! a+ {
- public void setGame_company(String game_company) {
1 W& u* e" D5 _. c - this.game_company = game_company;
7 x9 v$ ?: ? M% I* k; \ - }+ F2 \1 m0 W G6 K+ r& G \
- /**2 V w& ?1 F3 I2 R
- * 发行年份
% S; d9 T N1 N+ Q5 D - * @return1 S8 p: M2 R% S2 q" p+ E2 a% Y
- */
, c. f; [" w' W- f# x% Y" l% L - public int getGame_year() {
( ]- y$ v2 B1 K; k2 ^ - return game_year;
& Y: x& b4 P" v G - }: E0 k7 a$ j% Q' v w$ t
- /**9 C2 m/ b: ?. \4 @& j
- * 发行年份 F" H: l9 o5 h
- * @return
4 r: \, z7 c" J- T% k1 A - */
3 V$ V; ^& f. f x2 e - public void setGame_year(int game_year) {
4 ?8 y% R* V& U - this.game_year = game_year;* n# ^( ~2 H T$ A7 e
- }
+ t9 E) ~( N( u" B- |- {! L9 s- v - }
: m* C: {( ]! r5 D- T7 q
复制代码 - } M5 C1 k4 u* H% D$ Z, U8 ]' v$ V
/ h5 ^) v- m2 r2 _2 {% A+ O
* I4 p; f8 m0 _7 e+ w# S" l
|
|