该用户从未签到
|
- package s2.jsp.zhangxiao.entity;
' Z5 f- h& `# D5 s - /**
, M" u* ~( r* Z5 e7 p6 E2 N. N' J - * 物资实体类
- ]) @; ~2 x7 s- d$ O - * @author Administrator9 U# w0 G$ B N; a: ?) t, F. V3 Q$ Q
- *' C6 D/ i/ \5 f L8 w
- *// X$ a8 Q7 U7 }3 L$ p( `: e
- public class Materials {
) y- S' N: V5 d$ C! D! C - // id, name, spec, number, price, producer3 Q, G* U! Q$ p+ o& Q9 k; E6 z8 y
- private int id;
( j4 p# b- |% V; d! s' @$ B - private String name;4 d r$ a- N: O; n
- private String spec;
7 e9 `. }% G6 `/ ]3 z - private int number;' T+ v7 E) u- D7 d+ c) ~! u
- private int price;
7 M$ o2 f. [$ A" |& P4 _4 d' s5 e - private String producer;
* v/ c. b; C3 o& r" z. L n) E: C - /**
' C& R Z. U9 H4 l - * 有参构造函数
! z C& U$ B/ O' y+ E7 [3 ` - * @param id
# ^+ p. K1 R& l! j% g) g - * @param name* I+ j6 T2 k) e3 N& j. D
- * @param spec
7 _' a5 D7 F9 B, T - * @param number2 a) E+ x" e4 ^0 c) X
- * @param price
; V) s* w3 Z2 Y# ]9 O - * @param producer8 _8 e0 Y: Y. D' r! J% z& C
- */& G4 }2 n2 K( }3 j( k7 B, L
- public Materials(int id, String name,String spec ,int number,int price, & Z" f& L4 Q; t
- String producer ) { k% y0 ~9 N* y' H' t
- super();" M4 M4 E3 D- Q% h9 c7 U
- this.id = id;
; F% B; `" T9 |# n - this.name = name;+ a$ \5 I( q# W& C: K' l! k
- this.number = number;
" g! a2 ~5 u5 T1 [8 ? A3 i M - this.price = price;
6 v9 i" l9 `6 y Z - this.producer = producer;
7 [( }5 V7 M8 z- a - this.spec = spec;
6 Q* R' x) l/ l1 Q - }
" l2 M! o$ B4 n% Z7 l7 @ - /**
& e9 V" k% Q) L0 O) f( [9 k$ X4 n - * 无参构造函数4 P& c+ z2 B4 s
- */. g! @ H: p$ p1 ^* V% `
- public Materials() {
( a, U( _+ U, F; f5 W' J5 d - super();% J; [# Y- M: i# R& Q1 N, C
- }1 r, h8 |( b; W1 Q" d* I
- /**
9 m7 n6 S5 G9 H% O - * 编号
- j8 N6 g6 i0 N+ J - * @return
( u! E) n0 B% E - */
6 ~. @8 C6 w* b% b - public int getId() {# J. A/ N, j! _8 p+ x
- return id;# i R) R) ?. A
- }' J- r* n( i6 }" L. T4 l
- /**
! _! W4 v6 l- g/ L - * 编号: |" t' E3 r) r/ y2 _' |
- * @return+ S6 C! y+ j l: B, P
- */0 V0 Z* n8 R7 N/ \' S/ F
- public void setId(int id) {+ S% f* O2 B" f q7 u* F5 L
- this.id = id;) Q9 a$ E3 _& I3 b! t9 J1 I& ^
- }
; d$ }$ N3 N1 V - /**
1 Z& t3 u, J2 h% z - * 物资名称) H, [# a4 R0 w; J, C S9 T
- * @return* C8 F0 \$ {9 P: ?
- */! z7 P8 v, D. d1 ~& L0 A" M' V# n
- public String getName() {) z, m/ W) P E- l' c4 s' Q% t
- return name;" E3 N8 ^4 k% `1 I/ k- I! {- u
- }) u8 X. r! X% J, v& Q
- /**) m# ]0 C2 L$ ?' R' E- P
- * 物资名称. @+ K. w' y' t& Z
- * @return, N; p$ L9 V# o# |& w f
- */! D4 r; F. Q) \% ~
- public void setName(String name) {$ g3 F8 `/ g4 W3 ~5 X
- this.name = name;
4 s) b: G$ N: \. g( b1 ^4 p - }
2 n+ G- @) T, e" Q4 F% Q, a - /**
0 @. L: j" W- {) O8 H - * 物资规格& j5 g9 m. Y2 U
- * @return
: r5 j" F9 y% x: Z1 ^6 M. C - */6 m/ a/ X) d( u$ \
- public String getSpec() {
3 i( l( T6 s9 {) @+ z - return spec;& h$ h5 u: o" U; L' U" P9 _5 ^3 W
- }
6 Z; A) W! ^% |7 O3 A - /**( \% n; ]& D, R1 n
- * 物资规格
% I: H* i+ o3 U - * @return
1 y; O) I3 t/ b2 E; c8 J/ V1 G - */" _2 v+ H' P. h
- public void setSpec(String spec) {% K8 b8 a6 r0 P' _) s3 @. c! X; r
- this.spec = spec;
; N5 G8 o/ d9 I' X. o' O8 T - }
9 [& l9 q; A: _! R - /**, D6 E a! b. a# ?. F
- * 物资数量
% M; m3 H2 U9 W! B: x - * @return
2 l% L2 r+ X% G: R* f8 a0 o - */
: P b0 |/ {* q1 j& p - public int getNumber() {
0 L! g; H* @! {5 E - return number;8 }( C5 j6 L4 p2 N( C' Y2 }
- }
( b& w7 r% Q4 Z! ~' Z - /**# l, M5 u2 f# `* [3 u
- * 物资数量+ E, k0 l# {/ X% K( F1 J# u8 F/ b
- * @return
* z% l+ ?# V$ Z, d6 B - */2 }7 l- b' J! g8 ?7 G
- public void setNumber(int number) {% S/ X- a, J2 b6 v
- this.number = number;
* L7 Q5 T2 C- M+ ~5 C# L( k - }6 \' w3 x2 [- |4 U
- /**
- V) _/ S4 {+ p0 \# K* J9 @ - * 物资单价* s( J5 U9 W: F" S/ J" C) @4 V
- * @return
2 I$ D- e( @$ q" Z: a - */) `/ R1 B( b+ `! Y9 S$ a F: v
- public int getPrice() {
: z ~ J$ ?- d% S' Q - return price;; q5 ~* ~8 \+ C
- }
" m2 `7 p6 c& @- C, F* Y0 ~ - /**' @4 O4 _+ Z1 |6 w0 u' K" y Q
- * 物资单价) A B% M1 T- e& z, Q7 K
- * @return
2 s( h1 d4 B4 L) t- ]/ X - */
6 M# A) k7 G2 @, q - public void setPrice(int price) {2 ]9 L. b' x+ O" X) Y2 k
- this.price = price;
+ p% q. E4 y- j1 _0 w - }
$ o' R% ~" {- y( r& Y - /**
/ S2 T: z- \3 I H. y8 U1 j - * 生产厂商
' N8 {& @; M9 B6 ]- ~8 L' a - * @return( M2 ?, ` V# Q7 u
- */
( b8 x( F/ \# p% U& _ - public String getProducer() {
( Y( t$ N3 }# c/ b - return producer;5 M" D; Y- H. ^8 o% B
- }/ S Q9 b+ Y0 S7 M2 F# t
- /**
7 R, P% i6 I/ I; j9 n- a' z - * 生产厂商
) w! m+ H0 S% O# N/ y1 b& ?2 y - * @return
. p, K3 K7 P- T3 K0 Y - */# C, ]6 Z! K. F3 ?, I3 v# O' \* {. `
- public void setProducer(String producer) {/ Q; ^" \" k% d* o7 s: s
- this.producer = producer;
3 q! ]6 c) C+ U+ y- J - }2 Y6 _" l i- N5 E0 p9 U2 a [
-
* U' | E4 ]# ]# v* p - }" s% o. E3 j1 F4 n6 P
复制代码- package s2.jsp.zhangxiao.daoImpl;* P7 w- R; A/ E2 K) C8 |& O9 Z
- import java.sql.PreparedStatement;! v8 a3 o8 U) B; ~+ R5 w
- import java.sql.ResultSet;
5 I% K7 m3 q5 M0 H- G - import java.sql.Connection;, o4 M- t I- w" K; a: t8 n
- import java.sql.SQLException;
9 ?/ W% G1 F8 C - import java.util.ArrayList;
2 _* J$ J9 F0 s1 r - import java.util.List;
. W! J' b; _: i( b# b: u+ c - - L2 g7 i" _; m0 f+ ~0 o! x
- import s2.jsp.zhangxiao.dao.MaterialsBase;- P I) ^% _" q( [5 w `
- import s2.jsp.zhangxiao.dao.MaterialsDao;8 X. Y% y# ?0 z) v/ Z% i% v
- import s2.jsp.zhangxiao.entity.Materials;
0 N: {) g) a1 J; @( J8 Z# A - /**, ^3 k9 X" T7 d, ]. j) B
- * 实现接口的方法
$ N/ l( `1 j+ K0 M& h - * @author Administrator- R, |: E: z0 `: ~+ P N- A
- *
* T% ?! Z$ @9 q4 B- C F+ M) q - */
9 J- N* r) G0 y+ w1 M6 \+ k - public class MaterDaoImpl implements MaterialsDao { C/ x. f* A/ p$ c' v/ ~
- /**
6 T; F% D( S, N; Y - * 查询全部
' u+ N# g8 x4 b) Z - */
; P0 a' J) t) k- K - public List materialsAll() {
" J& D! T' L- m3 X+ _" Y - List list=new ArrayList();
6 s8 g! r$ {) E, F: T# V$ T" B - Connection con=null;6 w9 O% a; _0 ~6 u6 s. F
- PreparedStatement past=null;
" x) C/ \7 |) ? - ResultSet rs=null;
9 y' B1 S# g$ I' P( ? - //sql 语句1 I/ y0 {. B. T8 m8 r; c6 _
- String sql="select * from materials";
- v) v& M/ a: Z - //连接数据库% _, @& g0 l3 ^0 Q- _
- con=MaterialsBase.GetConnection();9 M7 Y/ I. H/ o. Y
- Materials materials=new Materials();
3 b$ a0 U3 H/ H" B: ^& _! N - try {1 g N5 m0 s7 A# S
- //传入sql
# m, A5 W2 a/ h# o, d - past=con.prepareStatement(sql);
% S2 l7 c+ d" c. ?) A' }5 L - //执行方法
$ A0 C6 p% b) ?2 _: J- }& j9 L+ U - rs=past.executeQuery();
% a4 l% g3 G. z9 k# W4 J1 a - //循环读取数据
2 @& V, K) g" j( X0 @( S) ` - while(rs.next()){+ A' l! a% D6 M2 [
- // id, name, spec, number, price, producer" j* ^/ ?% j4 Q; K
- //编号
; {9 [4 G5 p" }. T4 d/ A - // int id=rs.getInt("id");6 o! K* J& h1 V i D$ Q. g" E5 C. g
- // //名称6 C4 \* B) f* X- c% u/ X
- // String name=rs.getString("name");
, j/ W; T9 [. K. G7 i- ~( i - // //规格
- M# R6 U& d* a' q/ y) ~$ h+ o - // String spec=rs.getString("spec");) r( G, s0 P! T
- // //数量( f+ S: r) G) S, N
- // int number=rs.getInt("number");) L0 B4 g- G: G
- // //单价/ H( g1 m4 g& d4 v& A* F
- // int price=rs.getInt("price");
6 N8 R( {8 Y' e" ` - // //生产厂商. Y) B* i0 L! U( Q4 J- H" ]
- // String producer=rs.getString("producer");7 m; M, i3 x8 s, I% y
- // //添加到构造函数$ h0 L1 D% m) h; j5 R/ m
- // Materials materials=new Materials(id, name, spec, number, price, producer);
; z2 z6 G1 a( t7 u$ s2 |# T) w - // //添加到list 集合' K7 r+ i/ p; ~# _" h, V3 x
- materials.setId(rs.getInt("id"));. f5 m- [" N+ \# X
- materials.setName(rs.getString("name"));
8 @" f7 z! e1 |; O) g - materials.setPrice(rs.getInt("price"));8 _, J" H; Q+ `# S$ J/ p
- materials.setNumber(rs.getInt("number"));
% M( O: m6 [8 e. F: j7 `& _& I' p - materials.setSpec(rs.getString("spec"));
{: K6 w9 B- a r! q - list.add(materials);8 _' X3 B1 B1 t, r
- }
2 f7 p- A9 y; C5 I) B" m3 N - } catch (SQLException e) {4 x% R4 w4 Z6 ?
- System.out.println("materialsAll 方法出现异常");1 ^# w/ H4 E3 W7 |
- e.printStackTrace();
7 J' R8 v- g3 g( M2 g - }
/ C" A% ~+ r/ Z* e -
" k. `) }$ r/ }3 d! T - return list;
e5 h. g' q" J6 A - }
) B2 H( W5 X7 c9 [* M( {; ~& R) b - , A$ q8 ?) p; V
- /**% S- N8 g6 U1 |& X! G
- * 根据id 查找物资信息; k/ G3 v8 ]- S+ n, P% V1 E7 {, N
- */- K. M, |/ k0 I; g7 g/ p& H
- public Materials materialsID(int id) {
, x1 J- K- ^& H - //声明物资类
4 w/ V; n9 G& `, S% T - Materials materials=null;. M+ X' @% L3 T
- Connection con=null;
8 R* u: _3 m) y- Y - PreparedStatement past=null;
+ n( l; q" L/ x6 J, O' v! Q# G7 x - ResultSet rs=null; K8 T/ K! z( l
- //sql 语句
+ S& F# {8 a o' e9 G8 T - String sql="select * from materials where id="+id;
4 w/ ?4 z- j5 R0 b" D+ o - //数据库 连接
3 ]; m, m2 j% T g - con=MaterialsBase.GetConnection();
) r/ y, j* N! Y3 h3 G3 W1 j - try {: e* Q: H( i# c8 I' p& C9 g
- //传入sql4 d4 J+ X: j6 c
- past=con.prepareStatement(sql);5 m! @. v0 B* [5 U
- //执行方法/% I7 j: q; A8 A3 ^! K) r; `4 ~
- rs=past.executeQuery();" b& e9 L( m5 ~
- materials=new Materials();" ?' T8 O0 A! R$ p; n# Q
- //读取数据
1 i0 h& j+ W8 _+ [+ B - if (rs.next()) {
: Z% P7 ~" g2 \0 ~& { - //名称
, a- b" e" q( J. J1 f. q- o; m - materials.setName(rs.getString("name"));
+ b! k# W; y/ B, a - //规格" A$ G5 u; Q7 R& @: o7 m2 r
- materials.setSpec(rs.getString("spec"));* @# E8 I% |' l, r' h. Y1 D
- //数量2 A+ ?+ r2 ~+ Q u
- materials.setNumber(rs.getInt("number"));5 w: l8 j; h' }5 L* n4 o
- //单价
5 q2 ^) K3 {8 Q* ?1 ] - materials.setPrice(rs.getInt("price"));, j' }/ _2 ?+ q6 N7 \4 z
- //生产厂商
& Y2 s( I% O0 s8 x- [' }* b - materials.setProducer(rs.getString("producer"));# S1 f* |! L! G T7 ]0 T: k* e
- }
- b# y: j. \4 J8 P0 u1 y ^" r - } catch (SQLException e) {
+ k& z0 ?4 k3 B/ _# G' ? - System.out.println("materialsID 方法异常");
^5 X Z3 p% ^- e" a - e.printStackTrace();
1 I4 v+ d! B. ?! ]# O - }finally
* k# A% }8 } @+ [1 K6 a - {
7 e4 ]" P" | Q. \1 p2 S - MaterialsBase.CloseAll(con, past, rs);
3 i! }# I! v, W - }1 l0 A; ]% {, u
- return materials;
: s# T7 i: r! g: z/ i6 O( Y) n - }% R% }3 |: U3 g3 w, B! K$ b
- /**
) p- c. s$ U' R g* s% n6 Y - * 更新物资信息
+ w6 Z; d+ a7 G+ N: b - */
$ ?5 |) U$ F# r - public int materialsUpdate(Materials materid) {; I, t( j( y/ k( ^7 w0 Y" e
- //sql 语句
* L1 B: D( V0 g1 G& |/ E - String sql="update materials set number=?,price=? where id=?";3 b* m9 J3 U. W3 H) ^. d7 [% L
- //6 k/ a1 A& B& L; Y( z
- String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};9 @2 {( J' P8 Y; u& [( i
- return MaterialsBase.ExecutUpdate(sql, getValues);
( e" T% {' S4 e. d4 _ - }( g2 d9 O9 k% }/ _" w" c" }* {
/ d! m1 U) h4 e. s- }
# c# E8 {& P+ W" X1 Z. k! E
复制代码 . S/ o' B6 k' B0 n2 W v
代码案例下载:点击下载% l9 L# A2 H. r" x: E& z, B+ Z1 M6 U
# \; ?5 |; s3 s- g |
|