该用户从未签到
|
- package s2.jsp.zhangxiao.entity;) M, x4 [' v0 E) b$ l9 Z
- /**( J. J; V9 C4 A6 {( m
- * 物资实体类
# v5 ?! n# i# [2 j' ^% a! Z/ Q: @ - * @author Administrator
! `) [, |- d! y - *4 Q) N3 \1 P6 H, x2 I
- */" y5 g0 A+ A- G' |
- public class Materials {
9 x; E6 N: D' n) D3 H' q - // id, name, spec, number, price, producer7 j0 O. S3 D8 @& _) e" z! H3 l
- private int id;2 f! N1 k, O" T0 A5 e/ C+ I, y
- private String name;
5 w- K4 t- v6 Y' S H - private String spec;- N& e3 v. x- ^/ ~& S
- private int number;) W0 ]- A# ~. l' s7 q
- private int price;
, j$ W, s( d6 U% N& X1 x0 A - private String producer;
# X Z- a% g9 G: c: l8 W1 } - /**/ ]( t: \8 E& U" u
- * 有参构造函数
z! ^# r- }, I3 Y8 i - * @param id
( ?1 ?( X7 F, I1 o7 m( O4 `# O - * @param name( m( C4 U2 r- ]0 w9 Q. R
- * @param spec. w! h1 J2 s, c
- * @param number
" t4 V/ Y( R2 f - * @param price: M: p2 i; u5 j
- * @param producer0 `+ h) S( ^1 T: F5 W) K2 \
- */8 w6 y: J; a# E0 V
- public Materials(int id, String name,String spec ,int number,int price,
, A5 H* |5 L2 Z) H9 m - String producer ) {+ |% x) \. {. {0 _) [7 c
- super();$ a4 f& U8 S( o& l* c
- this.id = id;+ y8 r3 h: l" y: I+ P
- this.name = name;
+ n" \7 O! f5 D+ G - this.number = number;
* S0 c. `, j. S( W7 ?) S - this.price = price;
2 Q2 v; O# `! s - this.producer = producer;( |5 M* M( ]# N! A# b6 O
- this.spec = spec;4 ?* t2 [ W `* y/ a
- }
; `2 d5 v- g* g$ d* x# d- H% K' J - /**0 n8 Y& T! B8 w6 b' U* z
- * 无参构造函数" b/ X5 | g" s8 _0 A
- */
/ X9 K- E& w- N; f: H& S5 A - public Materials() {
* Z4 b; ^* b( _6 H2 P# d% V - super();6 |2 f1 |3 n* h, M" g- J3 a
- }" O3 h3 u# A+ n9 t. ~0 v" G
- /**
" a( x, Q9 I. F3 Y - * 编号9 H$ r3 F! R3 L
- * @return
& s6 G6 i& Q$ T& N; | - */( w; r) M$ [5 I' Y
- public int getId() {* Y, l+ m; R# u) Q6 r8 H( L
- return id;
; l! E" T( s& r' U9 a5 Y& X - }- g. r9 A3 p9 t* c0 X. k4 \
- /**
9 K8 T. \1 s; b& Q% X - * 编号2 {, @) }; V8 O0 G
- * @return* `1 H. p0 G L6 }! x
- */+ n$ e/ s" ^* U% X0 N p
- public void setId(int id) {
! _3 x% p* ^! |. ]/ t. \* o - this.id = id;4 F- L _* S! Q* B3 [' k
- }) H H* a* l' ], @4 {3 k3 K% w1 {
- /**0 l4 e% y m3 J/ I) h8 m
- * 物资名称9 H0 u7 x1 u# F& b& U8 e: S0 A+ ^* X- m
- * @return
& `/ E# x/ i! W/ Q/ r - */
- E7 ^' J7 N1 r1 j0 O& a& K2 b7 C - public String getName() {
# M( b) ^2 c$ l$ s$ | - return name;+ @/ Q f: `3 S: }3 \% M2 R
- }
# P8 k$ R7 a, z6 W2 R - /**
( X2 R6 C5 h6 b7 V; c - * 物资名称+ i$ D) V( B8 w8 ~% w+ M* q8 J
- * @return
' f% m: C4 j1 J - */- h) G& @, `) B4 S: }* M6 D4 Y
- public void setName(String name) {
; v+ R; j: }/ `7 O- m, N - this.name = name;! J1 u! }# K& }$ i# C4 F$ F
- }/ L0 M+ g/ K' n3 k8 o
- /**% \' E$ m5 k8 ]2 [7 u0 J$ P/ s# E) d
- * 物资规格, o2 ]0 D7 K' I3 c; Q5 Y7 D, W
- * @return( \, `$ b) x) Y: w( [/ T$ J
- */( @1 h d' Z! P5 W! x6 P5 L4 P9 O
- public String getSpec() {
. F/ l( m& i# x: Q7 g ~6 u& J - return spec;
b/ j; U9 H% _) ^3 N$ J - }. S* s8 c, [; ~
- /**
0 _6 o% C, a3 J7 |: h: l- V. k* E - * 物资规格
* l0 B0 g, h$ C* c* V' P - * @return
% S3 K3 z4 c* h& {1 y - */
( z; t+ X9 U% [ - public void setSpec(String spec) {
$ Y, U+ @$ }! ? - this.spec = spec;
! P* L: d+ m% Y, | - }
2 s: k% c3 W! [' e( c - /**
8 _( M, g2 m* X r" ^* d9 b0 N - * 物资数量
5 D/ s! | o! |. w - * @return% _+ Q4 n9 [) H _' S
- */- c1 @! @8 Z- Q# b+ q, e x( E
- public int getNumber() {
$ ?. V* Z: ~( w - return number;% W S5 E3 M3 f
- }' P N2 b& z& u3 v6 h
- /**3 D6 |+ Q' k/ D* q' a+ E
- * 物资数量
- ~: p0 V" y3 | - * @return0 M% D" c7 d5 {% t0 v# n
- */
/ n5 ~3 G" o; B% h M; [& \9 i6 K9 ] - public void setNumber(int number) {
! N" u0 E, \. M - this.number = number;. Z# |( U- U$ `1 ~ k/ V
- }* l# V; b7 D1 j A& P
- /** y0 q( j( r( A# W
- * 物资单价
) F2 v2 i6 J5 f6 Z* ~ - * @return
6 v0 O) S; a9 \4 T* u0 [# T- p - */
; ]. Z2 m4 f, l0 G9 t - public int getPrice() {
9 W2 o+ V& E3 C) E - return price;1 f1 A- ]( F' P. x& g
- }% X0 V9 O; B* a H% ^, x
- /**
7 j( z$ ~. S" O9 V; _( ^0 I9 O$ } - * 物资单价
x$ p/ B! D) T2 |* Z: v - * @return
4 e* L- s! R( I" Z4 b8 }+ H9 K - */
* |. Q' u6 J* u. o6 ?5 S - public void setPrice(int price) {- S0 _5 ]0 ^( Q' D
- this.price = price;
) }0 e3 Z5 [5 u - }
0 e# H6 y. E F% Z3 R7 E2 Q - /**
* U! }4 O" ?4 r* Q4 R7 a. S1 } - * 生产厂商
5 t/ m6 y3 Z$ E2 Y6 w y% d" e - * @return a- W; E5 c6 j0 c: c1 [
- */. x# M& N: P4 O5 o9 W7 L
- public String getProducer() {2 x. z% @% a. v6 N( P( Y" b
- return producer;
' P8 v. Z! `! N8 y7 H - }
A' N* m2 C# o7 r& B - /**. ]5 m" o/ U2 M9 x" x8 n) y3 s
- * 生产厂商, `0 \3 _- G }
- * @return9 |$ o9 i9 ]8 E
- */4 ]$ n# H. V0 W2 } g$ q
- public void setProducer(String producer) {8 [* `+ ^# d2 x
- this.producer = producer;
3 y! O4 [7 G* [8 _1 z, A& Y# ]4 Z - }
1 \! \! z' U5 V: X3 x -
& g4 J; Q6 j+ \! `7 J4 d- E5 I - }8 M2 P! Y7 W0 J2 A8 y4 w
复制代码- package s2.jsp.zhangxiao.daoImpl;
6 O2 U) @6 E5 m* K - import java.sql.PreparedStatement;$ Z$ A* I9 y' Y8 q3 C2 Z
- import java.sql.ResultSet;
) t/ N) {8 a6 `9 G - import java.sql.Connection;
5 q7 G4 D4 ?7 H3 {9 m) O- X( l0 B# u - import java.sql.SQLException;
3 i* ~1 @$ b( h - import java.util.ArrayList;( G* y2 j1 b5 w% s2 E, I
- import java.util.List;
+ ~3 ^2 \5 T1 R- [4 G9 b$ K - $ _# L6 ^, E/ c4 {8 O6 @
- import s2.jsp.zhangxiao.dao.MaterialsBase;
! X8 @9 w, q: V: Z8 x - import s2.jsp.zhangxiao.dao.MaterialsDao;9 v" j" G; L* l- \3 i# S9 d$ o: Y
- import s2.jsp.zhangxiao.entity.Materials;8 x$ ~4 b; t# m. g3 ~
- /**
9 m0 u9 m/ B2 S' [, b& j7 S q - * 实现接口的方法6 L& j( ]: l6 k9 y
- * @author Administrator
2 `7 z6 b. [9 A - *; w8 V# l# g% s k! ]
- */* B% M3 l; D/ ]( Z! A; y$ r
- public class MaterDaoImpl implements MaterialsDao {
/ I* R W: O. M1 x" e - /**3 `* M8 T3 F1 r* n! B
- * 查询全部
9 `& \) @( Z$ J5 z+ M2 \( l - */
2 L$ |6 z$ W8 u5 [ - public List materialsAll() {" }# m5 U q; e9 x2 |
- List list=new ArrayList();
4 t' r' [! | K2 q5 g7 b% {, w: T - Connection con=null;; t7 y* T$ v! V
- PreparedStatement past=null;
: }2 \. z: ~6 F- v3 |+ ]) T - ResultSet rs=null;
* E2 j8 E$ W2 f - //sql 语句. `: w; E- v7 |+ {& {
- String sql="select * from materials";
9 K+ O$ |, d% |* `! y2 F - //连接数据库
5 u9 m5 l. y2 \2 C. { - con=MaterialsBase.GetConnection();
3 t7 ?- o$ k7 X2 i% d& g8 r - Materials materials=new Materials();0 k% X( g( g0 r0 X$ m7 d9 o& G
- try {
9 n" e1 C2 a8 a2 c - //传入sql
+ n' w9 z* b& T; k* { - past=con.prepareStatement(sql);0 H- R2 g' { J$ O, q' W4 f
- //执行方法
" m- L6 l+ B5 |- o6 K2 G$ G - rs=past.executeQuery();
: i$ e: T! P2 c7 z6 {; Z - //循环读取数据9 c, U7 [, O2 E6 ~
- while(rs.next()){
# t" D7 T r1 f- F. Q% z" w# a - // id, name, spec, number, price, producer
2 Y' Y% ?9 L7 u" P6 p- g3 c - //编号( z4 Y0 J' F% z
- // int id=rs.getInt("id");
% t4 L/ I* s/ \9 J8 i/ q+ j% K3 H. a& I - // //名称( C- a/ f8 j# |
- // String name=rs.getString("name");+ B1 N- v. G+ B% j9 h; ?! Q v4 }) ~
- // //规格1 ^! P% k1 `2 L; G8 n+ m
- // String spec=rs.getString("spec");
9 W& z! s4 w$ F$ q2 v) g! I - // //数量
5 A, l& D- H8 C - // int number=rs.getInt("number");
. A4 P1 d; J$ @# O$ D0 A - // //单价( Z2 z8 {+ B! C; g
- // int price=rs.getInt("price");; @5 Z- k5 Z" h0 M, X. ^1 q9 s
- // //生产厂商
) B- m$ l( l! Q. t - // String producer=rs.getString("producer");
& d! V" z1 `, d7 t& Q7 k. V7 t - // //添加到构造函数
# U2 g9 r' q1 k6 \ - // Materials materials=new Materials(id, name, spec, number, price, producer);
' g; O0 p6 M' n" O" K# C, ]* B2 J8 Z - // //添加到list 集合
$ K; \4 k( [5 P7 j - materials.setId(rs.getInt("id"));
- Z. ^% G% A) X# R6 R - materials.setName(rs.getString("name"));, A) V' v( |- A2 J' A& s
- materials.setPrice(rs.getInt("price"));( e+ w' ]2 F0 o6 \
- materials.setNumber(rs.getInt("number"));0 b! E( a& Z' m x) q/ y4 k
- materials.setSpec(rs.getString("spec"));
3 @; l, `5 G, q) {/ R! b' o7 W+ r - list.add(materials);
6 Q0 g5 z1 d4 M, L - } 4 [) m' z' I2 Y: B* w) i( C
- } catch (SQLException e) {
* J) D. {- z/ W4 w& `. Y - System.out.println("materialsAll 方法出现异常");% H; ~. U2 _8 h/ A$ j% ~" Q6 C
- e.printStackTrace();: l0 F+ H# H& Z# I) z) V# k# I
- }# @5 x; b ]" r/ C
- & J5 D+ _$ B. L. ]- I+ P
- return list;6 E' E" H' [' P& M2 D( V
- }( D/ Y8 e7 [6 l' u
-
8 v/ P* }8 @6 t% T9 y' k$ W - /**- ^% {6 g7 ` R* x7 b
- * 根据id 查找物资信息( ?3 g- A2 i/ [7 d5 u1 x
- */
# g% K) P |3 }( ]( x: K2 { - public Materials materialsID(int id) {
4 v0 _2 `8 Q b; N$ E/ I4 m - //声明物资类) B6 U8 k8 F Q: Y& g! y; q
- Materials materials=null;7 w2 F$ w' U+ E% M
- Connection con=null; D! Q4 H8 ^* D; @
- PreparedStatement past=null;0 p: }! L) w$ S1 D0 \# c
- ResultSet rs=null;
. [7 E/ L8 j( i9 R2 Z3 S - //sql 语句. w! ~3 M$ U6 Y. V' l F, m) h
- String sql="select * from materials where id="+id;
) c# ]$ k+ e9 y1 E1 V: r' N1 z, a - //数据库 连接
* o: n: T7 ]6 C2 e( ^7 L - con=MaterialsBase.GetConnection();
! C0 \7 x3 a9 u) Z - try {; ^! E8 U g* K6 F
- //传入sql
, k8 v4 r" [. \1 K8 g1 u7 j - past=con.prepareStatement(sql);5 a. d- F, o( h5 L$ @
- //执行方法/
. d6 \( a8 d9 b+ B+ ]$ ]" V) Y4 f - rs=past.executeQuery();4 m6 t6 P o+ h- ?% m
- materials=new Materials();
$ ^- B' r$ c0 {* a5 Y2 r7 d U( e0 } - //读取数据/ J, K7 D ^ M5 O$ g7 Z
- if (rs.next()) {
1 n. ?; A" d# f- m M0 t7 b, L - //名称
4 r2 m( t# e7 Z* Y7 | - materials.setName(rs.getString("name"));" p9 l2 y! z/ d$ M# T7 p* R+ j
- //规格6 ^: f/ s2 A+ t, j7 u6 {$ P
- materials.setSpec(rs.getString("spec"));
2 M4 h5 ^& W2 A3 i h - //数量
4 v# z- \9 b3 N+ C - materials.setNumber(rs.getInt("number"));: o; @9 ?; V: a/ d0 {. E- W8 s
- //单价
* K8 k$ o# A/ ~7 Z! S% u - materials.setPrice(rs.getInt("price"));7 t, |4 c. R& ]2 C& G h- D* k
- //生产厂商
# P! l' V+ G- ^: P6 ? - materials.setProducer(rs.getString("producer"));
3 H/ p/ O, O; [6 i' w* C - }
9 R! h, z1 B B) m - } catch (SQLException e) {/ H0 _8 [2 A a- {1 s3 L
- System.out.println("materialsID 方法异常");6 `3 K; i9 u/ S7 w u4 z8 q) `5 F7 g x
- e.printStackTrace();
/ s/ J. e" ?; O - }finally
& x7 A! d5 N5 h. ? - {6 S' j5 J9 Y( K! l6 D; ^- G
- MaterialsBase.CloseAll(con, past, rs);% F: Y+ ?0 y, t3 S0 q; N$ }
- }1 x* d# ~' ?) j; J* N# p/ k
- return materials;* }0 t/ m2 `6 u0 V' i. x
- }( i4 ]% x! |1 W. l
- /**
* N5 n& Q2 Q: Z" t W& r# z4 S - * 更新物资信息
; R- v) M9 Z; V, C* }0 s6 N) ~ - */
# P6 w2 E( v0 f - public int materialsUpdate(Materials materid) {
& M3 g* E: i; w% M8 Y/ L1 h - //sql 语句
7 I8 X1 G. C+ U) ?# ~0 @ - String sql="update materials set number=?,price=? where id=?";9 t6 P2 D# P" v! J; V5 L
- //5 u8 m. e. ?! n3 e0 I9 Z
- String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};' [0 {( q0 R% r3 L6 v
- return MaterialsBase.ExecutUpdate(sql, getValues);
4 P6 Z% V8 e2 r7 V5 {. S$ { - }/ s U* L" j% Y: d5 y+ P9 L+ X/ y
0 n( S5 w% l7 o- q( v5 R- }5 J: I* H! \) E4 N, x
复制代码
* u- @+ ^ v4 v5 [7 F9 t代码案例下载:点击下载
S" X6 w B7 E/ c0 V; n, N5 J. n; j2 \2 Y( L& R" |3 {
|
|