该用户从未签到
|
- package s2.jsp.zhangxiao.entity;- G( V+ D+ Z! K+ l2 C& p$ ]
- /**5 L: P2 f1 I' y, X: u
- * 物资实体类1 t& v$ |0 P. T2 J1 g p
- * @author Administrator
3 m# S5 d3 g1 I9 \) _ - *
+ V# N/ y. |: P6 k3 \ - */ Q2 Z! m$ ]. E
- public class Materials {1 ]! V5 U) H! C: x% N) _& I- f
- // id, name, spec, number, price, producer6 o1 C! D% o+ @2 _0 C& s5 @9 l
- private int id;
2 e/ j' q" p6 L9 k: y2 p$ @8 }/ _: V) u - private String name;
/ k8 \& c, Q' D1 K - private String spec;
0 {+ P, O2 {- J5 t' W- K1 M4 t - private int number;4 R6 z9 @+ w' w% S+ T
- private int price;
& y7 G: s3 s: L% c - private String producer;/ s$ \* }* d2 f" s; _) [ j
- /**/ I& O) X$ S! w
- * 有参构造函数
2 {( x3 Q+ ~+ h' K) b& Q! { - * @param id [7 x, z$ H( A! p
- * @param name
) L# L3 A$ B `/ ~ - * @param spec" k) L& S$ b( X) @4 c8 ?' @! r5 Y
- * @param number
?6 K; u# P9 t. `! [! x - * @param price
, L$ R) W1 y( |6 w% z - * @param producer- V4 y% F# t w! I' A9 E
- */, p0 [ ?8 G+ m) T% Z
- public Materials(int id, String name,String spec ,int number,int price, ' `% O1 T8 t% r
- String producer ) {
+ u. `7 u9 G8 k6 d7 \+ _& S5 O1 N - super();
9 R5 w. H% f% C: n7 F9 F - this.id = id;2 q$ k+ v/ R' L, m$ B$ ^1 ]
- this.name = name;
: i8 ~; z; W) [! h - this.number = number;
# Z+ b& I" A+ O8 B2 {5 P - this.price = price;
' h, Z9 T2 l& a# L - this.producer = producer;
5 h9 K! u' V9 q' B- u3 v, X - this.spec = spec;
0 D" G4 D* q& G- [: N/ t5 F l - }- P/ I+ i3 Z$ ?' f7 Y4 z" T* C
- /**
0 A" D" N6 b; h- A3 r/ O - * 无参构造函数- r" M" \. ?! P% T
- */
* X8 s% y( G; X; N - public Materials() {
9 c: s/ ]1 M3 p. D - super();
" S: x l1 z% s" ?) A! T - }4 C% l% V/ W* k7 O* n/ k
- /**
6 g' I& n2 B* a& M* b3 L - * 编号
7 A+ F% J, v- a5 d$ L) s2 ?: u - * @return6 c4 }8 i! y& g, s, p9 n
- */' ~8 r/ Z- K& w( c8 v$ k% G
- public int getId() {
" p9 Y6 ^' O. {# l# V* y - return id;9 y- B. P' X( Y M& d6 s
- }
/ T0 R* F) P8 Z" V - /*** F5 O. w0 ?* S6 Z5 _# c" ?5 E
- * 编号6 n2 M# D m7 t Q' r
- * @return& x6 n6 v8 [' J. ~/ _
- */
$ J7 L; x# c- N2 v) V - public void setId(int id) {4 m3 |& J( f3 D
- this.id = id;
- C+ @9 X0 \. j! i - }6 E' q! A: \. H: ?8 T4 ?
- /**2 C6 q+ S( X0 G3 r, T' k2 p5 u& u% I
- * 物资名称
' D' S. R B) @& X0 r# ?* C - * @return
# Z; e* s1 e4 M" q1 [1 l - */
1 X+ r, l8 F: o1 l" g! J - public String getName() {4 z. i( H6 l( g
- return name;
% }+ t% d, x2 r6 O - }: a1 w4 G. t! s- y0 p
- /**
) s7 I. J* c9 t8 | - * 物资名称6 N& E3 b6 t1 c8 u
- * @return
+ G" F5 ~; x2 Y - */
" M9 Y G1 _* ]* Y - public void setName(String name) {. p0 V' _/ T0 I) o0 j
- this.name = name;6 ]' u3 ]9 @8 T# o9 P
- }
2 o: h$ C8 r+ J8 ?! ^ - /**% \: n3 ~) K2 S1 T; a- w, E
- * 物资规格+ Y, R5 I& Q) F3 E
- * @return
6 p, J- Q. x. N$ a" \# B8 A - */
9 O d& y5 a8 ^% g! J6 P' P) D: Y - public String getSpec() {
9 i' N/ u' G! m; [! X* w, [: W8 x V - return spec;! s) q. q: w) S, Z! G1 l
- }5 \+ F/ ^3 ~7 s. S9 S
- /**
" ]+ `6 P5 O5 Y0 L - * 物资规格
. A) r) S- a/ l3 r0 I) h - * @return
' ~ H- f1 E9 E - */0 o; f* n7 z0 a4 Y3 M6 |* q% W' G
- public void setSpec(String spec) {
) K! X3 a7 P0 G) ^3 h - this.spec = spec;
" K0 e$ W0 y: a! _$ b. ?/ ]/ Q' V - }
# Z. y0 C1 F* Y1 b. d - /**
* ^; q* }! U c$ \4 f' n; U9 n - * 物资数量
: M3 a1 g9 T$ W - * @return
& a1 k6 A/ W. J6 \5 F! D - */
) f( h. P( r7 i8 D) h - public int getNumber() {
8 m7 _ Z. V0 \0 `! L$ T6 v4 N - return number;% F( ^5 m$ Z) r3 f# W
- }
$ t- e& r2 a \4 ?, R7 E - /**2 C; `8 X1 O7 [6 B- v, \/ x
- * 物资数量; r: ^* p$ w0 Q m3 i- H. F' p
- * @return: Q, l3 q. \% D. M
- */. @% X8 I+ q! [9 B0 ~4 f
- public void setNumber(int number) {
: m. S( a# G1 P. ^, D. { - this.number = number;! r0 ]% C% H8 s8 ~- C
- }
# p$ D& r8 C2 ?% n4 ]# M - /**% p, h6 a" g7 e) `8 L
- * 物资单价
7 e6 c; u: a# x7 P' g - * @return C0 H# f1 n! e$ `* Z% ^
- */
9 r+ c8 k$ t* K - public int getPrice() {- p0 @' ^0 R/ l9 M# j
- return price;: @5 b% B N; `. I" C
- }5 f2 Q) f& F+ y
- /**
3 |% f2 R" r9 z u# v - * 物资单价
" P, z8 c: j5 m* V4 X# H - * @return
8 w0 G& k" v$ u$ A* ~% } - */
$ K2 T) P/ y! L6 u, o( I1 g - public void setPrice(int price) {
3 N2 F. t- S5 p, \4 W* M - this.price = price;
7 q% S! p6 J1 O3 S, Y - }7 ^, C, A4 J/ m( [) S7 ^
- /**
: Q3 q2 V" | U% d4 a - * 生产厂商, A/ m5 w1 \$ @/ M; z/ I
- * @return
' }# _& P' G3 H, v. s& L2 i - */
; T/ p/ c$ ~7 o" I# y2 { - public String getProducer() {
8 e& b7 z" z9 W& s- s/ ] h0 @ - return producer;! J3 L9 ]& N) ?
- }
2 h2 Q- O* [; v1 m v0 L$ L0 s - /**
4 @' P. q q- Y" ^8 } - * 生产厂商
% d n: _; U. I; _* E+ E1 A0 { - * @return
6 i- i+ _, ^8 p C9 r - */9 G9 r A0 p% r: U
- public void setProducer(String producer) {+ G4 U9 h. ]- D" o
- this.producer = producer;
2 e* k6 E( s/ g - }
) Y) g( H4 [. a/ b8 m* o# r2 b) t - % |$ p( z+ D: \3 B6 O3 Y, t
- }
, ~6 k; s/ {7 i1 d9 a* G$ M' a
复制代码- package s2.jsp.zhangxiao.daoImpl;4 V( }1 O- P& E
- import java.sql.PreparedStatement;* k/ c5 c0 U" K- {+ _+ j3 R* N
- import java.sql.ResultSet;
" q& I- ^- c# L2 H - import java.sql.Connection;9 H2 k6 ]5 _& T% c+ f' W
- import java.sql.SQLException;
/ P+ P$ H5 e A2 H' n - import java.util.ArrayList;! [) F8 K: M1 M" _8 n
- import java.util.List;
- ?! R3 j! n8 C O
* @, ?/ @, O% H, I& A- import s2.jsp.zhangxiao.dao.MaterialsBase;$ X& _. B9 y8 N b- b0 \
- import s2.jsp.zhangxiao.dao.MaterialsDao;8 J j7 D" d& b, Y
- import s2.jsp.zhangxiao.entity.Materials;
4 [* m9 d; B" n5 Z- p& N - /*** G+ M0 z5 T. h+ o9 a
- * 实现接口的方法- u7 T+ |9 U7 {- [
- * @author Administrator
* z3 m A) S/ G. W! | - *% k; X ~( h2 \2 M0 }$ j; `
- */5 B1 m7 g9 q$ O$ _4 V! z
- public class MaterDaoImpl implements MaterialsDao {
7 U* m/ |2 t5 u# }5 X - /**3 C7 h' |4 d. t- D) h
- * 查询全部
$ s( P1 o2 h. e - */
6 H5 \) w# z, A - public List materialsAll() {
% J! B- M9 Q7 \) i+ j! E - List list=new ArrayList();
$ N. D9 Q! T& B) h - Connection con=null;. y/ @3 U) N3 Q$ c
- PreparedStatement past=null;' c" R. d2 t4 O" ?4 R/ ?9 k1 d8 F# ]
- ResultSet rs=null;
" M" e/ S' H* f ]5 b3 } ^ - //sql 语句. C9 ~- I9 P: F; W! v0 m9 B' ~
- String sql="select * from materials";
$ D& U# Y- Y/ ~. {) V - //连接数据库
7 ^' l# [7 k4 J7 J% l! C - con=MaterialsBase.GetConnection();
& H9 |7 J1 d! R+ [ @ - Materials materials=new Materials();" I9 z/ h/ L$ O: j0 x, C) x! F
- try {5 h& [; T% t& S6 K. F+ M
- //传入sql * q- ?& Y' ]0 |' ]1 p* Z$ ~
- past=con.prepareStatement(sql);$ e0 Z& V1 k/ k( q
- //执行方法
& p5 t* _3 r# J+ v. v7 p( t - rs=past.executeQuery();0 M$ Q# r) }% ^; f, ]; P B) B
- //循环读取数据
) t$ Y7 [4 `" m. e# g2 p# j8 t - while(rs.next()){
m; s- u$ l4 U5 w$ p - // id, name, spec, number, price, producer
2 j* y6 t2 C* i- Y - //编号
, D% g$ b& A6 k8 L- ] - // int id=rs.getInt("id");* n( X* l. Y- d, }2 b! e# f* r8 m
- // //名称+ H! _! ?( y3 j' ?, Q
- // String name=rs.getString("name");* u8 h6 n1 \7 ]' n
- // //规格* @) a0 L6 V4 E$ T) }
- // String spec=rs.getString("spec");
: u; S( D- ^2 o" x1 h Y - // //数量
5 W4 e4 s: M6 a% n: v8 [ - // int number=rs.getInt("number");: V% j; I* f7 k/ U( V' B3 W
- // //单价: r1 l) m9 M7 w3 U2 d, b
- // int price=rs.getInt("price");; e& U7 w5 m) O7 @5 o
- // //生产厂商
8 X& U3 L) o8 `, H4 I9 W' j - // String producer=rs.getString("producer");; u& k0 z' @% r" R
- // //添加到构造函数
1 S- o5 u0 [0 C - // Materials materials=new Materials(id, name, spec, number, price, producer);2 i! Q# u1 \) {+ d( g2 c. C. W
- // //添加到list 集合6 v2 y5 q& B$ m: [
- materials.setId(rs.getInt("id"));
; ?. o& W. u: L% X/ f - materials.setName(rs.getString("name"));
3 c- z( g* q: i' K0 W - materials.setPrice(rs.getInt("price"));
- ]& r( U6 @( e - materials.setNumber(rs.getInt("number"));. x/ C4 X7 p% `, o2 E' O
- materials.setSpec(rs.getString("spec"));, R# P& M( F! W
- list.add(materials);
$ |! [! u+ t( ]$ |# d0 B) a - } # @+ p2 Q" Y: A0 c7 t% _- N+ D
- } catch (SQLException e) {
2 q. J5 r/ X2 y - System.out.println("materialsAll 方法出现异常");) n; G, `5 E9 P- z
- e.printStackTrace();# ]9 y/ d& o t* k& T
- }
5 M! B. p$ g! C4 C# B, v - ) a6 |4 i! X v( e
- return list;6 W. f5 c: _1 a5 T1 Z7 F
- }
& q6 o' ~. b* h -
X b0 G6 B( x: @% C* H- g+ C# G - /**% L1 |$ P% J8 `9 T
- * 根据id 查找物资信息
0 t$ }! T# W- _0 z9 m4 w - */8 T: \8 d3 q4 O( F8 O
- public Materials materialsID(int id) {
6 p h {3 L* {' k+ H$ ^( W - //声明物资类
0 f& z3 _- R' e - Materials materials=null;- E, H5 \, d& I1 p4 ?
- Connection con=null;
' U5 Q; l l6 W8 ~$ e - PreparedStatement past=null;' D) E! P/ r5 o+ B4 T: k' u
- ResultSet rs=null;
& r) E8 f# _0 J - //sql 语句
, D$ H) a( n& x$ O9 e" | - String sql="select * from materials where id="+id;9 |9 r k, H F1 @
- //数据库 连接
2 ]0 U* ?: d0 [. n, ] - con=MaterialsBase.GetConnection();* J& G1 C2 n$ Z
- try {
: j5 I! N1 v% }, u. x. n+ T- O* e - //传入sql
. E4 `5 t% k6 n+ t7 P - past=con.prepareStatement(sql);
% u3 k' ^/ i9 a4 x - //执行方法/3 b7 S2 [' d( x$ x" G9 D
- rs=past.executeQuery();4 j; s$ }$ k% l$ |- v. x7 O( s7 {
- materials=new Materials();1 e: h1 U; c$ E% i, g# G
- //读取数据" O/ e+ Q9 g$ F( q- ]$ q4 Y) B
- if (rs.next()) {
' p# I4 ?& u, _* ]2 z: ~0 ? - //名称
. `" N( F# l+ W" k5 V9 o Y6 ?& a - materials.setName(rs.getString("name"));; x7 U9 A' g7 M/ t" l0 ^
- //规格! Y2 J5 w; N) h, R% D! o
- materials.setSpec(rs.getString("spec"));
8 E8 m5 L1 C' b9 F# `: B - //数量0 r( b9 y4 q. J" ?
- materials.setNumber(rs.getInt("number")); ?6 Q3 q; v: _% Z5 G5 a9 x* c' J
- //单价 v& {1 m' s, K6 R( ]
- materials.setPrice(rs.getInt("price"));
. U1 E# S1 s- p6 K5 A - //生产厂商
. E8 u1 V! D* S5 Q - materials.setProducer(rs.getString("producer"));# t4 X3 z+ F: q& H* r& K) d
- }
+ i* E! ?$ P, Z; f% d% n - } catch (SQLException e) {
) o3 j/ W% K5 B' M0 h - System.out.println("materialsID 方法异常");$ c& }% h8 P# e5 ^
- e.printStackTrace();
& S+ A8 h- W1 ^6 q9 Z - }finally% R. r, n7 m% r1 B+ T9 H& b) x
- {/ d0 U/ y3 n8 l" |7 W3 Q% ]' m3 j7 ~: G
- MaterialsBase.CloseAll(con, past, rs);" {9 [& J7 @8 v$ J: V1 @
- }8 [% Z. H' l: J; ?, N/ m
- return materials;
* z- p5 i' S! x. t* r - }: R) D" w1 }2 j( o7 t
- /**
^7 N1 D: l; @. P* J1 u! U9 q - * 更新物资信息
9 S& L8 i8 @& O: n; h( E$ m - */
1 P1 m; {/ J* t( z - public int materialsUpdate(Materials materid) {
& ]1 j( h7 d2 j$ ?- d3 V( j - //sql 语句
- h, d+ g" n, P) W- I: ~, x. ` - String sql="update materials set number=?,price=? where id=?";
$ C9 f _2 m: a6 w# c - //$ ?7 X, x# g9 s o8 z$ H
- String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};2 N5 s, e9 S2 f, H; b0 Y! V
- return MaterialsBase.ExecutUpdate(sql, getValues);! Q2 E* S" w/ t2 F7 F; W
- }
% R- X8 T; {0 e: W8 L* l
6 f5 k( @5 s1 U4 s8 K* ], z: ]# z- }) L1 T0 {$ N9 H- Y4 S
复制代码 ! L; C$ X+ b. s
代码案例下载:点击下载
: r: ~6 A T9 E7 D( x1 J) o2 V
) j+ Q& [/ R" d) x |
|