该用户从未签到
|
- package s2.jsp.zhangxiao.entity;
& Z: r) _ r) N; i% g6 } - /**
7 |+ S+ {9 K+ B - * 物资实体类1 a5 Q; H% N% N
- * @author Administrator
- o/ \% |' p+ q s; H - *+ C! Z9 z- w" C; Y) M
- */8 E( @# ~+ ^8 \3 X
- public class Materials {( z. V0 Y0 N* }" R' p4 L
- // id, name, spec, number, price, producer
. c4 O9 H# I1 y3 c6 d - private int id;
8 a1 v$ {+ g6 P3 c2 U - private String name;
! }; v, n9 C0 i" ^2 k5 [, i- N2 } - private String spec;# P) F1 g- ?8 i: R( p/ D T
- private int number;% k( t$ v1 {5 {( f
- private int price;
; a( S& o4 d; k- h/ L( D - private String producer;
/ Z4 w; C& ^' x: b7 k - /**+ ~; ~! `: n% }; Z
- * 有参构造函数. u1 @! |: k+ ?3 `
- * @param id, O) m# D' @: \# v2 M/ L9 K9 u
- * @param name
0 D8 C& g, ? I9 k2 |8 x - * @param spec% j. p- A! R: ]" l4 o k
- * @param number
$ U3 L8 n, K9 ^. k& @5 R1 e - * @param price
3 x. u5 G5 B- L X - * @param producer
+ u3 `: s2 I; H; ]$ b# a - */
6 \+ D) M1 f. d - public Materials(int id, String name,String spec ,int number,int price, 1 } a0 j" g9 K- X% ~8 _
- String producer ) {2 R4 q- }% o3 b$ |3 L# b$ `
- super();& O8 p8 p: [ Q. M2 L
- this.id = id;3 v! }7 x6 X& G
- this.name = name;! @, {, K# g1 Y2 ~6 L6 }3 |
- this.number = number;, z" N) W# N- R8 _1 R
- this.price = price;3 {0 O* c Z' B' F7 a$ v
- this.producer = producer;
) U" b* M9 S5 Q - this.spec = spec;) A! d) f6 E s; a7 z8 D J1 n, V
- }
$ J5 H/ `9 X4 `* T! P0 H - /**
; v) p' }7 W( A- Z. K1 K+ f - * 无参构造函数
3 g# k3 E$ u3 W% D. A- H - */: z- \; k1 n& o2 X8 m% }
- public Materials() {. A$ ~8 b# ?- L/ e @1 W) N
- super();
7 X Y% n8 [8 {4 O% }5 Y. Q - }
' d7 q/ q | h+ u7 ?# V2 J( q - /**0 {3 K1 C1 U$ t8 T) t/ j- w
- * 编号) s; q# E! y2 f. |0 B5 w& r
- * @return8 j4 e$ [6 C: k0 W
- */
. `' L. @3 Q1 x _8 \/ J9 u - public int getId() {
" S# ]+ ^3 K# g2 R/ e9 b Q1 Q( e - return id;
( X3 S P) v' x! I6 Q - }; _ @7 I2 ]6 h$ Q& x7 C' ?
- /**
8 f o6 ?/ l% }2 o) Y5 J - * 编号
8 k; X- N0 i9 b5 J4 T- a! h$ r7 S - * @return/ {1 `. |! ~1 c/ p, R0 b
- */5 d- \" k2 i, g, Z; m
- public void setId(int id) {
& o: K" b) l* a- k1 h. U, | ] - this.id = id;+ b: F1 [1 }9 j6 N7 m
- }
* m. A& d+ [5 A5 x$ Q - /**3 A1 w1 Z- `4 U( F7 x' u
- * 物资名称
* {/ {! z4 _( S+ @ - * @return
' W1 R' J1 ?- a; k* M. E& b - */& u) `7 ] X+ E$ V4 i. n* b; W8 H
- public String getName() {
~! e7 l8 B. q5 R6 A - return name;
6 m- _# i$ s4 F' V$ q7 F9 Z - }
5 q I8 z: D" g# y - /**
, K+ ~7 G% X2 V - * 物资名称
" t, l/ S% q' Y! D. ^- C' l5 q - * @return
* `4 K' P5 m0 z Y# V0 v - */
! p( }* \! Y' z - public void setName(String name) {
$ e# Y- m( `. H - this.name = name;; S( K' ^& p; Y0 c N
- }
4 s: R! |( j( h8 a$ b9 K - /**
" O3 s; ^. k% K' r3 p, b E - * 物资规格# ^! I l( e- Z) r$ B! f/ v/ ~
- * @return7 ?. O, p1 T& d: A, k
- */' {3 e1 A& X! L: U% [! h" W
- public String getSpec() {
. a0 B. Q, \+ L% _) I* c+ f - return spec;: Z( K% a# x0 ?* F. z+ x
- }
8 B3 J" q$ J% v, u - /**2 S- }& ~+ A7 C
- * 物资规格
, o y3 l y- D% b1 K9 W( H - * @return
; l$ y- D4 b* T+ m - */
' I& J1 d6 R; q; T - public void setSpec(String spec) {
+ s! @7 E" }# ^4 z* C ` - this.spec = spec;# J' _$ k- q9 M: Q
- }
/ r: ]8 I& M* A9 D! M9 k - /**
; d* w) C" j, c; f - * 物资数量# Y9 z5 r( r+ K7 }' [+ c$ K) i% `- H: i
- * @return+ W! ?6 N2 F1 d6 C5 w
- */$ O V4 R4 `$ U: i3 V
- public int getNumber() {
4 B- d* q$ n& Y/ B4 D* \# y - return number;
3 r+ ?5 ]. O6 _) Y - }
, D/ Y0 @; M' C- r4 b% v0 | - /**
1 o/ J+ N/ h7 b3 Q7 _6 t - * 物资数量9 P) P( C! Q& @5 b8 I- L( m# ~, N" _
- * @return
( x; K4 k, t9 s8 C - */: ], M+ r8 Y7 V# U+ |
- public void setNumber(int number) {
$ b% `) e8 w) R* T - this.number = number;$ z' p$ r4 m0 U
- }
: q- h3 A2 \( D8 E) o' J* ?4 n+ y: z - /**8 Y# i. ]6 t2 O' E+ p% d5 R
- * 物资单价
" m6 g! Z' n% H0 D6 X - * @return
+ a1 W! R6 |$ r6 {9 l' V - */# i' x) Z+ S0 U
- public int getPrice() {0 z+ G/ r: d5 y5 v( ?# k8 @
- return price;" p3 m( L- [5 ]3 j- C: R
- }
' E% z" U! u. M" \6 M& Q - /**% N: `+ E7 D8 V
- * 物资单价
- ~7 F9 |$ t% S: t R9 n - * @return/ v. g9 w; u ~8 R7 y. A* Y# z
- */* x# J) K h0 g/ B
- public void setPrice(int price) {0 @$ v+ T! E( s. [
- this.price = price;* v. K: q" n) q! o
- }
4 A" i# R+ n$ y2 t - /**
( C1 N b0 b v& N6 c: x - * 生产厂商
" o8 a& B9 {: s - * @return6 a6 L8 ?: y& |2 L8 a
- */# b4 H: M( }6 d; ?9 X! T
- public String getProducer() {) v/ c, K! B$ ~6 i
- return producer;. e9 P+ s# `3 J
- }1 r0 A& U* E1 C" h6 G( o" H' l* U
- /**7 d, _) |/ g8 j- \
- * 生产厂商5 `1 F0 h0 `9 T0 w+ z* r. }' Y1 v
- * @return
4 i' \& o3 e: M9 O0 l, {7 A3 d! P - */2 n% i) L# e% Q8 [$ x, o9 d6 [
- public void setProducer(String producer) {% Q& e/ B0 H+ v$ c, l# V7 v [
- this.producer = producer;+ ^- _- F b: d5 Y( [
- }% P0 _. B E: ?8 e: Z# ?
-
" K4 [, B3 U" T2 q2 k t2 v - }' C) s3 E8 B! a
复制代码- package s2.jsp.zhangxiao.daoImpl;" j( ?% u& X2 c. {
- import java.sql.PreparedStatement;- L7 T) O! X: `
- import java.sql.ResultSet;
: t1 ~/ E; V, `3 ]; b% M, o1 |- M$ x - import java.sql.Connection;
0 s$ U- L) r, m+ L r7 Y, G - import java.sql.SQLException;
1 f+ k9 c! v% w5 q- u. k/ ]/ O: J - import java.util.ArrayList;; F' o% [/ R* D7 U* }' z, g5 j
- import java.util.List;
5 e @, f8 J8 X x. K
3 \" l) l7 z% A; C- v$ C4 h- import s2.jsp.zhangxiao.dao.MaterialsBase;# b7 m$ |/ r. O# t) h' l
- import s2.jsp.zhangxiao.dao.MaterialsDao;8 J7 |4 N+ h9 [: q
- import s2.jsp.zhangxiao.entity.Materials;
4 ~; M, K h! T, W# f: e; C" @: h! V - /**
/ e, f+ Z* }8 n& v& a - * 实现接口的方法+ r7 p8 G& J7 q
- * @author Administrator
, w) z1 R" p% j! _4 ] - *
2 T' m* ~5 N' Y - */; n6 P" ?& P* \) _8 w9 p
- public class MaterDaoImpl implements MaterialsDao {& K8 h( ~/ T) S$ T& i2 ^6 W
- /**, v& Y- F5 _* h5 y7 U- |
- * 查询全部0 q7 `. @( v1 n8 }, t' k
- */# y& |, V h. K
- public List materialsAll() {, h$ O3 u% s% W* y
- List list=new ArrayList();
; o; ?% k! I1 s, B; N! ? - Connection con=null;
+ l3 [6 f6 O# r7 M3 b - PreparedStatement past=null;# ?9 I: G% X2 z, O4 O
- ResultSet rs=null;' O; c& r/ ~3 u
- //sql 语句
3 n9 t! K* {8 i' R - String sql="select * from materials";
( R' i k* ~; ]+ M) ~2 _ - //连接数据库
4 f9 k) f2 G T. ~: z - con=MaterialsBase.GetConnection();) l& Q B: B+ B7 v7 A
- Materials materials=new Materials();
/ P6 K1 d6 p/ t* V. V! J+ q" f - try {
! t$ ?% j5 s: v# h% l - //传入sql
) [* D8 v# ^, Y S - past=con.prepareStatement(sql);
, w u0 K( ~8 B8 {6 p! G - //执行方法
. C3 o) o6 Z: m6 P7 M2 G - rs=past.executeQuery();( a# S3 F8 r3 w
- //循环读取数据
, w! _/ ]+ A# g f6 G - while(rs.next()){8 V# ]7 N. s$ b- O7 g# C! ~
- // id, name, spec, number, price, producer
7 z. A1 w9 t' j0 l% M1 }9 r - //编号
$ K* {. B" q5 ^0 V1 v - // int id=rs.getInt("id");
$ V1 n. ^7 t- }& n8 l2 U/ ]) `/ ^6 O - // //名称. m7 j! M; V( Z
- // String name=rs.getString("name");, K. C( |% Y5 ~2 i
- // //规格
4 n0 U$ x1 _$ ~! Q; e - // String spec=rs.getString("spec");
0 x' W' B% s H" D" {* Q6 Y ? - // //数量& H) v T. }8 Z& [. n
- // int number=rs.getInt("number");
8 h8 r8 C5 O1 v- u: d' |, G - // //单价* k9 \* R: R8 j$ r0 u* C
- // int price=rs.getInt("price");, l. F8 T4 n3 G$ q
- // //生产厂商/ ]& _( `$ g# t2 l8 a+ h
- // String producer=rs.getString("producer");
" I( }9 {2 J4 n+ v+ ~8 y1 t - // //添加到构造函数* d! }+ r) S" B2 Q, p2 `0 Y
- // Materials materials=new Materials(id, name, spec, number, price, producer);: ^! F! O* a( m S/ Y' T
- // //添加到list 集合0 i t' ~8 d2 {
- materials.setId(rs.getInt("id"));3 ?: ]) V. P3 I$ q. B, e" u
- materials.setName(rs.getString("name"));
4 T$ a( K7 l7 @* k - materials.setPrice(rs.getInt("price"));
" ^( S3 s, ?. C+ o# }0 ]; b - materials.setNumber(rs.getInt("number"));
1 C) s, ^* \0 | d9 d. ]8 u - materials.setSpec(rs.getString("spec"));3 A$ ?' q5 Z$ k! J, s9 [
- list.add(materials);4 {: ~" x4 x: G4 N1 l& o2 R
- }
: G. J% J& Y2 \, q - } catch (SQLException e) {/ ]& }- S3 z2 l: \
- System.out.println("materialsAll 方法出现异常");2 n1 x+ \7 m& f2 o8 h6 @
- e.printStackTrace();
+ F, i6 v: Y i# Z' C# r4 f) [3 p - }/ a7 r' d! [. _5 ^4 l' l
-
+ T: u( Q. A- T+ S* `- @/ X - return list;
g' R# M+ p V% k) `7 s* M - }5 k" \# w/ A9 J2 R5 U! _9 e
-
# e: F6 F% c4 L! P - /**
. t; g. y% U$ u1 s" ` - * 根据id 查找物资信息
7 m# O& r+ k7 l7 }8 o- ^- L1 S s6 e - */! o; e; u9 ^/ F
- public Materials materialsID(int id) {) A% ?+ j: T' |8 B! }! I
- //声明物资类
w# l5 L. w @; O) o - Materials materials=null;6 U8 J9 X/ T* H1 e
- Connection con=null;
4 H% g1 }; f9 z+ H - PreparedStatement past=null;
4 \0 h/ L. U5 _1 S. @0 U* B - ResultSet rs=null;
6 D" o6 ?+ _5 c - //sql 语句% F7 e5 K3 J2 k+ A5 j
- String sql="select * from materials where id="+id;
# M% K/ ^2 B* n; t! \2 _" e - //数据库 连接
# e( R* M% }9 x6 s0 i n - con=MaterialsBase.GetConnection();6 C& G, m$ a4 d5 c5 g
- try {
8 N0 {: Z& U8 j& E - //传入sql9 T3 @/ m$ O+ d. Z! W/ M
- past=con.prepareStatement(sql);
5 E. B9 W, n+ V' t - //执行方法/
+ b8 u6 M% C5 Z$ ?3 l - rs=past.executeQuery();
w- P; V3 q8 v7 z. k5 [( Z( j - materials=new Materials();
. X+ T4 j8 x% J3 C - //读取数据: p2 z. } Z! A- C7 ]6 x; l
- if (rs.next()) {
! x" t" \% i$ ^6 i: l) e5 a, L- q* B - //名称
* u$ t3 o0 y* q8 S* E1 O - materials.setName(rs.getString("name"));& O+ k- b& g& j
- //规格
7 j+ C1 \& G! s# s0 s1 [ - materials.setSpec(rs.getString("spec"));1 ?( f4 z* m u# Z0 I
- //数量
' k( j( _+ x' l; ]$ ^, p - materials.setNumber(rs.getInt("number"));5 E1 o5 @% k% d. c4 Y& a9 r F
- //单价
. e% x6 C2 @! ~1 ~ - materials.setPrice(rs.getInt("price"));
- E6 C7 e; r" Y4 c, A% N- ^ - //生产厂商" ^" G' `! b, T
- materials.setProducer(rs.getString("producer"));% E- {' F$ N8 x9 ?0 U
- }/ r5 \" A% ^6 U8 t
- } catch (SQLException e) {/ N6 w5 S6 g8 }1 H3 l
- System.out.println("materialsID 方法异常");; t8 m- H E; ?: _* H
- e.printStackTrace();
: m7 u: J1 @, {* T$ T* M6 t - }finally! I) F* B* r+ D( m5 \
- {
3 H" f+ n& n/ V& g, ^5 r* \ - MaterialsBase.CloseAll(con, past, rs);0 L. A( g1 d- h
- }
! F; ^6 I: \2 {, i! m+ N - return materials;8 x4 w$ ]' ^: b
- }
- Y, S$ b, k3 r$ z9 ]/ l* o - /**/ r0 g- p( j6 D- m- S: X. M/ o& b
- * 更新物资信息. z; x9 U: L5 w* d' X; M
- */9 ]6 x# l; n* J0 t q
- public int materialsUpdate(Materials materid) {' s3 T+ q4 K8 C- ~3 a6 t( p
- //sql 语句
Q( l: U0 a. I! H7 ~4 v( s/ @1 T - String sql="update materials set number=?,price=? where id=?";# A* z+ Z c( n8 }% k) V- C
- //$ Z/ R' O5 I- X
- String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};
2 Z+ C8 K9 f4 D' l - return MaterialsBase.ExecutUpdate(sql, getValues);
6 K6 ~' c8 ^7 a* i5 {0 t - }
! J" ]. H) H. U8 i - 1 C0 }1 J( k2 n F+ _. `( a
- }0 z; I9 m* c. ?
复制代码 ! C8 u, \2 n, Y1 S
代码案例下载:点击下载+ z- t! Q' j1 h9 k5 Q
/ O T7 w% i7 M# A |
|