该用户从未签到
|
- package s2.jsp.zhangxiao.entity;+ [* K; d0 g) y' E8 Q
- /**
d6 u% _6 E( |) w, F: o( R - * 物资实体类
, @6 v0 f Q2 d A( h" y7 M, X - * @author Administrator
& z# ]* u, O( p' i/ W8 X - *7 n7 U3 g$ Q% R1 v, p5 X/ \
- */
& ~; r2 L% n( r1 K - public class Materials {- Q$ [, N# e) l( I, w6 N/ Q
- // id, name, spec, number, price, producer
& D a$ T! k( y% p. p - private int id;
8 o+ x, a7 z6 ~' { I/ ~' ^' h! x% s - private String name;
, p% x, ?! f' l - private String spec;3 L, C& `( b! j$ \
- private int number;' C' B3 j1 L( q* W% e
- private int price;
1 P" ~% \8 I" K3 ~5 o) _ T) w - private String producer;
0 _ O, S h2 B. \* u5 u! M - /**+ o" k v/ J) l
- * 有参构造函数
/ ~" D8 a3 [3 f4 D+ `% W - * @param id
6 y; ~; C Q1 G+ _1 Y - * @param name
2 m- ^2 O6 w9 @! J' p0 |1 ? - * @param spec" i; {+ a0 z" t- i( r7 h
- * @param number& |8 O) E% x, ]' D4 z; n9 f" G
- * @param price: y0 L. Y0 ?/ ?! j. _8 y/ D
- * @param producer/ Z& Y) e) r9 F/ v
- */0 g. K7 }+ n7 f- J1 r# a1 M6 ]
- public Materials(int id, String name,String spec ,int number,int price,
, c6 U7 f. \3 K" I - String producer ) {
- P6 B) [3 c. X# L# E - super();! N% j* B8 O. U: Z: n6 v
- this.id = id;# R- t. o1 { M% P! u+ u, H
- this.name = name;
. R' v( g8 j, @! F - this.number = number;
/ h2 P/ r2 C. y# X# l - this.price = price;
J. C1 Y6 Z6 a# e8 C( l - this.producer = producer;
* c1 g1 A+ f/ ^: X; Y - this.spec = spec;
2 ^$ s& Q" X( T! \) [% C - }9 X" [+ m" R0 t8 s' }# I" T4 u
- /**4 C- l" w8 ]# H. O. Z
- * 无参构造函数
. ~7 O9 U: p, v. l+ ]" d8 a - */0 Z7 R2 o# y/ f7 g3 ~, v' A/ B& j
- public Materials() {" l" u" E+ w- w8 J+ c! b1 @0 K
- super();9 G- d" o% \" e# R" Z
- }
. h0 A2 g9 D. I% g( a0 }4 p% G - /**
& A9 E( v6 X0 h4 D' B- B: f: }: W - * 编号
1 @8 _9 h1 Y* ~; c. Q9 i; d - * @return
/ ]( S( x7 |8 W( |8 C" |. { - */
6 d7 F0 A8 f8 u - public int getId() {3 X! t& r; t1 U: [" _
- return id;4 e$ v7 C' \1 j$ `9 x- F
- }" q9 n8 b M$ V- R+ Z
- /**! `5 s% k! i" j5 ~9 w* o. w+ j! j
- * 编号
& r1 r0 s( F7 X# f - * @return7 T: T0 F* t% l6 p- p- o
- */. L% T4 p P0 q* b/ i
- public void setId(int id) {
' G% d6 w/ q) N) H1 q9 R' m: y' R0 [ - this.id = id;+ ~7 u9 w5 E4 ?( z+ t
- }
9 p+ p, H8 Y: a3 p; s6 u2 {7 f( J9 ] - /**
8 O% q* L$ V7 p, W, x - * 物资名称( m1 x1 _. H# z
- * @return) G0 _' r, j4 A2 z
- *// g! W- X/ ?8 e
- public String getName() {
8 `2 [9 n) ^# N1 o" n* x' | - return name;' O* A* Z, z: H3 R* q
- }
E& j+ E& t2 `* j) K9 d - /**
7 W% _ S) s! D - * 物资名称7 J0 \/ h: l. n: \" t& Y
- * @return
5 E I' q) c9 F# n- F9 t( R - */
9 w' f9 V3 s0 U% a& S - public void setName(String name) {9 o; E7 h- Y, {% m
- this.name = name;
1 h3 O' a2 @5 c2 Y) ]% z - }1 ~) [# b, I* Q2 a1 t
- /**
0 C7 {8 G8 n3 T2 }9 V - * 物资规格6 y. |% M: H* s: ?
- * @return m' `; v/ w: e( S8 c; n) ?
- */, n( k6 p% U: l4 P. s
- public String getSpec() {
/ {$ F) \( r6 F - return spec;/ ]. T3 M" O( s
- }& z, Z9 t- H0 n0 j! z% F5 q
- /**& \! R# N. f% C; b8 }" e7 Z
- * 物资规格
' f! k x) J X - * @return
1 f. Q- V! `+ D: O+ f/ { - */! ?+ S9 P3 [$ n+ d* p
- public void setSpec(String spec) {
( j z3 X( Z" U; o0 O4 u6 i - this.spec = spec;% A3 r k% p' I- m) K& c
- }
: z& h8 I; G. P) d2 U$ g - /**% P( E' E0 A, e" V. Y
- * 物资数量9 h1 n/ v$ Q) L' Y
- * @return
: s J( S% W6 H( b" V$ B - */% B/ e/ N% w+ O7 a* J8 P5 ?
- public int getNumber() {$ g* o) l' t7 b! {% n1 t
- return number;
, |6 T! u# H# N" J% N: ?8 g3 t - }
% w. w6 S8 g$ _3 L0 G( i2 q - /**9 m9 Z: m7 Y# \4 s
- * 物资数量
/ d6 j1 B3 O6 J# u- \ - * @return$ j' v0 u+ ~9 O) P6 N5 M
- */
' }5 `: v% [# I } - public void setNumber(int number) {
1 d7 `1 ^) H8 {. Z0 p6 V - this.number = number;
- B' J1 ~# o# c9 i- q# E - }
( x! C g5 J z9 W - /**) B- j' B! U6 `1 Y% x6 x. e4 D
- * 物资单价
2 s; h( T$ d- c) p9 r' k - * @return' U4 U2 F* M6 Z. C3 f& G: A* _
- */
0 s+ g( P* q% h$ W6 M8 m' j& { - public int getPrice() {2 b: f( ~" y- n9 x% ]# F
- return price;9 n1 L4 Q! e# p! {
- }
, E* G+ D. N7 [2 ]1 @( l - /** A7 B: X. E; c0 V5 ]; K
- * 物资单价 L" U: L2 x& y+ ?6 {
- * @return
( s4 L9 w' C" y+ q - */ |. C6 V3 e# n
- public void setPrice(int price) {
* n, h, p6 ]7 b+ k - this.price = price;) O9 `+ v! @6 V. @
- }
8 ]8 L. z Z; I" |8 W! U - /**: ^" q/ j& f4 u0 k) P4 C, \
- * 生产厂商3 G4 }' `4 O) g# G
- * @return8 A7 w' g4 M; n: S( ]: c
- */
& ^) ?0 l7 G2 M2 k - public String getProducer() {% s% D2 l$ k" @/ n, l! j1 H' Q
- return producer;0 W; @2 e* g$ ^, e, S8 X
- }
) }+ j1 e+ F9 Q9 P2 r) k - /**
1 Q; n) @; W& k+ B! k! t, E2 a; @ - * 生产厂商
( W3 b j8 q+ C" l/ M - * @return
1 ?! q/ H L1 }/ [+ l* g - */
, ~3 i2 A. E, c" b, K; K/ \& T1 h - public void setProducer(String producer) {
" }% W t8 a# q( p - this.producer = producer;" U4 n* Q) L- l ?& z& M
- }7 j# ~- g. h6 ~; O" A8 f
-
5 d# S J* P2 B- ]/ | - }& b2 h4 f* T% c1 b3 C. v, T6 c" z0 C
复制代码- package s2.jsp.zhangxiao.daoImpl;
% n3 C" N4 o ~ - import java.sql.PreparedStatement;) ?( \' C/ b3 g( C/ Z! W% {) L
- import java.sql.ResultSet;. ]8 ]- P) e# X0 a& k$ o# x& m
- import java.sql.Connection;
, h( e( V2 j. V! O! { - import java.sql.SQLException;. P, m$ d+ v, t& H/ x
- import java.util.ArrayList;
( r6 C( J$ n: T) U, k0 J, b7 f - import java.util.List;
$ ?. W# l* U5 a5 i- B
# |3 |" d5 D' K6 \: x- import s2.jsp.zhangxiao.dao.MaterialsBase;/ W# o. j+ j4 g) l0 }$ ~
- import s2.jsp.zhangxiao.dao.MaterialsDao;
0 n6 Y: T, K6 M- T# ]5 W - import s2.jsp.zhangxiao.entity.Materials; b0 R; |* B: t3 u3 o; ?
- /**: h) H: L% A A8 g
- * 实现接口的方法. ~* n. Y& @* k' N
- * @author Administrator
) R/ f" e# |4 E6 d1 ^3 d! o- [ - *
5 J# ~0 X# T1 U3 u) P; K - */ e7 V: E3 Y7 e: \$ [* @0 ?/ @
- public class MaterDaoImpl implements MaterialsDao {
7 B4 P0 @6 v) } V8 { - /**
: S# x+ e4 M% Z6 g; \ - * 查询全部! y5 A. o9 y& s
- */
7 r( E2 _( u5 e& y } V. i* v - public List materialsAll() {
* ~# V! v1 D. V4 O9 ~ - List list=new ArrayList();$ r' t, o- i5 a+ R! k/ v" [1 q8 _
- Connection con=null;0 n* [* ]* B& V& ~- Y( x
- PreparedStatement past=null;
% L( |( w+ h; {# c7 s- t% J* G5 r- g3 D - ResultSet rs=null;
}2 ?- d4 W4 ^ c& e - //sql 语句
5 a& c9 w1 D, I& `) j' A - String sql="select * from materials";
5 H, `; t- c, t) L3 k8 j - //连接数据库! f) `: |! a9 B* r
- con=MaterialsBase.GetConnection();3 B8 a$ w8 ?/ g# x$ c
- Materials materials=new Materials();9 [+ z+ I( G3 N/ y8 S
- try {
: }: d) _! c2 S! j2 _/ i - //传入sql
' _' X, i& m+ a9 @0 ?/ f - past=con.prepareStatement(sql);
+ |5 Z5 {1 M' r - //执行方法9 T0 s1 n9 i. [3 \1 H3 I
- rs=past.executeQuery();1 a# b$ ]" N& E& K1 _8 V/ b
- //循环读取数据
& T( Q: Z" H# y# @9 n - while(rs.next()){3 [3 K# W/ w* V$ _) _# a
- // id, name, spec, number, price, producer( a1 y: i5 H! Z; R& Q5 v8 t% b
- //编号
& Y( V8 s% P+ B N& c - // int id=rs.getInt("id");
* b; A( w3 d/ U; l - // //名称
3 k3 B+ y/ @! h c - // String name=rs.getString("name");
% z2 H" _( f1 j - // //规格 V) F" Y& j7 l' h) N( r6 {; L* F
- // String spec=rs.getString("spec");* U+ {* @8 y: x! g8 T/ O5 `
- // //数量
4 Y) h% d+ ]7 ~* v* v* { - // int number=rs.getInt("number");
: K* _ W" v3 _# M+ M - // //单价
/ x% [. f3 K0 E+ F' H/ U: x5 X, f - // int price=rs.getInt("price");; F) |; V" `/ | q7 G
- // //生产厂商, F7 y5 _; h9 X) M5 q% A
- // String producer=rs.getString("producer");5 l7 r0 s& e+ B
- // //添加到构造函数" J+ [5 F$ o0 B8 ?- A$ n. b+ c
- // Materials materials=new Materials(id, name, spec, number, price, producer);+ {& N, p' c; }9 R) p2 m
- // //添加到list 集合
0 h y+ G2 ]* r# S. M1 Y0 ` - materials.setId(rs.getInt("id"));1 N r4 l5 u' s6 ]3 R
- materials.setName(rs.getString("name"));
1 L9 K7 \4 n- B4 c5 V) f - materials.setPrice(rs.getInt("price"));: ]5 }8 n% u% B Q
- materials.setNumber(rs.getInt("number"));
y0 ~1 h9 e6 L9 l0 Q4 L - materials.setSpec(rs.getString("spec"));5 j$ ]. U% Z( ^
- list.add(materials);! ?& O. j6 _: C
- } 8 L; C6 o' E- y j
- } catch (SQLException e) {) F! N; b( m/ `7 W
- System.out.println("materialsAll 方法出现异常");
+ b/ |; y! G& @9 I; n8 \. m1 O5 @ - e.printStackTrace();, c1 ^$ ~9 H. G p [0 C2 g
- }
2 t( _& c6 ]: [( C4 R - , z% Q* h; j" r$ O' A9 i
- return list;: D3 j8 m6 [; T4 x. y' N5 ]
- }
2 x _( n8 c; l( O m2 [2 d - 7 I6 N9 ]! Z% |$ R" X! B# E& |/ b. Y
- /** l6 z7 ~3 u) L$ [6 w- Z/ Q# v0 h
- * 根据id 查找物资信息
" l c$ F1 D' \, | - */1 G! Y$ S3 O, {" x+ @7 w" J" @
- public Materials materialsID(int id) {0 f2 W; L" y" ?" \6 `& K+ J
- //声明物资类. ^- ^9 w3 F5 I. t/ L( N
- Materials materials=null;8 Y8 v& U- {$ y& {% ]4 T* U% D
- Connection con=null;7 t* }+ q1 Z& a! m5 x
- PreparedStatement past=null; T5 h& @ |: Z5 A
- ResultSet rs=null;" B8 _' A7 F& H) Y2 V- w
- //sql 语句: j1 `; s: O& y: M8 [( ~( O+ J
- String sql="select * from materials where id="+id;5 Z. c) k. j9 I7 L9 j: m2 C
- //数据库 连接! ~) `0 C) c& P/ Q6 @
- con=MaterialsBase.GetConnection();5 b6 l1 O+ X; c( L/ L8 Q+ q
- try {
' v3 G$ a0 L% ~( t8 Y - //传入sql7 u B4 p5 z& T) z
- past=con.prepareStatement(sql);2 h( \; s- V. T9 e
- //执行方法/
5 f# B, Z1 D( I8 f! u - rs=past.executeQuery();
/ `4 h X+ `* F; x) ^3 @1 u - materials=new Materials();9 R$ ]* q9 n2 G4 m$ B* w: {
- //读取数据
/ V9 \- w% G. m' l - if (rs.next()) {7 E& w7 @ M0 J" o6 Y
- //名称5 g# t/ {6 t/ D% _: ~! r/ u; @# |
- materials.setName(rs.getString("name"));2 M# w8 t/ |+ e7 m/ @0 `
- //规格
8 R \5 K/ w- T - materials.setSpec(rs.getString("spec"));7 O5 b6 s- K/ A, q6 A) B
- //数量
) V$ f" Z0 U# M8 J% `2 {# g- u$ `! S - materials.setNumber(rs.getInt("number"));7 x% w2 ]3 A) R/ r* R5 o
- //单价
% M- {$ j' \& _0 n; a8 N: l- Z - materials.setPrice(rs.getInt("price"));5 ^" V, e' _! l0 E' d
- //生产厂商. D2 F3 c" P, P8 h
- materials.setProducer(rs.getString("producer"));8 ~4 ^6 j2 n. R8 y, r$ g2 o, \. k
- }5 g; J( |% f5 l% l& ~+ m& V1 }
- } catch (SQLException e) {) K6 t" W, R4 v: D7 Z F
- System.out.println("materialsID 方法异常");6 }. K5 w4 K! m2 ^. r% c3 Z
- e.printStackTrace();
: n$ A8 t6 d& {# q# R2 W6 m2 f - }finally
; _* a9 |! F/ T% K1 X - {
: t* A6 ]: N+ O2 [ - MaterialsBase.CloseAll(con, past, rs);& w3 p) S. H) ?5 S! q8 A
- }
) A. o2 h1 P$ ~! d2 {% Z! r8 ? - return materials;
7 c Y5 R" [" ~" |5 M - }# E! l5 k- s& x% t' j
- /**
$ r8 b* B* h# x% F/ q! A+ _ - * 更新物资信息
: j7 F; w+ W' q; R# w' O - */
7 s0 i5 D3 B% z6 V$ u4 B/ N - public int materialsUpdate(Materials materid) {: S* j- a+ f: \4 r' d+ l! m
- //sql 语句
% P3 f# z6 }( P - String sql="update materials set number=?,price=? where id=?";
# I8 \& ^7 f4 ~0 f5 S - //
E5 W9 l: c) _) t; I - String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};
# ?0 w, v L6 q. s D - return MaterialsBase.ExecutUpdate(sql, getValues);5 {" n' T" _( Z5 S+ [. I, X
- }/ k$ `, M& d1 v w4 r) j* p% X6 X
# f+ g- Y9 {& r0 j- }6 y) c K2 L7 H& x6 m+ Y
复制代码
+ v2 u4 Q. X8 i9 V* z# h* B代码案例下载:点击下载. ] x& V) m% @( |- t
2 g. Q/ ]' _; |7 f9 O |
|