该用户从未签到
|
- package s2.jsp.zhangxiao.entity;. b2 s& |8 ]; J; i7 ]
- /**- D0 v1 }( x. |( P7 G! C, m
- * 物资实体类
" ~) A E5 V9 j, f7 c8 C$ A# I - * @author Administrator
8 F- R: B9 D7 E7 u4 _ - *
! n& E9 p1 p* A! t# | - */
) A# |- \$ B3 ?+ h6 i- L' o - public class Materials {
# m9 u( N1 Y/ ~0 N. p- s8 D - // id, name, spec, number, price, producer+ G5 p; s$ L& ^# K( m. k
- private int id;; L0 ?8 W7 \' C7 c' ?* j, j
- private String name;
$ ~* p' Y' P) b6 q+ s& G7 s% G - private String spec;4 ]) w% Y! L7 B" t, \- M
- private int number;5 q8 z) Z5 d! g" o
- private int price;+ V" t* S6 e0 x$ [
- private String producer;" g3 h2 |* {- I' ]
- /**
: _1 }* X$ b P; J" P7 z - * 有参构造函数
, I4 n0 W, h4 h H - * @param id6 [7 ]7 L5 t) H. J* t! I
- * @param name
) k) z+ W6 V) e0 i3 ?* s# n- s, w - * @param spec9 ^7 e! G) ^5 s- u5 x
- * @param number
: b, q- ]" M! T! Z) I, O9 l - * @param price" B3 A4 ?6 ~0 d: ]4 `2 q
- * @param producer
" z2 J. c0 Q- I' {% g - */
M7 R0 U( I0 n$ D( T9 G - public Materials(int id, String name,String spec ,int number,int price,
5 f0 K# v' B- }* v - String producer ) {8 i4 o* E& _: V5 i
- super();7 s! T" g8 D% w, X# K
- this.id = id;" e, q$ P; m$ Q& H2 ]3 ^0 w
- this.name = name;
0 A9 r: D3 `% s5 c" z6 ]( y F1 C - this.number = number;: ^- ~; @- I: ^; ]" \
- this.price = price;5 H( k% Z2 X& `) v! \" R8 h
- this.producer = producer;
: l& n, l% m; T# p- K" d' h* ~" i - this.spec = spec;
/ A9 Z; `6 r: i3 R - }
5 @! J' ^& T7 }4 ~1 P8 W - /**- H, ^8 z4 I+ b$ [, A
- * 无参构造函数
- x0 x/ l, z0 @2 J1 ]+ c - */
% W! e* a1 }* }8 H R5 {( E - public Materials() {6 t( L8 i% T! r; s& f
- super();2 K! b) |( {/ x7 u' r5 U# _
- }
) t, _: F3 @% ? z& [- K - /**, R' w* O1 v# N! M
- * 编号
/ o0 X- V# f- D, R- D - * @return
/ [6 ~% p; O9 O# N9 C1 r/ n - */
$ V0 w' R8 U2 ?! Q - public int getId() {
+ a+ e! b1 m8 D( L - return id;
) k! Q6 F7 p, V! x6 W - }$ m. _5 f( M: e
- /**% ~6 n2 P7 P/ I) N- E
- * 编号
. }. s: T: A* F" D* j4 G% m8 } - * @return3 N3 X t* Y' ^1 Z( s6 _
- */
/ c1 a0 Y s' S% P7 Z+ m; b/ | - public void setId(int id) {; L) E2 E, |" {6 z; [
- this.id = id;
$ _. n/ s& e" T" Z% ?7 M/ a - }
& U# h$ R. b3 |4 p, P7 K( x - /**
: W+ p1 V% l1 W - * 物资名称
0 n' e+ X$ Q9 ?7 I$ q4 p& ]/ b - * @return
- l8 Q2 x- G5 T% t - */
$ E. t" z+ I8 G, ` i) y - public String getName() {
$ v; J( e, B" B: U9 Y3 f - return name;
& n0 R: y# o5 t9 ]: J E - }7 j) Z5 H( }3 K; Q/ H
- /**
8 M- `9 B+ p& v8 ~) |2 C4 A0 R - * 物资名称2 e) u) O3 f6 ~3 ~3 P
- * @return8 q5 O/ P8 k& }
- */
7 w _- } g# v: R( c( d9 a4 }# X - public void setName(String name) {" C" F: J8 Z# ^$ [% t B' m7 u
- this.name = name;
5 |: D! j1 a0 L, Y4 J - }+ w/ u% j/ c2 J# w! D0 p6 R
- /**- d0 ?: Y: h! L/ d- T3 o; x# F
- * 物资规格' U9 v1 L4 a& q2 ~9 P
- * @return
9 E1 W/ N7 U0 P o$ j; g - */
) D* U3 V) l- L2 w. F/ c6 e( c - public String getSpec() {6 Q5 V/ C/ i) P3 F$ B: r9 t/ l* X
- return spec;+ t% n5 A8 U! }: S4 z
- }
8 n& l, D3 K4 f U, }5 Z - /**$ b7 R1 i8 n: p/ _, G* _+ Q2 |/ T
- * 物资规格. Z- T# |1 q9 W x0 P4 b9 P( N
- * @return9 u! K* \8 s" r. P2 z( Y2 L6 t
- */
' {! m8 L4 R, X: L- K - public void setSpec(String spec) {
/ r1 ]+ H) p& y, W8 a# t' `8 q$ s% l - this.spec = spec;* M3 Q+ ]* [2 G' u9 b/ z
- }3 W d$ h7 m1 g: v, u8 W
- /**7 E# o) f9 Z1 [. w! Q( ^
- * 物资数量2 u' X& `7 j: }6 \# I) R. E
- * @return
! y6 E1 W* H* g5 N - */% K# W) M/ m! G2 x
- public int getNumber() {
# l; T1 K: E" V! r - return number;
R6 j/ K1 G1 g* x+ [6 j+ m u9 Q - }9 _8 D! j( b' ?$ J6 W1 v% }
- /**
* H6 b) L- ?, Y* q) [ - * 物资数量
: @. i$ r: b# V; n, J - * @return6 z# l3 s. U w
- */8 e" A" T, i/ U: ?) \# r
- public void setNumber(int number) { {5 s; X* ~$ A3 o* I) N$ G+ e
- this.number = number;
# S$ f. C4 k$ L) m. w - }, C- Q2 u" e8 D; H) C, ]5 l$ y8 A
- /** l. \- e9 f4 B& e6 {, H
- * 物资单价, q, r: J0 F, Y) w4 [0 u( A
- * @return: M3 g2 ]. W8 w0 ]7 j( g
- */
% g( `* P7 N4 U5 k' @ - public int getPrice() {( J; }: i- v2 H
- return price;' x3 J6 B5 h d+ n8 L; y# Z V1 s
- }
" h) q6 B" g& d. E" G8 a) @6 x - /**
4 T; s' k, ]% @6 X3 x: G+ N1 C( s) ^ - * 物资单价
5 r4 W3 Q$ J( b5 q& O4 C' _* y9 C - * @return
* _! f4 ]; K( t! v - *// m( c( i$ o8 E3 Q# K, ^4 x4 L
- public void setPrice(int price) {5 M# l. j( b, H
- this.price = price;1 c, x/ L2 b% B: R
- }6 @ ?; z( [$ A/ ^* h' U8 a1 Z
- /**2 e( p, w, d0 R3 |0 U
- * 生产厂商
# @6 Y6 \; E* V7 r - * @return
2 L c2 X9 {7 \9 \) ? - */
2 S- t7 {5 p& Y- ^+ D" | - public String getProducer() {6 i3 t9 l Y4 J$ z5 K/ p
- return producer;/ R& k) H5 u: n, M v
- }
6 N T" ?" Z d5 f! }' @2 d - /**# u0 Q% \: w8 h0 Q Q- k
- * 生产厂商$ S" V% O) O4 y' {, q- Z+ `
- * @return
5 t# c5 ~# J% }' r1 k - */
' |$ I% ^* w/ w8 S% L$ d1 W - public void setProducer(String producer) {& q6 ^0 h1 r; b/ g+ R
- this.producer = producer;) J! C: a6 h/ N) k. B
- }
$ p9 @2 Y! \7 R7 s2 m5 f) t -
, s, s! A3 r- n# _; Z: \ - }
/ K. P- U$ C8 u/ r4 K
复制代码- package s2.jsp.zhangxiao.daoImpl;
* r, t) d# l0 V; G5 x - import java.sql.PreparedStatement;5 ~' q& l6 |3 j
- import java.sql.ResultSet;
y' p( X2 @: l# I- Z$ A! C7 l - import java.sql.Connection;& P7 @9 \5 j( |& C
- import java.sql.SQLException;& Y8 j Z5 v! Y; E! A( F
- import java.util.ArrayList;6 D, i0 H# i3 C' j9 U4 S8 q( N
- import java.util.List;/ \6 W0 ~# K5 [/ f, ^
- ( _' R: j: s+ g8 w. P. @* C
- import s2.jsp.zhangxiao.dao.MaterialsBase;% F% F, B# K% Z/ q
- import s2.jsp.zhangxiao.dao.MaterialsDao;
9 f* S7 \9 N' C; i5 b# A0 w - import s2.jsp.zhangxiao.entity.Materials;
/ R# M+ H: y4 W" X4 x/ L% m - /**
- H& C) g# W3 c2 a8 a - * 实现接口的方法) {& N+ C4 l9 I/ w" j! M7 y. P3 e7 O
- * @author Administrator
+ c# w+ B0 P5 g - *+ _6 W4 C* M2 ^0 R
- */
. M, x% Z; o9 Y2 a! h. r - public class MaterDaoImpl implements MaterialsDao {
: a; E8 A9 \) u - /**( w# G5 G! P/ o1 X; H$ Z# B
- * 查询全部+ z8 m0 O" n: K! [" z
- */, }# c, M" ]3 ]/ J% y0 ^; i
- public List materialsAll() {
0 w$ Y. U5 W a/ x$ p5 `! ? - List list=new ArrayList();2 G% J6 A3 a0 \) c& g: h0 M. g2 K1 p
- Connection con=null;% V# J- E# H& o# D! }6 p' A
- PreparedStatement past=null;
) V0 }/ y* `" u4 [. J - ResultSet rs=null;
( w, Y: G/ m9 c. Q - //sql 语句) W( P; E8 a# B5 [, @" W2 S x, z
- String sql="select * from materials";2 L: r7 x2 r1 l4 ~! F! v9 w
- //连接数据库
8 ]( R2 b* M- l: B - con=MaterialsBase.GetConnection();, [7 Z9 q0 b0 j, s4 l$ g2 X" `
- Materials materials=new Materials();
7 q$ P8 G$ A6 |" C - try {- R( A2 Y! y* q5 l$ w5 K, S ^
- //传入sql
: @# M5 S9 E" n8 P - past=con.prepareStatement(sql);. {/ w8 X* |/ }
- //执行方法6 A7 q/ Y3 u) L- R
- rs=past.executeQuery();
" [5 J1 G1 {3 h S4 D) [3 O* n4 O - //循环读取数据- d, f+ ]) D& p9 u( p
- while(rs.next()){' T0 n+ C. ?: ~$ b5 E5 b( z
- // id, name, spec, number, price, producer
7 u0 G/ b; s$ J+ w - //编号1 s- A8 B3 ^3 s7 K
- // int id=rs.getInt("id");
7 e. ?' C' f. E+ l9 r9 e. X - // //名称
4 o+ p# w+ o4 l5 }& E j - // String name=rs.getString("name");3 p+ Y4 _" M+ b0 Z( }5 e
- // //规格
! k v: @$ ^& |1 w7 ]1 _# G7 v - // String spec=rs.getString("spec");4 u% v: w$ |0 q, z, ~6 t$ w; H
- // //数量" v. S I# y. ~8 ~8 w
- // int number=rs.getInt("number");
* G" X: ]( {. w n* G - // //单价
" y2 _) j3 v8 V9 D' I - // int price=rs.getInt("price");+ y0 q) }4 z# t1 {' W
- // //生产厂商
8 C8 H. o( Q. h6 O6 d% t T$ Z" o& U - // String producer=rs.getString("producer");
/ d9 k) m: K) A1 F$ F0 p - // //添加到构造函数7 o6 c9 G+ ^+ R; A% N; x x8 q
- // Materials materials=new Materials(id, name, spec, number, price, producer);
" }7 ~3 R! l9 ]7 _ - // //添加到list 集合
7 Q# y6 q R- p, a6 G/ v - materials.setId(rs.getInt("id"));( ^. V* ?" k' V& c" _* J9 G
- materials.setName(rs.getString("name"));/ \/ x f ]4 y1 Z6 ?
- materials.setPrice(rs.getInt("price"));
6 F) N# c% j* v( z - materials.setNumber(rs.getInt("number"));- U1 {' B: a% i
- materials.setSpec(rs.getString("spec"));
0 j5 r9 n. l9 J i1 i - list.add(materials);8 w! o8 S' e5 H. o) F7 P4 \
- }
/ ~5 v3 g0 v7 b! l - } catch (SQLException e) {+ T4 D8 Y s3 D( j
- System.out.println("materialsAll 方法出现异常");
) D/ u. }0 [: E9 @ ?- j. a - e.printStackTrace();. N. ^! M4 G1 d$ [: r# a* l# [/ E6 G
- }" z: U5 m3 x; d9 l }: K. E
- # C7 a$ h! b! M( k
- return list;' [' d! f+ t# V$ ^# z. T: i
- }
( f, i) F" V9 }: ]+ P - 5 T% x& z/ r$ |* ^( H
- /**/ o! J! o, H8 \) L w
- * 根据id 查找物资信息+ _2 q7 F- r2 o2 Y
- */
3 c3 r$ A) B; e0 L g - public Materials materialsID(int id) {% D$ [5 L/ x6 }8 |, @7 v" K
- //声明物资类
# P2 N) r0 q/ o1 s9 X - Materials materials=null;! k5 V- n" @, W$ Z! ]
- Connection con=null;
/ E2 W, h/ L1 Z6 ^$ w6 b; v+ A - PreparedStatement past=null;
! C+ `+ z6 R; v! B4 _, {7 ] - ResultSet rs=null;; G; w- ~, o+ E# y; @$ M0 {( D
- //sql 语句
3 y+ i% H% h; l8 r4 Z7 \ - String sql="select * from materials where id="+id;0 Q; c+ A2 ^6 C4 U) ]0 |
- //数据库 连接; z- O8 E6 ^6 ]' v: r$ M. o; ^$ o
- con=MaterialsBase.GetConnection();
$ a/ ]+ y4 D/ B( m - try {" ]: V6 g9 x- z; z' C
- //传入sql9 t. m* y3 o7 f& M
- past=con.prepareStatement(sql);, Z5 w. W, L- ^
- //执行方法/
6 z$ k+ @* e& |! E0 q - rs=past.executeQuery();
9 r& `5 L. R, k- {+ o - materials=new Materials();# Q- j6 r u3 r( E
- //读取数据
0 @: C" \) U$ A- J0 B! q - if (rs.next()) {1 i: x+ u) Z# ~$ Y- Y4 z4 C; _
- //名称6 H& F& J: m: e1 L& J
- materials.setName(rs.getString("name"));
- _" G0 O8 ?6 g( E o n - //规格0 E" d! [5 \- a; N
- materials.setSpec(rs.getString("spec"));4 Y/ O- u. w" U6 |
- //数量4 H0 B/ A3 s* u9 h9 I# C
- materials.setNumber(rs.getInt("number"));
5 A. g5 U( `- B - //单价2 F4 ^( c- M: w
- materials.setPrice(rs.getInt("price"));4 \3 u6 l+ F: Y) s. A1 q
- //生产厂商0 N0 e, H. d+ ^
- materials.setProducer(rs.getString("producer"));
$ p, {* U& t" C% z2 ^6 ]8 q3 p - }+ p ^8 L: { G
- } catch (SQLException e) {
* O9 V5 s0 s- a# P5 A - System.out.println("materialsID 方法异常");9 ^0 S. A/ x. b# g5 U
- e.printStackTrace();
3 [# F* |3 b' i" F - }finally: @- X- F- I" F8 u
- {
+ `, C- U5 `- }6 V X - MaterialsBase.CloseAll(con, past, rs);
+ `* ]- x% D/ T4 k: e! G - }
, P3 b- s8 k: M& M7 b7 i2 q - return materials;; ~, z. g4 r2 F c1 C; {9 Q+ z. t
- }
3 G5 [3 z# Z) r - /**0 U, _0 `& c; P0 S* A9 M3 u
- * 更新物资信息
6 ~& H' i2 Y4 |5 d1 Y& ^ - */- O, z) d: R" V& T- M5 R8 X* R
- public int materialsUpdate(Materials materid) {: E. Y- [8 h' o5 Y9 g3 q Q
- //sql 语句4 b$ Q8 B7 R& r' {% e1 R3 |3 k
- String sql="update materials set number=?,price=? where id=?";8 y/ ?$ J" P. `% _2 N/ @
- //3 F3 k8 w' C8 M5 d" G
- String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};
" I2 |* D# x' v - return MaterialsBase.ExecutUpdate(sql, getValues);
$ W9 c( S" m( Z& H - }$ l. K8 Y6 S" F6 o1 \8 _
1 Z' {9 Z- b$ Y; E1 B$ c- }9 a5 [$ ~# I# U1 D. u2 d
复制代码 ; Q/ s4 A% {2 G. d4 d$ h
代码案例下载:点击下载, }7 S0 [# b* g
! w7 _& H8 h ` h! x! L1 W; e
|
|