该用户从未签到
|
- package s2.jsp.zhangxiao.entity;8 B; ]9 T# c% E2 [2 V8 l7 s
- /**& H I9 z; y2 u
- * 物资实体类5 j+ t0 R: {0 [
- * @author Administrator% w- v! K' E6 b
- *2 T: I' n: C! c
- */
$ k" M H: b6 ? - public class Materials {0 h3 @4 Q# L8 W$ \! y# ~
- // id, name, spec, number, price, producer L6 E! o G- Y! [6 F2 L, R
- private int id;" D. d$ o4 X- _, i
- private String name;
' B7 b6 c! U ] U' t - private String spec;7 T5 I% Q' X. C+ K
- private int number;- m, [- i" g: o7 z1 p9 i' {) m; r
- private int price;" B/ M! C6 e: M+ w
- private String producer;
- v( w! m/ Q0 f3 w0 t - /**
& M9 r1 J6 G+ B1 }7 {( m( _: Z - * 有参构造函数: A3 l& A" u$ u' r
- * @param id# A# q8 v% W$ i' u5 k' y
- * @param name$ E6 A. S7 M- n1 \# ?! I# [( `
- * @param spec
" q$ ]1 B3 i+ h7 ^$ b# ] - * @param number
# G0 c: C; J' j' t' n% b - * @param price' C* [/ {/ p; V9 T7 l
- * @param producer; o) ]( P7 n) e: ?7 g; n
- */8 ]% _+ ], k* I4 t
- public Materials(int id, String name,String spec ,int number,int price, 0 \! q( I, b$ z0 e' }
- String producer ) {
) U+ c' _; }$ ?7 X/ w - super();4 h4 H3 Q6 @8 H' F3 D4 v4 r
- this.id = id;
5 s7 S8 L' g- M6 \$ Q" } - this.name = name;
2 W2 i' k% x; v" O - this.number = number;
# F1 G' Y. ?; w) o - this.price = price;
2 u, u% J% A' `4 s/ y: `3 ^& a1 T; b - this.producer = producer;
- J" u0 H1 C* O - this.spec = spec;
1 i4 e1 ], k3 ~ @ - }
# q" j+ L0 v! e3 ^5 ^9 G - /**% c( B0 U, H4 a1 c4 T. l$ g! m
- * 无参构造函数" ^6 D$ R1 Q, W* b5 E" c
- */' a$ s+ Y1 b: c3 z; z s
- public Materials() {
( O+ z. @' O3 t: H, K# l9 B% c - super();8 y q7 \+ h% o( G; ]
- }
: b5 U* }5 \ z1 V# N, G - /**# L r. E+ \ h/ y5 ?3 e9 a
- * 编号; @" [$ V9 {7 A3 E8 @
- * @return
4 ?6 G6 @- n2 x, k1 r" A; g - */5 B, Q2 X' u- R# x5 J5 C
- public int getId() {, l4 I2 o& \0 D& E+ m9 H( Q/ |* u5 t5 `
- return id;
w1 M1 I B! u; | - }* R% |6 p' q9 i3 Y# D6 l2 w
- /**
( e+ ?* q' v8 m( S4 f% S$ I1 s7 ?& J4 S - * 编号* H( Y1 I( @( g2 @, h Q$ r: \/ p
- * @return
& w( H' H. w! i - */, ]* [0 p" N% \ L
- public void setId(int id) {
1 [9 @9 J/ I9 g" O% b5 T" D2 d& O - this.id = id;$ r! ]) p3 m3 P' o3 r: r/ Z# l
- }
; O- G& {, e, J2 W8 U9 O. }* B& f* ^ - /**8 y, M. J1 r# p3 k" S! x) X$ @
- * 物资名称
+ d: u4 O9 M2 q' i' M- p - * @return
1 W: P2 L8 J$ s+ Z - */, g5 t4 @4 k) G$ e, D8 s% p+ j
- public String getName() {
- e4 s* s" D1 g: r1 S1 y* Y - return name;
4 n1 t; @/ q G& r) {1 g - }8 {9 l( a8 i& ]; M& D
- /**
! C- ]" P6 G ~" S4 B- ~# v - * 物资名称
$ A. ~- p" K) F7 @6 f" O) } - * @return
" M6 B4 h2 ?0 A - *// j! D; X1 K. K& U
- public void setName(String name) {
7 z% }2 o: I7 s# N - this.name = name;
9 ?; s) H$ o1 M9 j( w6 e* T( {- Y - }
9 y$ C% p7 X3 a9 e8 J. C" w& a - /** S. F: E8 e) q" Q- f4 A( T2 w
- * 物资规格
9 j: j7 K; P6 W( g/ z+ c' ~ - * @return5 E- N w( }8 R# N% ^
- */9 l; N" u$ y& v+ l+ K
- public String getSpec() {. |$ I; o% [- I3 b
- return spec;
" ]: q. \) q& }. ]: z2 ] - }
; p" T- x! o1 \ - /**! Y7 V4 u$ B) `; e" d g
- * 物资规格
& ~( r# \/ V8 W. ~8 q - * @return5 X1 S. [- y: z1 p
- */; C3 R; h8 ]+ ?/ w7 A7 J
- public void setSpec(String spec) {! ?; C% g1 R1 n2 W5 `6 o0 e1 X- E# B
- this.spec = spec;$ B' L! ^" T0 T X( j, W# h
- }
% {. _6 e! i/ N/ K' C3 v% Z - /**8 [3 c" L9 u, c! {0 {
- * 物资数量8 \( P+ J0 V" W* r' n
- * @return
2 I$ u4 g6 a z! s! s) v: x: r - */
2 B5 G- ^! Y5 B6 y- F {4 X0 v - public int getNumber() {/ d% i8 ~& i8 h; @% e" s7 W, D2 M
- return number;+ Z& Z& B+ ?' }
- }
, a8 M- z0 o8 m7 W* B# |9 S1 h - /**- \9 i0 b0 n) f9 [$ `
- * 物资数量- F k2 k e3 b
- * @return' H/ R9 S2 g) S
- */5 |: p7 |# _' A# H# L: l
- public void setNumber(int number) {
4 ]) j. O: `# Q9 ]' L" n, L" s! U - this.number = number;3 @; p3 J- V$ m6 `1 Y, a
- }- f+ N. i9 g# a' B# F% \
- /**
7 I6 l6 M! G) F4 V - * 物资单价, |5 T* c! ~' [0 q+ }
- * @return
& F+ q" e+ ?2 t8 s - */
/ P+ a7 m2 K) n - public int getPrice() {
1 i' X" |0 L7 h; ^$ m3 H8 x! ?$ D# A - return price;
- u5 E" S! M7 n; B M' {& Y - }* H$ u7 U- p% `; w- v7 g
- /**3 l! ] P; d% ^! B! c
- * 物资单价& M1 X8 I7 b- x, B4 d+ z( F
- * @return/ G+ E4 t" |' A( R% C4 \: B
- */
# G: Y$ l/ y3 H1 w- ]5 B6 b/ Z - public void setPrice(int price) {
. E. S# y' O, c- V2 W2 r& m& X! y' \ - this.price = price;
/ _$ r9 M5 |, D7 B4 V# s - }; E) v+ W, v; i) o' I
- /**
5 g' ^( O# ~+ s - * 生产厂商
+ i0 i, w% ^4 ?; _9 g: S; q. F - * @return% t5 }0 m, h4 |: `9 W7 h
- */
, ]6 g' x7 S0 Q - public String getProducer() {
. g2 V( W2 B8 X$ l - return producer;. p' `7 n2 C3 [& _ r/ h; I
- }
8 E1 z3 ~* v+ F - /**
* P; f+ @! i& b7 P( @, j4 s, W - * 生产厂商
: `5 s% ^+ t+ J+ _* X - * @return! j1 @6 |6 [% d5 n# h! `6 H
- */
3 z" x) V. n0 d7 s) R+ M - public void setProducer(String producer) {
$ J" ]' J7 g: ^. z3 g3 B' \7 f - this.producer = producer;
: b- i: L! R8 x5 Z* k - }
* a8 b# g$ i I/ ~ -
1 ^, \0 {, O+ D/ N% S8 w - }
1 @6 l7 \9 C, ]6 n$ Z
复制代码- package s2.jsp.zhangxiao.daoImpl;
r& Y: k5 I+ A, U |3 J - import java.sql.PreparedStatement;
# }# y' S% k6 j' s& N8 S - import java.sql.ResultSet;
! b% l2 k2 s4 d$ K2 [ - import java.sql.Connection;
9 F! l+ J0 V. H) {6 u9 l! t - import java.sql.SQLException;$ z0 ]# x$ C; ]' l) i6 a! ~7 ^
- import java.util.ArrayList;2 f! O4 r9 M m: h( I% ^. ]
- import java.util.List;" q, i* ]- x3 t \; _# C) }
- - i) J: `4 K, ?9 ?5 I0 v9 \
- import s2.jsp.zhangxiao.dao.MaterialsBase;
" d6 s$ _6 `5 `4 @% [; O+ q - import s2.jsp.zhangxiao.dao.MaterialsDao;, S* r) A$ F* X
- import s2.jsp.zhangxiao.entity.Materials;- |( f, ^ L( n& A: S
- /**
0 t( Y/ S, f$ `( p% P& D8 [% f: m# \ - * 实现接口的方法
- ~( X- s8 X# X ]) ]' ~ - * @author Administrator
* v- w0 A+ C3 x( @7 U: E& \$ a - *' A0 x+ V: Z1 _2 W$ }
- */
( ?0 V# C2 Q. i& z0 X! X! q - public class MaterDaoImpl implements MaterialsDao {
8 g5 r% o9 u; g - /**1 ~; W' \: L2 i1 T2 _, j
- * 查询全部
) U' k$ w7 ?- [/ U9 N+ _ - */3 y$ J/ R' F' O) _ M# o& S
- public List materialsAll() {1 U6 w; x+ g6 S. C% ~
- List list=new ArrayList();4 B5 t) \, K) k8 I( d% o
- Connection con=null;$ P, w8 T2 `9 v9 o& ^ s, q! _
- PreparedStatement past=null;
$ O7 h4 f( D6 j - ResultSet rs=null;5 N& t9 y% y c- j7 ^* ~1 ?
- //sql 语句: H3 |2 L x7 M+ n R
- String sql="select * from materials";
3 V6 g8 a4 @( J( [& h3 x - //连接数据库
& w4 q: Q9 ~. z3 i, m - con=MaterialsBase.GetConnection();
( h) y; f/ Z. z+ j - Materials materials=new Materials();5 n: Y0 t% s+ {1 C
- try {
# u* H$ T0 d! @0 {% V - //传入sql
4 u S# J8 `/ ?+ l, Q - past=con.prepareStatement(sql);
% W8 E/ L8 L) c6 ~" @ - //执行方法
/ e/ V7 W" @; _' S - rs=past.executeQuery();
! l; }0 c7 e. i0 r4 ~% W+ q. Q - //循环读取数据
8 @5 Q8 a, G# u% S# S( s - while(rs.next()){
6 J8 w$ k5 e% @3 K% G - // id, name, spec, number, price, producer# j0 G2 B7 h: ], _4 g3 e; A G
- //编号
7 j& C7 {5 |9 a2 t - // int id=rs.getInt("id");
) _, z: ], z, K* i' o4 [ - // //名称+ M$ Y) A T+ O9 o% N
- // String name=rs.getString("name");
1 A3 |5 g* o: t2 o$ Q/ f/ r6 n! R - // //规格
; G' p, R/ \# b- Q8 ~$ Q: _ - // String spec=rs.getString("spec");
, h- t: B9 X f) H, W& B& q - // //数量
4 E4 D& K* v3 O6 n/ U - // int number=rs.getInt("number");
3 s5 B% U# d7 I+ \9 A! @ - // //单价- ~/ h7 K4 s0 ^, J
- // int price=rs.getInt("price");
i* ]7 M+ z" m l) `/ ~0 n1 f9 J - // //生产厂商0 v G) c: R3 E, P# _4 M; {/ K
- // String producer=rs.getString("producer");; P! B1 a C5 |( X* h/ {
- // //添加到构造函数3 i9 F& p' H7 o5 z2 `1 x
- // Materials materials=new Materials(id, name, spec, number, price, producer);
" v' l& g; H# g4 B- X - // //添加到list 集合" X5 ]5 _9 d. X/ p2 h# H; K C* b
- materials.setId(rs.getInt("id")); `0 r4 Y8 d$ C# R" U
- materials.setName(rs.getString("name"));
) ]+ p4 M: K' y6 h4 E% d5 S - materials.setPrice(rs.getInt("price"));
3 A$ `3 ?* H; R8 @5 v* k' z0 y - materials.setNumber(rs.getInt("number"));
' w p7 B' Q7 _+ g+ j - materials.setSpec(rs.getString("spec"));
( l% ^7 L7 D+ U8 T - list.add(materials);
: S& c$ f. d& P6 t - }
! C; f5 R/ Z |; I5 h - } catch (SQLException e) {
6 @1 ?% I6 Z+ e' }# o: I3 | - System.out.println("materialsAll 方法出现异常");0 d3 z4 E$ K% N! V
- e.printStackTrace();- K* @7 b# v- O4 M h1 F% H* O- h/ V
- }0 z2 D" C& h* s b3 Q
-
. C, {' l1 d$ h: D& L, N8 X3 { - return list;+ u, ]+ D/ }3 |( f0 J# F
- }
( e6 w1 z/ ]1 m& M -
9 Q h% i6 N, h. B+ \) O5 _ - /**0 ^0 \6 ?5 A1 j( Y
- * 根据id 查找物资信息
5 B9 J% W- Z# @5 c% F - */
( o9 ?' p3 m) s1 Q1 ~ - public Materials materialsID(int id) {7 s5 o2 ]0 e- K
- //声明物资类4 n9 j# `8 b, P" _
- Materials materials=null;
6 _7 _/ q) I* Z! v - Connection con=null;. Z/ u. i @' x7 f
- PreparedStatement past=null;
D M2 @9 R3 V$ L' k - ResultSet rs=null;
3 [, b; D* {+ r, S - //sql 语句
* J0 d* q1 U3 y- U" i - String sql="select * from materials where id="+id;( ^7 c5 m! \1 M, X+ |
- //数据库 连接
6 I) V$ z; N, Q+ u Q - con=MaterialsBase.GetConnection(); v! B+ c( h) l7 O3 v; K1 S( X( k- h
- try {" \% f5 m7 L; Q+ M0 q( P# z8 S
- //传入sql
; D" Y/ k. c# Q( a - past=con.prepareStatement(sql);
7 \+ Q: \' E i) Q$ r - //执行方法// W! p, G: N; ?( ~$ a- m4 v. w
- rs=past.executeQuery();3 P$ M+ m0 o) `
- materials=new Materials();! X4 ?6 x2 `" ~
- //读取数据
/ i2 _. v4 M1 d) G$ D: F! ?1 ` - if (rs.next()) {
8 K* [$ Y7 `. }/ m0 A5 \# r - //名称
2 D8 Z$ H1 ~6 ] M' e - materials.setName(rs.getString("name"));
6 V* M/ U$ B; Q - //规格
2 O/ Z2 a8 H, W! H - materials.setSpec(rs.getString("spec"));
0 d4 V& m7 V' }. T! E - //数量" R' f& A) s5 G/ u7 k7 g
- materials.setNumber(rs.getInt("number"));
" [0 ^) e$ F4 {/ o! U! J3 \ ] - //单价
# B3 i8 J, o* r& _* ^ - materials.setPrice(rs.getInt("price"));
: b+ A: \- Q) |- V h1 k( |' ? - //生产厂商
7 \3 p1 m! X2 e - materials.setProducer(rs.getString("producer"));
5 k+ u# f' A) k0 q; I! ? - }
0 s P- A% T' V$ z* k. d0 P - } catch (SQLException e) {/ `) q) c, \' v3 h( D G
- System.out.println("materialsID 方法异常");: P3 l4 b0 P( B: L
- e.printStackTrace();
( c5 o( j6 p$ J4 Z - }finally+ A" W! x9 @- C# l
- {
( M) z2 C1 N5 V1 K: @ - MaterialsBase.CloseAll(con, past, rs);$ A- e7 [* K! X- d' s* Z
- }$ f* b' M: R) P) ~
- return materials;8 O! f0 A2 F* W3 y6 ?
- }
- \0 _0 _3 M' [3 [ - /**
0 ~" w+ [; I3 p/ C# S - * 更新物资信息
. d0 ~. q2 B7 H& x3 d- z6 R2 ]8 c: y - *// H! r1 g H- J, f) N
- public int materialsUpdate(Materials materid) {
: R/ a8 q+ E7 v/ t9 W8 k' y - //sql 语句
8 \- V0 X( H4 l; e3 q3 w/ a j - String sql="update materials set number=?,price=? where id=?";3 ^ N' P4 [. s0 k/ H5 x
- //
9 {/ L& T6 \9 ^+ q( L% u, p: @ - String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};) }1 h; P& N/ L2 ~1 |, \
- return MaterialsBase.ExecutUpdate(sql, getValues);* Y) G9 Q1 R4 @# A f
- }
( a" }* o* F3 R1 T& r5 V- X
( e6 I. [7 j4 a _. W- }4 P- [% q9 i# t
复制代码 : G4 G# W p5 `7 I6 R' K* o
代码案例下载:点击下载
: Y. w( ^. j. S7 Y/ Q0 ?' M, l" P3 ^+ c5 d- D
|
|