该用户从未签到
|
- package s2.jsp.zhangxiao.entity;
1 D2 c( w$ u R - /**8 h) ^/ A! v6 L2 c" m
- * 物资实体类
7 [' L# j# X; ]2 b" i8 ]: f' o - * @author Administrator
. Z. ~/ Q6 O' j5 O& u9 d: Q+ k! s- z - *
& U+ P. F( [# b8 @ - */# m' _% K5 h8 b. B5 m9 C
- public class Materials {/ F8 U1 F* b$ J" n
- // id, name, spec, number, price, producer3 A. {5 E3 D6 U
- private int id;
' Z% r5 W- ~; x s2 R& j% ~+ X - private String name;$ G; W( Z. Z: n5 A& f7 q
- private String spec;+ f7 n; e+ u& A* b6 e
- private int number;
) p- s( ]2 [! i4 g% ] - private int price;8 K4 Z! l$ y* T6 e7 R/ T
- private String producer;
1 V( p [- f1 K( r - /**
! C3 N+ W# O8 D! `) ]" Y - * 有参构造函数
& j5 F# @* K% d4 K, U. s# X - * @param id/ E9 @ v3 n* D/ L$ _& [3 d
- * @param name8 m# F: p3 m4 Q
- * @param spec
2 {" ]+ k1 t% g* p3 J - * @param number+ l# d% ^8 Q. L! G5 S$ M
- * @param price
5 [; S/ S g- {; k" ? - * @param producer3 \' x. I8 W! ^4 j
- */4 b' R8 ^# H0 d7 `6 c5 H
- public Materials(int id, String name,String spec ,int number,int price,
- U) d' R8 n' O3 ~- A4 C. v* ` - String producer ) {
. K4 e" ~: Y6 p8 e - super();
7 C, @; H6 L U7 R& E3 R - this.id = id;! B6 h: p! ]# O8 L5 O0 S* F: x) Y& g
- this.name = name;
7 ^5 ]: [0 e9 S% @8 L - this.number = number;& P; u) d5 k5 D' w
- this.price = price;! k1 m$ e* M# y2 _( M$ a. ]
- this.producer = producer;
3 z( H8 t0 }! ~4 v - this.spec = spec;& |, P0 {9 I' _3 x: U
- }
1 t. d- }# d& n; v* _' V - /**
{- g' T$ C7 r( w1 u4 _. E - * 无参构造函数
) A& ]7 N7 ]; u t% T4 s - */, O( G: I& B7 v/ V6 A
- public Materials() {, R3 Q( d) M5 b- g
- super();
/ `5 a G4 `# _9 [, C- Z6 \ - }
) Y. Q% F; M2 d! j$ V/ q - /**2 Q: E1 S: W" d4 b9 Q# e
- * 编号3 z: C% W* X7 [
- * @return
3 H% b. O3 i! D3 T; o - */* [* S2 ]& d. w9 _4 v# Z
- public int getId() {
* Y1 C6 ^6 N5 x7 J - return id;) x" }4 N* C7 W* P! T
- }* x$ g) E: {: ^. s
- /**
1 j0 Y0 ]* V; J; ]7 y - * 编号7 h( S5 D( Y) b! N
- * @return! N: G! a7 k4 K0 E0 s, I
- */: {& C+ G* u9 ]& |" r
- public void setId(int id) {0 V, i6 F J N S5 Q: P* w' W+ X
- this.id = id;* ~1 Q0 A0 j7 _$ t( c( d
- }% K" F+ \) _% u f, Q
- /**
- ?+ o) e! l- w* {/ B& ?5 L* S" z - * 物资名称
5 k* O( A5 I G& ?* {' { - * @return
5 ^/ k' R' T/ b7 Q - */
E8 t' p0 Z3 E - public String getName() {
/ g1 V7 X$ T! z) x+ Z - return name;
/ ~7 O* r) ^+ D5 S - }
/ F3 n; S7 P5 L+ L9 ^2 f - /**" N, w9 e2 t+ I: s6 |- E
- * 物资名称
' z" L- @9 s; D! L7 K( }7 |8 E - * @return7 _% {' o" ?0 F' V0 K1 Z. U
- */
5 _& V1 W# N% b( N( B; g; K - public void setName(String name) {. l, o |- C K9 B' O0 g* H( c
- this.name = name;+ F! S! N; e, e( M' j
- }( S" [ l4 Y2 B# b3 G, I; C& c
- /**3 j# p" B3 P9 l
- * 物资规格
8 ]7 L, h! ], Q( v+ W: P, Q - * @return( g7 Z' @" ^+ B' C6 U9 q9 M$ A
- */
7 z% e' b. W+ z$ \: ~4 ]- U7 j/ | - public String getSpec() {. I; D, s$ n( J7 [! E B
- return spec;% a/ x8 p3 h/ ~/ l" g
- }
3 N( H$ r+ ]1 ]) J - /**
) }6 F) E- ]" t+ @& C; o - * 物资规格% ]' r- N4 ]) D6 U- E* T
- * @return
- m8 [# d+ @9 g" w* l, _$ A - */
! {7 P X" C6 z! @ - public void setSpec(String spec) {
! ?: n( D& j+ \ - this.spec = spec;0 ?: X0 J0 k, @) r; W
- }
4 y3 Q) j# R3 h$ a' Z" {# ^2 S, @ - /**
( j! r g% s6 a6 c - * 物资数量
/ { G W1 X: s - * @return6 u! s" Y2 P5 E& r6 t1 F! R4 P
- */
7 Z# P1 J0 v0 [1 ]2 F3 `( B' x - public int getNumber() {
. W, w( w6 Q4 V& Q: w' @# R! ~/ ^0 \ - return number;
8 K- w/ y" Z1 k. |2 P - }
; k# _* a2 g e0 b, t9 V7 w: L" H - /**$ x) h( `% C5 c
- * 物资数量
' Q/ m6 W1 w0 B/ ]9 e% o+ ` - * @return8 W2 `6 C: R* M: U$ c. ?1 H. ]$ C, c
- */
7 P3 p3 J, k/ s# M1 K4 ~ - public void setNumber(int number) {
, |3 b+ ~% g# n - this.number = number;* r& O1 I3 g i& Z
- }
$ ?5 i4 ]' S! s2 w9 ` - /**+ R2 ?$ W+ ]/ ]6 y
- * 物资单价3 {9 F O u# ]' x
- * @return
/ f' W- j8 C- j7 p9 s& ^% c - */
~, [5 T: l/ g- n1 u - public int getPrice() {
. k( c) }+ o3 ^: _* t - return price;5 r% X6 T. Q. Y* k
- }
; t1 n- c1 U% e' d - /**
% V' g+ e7 k7 a& ~ V - * 物资单价
_. R4 k. C. o- X4 a - * @return
4 r8 U& g* o8 \7 G, e4 q4 T - */
- f5 \* X0 R! {% \- G - public void setPrice(int price) {4 M' B, C" q7 H$ ^+ X/ w) A1 J
- this.price = price;3 L+ o: ]# I% P& c9 T9 ~4 U$ o+ ^
- } g4 {' k1 g/ k* a2 q
- /**/ c9 ]/ e, O4 e
- * 生产厂商' l7 n D, T& E' e1 {8 D! s: E0 k
- * @return
7 c3 T/ z: {# Y' a3 V# W - */6 Q8 f6 W3 M% w9 l
- public String getProducer() {! T1 t+ A* c& `1 s
- return producer;+ t- O: |6 t' T/ k
- }8 `' | m t2 z s! Z# e
- /**
/ ?$ x3 |/ ]2 r; J1 a( j. k - * 生产厂商1 v# y% J- |) P, W. S9 g& F, `: U
- * @return
6 `$ c3 I5 \& ~8 z. T - */4 s1 D/ g o4 N1 a M
- public void setProducer(String producer) {
3 F6 c0 P3 S/ R3 d1 y1 W - this.producer = producer;! ~1 A& L/ R6 B2 F; u. c; [5 b
- }4 G1 _1 n8 `/ ]/ Z
- 1 j$ O6 o' Z! T
- }
* n }, Q; ` y3 \ b q
复制代码- package s2.jsp.zhangxiao.daoImpl;
0 K5 K( o' j. O7 D6 S3 l - import java.sql.PreparedStatement; d4 L2 D, O! m1 C7 u6 n( Y5 I0 o
- import java.sql.ResultSet;
% j" V6 z' E7 b - import java.sql.Connection;# _. M4 f1 w7 e! `' ~
- import java.sql.SQLException;
7 }: M; v! z0 Q7 o% o/ F$ N4 ` - import java.util.ArrayList; h, k8 t% Y* F) x( Q
- import java.util.List;
0 P5 T% C2 R: D4 B$ u - . } B' _4 J: c) R7 b ?. {
- import s2.jsp.zhangxiao.dao.MaterialsBase;
1 P/ ]5 f0 T; j! I6 w X0 H - import s2.jsp.zhangxiao.dao.MaterialsDao;" q; V6 K2 p) d0 B
- import s2.jsp.zhangxiao.entity.Materials;" b2 e. ?% c% ^( n, E
- /**% j; d/ N0 J; t2 \0 H
- * 实现接口的方法* r( x6 r' D% `1 a0 E, t$ I1 P
- * @author Administrator
. w0 {. X0 C) b( X/ D+ M - *
# g+ K+ h3 P2 Q( i - */
3 k) K# I/ [ o1 n( a - public class MaterDaoImpl implements MaterialsDao {2 [, ?2 r0 a( ]! X G& |
- /**
% q$ F3 `* {! Z - * 查询全部 Y2 C% @4 u6 O, r% {+ y) I+ ^' t( ]
- */- r$ U" c- @' W! `" E
- public List materialsAll() {
4 r# t" Z& t3 ^# x1 j - List list=new ArrayList();
4 P; O" p k2 O6 S8 u% h - Connection con=null;
$ x, C$ A; Q2 D: ? - PreparedStatement past=null;
7 W: S7 p1 j) k6 q* q - ResultSet rs=null;
3 D- [! n$ ^% q( B2 e) h - //sql 语句+ I; P: n$ F3 ?! V, n; y5 V7 U' R
- String sql="select * from materials";( s8 b8 a W# S x; G8 j- Q
- //连接数据库
/ m0 s7 l; A9 `$ S2 r - con=MaterialsBase.GetConnection();
2 ]# G& K0 N Q: o0 N4 o9 S) N - Materials materials=new Materials();
; C+ q0 }4 G! @) F2 g - try {3 g) d' d8 Q9 t0 z* K& W0 ^
- //传入sql
6 u& d, I; z6 T1 g B& }( ` - past=con.prepareStatement(sql);/ ~9 C/ K b. s: f# W
- //执行方法
* b$ j5 {' G: L, E7 P - rs=past.executeQuery();
/ i2 x7 c) J- h! r/ H- M* g - //循环读取数据
- a8 c, ^9 C0 h5 `( y( n+ g5 Y! _* s- { - while(rs.next()){
1 S1 y |, N* T' B1 t - // id, name, spec, number, price, producer# x5 j" X( P* Y) W# M: }# s6 d
- //编号
/ u( {& }" m/ |7 W* l0 H1 p - // int id=rs.getInt("id");: f3 _9 C8 m S$ e1 ]) a
- // //名称) D; w/ @' } J
- // String name=rs.getString("name");$ y1 c) u- l9 i0 Z) h- d
- // //规格1 q. w% }( B& @
- // String spec=rs.getString("spec");" A! E. f1 W3 G1 o* k8 W X
- // //数量8 O1 F6 x7 P1 D4 c* |
- // int number=rs.getInt("number"); s4 J. \6 i7 d9 ~- z0 }
- // //单价
3 \' S6 x( }# S' v - // int price=rs.getInt("price");8 a; m7 D. w0 D$ ?" u2 z$ k6 ~
- // //生产厂商% o2 N7 u3 V# [( B0 [
- // String producer=rs.getString("producer");5 a Q- {0 m- a7 D
- // //添加到构造函数
5 ?/ f8 O) x) k" J( E7 Y - // Materials materials=new Materials(id, name, spec, number, price, producer);
( A; Z! R# Y* j! b/ g - // //添加到list 集合
7 o2 ?# i2 f* h: D - materials.setId(rs.getInt("id"));8 e! l0 `$ ?; H# w, ^7 X$ m
- materials.setName(rs.getString("name"));
; D: k3 L4 S d! T - materials.setPrice(rs.getInt("price"));1 c* f: Y Y8 _1 I9 S, T
- materials.setNumber(rs.getInt("number"));
7 u0 @/ i9 f- J0 O6 K+ ?/ m - materials.setSpec(rs.getString("spec"));8 ]/ H5 ?( g/ ^. K8 n/ {
- list.add(materials);
: K6 A7 H4 H7 N% d( B5 c" {7 q5 A - }
! h U( p. ]- Q* H7 d6 s - } catch (SQLException e) {% `& }4 n1 x# \6 K
- System.out.println("materialsAll 方法出现异常");
. T5 B2 J- p3 u- T - e.printStackTrace();
+ X3 t" y4 N, M& u - }$ e, Z: H* a' u5 |
- 5 x7 j- q* r9 Q. j/ \
- return list;
5 c5 |7 b" x" Z! W - }
3 E- z! } P8 S/ {& k( W6 x7 N -
( g" J8 q1 C: v! y - /**, T) l" @- S- z0 z) f
- * 根据id 查找物资信息$ @6 s/ v+ l2 m7 J6 Z f4 r& q" J
- */: V) }% x% s# E% B, t7 a
- public Materials materialsID(int id) {
9 Z' r+ O5 _/ {; \' q2 m - //声明物资类4 A7 j6 `, k0 y8 L
- Materials materials=null;
' `5 G J8 g5 s k& a: ^ - Connection con=null;
8 @" Y7 D# o8 C% q2 s$ ^ - PreparedStatement past=null;
- w3 k# G E f. W/ e6 W; ]8 k - ResultSet rs=null;
: z4 u7 S: |7 u9 b7 z" _- Q c6 J - //sql 语句
' O+ g6 }- h7 V! c - String sql="select * from materials where id="+id;
* g9 b2 _5 G* h* {1 B6 x3 } - //数据库 连接
9 Z2 P0 u1 S( Q9 ?2 t - con=MaterialsBase.GetConnection();
. d' a4 J5 K( U - try {' N2 s R0 q( [: Z q( @) @; H! ~0 G
- //传入sql. \: X; R" [7 O2 X9 H* L0 d( l, A
- past=con.prepareStatement(sql); H1 q% m, O; ~5 S \, \( d( |
- //执行方法/
! a H2 x' z% X' K% i \" n - rs=past.executeQuery();- c6 m3 x0 l; [2 d
- materials=new Materials();
6 ^! P% O5 m) q8 q9 ~0 y" H - //读取数据7 J. A# V2 B+ |+ y% S
- if (rs.next()) {
! l* s% W- } x - //名称8 i' U X9 c9 [6 Y0 f
- materials.setName(rs.getString("name"));3 s3 G6 n4 B \0 o$ c
- //规格! Q5 j! E% n5 I M# w/ d' i
- materials.setSpec(rs.getString("spec"));
1 a Y F' v+ R+ y; f% F0 _" N b* u - //数量5 o3 Z6 E( m, H" u9 c
- materials.setNumber(rs.getInt("number"));
+ |& U# m( q$ v6 {( f" O - //单价
+ V( [5 W$ s& t - materials.setPrice(rs.getInt("price"));* I6 I2 P9 g; ~6 \8 M
- //生产厂商
) l$ Q1 t+ Q% m5 l; X - materials.setProducer(rs.getString("producer"));3 t( M7 ?- u5 Y6 y. S
- }
! |: y* x: a1 o7 o5 [. n; {) w - } catch (SQLException e) {
! F' {& [! g4 p+ ?# W* X9 m - System.out.println("materialsID 方法异常");
& v0 \/ ?" X: F. V" A( {' {/ t - e.printStackTrace();
, O, y T9 B* ^. ]. ?' t6 ] - }finally
+ E, W% d, i5 m! a0 t T - {3 b" h6 ^+ W( q+ K+ S6 q
- MaterialsBase.CloseAll(con, past, rs);" t% y- K6 |5 ?2 W3 ~2 D; f5 e
- }
B2 W. ]: ~0 m; n - return materials;
6 G7 g# K" J+ A5 f3 q - }3 G$ V: [; m/ \' [- e
- /**
6 W* V; D* B3 J - * 更新物资信息
: E) x i ^1 I8 _. I0 | - */5 z$ W" d( d1 O& g+ c3 I
- public int materialsUpdate(Materials materid) {
$ h. [0 Q N/ X7 J( t - //sql 语句
! f4 Q! E( s: |7 K - String sql="update materials set number=?,price=? where id=?";
/ M* E6 _* A' X$ t - //" n# I3 n/ E1 }' e/ u) h
- String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};' f4 j/ ~4 F/ |7 `8 f2 O
- return MaterialsBase.ExecutUpdate(sql, getValues);
7 I' z! y" `: t - }- h9 E F5 Q2 u; \$ [
- 1 E L$ h' `8 N0 z( l
- }$ {* K3 X* ^( _) d5 d
复制代码 . {& p% k! E* ^4 O
代码案例下载:点击下载* `8 o4 ~) q/ |- K
8 e4 e3 l! R0 W' R. ?( T9 E |
|