该用户从未签到
|
- package s2.jsp.zhangxiao.entity;3 {# Y4 C9 G, b& a
- /**
) ~/ o1 E. f' R5 U% \1 q - * 物资实体类
, R* I8 D. s7 a9 \6 n3 I - * @author Administrator& ^5 Z, s1 @; P
- *
+ z$ ?" U% s1 T. K - */
# z) f! r' `. B) g - public class Materials {" F9 d7 i: n' J5 H8 Y3 N3 A
- // id, name, spec, number, price, producer4 H1 \- \" z/ m
- private int id;
2 z; N; j3 o2 S1 q0 r; ~3 f( ~ - private String name;5 Q& O6 A$ P- E
- private String spec;
' D) H _9 r& `6 S* I" [$ @) ? - private int number;( K* X1 {7 U5 ^- [
- private int price;
2 p! U9 N* {! ^: a9 j i, @$ G - private String producer;7 _/ ?5 a, Z) U3 K+ v* M
- /**! E7 M5 C9 _0 ~! _! z3 b1 w
- * 有参构造函数
: r. T( T% }1 U# G- b/ P% I - * @param id3 M/ {% R7 Z$ ?' Y0 a
- * @param name
1 y* f4 N7 E" o: U - * @param spec
]: d# _) C) L" Z0 l$ V7 b' w - * @param number. j: \) l; U+ v1 i
- * @param price
3 O5 r7 ^9 x* D" v4 a$ e( q - * @param producer, o( w4 P) H& c5 T2 z9 b8 \
- */
! ?' M) G0 G: A. w3 Q P9 x/ U - public Materials(int id, String name,String spec ,int number,int price, z/ ^, |9 t3 P6 c. ~! y' p3 Y
- String producer ) {* u2 _" t3 _( a$ {
- super();- B/ ?) ^. k& ?1 a# |) ~0 ~. E
- this.id = id;
5 G" L" `3 P- O, L; o- w3 E - this.name = name;
5 H) T2 F5 \% }- L# _' t- i - this.number = number;7 A/ r- Q8 e0 i" n! c/ ~& R% ^
- this.price = price;3 I+ ^4 d7 F4 R5 U. r3 @$ a$ d
- this.producer = producer;5 j9 M, Z. l+ U! |+ N& L
- this.spec = spec;
( \, }9 { k) f- U - }
$ o4 e% |6 L' s' C9 J - /**6 C* l! s) r8 o" q# H1 v
- * 无参构造函数
* }6 m* S# a+ {$ b - */( o2 b5 z( q( R; J- g7 j" |
- public Materials() {) c* Q4 b% t# l: l
- super();
* u& t" @, a; r3 e [. `5 x3 h - }
" L6 S0 y1 u' {$ b- n: R' G - /**
% Z! B' i! }0 J: }" F$ @ - * 编号
% K! ^! y. g5 N. P; P* E - * @return
, \. `$ G6 u1 ]/ c) N - */
R4 }; k* x1 n( @1 d- r - public int getId() {
% q3 \- h4 R& f! D2 @ - return id;# ]! _4 i" n0 r2 r* _4 q% j
- }7 ]3 g# d. T& q
- /**! ^6 h9 ~( x# e
- * 编号
( u. y: l! S- q+ }$ R/ ~ - * @return1 u ]& p, ^* \" `) E
- */
% w, c$ @' @# R - public void setId(int id) {
1 I9 ~4 [* K0 P! P5 T - this.id = id;9 _; p# r1 P8 i
- }5 r1 B& ^& z/ e/ b
- /**0 O# n) r' k8 z, ?
- * 物资名称9 u1 [( E; s5 N, [* W* y/ Q
- * @return7 ]" Y# G0 I* ]* d3 G- M
- */% p$ {! _$ y6 E7 o
- public String getName() {% \4 K% U! n, t L$ ? e1 M, _$ P
- return name;
2 L# A% J P* L8 S# h( B1 c. B$ F - }$ S8 c" {( l8 ?# G4 m5 z) N) n: f7 t
- /**
% s0 I+ W" O1 X3 U - * 物资名称% Q: ?% j6 D+ V. Q ]! z
- * @return+ }' E4 v( R; \! N* n/ V/ O
- */. A' x# M! F" z% a! t
- public void setName(String name) {7 f, C8 j! Y) g; U6 k$ W
- this.name = name;
: D0 d3 v) a( W/ ^6 o6 q - }! }; e% ?# R2 V: a' e# K
- /**$ ~7 {* j9 E, j }/ C) r
- * 物资规格
) I' p! z7 |2 l6 U0 R( O" {2 n - * @return2 G& i* N& e% i/ q' ~
- */
$ s7 w- B+ f3 A$ F - public String getSpec() {
2 E' Y9 n- Y/ j% r) D - return spec;9 G% C; M" r8 W
- }5 u- K& D5 V+ K+ D
- /**
( V- Z; {) W8 v, I7 A, N- } - * 物资规格
s1 p* T8 S# o& m. Q1 i4 y* I: ] - * @return1 g) m0 L; {% I( T# F
- */8 L1 h* i$ T. G b# u) L
- public void setSpec(String spec) {
& Q8 z2 A$ L! F+ n4 p6 Y - this.spec = spec; f" l) q" G& h: G g7 y: G
- }
( }% ]9 m7 l1 ?0 T2 D" s; }; ?. ? - /**- z3 c# k T- A
- * 物资数量
3 @* V1 G) y" K: b - * @return% U% D1 T3 P! Q6 j# ~% S
- */
( q- x4 r0 ?& q4 h' C) h( y& ^ - public int getNumber() {
5 B7 t0 F# F9 n5 C- O4 h - return number;
; I {3 c' z' |0 u - }
8 V4 C4 e. o# W$ P8 W. c# K2 F - /**
7 }7 j1 ~; R6 p7 w4 r5 a/ Z) ], m - * 物资数量
, O% y/ Z4 C0 I! | - * @return3 z: @0 J, C8 n* g# s2 W, B9 i
- */7 `: `# s( N% ^* P
- public void setNumber(int number) {
+ B: h0 z; p; @, h# d& Q - this.number = number;& [* F0 H7 h2 G& L6 p' ^+ _3 @' L
- }
* L' {1 ^' {2 x" _ - /**
' k$ n* U2 a+ N( W. o - * 物资单价) j" `" m, i; R5 h8 l( Y& Z
- * @return
' Q& x2 E" t% L, P) | - */, V+ S+ P! `$ X# U) N |: r) ^1 o# D
- public int getPrice() {2 w k* _) o2 Z# t
- return price;
& h" A* o4 k: L! D0 v1 {8 P - }
( u7 h* F) A( e8 t% i! ?; c - /**& g$ r* n7 G5 J5 i, p* |
- * 物资单价. H5 N% _$ [8 @2 e! F: V' k
- * @return4 z) _0 I; ^ _8 s7 f) w, W n
- */
5 H+ E( O( W1 o8 |* v0 Y7 ^* } - public void setPrice(int price) {" D' ?" z; R! N$ ~3 G
- this.price = price;* o# _ S# T7 C) ?8 u5 e% f
- }: {' z5 d3 C2 s: `9 q
- /**- W4 d$ B' x' ?' U+ |
- * 生产厂商* T4 T7 a7 S2 S" m
- * @return
, _1 R- F% T/ f3 f- Y# d - */5 W, ^; t) L! Y0 u: l* a
- public String getProducer() {. q# V( K* W% B0 o
- return producer;
3 e5 L+ ?/ d/ }: Q; \ - }
5 {7 `; z) G! w4 t. y& a4 X - /**
% i9 |. m, [8 S' ^# {7 _8 V - * 生产厂商
q$ A; d; i! B9 r1 k; h6 d% g- U - * @return
3 a# X. P* |. T' b - *// l$ |# D- m( n9 s
- public void setProducer(String producer) {" @% e! A4 k8 M% t
- this.producer = producer;/ L* `/ f; K# P. e& i6 e
- }% B1 W: t6 B5 I. s p: l& T5 N
- - U! n8 E7 A: W$ Y% I2 s
- }
% `) U7 E( p5 N% ?9 [6 Q
复制代码- package s2.jsp.zhangxiao.daoImpl;
' z8 }1 S7 Y7 l( B4 e - import java.sql.PreparedStatement;
+ S6 j o! S" F5 r - import java.sql.ResultSet;2 v5 o6 G7 t1 N! V- A
- import java.sql.Connection; u+ ?8 @7 p5 e) N. |9 v8 ~4 {5 [
- import java.sql.SQLException;: f y, [3 w" l+ h) h8 _
- import java.util.ArrayList;) V4 u% e: M% v. M- V0 s
- import java.util.List;
- C/ }. H$ ]* d, |5 [$ M+ H
" @$ F( f8 I. \; v0 u- import s2.jsp.zhangxiao.dao.MaterialsBase;
, N; J5 S: [& P, ~ - import s2.jsp.zhangxiao.dao.MaterialsDao;% ^0 g) Q' [" w9 p
- import s2.jsp.zhangxiao.entity.Materials;3 s' v w* v: i
- /**, {; w" D) }! j3 Q0 {8 Y
- * 实现接口的方法! Y& Y: n0 E) M' j5 I3 P
- * @author Administrator) |8 h* {% K! j! a+ R/ @
- *# |. h" E. b ~/ O
- */) e. R/ R6 s! V0 F$ O7 j
- public class MaterDaoImpl implements MaterialsDao {* o0 C, y( J6 x8 D% C$ `9 e( J
- /**
7 m7 x9 a- }# q0 I9 b7 `+ G) @5 I8 _ - * 查询全部
# A- G4 J( N X3 I$ ~ - */1 y, e: E+ H" J" e/ ?
- public List materialsAll() {
3 d3 s% c4 g4 D7 @' e6 s - List list=new ArrayList();
' @- i, d1 J2 A# h0 j8 N% E - Connection con=null;
* y) t: ?3 K. I7 j: T - PreparedStatement past=null;
' Z7 Y" J1 l7 q3 i' k- s - ResultSet rs=null;
/ ~2 K3 O, B& U- P+ |" s - //sql 语句* N- d) ?# |7 u6 _3 k
- String sql="select * from materials";
" d" W& W! V: ]2 V0 I8 H6 S$ T" I - //连接数据库/ ]& g+ H/ Z& ?7 q
- con=MaterialsBase.GetConnection();
. X6 a: ^" J1 @* o3 S - Materials materials=new Materials();
1 l2 T$ j1 p' x) q6 M& d - try {
# P+ g7 D9 I* m4 X1 I' A" y8 H - //传入sql
( o& `* g) f/ y6 P - past=con.prepareStatement(sql);$ c6 y+ C$ P0 l \
- //执行方法! c4 l$ q. y* y; l* y e3 ]
- rs=past.executeQuery();
8 `# X: g) { Z7 O5 w9 i, ~1 p/ t - //循环读取数据
: E7 _; Z$ u8 R$ h' ~* U1 ] - while(rs.next()){" U! O, \0 b+ d, K1 s: R
- // id, name, spec, number, price, producer
' S5 v! l& j/ S* _ - //编号* ]/ \% G" E& K7 {4 l) N1 d
- // int id=rs.getInt("id");
. L x+ g5 C/ S3 _& T - // //名称
7 W; L! E- S0 f2 x, l2 n - // String name=rs.getString("name");* K+ [4 O1 ~' H2 a* U1 O
- // //规格 [+ B9 v' y* I. \
- // String spec=rs.getString("spec");
7 ~4 W1 ]- Q1 T) `4 s - // //数量
$ ^* W7 k: x) j# `$ T# ~; P( E - // int number=rs.getInt("number");. s- }/ w* T) K- L3 |
- // //单价7 a- k- x0 @* ^1 M
- // int price=rs.getInt("price");
# ?8 K. `, b( k! B( s - // //生产厂商$ a: l, g, A2 i8 c
- // String producer=rs.getString("producer");
`7 ^$ H5 e2 g) i6 n - // //添加到构造函数
# O% o( `7 p* c# h7 u - // Materials materials=new Materials(id, name, spec, number, price, producer);
& }3 V! K: \ I8 b3 l4 m" g7 @2 ~ - // //添加到list 集合' y3 p* _( W- j# ?* `' m$ [
- materials.setId(rs.getInt("id"));
" B% g+ y. R7 @; E; u - materials.setName(rs.getString("name"));- }; v4 @4 r* U9 q- Q7 H
- materials.setPrice(rs.getInt("price"));* p0 g; Y* F9 w" g/ B; N
- materials.setNumber(rs.getInt("number"));
0 I) ]: E; B5 y, o; v - materials.setSpec(rs.getString("spec"));
3 S& ^& R7 _6 o - list.add(materials);+ M9 M: y$ G& u: j* `# b2 k9 u
- } * @; w" J m4 \' {+ L" h) M
- } catch (SQLException e) {
w' b5 t7 V4 w! Z( a' n& i' q - System.out.println("materialsAll 方法出现异常");
6 W2 i E' u- r3 E - e.printStackTrace();1 C( f5 O; W- A4 e
- }# G5 X- ]+ `$ G
-
, u: s2 Z& j; p k7 q7 m - return list;
) b0 Q$ u; J! y2 _: \' s: Y: s. G7 r - }
' C. K6 Q; K3 a4 Z0 z -
" ~/ y/ `9 x0 I. ?+ d" ?& k - /**: y! S b1 K) y1 T% U+ I0 k& p
- * 根据id 查找物资信息
9 p' X" l4 N" w - */+ Q, M( |1 L3 }9 N5 D
- public Materials materialsID(int id) {5 x3 ?4 ]$ s) x9 v3 L
- //声明物资类
, B. C8 o- E& F4 ^% v - Materials materials=null;
7 ?$ e$ o! K1 b# @8 i4 e# | - Connection con=null;
" ^% c9 g2 u$ K2 @$ O - PreparedStatement past=null;1 [$ {2 M6 q+ U$ o# |9 d8 I4 z& B, ?4 j
- ResultSet rs=null;8 o: v; m' }# m5 P q- S
- //sql 语句
6 ~( G# S& R9 C1 L' y6 F - String sql="select * from materials where id="+id;7 ]! f- U/ b: Z a/ V; G" F
- //数据库 连接$ H9 `3 t# e0 V$ p& e4 O& w- P) f
- con=MaterialsBase.GetConnection();
4 o, w @* p7 ^! _2 O9 k - try {
: Z8 F# e- }1 p - //传入sql8 J! J. J: p0 _1 I* E- | W+ L
- past=con.prepareStatement(sql);. P2 t9 ^6 G" H4 v/ T
- //执行方法/
" `& G, c" y/ S q! u6 [ - rs=past.executeQuery();
2 ?1 `7 O5 A, J - materials=new Materials();! u- A3 y; N4 D+ E: [& [
- //读取数据
7 E3 q% n$ r" `+ b8 C - if (rs.next()) {
- n/ T( s* `& @ - //名称# L2 g7 S! A8 n0 R4 D9 G/ _
- materials.setName(rs.getString("name"));
0 J" e. q) `9 b! C7 N/ U# }+ Z# l - //规格 @) ^: ~& h1 W
- materials.setSpec(rs.getString("spec"));
! U, p! v D# ~9 m; s - //数量
, N( o; B" k) y - materials.setNumber(rs.getInt("number"));
/ N; v) @0 G _! ~ - //单价
1 N3 V; `" L. x! a( `: \( { - materials.setPrice(rs.getInt("price"));. i/ D+ V5 k R1 Y* o- ]+ Q
- //生产厂商
/ |( ~9 j; I" Y8 [0 a - materials.setProducer(rs.getString("producer"));
# b2 L% L9 ~+ Z, D L4 j7 B - }
% N1 L' K# C( t. D! M - } catch (SQLException e) {/ `# z$ s) D1 e1 z
- System.out.println("materialsID 方法异常");& ]) X5 e7 _: c8 Y: k, \" r$ ~
- e.printStackTrace();
0 t- {; g8 o0 I - }finally8 ?3 { m5 [+ Q0 D- Q
- {+ t8 Y* @% o7 C# `5 u, r! `' Y
- MaterialsBase.CloseAll(con, past, rs);4 }; y2 o' H9 Z) [9 {4 o7 P
- }! l' N7 W3 V' R5 Y' V# L
- return materials;/ @# X1 v; A6 D5 E$ F5 r+ ]( K7 ]
- }- R" N! L, a) J8 J$ H
- /**
" _* f, c/ `, e3 m - * 更新物资信息. M7 F m# W0 t# w6 O
- */& x9 Z; b" k1 f' d
- public int materialsUpdate(Materials materid) {4 g m' O% \6 ?7 o0 J2 V
- //sql 语句3 Z% ^" B( _8 M" U9 E8 Q% e
- String sql="update materials set number=?,price=? where id=?";: R% a S1 n. I0 L5 v5 c
- //' A! \; n- V2 x$ L. @$ e5 o8 W; t
- String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};
7 V( D& ~; ^) m8 P - return MaterialsBase.ExecutUpdate(sql, getValues);
9 o! Q- o+ _1 Y1 m6 U* y( a - }2 }7 e; ^2 Z4 o7 |5 p
4 P) ~* q2 T$ ?- } T; R, W8 O" E9 N5 Q+ \. c( ?4 C
复制代码
' C- |! D* U; l代码案例下载:点击下载) q- u- b1 ?8 D% v0 b) P
9 T6 q, } Z I7 q1 l
|
|