该用户从未签到
|
- package s2.jsp.zhangxiao.entity;
/ V3 D# P: T* ?# P# ^- O5 N; r/ X - /**: g& o3 ^' |: d4 N/ e
- * 物资实体类
0 Z4 ^% `' Y$ \3 [( X4 p& t - * @author Administrator8 |- V a# G7 `; h
- *
`7 v8 P/ v/ V4 _. P - */3 ?$ o: u$ z' m. k
- public class Materials {
: T: M- @2 Y+ S, d+ [2 E3 ~ - // id, name, spec, number, price, producer% O0 ~3 z' y, H2 j H
- private int id;
9 }4 C/ `' ^1 ~3 Q7 \! a - private String name;
C) _% Y7 n3 P/ U! } - private String spec;
: ~6 v7 u2 n) g- X - private int number;
1 L! ]# `5 Y% ^! M - private int price;
+ Q0 m% U) X8 q1 C( g0 A" B% b4 T - private String producer;$ G# i: u {) d7 D; u" C# U& Y& F
- /**5 A7 _; f, A& o; C8 f z1 r
- * 有参构造函数
) |9 _; m+ t' @5 m5 E* t. v E - * @param id! I2 }3 l- b* o) C0 Q9 g
- * @param name
7 J* H" ~7 G+ a$ b K( I# M/ } - * @param spec) s- j) o0 B5 ~4 U0 W, [/ f" j
- * @param number
4 ~7 l/ R- v+ M; A - * @param price# h9 K+ Z' v% l7 L: C
- * @param producer/ `! W2 t& g; Z. b M5 ^9 _- r" x
- */
+ Y* P) D& G* p% E3 Z- P4 d% C - public Materials(int id, String name,String spec ,int number,int price, 7 |$ h9 l1 {$ w- F0 b5 A) J" C) ~
- String producer ) {5 Q& F+ {# n8 U# K/ w j$ g1 k
- super();* I4 @2 z' h, t9 i/ L) V2 {
- this.id = id;) z) l9 y1 L& U
- this.name = name;
8 ]& y' I/ ]* R - this.number = number;% [$ T8 |! o/ e2 y
- this.price = price;
* L* `% }* I2 {4 {' Q, X - this.producer = producer;
7 C* n# ]* n; j4 R" k, N; k - this.spec = spec;( ?% z% S: P. l" r2 \( l* c# J
- }5 L, o' s; H( d: G8 Q
- /*** d( W0 `4 Y: V
- * 无参构造函数0 W/ P5 j# C0 w1 b" {4 @
- */
: c1 o, | w( J/ Y/ p7 R/ ^6 C - public Materials() {" T; {% k! z: n2 K3 R+ F
- super();
, v- b( m# a5 i) n' i: Z - }
, ?' `- }8 _. \: i - /**$ N/ ^ T; w; j6 u# I+ Y1 B+ s
- * 编号
# R8 f. l2 I# T; L - * @return
3 Z! J/ C5 C, i' Y - */
7 e( D/ q5 T3 N0 g7 |7 T - public int getId() {
4 t; D: ` H4 C6 H - return id;
3 F2 U' a' p- ]/ G3 Q- `) C/ ]- p$ Q - }
% s6 v+ m$ n( N* @ - /**& B' |1 _7 A9 G: u* b4 N
- * 编号
* L( L0 m0 l. i+ b$ i' Q- t - * @return3 ?. u7 I/ x) ]5 K
- */ e/ P& ^1 a' D3 j6 e- o! \: R: O% \% a
- public void setId(int id) {6 x/ e, ^ u) I5 d5 f+ {$ w- B# a5 G
- this.id = id;9 D4 o# Q8 K2 ~7 Q9 K
- }$ E3 U: Y8 h5 b" Y. G
- /**
4 F M9 W( ^6 Y7 G1 O - * 物资名称) J/ H9 v: O/ e2 j7 F
- * @return8 E. u' F K& g7 o0 D* A
- */" b) B- ?$ H7 W1 v- Q& e" O' `
- public String getName() {) x: f* I0 f/ c3 i# n+ n0 x+ e A! ?
- return name;) o- `5 N. K# a5 w* a; k: e
- }- S' \( J3 z& V3 k9 n" Z
- /**1 E, H" T# k; [- Y
- * 物资名称
+ Q% [* R9 @! G5 Z7 g - * @return) [! | j; w: ]3 r+ E! Q8 N& y: }
- */, A% ]) W$ H; T3 b1 j8 j L
- public void setName(String name) {
( R: M2 l: t: k - this.name = name;; s% |6 _1 w5 G" k0 G- Y3 @
- }, J2 l! W& O0 m: R- {
- /**
* u: ^ ~; h+ ] - * 物资规格
% G+ U. N! h1 @, U - * @return( j. |& O$ ^4 ^' i/ Y# _, N7 e+ G
- */
5 e$ f6 G0 p+ }- ?$ t - public String getSpec() {9 B% p; } ]+ M
- return spec;
5 _/ u. _1 Z5 Z: S7 @; L% C& A6 H - }
& R7 h0 X6 ]1 n# t$ B$ } - /**; B0 f1 g! c$ d) U
- * 物资规格
: {9 @4 b: [! b - * @return
4 Z" \* g. T3 l - */
' L9 Z* G+ B q1 f& V/ {. j' [' _7 ^ - public void setSpec(String spec) {
# u$ X* |2 u/ a/ s' @ - this.spec = spec;
3 @& N2 x x9 r1 c! \6 l# h3 s - }2 z7 F$ f# @1 h
- /**: |0 {7 E9 e7 X3 C! G+ l, f
- * 物资数量! z: z# J5 c- l, [
- * @return
. c: ~2 h: e" k4 A* o - *// T, q8 o3 l* s' O6 [
- public int getNumber() {* e7 X0 P8 p+ p6 b) Q- _' `& v. o
- return number;& }9 G) U1 I" h" [7 i! n* H
- }% K) g1 c! s- v9 \ q
- /**$ m# }% F% o2 R7 k& ~
- * 物资数量
. [) J% @/ g( I+ L% n - * @return
B# ~( p6 i& E5 e - */
% J* x' X8 b# v) V5 W- f: R0 m - public void setNumber(int number) {
5 N, J- s; V/ U( b9 m! D - this.number = number;& U4 N) k" k6 F, U5 C/ x) Z% E
- }
0 Z+ r! Y6 A! c - /**, v: U8 q3 l4 x3 W2 ^8 [0 i& y2 c+ t
- * 物资单价
3 b4 r' s% g! z& m6 H4 h1 O9 l - * @return, v; R' j; ^% ^2 a
- */& O7 F4 G- X! T! d7 _ z7 `
- public int getPrice() {
4 @8 b- K. n# g" P, j6 L a - return price;% O9 a- a- U! Q7 g/ g) t
- }8 e" D; K9 W* ^7 v. @2 e; e8 m
- /**
: U h. Q8 b8 r - * 物资单价8 o0 _5 x8 }; _0 o1 t
- * @return: U" s4 c+ E9 ]) Q5 _" V; {5 |( n u
- */
& I3 X& X. h+ x6 F# e - public void setPrice(int price) {% \' ?: F$ k: }
- this.price = price;
7 k! L0 a, Z; F5 n - }4 s+ Q! ~6 ]- z ^! A
- /**5 O. K/ t* Q) J) R) f! E
- * 生产厂商
) Y V9 Y* x9 P3 h( u - * @return5 |1 u$ [ I4 ?2 L
- */
- B+ ~% c) A+ ^+ }; }' u - public String getProducer() {( I' \* M" L. [5 T! k, M
- return producer;
& Z3 P1 F$ p& N l0 }8 Z. U+ T - }
* i# C" i# R( U - /**& l1 N$ {; s# F/ g
- * 生产厂商/ _$ ?; f' j) j6 h3 |2 D4 ~ z
- * @return
1 n, M, B. Q- c2 p9 K& m - */
# @6 K7 s$ r8 N* I% K2 Z1 \ - public void setProducer(String producer) {
# H+ \- j Z' a3 ^1 U8 c; h - this.producer = producer;
6 s8 Z+ u6 G( U$ z# h - }9 |2 j' r) N' n
- . G* w1 h( t( q& ~( a( V6 r& N
- }0 ~4 }. a; T2 _8 G( k
复制代码- package s2.jsp.zhangxiao.daoImpl;7 y! G6 u4 f+ P9 L
- import java.sql.PreparedStatement;
" y. {% w, y, C# K$ x - import java.sql.ResultSet;
' C# D5 w: V4 {: j1 [ - import java.sql.Connection;( Y! P7 }3 {2 d! i' {" Q4 ^
- import java.sql.SQLException;
9 i+ L. {3 x; a9 j2 e- @6 l - import java.util.ArrayList;
: l' Y; g" @. i! } - import java.util.List;# n. k5 ^3 z0 H6 o; T
- 8 m0 B- `/ W. S) d: b s/ h
- import s2.jsp.zhangxiao.dao.MaterialsBase;) ]1 r: J( J! i4 q7 ^* k" Y
- import s2.jsp.zhangxiao.dao.MaterialsDao;" W$ Y. M" i3 m
- import s2.jsp.zhangxiao.entity.Materials;9 G1 M4 P* e5 d# C. ^+ T6 f/ }3 \/ \
- /**) a- J! U; V+ R. R7 @' \4 {0 p
- * 实现接口的方法
1 Q3 P Q. T& V - * @author Administrator8 R! r6 T8 E8 |( h, k& R
- *' N3 v# j3 E$ f: [6 l6 r% N/ N" y
- */
, V/ @7 z, N5 H" e; ~$ Y' J+ u; c: _. P3 S - public class MaterDaoImpl implements MaterialsDao {. V6 L$ {& w% a& h; U7 A# u& n" E1 y
- /**
; [+ @- m! I4 p* o; f X% J. i; s - * 查询全部
2 @& {7 L) n% u" |; C9 T - */4 W6 x; x" ^: P+ n* \
- public List materialsAll() {
0 F& y" {3 x5 d2 `7 P% N+ w - List list=new ArrayList();% ]7 ]4 O' Z2 z/ \% f: U/ ^6 `5 i
- Connection con=null;
( S: P# K/ J* ~* R$ I% V - PreparedStatement past=null;: {/ o& U/ i, M' q- ] u" S
- ResultSet rs=null;' G# O8 C0 c/ N. K9 D0 |, w
- //sql 语句
7 a* t0 f' G4 I2 `- `* |1 K - String sql="select * from materials";3 e7 N! J3 v2 Z3 k4 q
- //连接数据库
/ l: F/ {) K3 I- i# I G6 o- e - con=MaterialsBase.GetConnection();
7 S- ]! |. C5 h* q8 D6 h, N - Materials materials=new Materials();
' c; D T6 |8 [ - try {
+ E7 T$ u1 Y! U( [4 i+ x! O; [. n - //传入sql
' q0 Y3 [) _4 l7 b$ F# S - past=con.prepareStatement(sql);
- L' Q8 r* f# F) H& @2 I - //执行方法- U5 V5 N9 d* n' X1 h1 o; M
- rs=past.executeQuery();
8 T: k8 B% X# V \- R4 o - //循环读取数据
! C" h4 T. S0 c - while(rs.next()){$ c# |, y; b6 f
- // id, name, spec, number, price, producer
# b* R1 ^$ `8 L - //编号4 a$ {! l. F+ H1 A# t8 l/ ]; ^2 ~
- // int id=rs.getInt("id");* ~, ?, i" ?" s) g6 r- V, m# L
- // //名称! G3 O' A" B+ z4 t/ B* Z
- // String name=rs.getString("name");
9 [$ f7 J% l8 O" w) W5 ^ - // //规格
g0 C* x/ V3 A3 s8 b* f - // String spec=rs.getString("spec");$ U3 Q" h! |/ r+ y' ]# @5 V
- // //数量4 U1 s- z& I2 f* X$ r
- // int number=rs.getInt("number");8 e: c/ R# g) r
- // //单价
9 X; j( w0 A4 h$ I - // int price=rs.getInt("price");
% M: Q% D& r2 x - // //生产厂商3 ~" v- g$ [5 V( S, c0 r* G
- // String producer=rs.getString("producer");# Q6 E1 F9 \/ g
- // //添加到构造函数
) Y9 f b; w; V4 j7 G - // Materials materials=new Materials(id, name, spec, number, price, producer);7 G% S& G: i- X* l9 }7 v
- // //添加到list 集合
) g8 R: n" l$ I2 W0 V& U - materials.setId(rs.getInt("id"));
3 z' L1 H; n6 B* J: {- v. ` - materials.setName(rs.getString("name"));; n* D1 _. j& ]$ _, b+ k0 i
- materials.setPrice(rs.getInt("price")); P8 L$ U# e6 G, O, Q, H
- materials.setNumber(rs.getInt("number"));4 N2 Y1 v8 T4 p8 R: G: K
- materials.setSpec(rs.getString("spec"));
$ p/ J }$ f4 o0 S - list.add(materials);( q/ y4 X- t' ?/ p% d: V" t
- } * A5 L# G# c: _* Q3 Y
- } catch (SQLException e) {
5 m% ~9 j( y; ~7 r9 g - System.out.println("materialsAll 方法出现异常");+ [% l& F0 ^& n- p
- e.printStackTrace();: x2 h! T* I: S
- }1 f! o9 U# C6 t
-
b! ?: o4 H' Y3 x* Y6 R/ D& b2 @ - return list;
- }9 N* s# P; B N - }
; F' m2 y. }: E7 P- n7 I -
( o4 u% H* H# n5 \) M( G - /**
8 r; q! ?+ P2 g8 A4 R - * 根据id 查找物资信息# e$ h) G6 s# x3 @3 G" ~( A7 m9 Z* c3 }
- */- B- p- P/ m6 z, s; [$ J
- public Materials materialsID(int id) {
0 J! t" v* m4 |; C5 X/ n4 p - //声明物资类3 O% u9 @" t$ v. L3 L% g1 _7 T
- Materials materials=null;2 }, [) S- m6 B/ M
- Connection con=null;
9 M6 ?9 z/ E% E' ?/ | - PreparedStatement past=null;; S$ y& E; `% o, }3 X1 j! }
- ResultSet rs=null;
5 D9 Z" O5 P T A" q; e# x. u: l - //sql 语句" I" b% ?8 P! e
- String sql="select * from materials where id="+id;! [$ @, x) q& H7 m* ]
- //数据库 连接" Z% R# Z: v" o
- con=MaterialsBase.GetConnection();7 ^* V+ d6 A' A
- try {
1 P0 d j) e" r2 d - //传入sql# j8 F, r) ]9 C0 b7 ~# J9 f3 C
- past=con.prepareStatement(sql);
3 Z. ^) p! X4 r* R8 q( U/ A+ J# F - //执行方法/# r0 k. M2 ^* W3 X& \6 V
- rs=past.executeQuery();5 h2 ^! n0 U9 u) e: U' V* O
- materials=new Materials();
8 @. p. h- ]- d: A' y: R - //读取数据1 ^3 n s/ d2 j2 t8 l& ]2 b/ r
- if (rs.next()) {
; t5 t/ H# U4 S - //名称
; K. @6 h6 M* B6 J6 r% R% q - materials.setName(rs.getString("name"));5 h" o6 Q) d6 f8 b. T2 z
- //规格+ i3 Q% J' j. A% p$ |) {- V
- materials.setSpec(rs.getString("spec"));* J R5 f: l" Z; H8 J
- //数量
. g: t" E9 ~ L8 |- P - materials.setNumber(rs.getInt("number"));
# U" q" e) \0 c - //单价
; t/ j7 m) [7 Z2 |. _& b - materials.setPrice(rs.getInt("price"));
: }2 z* G |6 f& q: z5 y - //生产厂商$ D# _4 ^) n- L7 o5 B5 R4 z
- materials.setProducer(rs.getString("producer"));
8 C4 @4 I& F; [& U% i - }
# |9 D- r/ y) _/ W' d K2 i* j - } catch (SQLException e) {7 J W: S. }: t
- System.out.println("materialsID 方法异常");4 |. R) L1 g+ T: o+ f/ d
- e.printStackTrace();
/ r# x+ w+ S3 p# | - }finally2 X! _( x p' g2 W3 t; a4 f
- {) _+ o I& f6 t2 z5 X# }
- MaterialsBase.CloseAll(con, past, rs);# J) G* G5 M0 G9 t+ v$ C% ?
- }$ Q# b- d+ i6 u. ]& K5 X
- return materials;. g$ w8 Y6 U9 H3 {9 Y
- }# [( w7 q8 H% Z8 V; l0 j9 E& }
- /**
$ m0 I, O) }/ K5 R5 l - * 更新物资信息# A! c1 W3 W$ M/ L* I
- */0 T2 r1 [% o% k) v2 `! G/ {6 h
- public int materialsUpdate(Materials materid) {, I. y3 i- A. U: h; N
- //sql 语句
! E9 z4 ]5 y9 _3 D( n% P - String sql="update materials set number=?,price=? where id=?";
5 X; S( ~# Q0 z; o8 ?0 y2 l8 b - //
0 M2 Q8 h/ }- Q. }( \: Q - String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};$ y8 s3 P" _. a. A& h
- return MaterialsBase.ExecutUpdate(sql, getValues);
1 c W) e0 n2 J% a f% @; L - }
9 e0 _3 W: \& J& O5 i+ i: n
. u; H$ J2 v2 v; v" I/ n- }% x: w5 ?4 H/ _
复制代码
7 y2 I' {% y- N9 `; j& s' e代码案例下载:点击下载
- A/ a- K- v; `( I; R0 }' y$ O, |# O5 C
|
|