该用户从未签到
|
- package s2.jsp.zhangxiao.entity;: L! K! u/ e' S
- /**
( C) b; e! R) G; d - * 物资实体类4 F0 l! f6 x a2 z# B, j8 M
- * @author Administrator7 Y( Z2 U( E# \4 _' \5 I
- *9 f/ s; R, P5 r& e5 ^& w I0 C% |
- */, X0 z2 A7 Z5 A/ L B4 S
- public class Materials {
2 e" n! O( Z% T# ~ - // id, name, spec, number, price, producer: t' N v/ D/ j0 l) h
- private int id;4 O# t+ Q- L1 J) W- n7 ?
- private String name;
$ O9 ?- ]/ z9 i& j) k3 Y. m( P. B - private String spec;& F7 X1 z1 m- R- Z" P+ n
- private int number; k) _: ?* k* {) y5 _
- private int price;6 U2 M- r6 ^) Y% U& V
- private String producer;7 S) u$ y! J5 M# n0 m D# f0 `
- /**
' V: l. R* R6 L4 X1 \& N - * 有参构造函数9 o4 u% n! g. C5 O* b
- * @param id$ U& t- u8 |! _2 S. k+ H1 b1 U/ c' I
- * @param name( @& V) D" S; ~
- * @param spec
" B A4 A( w7 N" I8 E$ ]: _ n/ L5 ]* y - * @param number
7 K6 ?% k7 d/ n1 R+ z' D Z - * @param price8 X0 v8 i. X. Z1 c% u$ [
- * @param producer$ r, G/ p. y% b; e; ?+ [ Q
- */; F7 g* ?! L* S% M5 p
- public Materials(int id, String name,String spec ,int number,int price,
1 K a1 D+ @0 S; M1 J. U! A - String producer ) {; ]3 Q5 n$ ]% S) _) ]
- super();9 H7 R1 o) I( U- {. O1 K. R O
- this.id = id;
1 U0 U+ K7 M. ?" k- w" a - this.name = name;* B4 P* n) L; D ~: H- [4 B
- this.number = number;4 r- W( [8 ?( J7 ^" o
- this.price = price;- n2 g+ d2 o7 f" Z& a, B# m n
- this.producer = producer;9 y9 [* T# A* U: S8 n. f
- this.spec = spec;
2 k$ v; Y9 g% F) M - }# E7 A+ O# L: F1 P6 o0 c, j
- /**$ S& T+ y) D9 h( A7 L6 D
- * 无参构造函数
* `7 a. U: x/ @4 p% _3 ]8 ~2 w3 a - */
9 a; R" p1 g D! P6 @ - public Materials() {
, i: r4 q( N) Y3 T1 v. f, O# {0 y - super();
7 Q" ~$ ?/ j% e - }
$ \! U2 E. C$ h! }2 N - /**5 L7 ?9 w" x) p5 z1 G
- * 编号
5 e7 P1 T: J: _0 |$ y p5 T - * @return) N( |( j& m% s U
- *// j- u# l C, |
- public int getId() {
5 a& [$ V/ j, L" O - return id;
% L. x, k# O5 D* h; S4 b# i d - }
' H* C! G: ?5 a! L" s$ ?+ K- t2 m - /** H* S) J7 N4 v5 |9 E( |
- * 编号
& s& w7 x& B ?% y( ~6 W - * @return
0 _ @- N u; m; X - */
8 h) U4 K7 @* i, w% ]" x/ M% r - public void setId(int id) {' l' C' v0 K. u6 M" W v
- this.id = id;9 n# a! @' T6 E' I
- }* w. a# t6 ^. F" Z3 ]3 g
- /**
! J5 Q; i# ]! i; P3 |4 F - * 物资名称
% {0 m" ]# O% Q8 P% u9 g+ r - * @return
6 }# Y0 R/ W8 X* Z2 {, }$ A! @ - */
& K. P ?; G6 J - public String getName() {* V7 ~0 b* M! v9 r. y8 v' b
- return name;
/ ^0 @% Z; n& Z9 _4 M8 K - }
6 Q" J3 r. l6 C9 K - /**- _6 Y3 \/ n2 c: J9 L
- * 物资名称) [9 D( @) @2 q0 G4 e6 W
- * @return
% B( i- K1 o9 J' W' B) E - */
1 M9 T$ Y9 Z+ A: b/ _) @ - public void setName(String name) {
5 }9 c1 P+ I/ {2 S - this.name = name;) J/ u/ u) b+ S2 X4 M5 @6 E% }
- }" L% j( O: m8 j1 D
- /**
- A* V7 N& `5 c1 P1 ]# }. ? - * 物资规格
! t8 e- b' }: o2 r3 q2 s1 o - * @return
( g8 n" I: j! V4 B/ y - */* ^3 u h6 b$ H8 F' E0 {
- public String getSpec() {
! C3 m6 u% t+ ~) l) a' B7 D4 H6 d" C - return spec;" H3 I0 {+ M- S8 x
- }
$ r. e, V# r' Q: v2 x, L' n9 ~. o - /**
% e7 x4 |3 y7 n U - * 物资规格/ l) t$ h2 X& w2 ]4 j* _
- * @return
k+ i4 Q, m! }6 M1 b - */9 e( r2 L) {2 f
- public void setSpec(String spec) {
* I, g0 T8 w$ p! ]# v- E - this.spec = spec;
" c2 p; s: }" m - }3 a. M% a1 g5 Q7 t, L! ]0 g
- /**1 O7 v+ c7 @" I& \) Z/ T( Y6 ]
- * 物资数量
5 U8 {$ C3 ?/ Y$ C% ? - * @return
. u9 d% C2 K6 f - */' b0 m% c' c7 i6 s Q/ C
- public int getNumber() {
7 ~! d8 T+ u! `- Y7 K" q1 f# X - return number;2 q, k, H5 k. L
- }
; m+ a( `, n0 P0 w1 \% ^ - /**. T V+ r, m5 V) F0 I8 [
- * 物资数量
1 V+ a1 v& v( Y - * @return
4 P, o0 M2 P+ G M3 y' k# [ - */+ L. I7 | H p/ x( g
- public void setNumber(int number) {
* Y! B: U. q# Z$ m - this.number = number;7 t) Y& n9 f( H# m! {7 l& _' P5 H( k
- }3 `2 \% V* Y( n. ~: r3 W6 b
- /**% q( j* I% ?' `, m
- * 物资单价6 a, D" S0 o" Y0 {. }9 c
- * @return
0 c' i4 n0 U5 @) u. u8 D - */
3 K$ z* g% b7 K7 C/ M# I( @ - public int getPrice() {
6 s4 V6 c9 g/ e0 ?+ } k - return price;. O+ W: l1 |8 ]( U. u2 V/ b! y+ q
- }4 I/ k; e- o3 o9 s1 S
- /**# N1 U2 g) p: f5 F( Y" q
- * 物资单价" e9 e/ U5 J" C
- * @return" V+ q2 A) r- s4 _+ ]( ^; i
- */! L# `+ W* `9 o! P6 ~. Z' @/ k
- public void setPrice(int price) {
( V) P6 @: E; J - this.price = price;) H$ g W( ?7 r' A5 n4 F( W
- }6 b. j1 D+ s- J5 |6 w
- /**
3 n0 `+ M5 k" w" ~ - * 生产厂商
/ U0 w2 j+ _/ ? V$ `$ U5 G3 B - * @return8 e+ U" O8 T/ n- }% T
- */& U- e e7 i F) q" c
- public String getProducer() {
# C" F6 v6 X6 I+ a$ ]. t - return producer;
7 q9 F" O! i: D- x9 U/ m( ] - }/ e# D: T# m6 d! L; a
- /**7 D0 H: h$ H/ L' T
- * 生产厂商
8 n& R4 h* g& o3 L& P% ^ - * @return
. {7 W v) O* j+ K. H - */
4 ]# R" H+ i8 x0 K6 l/ h+ Y - public void setProducer(String producer) {, M( E. P2 F' f# N3 t
- this.producer = producer;, d+ F! B, N( G" E. r! U2 m
- }
: Z. ?9 r) ~/ p t: l* _+ C - 1 q( z( R: \% T
- }
; k% q: L$ [ e# W
复制代码- package s2.jsp.zhangxiao.daoImpl;9 z2 O- U2 P5 m' q7 j% o& |
- import java.sql.PreparedStatement;
8 ^! i9 j1 X. t, j/ d7 [ - import java.sql.ResultSet;
- S/ m& f5 V" k( t V, w$ |% z6 y - import java.sql.Connection;
) L' N4 i8 |0 D% | - import java.sql.SQLException;" {9 X5 ~, z$ Q$ R4 g0 B( a
- import java.util.ArrayList;9 P! `4 ]/ f! h- s. W& W
- import java.util.List;
) `( V0 f7 w+ s8 z% H T4 g7 q# c: A
6 o6 S5 L4 q' _$ y- import s2.jsp.zhangxiao.dao.MaterialsBase;
3 C5 @2 ^* N2 P0 B - import s2.jsp.zhangxiao.dao.MaterialsDao;3 v0 Z s. o# e7 j
- import s2.jsp.zhangxiao.entity.Materials;3 w3 j$ c; h) b. t+ z
- /**
# @9 P1 |3 {# ~* ?7 d0 ^$ l0 P, e, Y - * 实现接口的方法6 f+ b" m4 z+ N1 _4 v
- * @author Administrator1 S3 K, F; o+ S
- *
$ u$ G6 F" h; P0 k0 G0 h - */0 Z( Z( a# |( _% ]5 \ G
- public class MaterDaoImpl implements MaterialsDao {
: R7 c, B( V! C5 Q - /**8 i5 f, E( G) l- B& H4 n# N
- * 查询全部
- E- ^2 x! L' t& s ?9 n0 c/ | - */
7 X5 g! Z2 b p/ y. m; I - public List materialsAll() {
D$ l A$ D' d0 C/ l0 S/ u - List list=new ArrayList();
' |% _4 F5 f- D/ S! B2 g - Connection con=null; f3 A1 z" B( ^1 {" Q9 o. _
- PreparedStatement past=null;
& L, u; G: \, \( c4 r - ResultSet rs=null;: s9 b9 y2 E- z7 N$ [, l
- //sql 语句8 A: b$ P4 D5 C+ y: F5 ?, y
- String sql="select * from materials";) G) t, V3 v, N% e
- //连接数据库
6 h+ S$ Z4 A ], b8 Y& {) N - con=MaterialsBase.GetConnection();
9 s3 X# f* v- R5 x6 e. [ - Materials materials=new Materials();
2 k# m7 @! J9 h# B - try {1 s6 {) P" j( b$ j7 o O1 I
- //传入sql $ P1 m0 J# s" p6 N: `) O
- past=con.prepareStatement(sql);
8 h' W: M- X4 }* v - //执行方法* v: r7 S7 n2 o) K$ y" P" W
- rs=past.executeQuery();' i- p' K# O& f% W) O
- //循环读取数据1 D" q/ m, X; q; q% \
- while(rs.next()){/ A( X# g! n, B8 J4 \2 {. f
- // id, name, spec, number, price, producer! Z8 p: Q6 P7 [- A: K7 d
- //编号
1 u; g) t( t4 k( D) m. w8 h - // int id=rs.getInt("id");
8 y: k* R0 O2 K - // //名称
- C: j0 J" t" _5 m! B# D! s - // String name=rs.getString("name");3 l7 m2 I3 M. [( M
- // //规格
) i! m* L2 v8 X: U6 ^ - // String spec=rs.getString("spec"); h2 Q" i( _% h( T0 G
- // //数量
: @% d) i7 r ^ - // int number=rs.getInt("number"); c5 A# F5 l( |1 F0 k
- // //单价
8 ^/ G9 Y, _# r0 Z9 d- C) M9 d - // int price=rs.getInt("price");% n n: |* ?! L" ~9 T1 [
- // //生产厂商. o$ S* h5 t- q' O5 }
- // String producer=rs.getString("producer");& v- w" J: v- O+ M& x; x
- // //添加到构造函数- h2 r! n0 ^) f9 a# Q) K
- // Materials materials=new Materials(id, name, spec, number, price, producer);
: e+ h9 Z' @6 d9 E9 {; f - // //添加到list 集合
; j: S2 b# K. [% |/ s4 n& D! _8 ] - materials.setId(rs.getInt("id"));7 k( [$ F. `2 B5 @
- materials.setName(rs.getString("name"));+ m4 I, y7 x0 h8 }. ]4 W, }
- materials.setPrice(rs.getInt("price"));
" q5 A1 b) {/ ~8 y f: e - materials.setNumber(rs.getInt("number"));" L8 t, p9 {. p
- materials.setSpec(rs.getString("spec"));
. `6 g8 P. y, U9 Z0 X8 ] d - list.add(materials);
+ _. n& [ a2 \: m/ ~& x. P - }
# j" g) A7 e8 M8 y* V- X - } catch (SQLException e) {
' x1 G9 V2 e; ?9 _ - System.out.println("materialsAll 方法出现异常");
* d$ Y$ ^( b; `' \3 S( g8 s - e.printStackTrace();
8 I$ [) k& W9 Z9 r - }6 [; `4 c/ K H" p) p
- $ z4 V- o8 @ U+ ~9 _
- return list;
% {: u7 X' ^5 Q7 \9 f - }
8 r+ B7 @0 r, y - ! [) l- @: K( V9 W9 Y: S
- /**6 [6 h3 k+ ]) L! V4 E3 P, x; A8 u
- * 根据id 查找物资信息
4 E6 s* |3 h+ v5 | |9 f. D - */
$ s+ w H. n2 Q5 J9 x9 f7 Z - public Materials materialsID(int id) { _8 o. n3 C6 E0 S1 l' k
- //声明物资类/ m4 e. f- [4 t9 `5 v* Z
- Materials materials=null;
" Q4 p z* u/ Y - Connection con=null;
, H* g" a6 k6 ?# D. R - PreparedStatement past=null;
, O9 _' }: ^8 c4 c8 J0 V4 P - ResultSet rs=null;
- O* O$ k9 R' y4 A- r7 Z8 ? - //sql 语句
- V( f$ N' O# K7 ?8 R0 N - String sql="select * from materials where id="+id;
9 d! O/ x1 U, o0 g0 v - //数据库 连接
( m% |1 B0 X! y; X- J0 ^8 M - con=MaterialsBase.GetConnection();2 P" ?5 {; S: D! A
- try {
( W7 I% p4 T& o: [ - //传入sql& B* I5 g U) D. E- r0 _
- past=con.prepareStatement(sql);1 [* P( X: ~6 Y! V+ f' p/ L W* m9 F
- //执行方法/! @/ @& s* h& ~: o7 X; B: }
- rs=past.executeQuery();
* x3 P* O% Z3 _9 U4 p - materials=new Materials();
: p' u& `" N" |$ E# [) n4 P2 h. E - //读取数据) I- q/ ]! l- O3 _; J
- if (rs.next()) {$ G: r8 }$ _: K8 \. s
- //名称
1 z9 O' {1 i) l2 F - materials.setName(rs.getString("name"));7 O6 [- [1 t" x4 S6 B0 u
- //规格
4 W' |0 N+ H7 D1 S - materials.setSpec(rs.getString("spec")); L, P' V7 T1 s' z1 E
- //数量
5 A$ Q7 f0 G' `) x - materials.setNumber(rs.getInt("number"));: d; U9 m$ i* {! m- M9 ^+ G8 Y3 m
- //单价
w( o0 Y1 m8 N. } - materials.setPrice(rs.getInt("price"));
+ y. ^+ f& i1 d# A1 T; w ~ - //生产厂商( r4 m; z3 [ v* p4 Q5 e+ k: l
- materials.setProducer(rs.getString("producer"));
% F- S6 V# v6 [8 g. S2 Y3 k - }+ Q+ @+ p0 L; ~
- } catch (SQLException e) {& O+ s' h& Q1 g0 T- S6 S
- System.out.println("materialsID 方法异常");
# }2 B7 W7 C; ~8 `+ U( o - e.printStackTrace();6 a/ K4 [1 e) s3 ]
- }finally! A( }9 W3 C% ^: p2 h! E2 D9 k
- {+ B$ W: x6 R9 f1 E3 {- N
- MaterialsBase.CloseAll(con, past, rs);! {& d7 t8 J1 L' T2 H
- }/ q+ s; w) p5 n8 L6 e) e
- return materials;1 f3 e1 z0 F( Y3 F! L) o
- }
0 g4 S, E; ^& F5 K2 |/ H - /*** Z. c1 E+ ?$ N _* P* |8 Q- Q, `
- * 更新物资信息* m; r0 w" Q J
- */
3 k) M' q% r. Y" [% C! A - public int materialsUpdate(Materials materid) {8 X: ~; l* G* V8 T1 ^, n- ]3 _
- //sql 语句
2 i( J1 h6 G/ o. Z" \5 ?! c - String sql="update materials set number=?,price=? where id=?";+ M6 ?' L! r! N, ]
- //# O1 k$ ^& b' u* `0 W; K& m+ x
- String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};
6 ~8 Q- w* o$ {- n7 z - return MaterialsBase.ExecutUpdate(sql, getValues);. U* ?- {+ h: u& a! b1 k
- }2 U) s: q5 f; n( J, \9 c9 p- E; H5 I' I
- ! G0 r/ N. p6 X0 Y% R
- }
. I) Q+ A4 e6 E
复制代码 & `# }0 Q, j o5 z: Y
代码案例下载:点击下载
9 B8 L0 Z9 _+ ^# s" m* c# @0 P6 w! m# I2 A E
|
|