该用户从未签到
|
- package s2.jsp.zhangxiao.entity;: w2 g4 z, S& R) E9 W& o
- /**
6 ^6 P T! N' ^+ n - * 物资实体类- v0 a& l' w6 \1 J$ l
- * @author Administrator
( w S& p: F/ i: l, j - *
2 a3 O# e8 K3 M - */. A i" y; X! m* j* a
- public class Materials {
" l* _3 U" G, H% Q9 C. N - // id, name, spec, number, price, producer- q6 D9 k6 t# |/ w7 C
- private int id;$ h9 ~9 f1 \- a+ [
- private String name;
! E" W' b: e1 t; k2 l& @ - private String spec;
) E7 b3 C8 _' R* O; b - private int number;
$ d% O/ e- {4 c/ d - private int price;; }3 N. |( C2 {4 U' K( }2 F2 [
- private String producer;4 ^' a. K* s! e: Y: n y$ R6 K3 D
- /**
; I6 U/ U9 Y: n* f6 m0 {& V! B - * 有参构造函数6 O" n: Y9 |6 @( a& `
- * @param id
. ]: l, S$ O1 U& o- E - * @param name, |& e: [/ d/ J
- * @param spec
) W% q8 k# X+ c$ [4 E - * @param number2 I) w1 ]) e6 u. S2 E! ]
- * @param price0 p' |/ k! H1 r7 s
- * @param producer$ J! U9 a+ i3 b% M e4 U
- */- P6 b$ m! M* [$ b; O
- public Materials(int id, String name,String spec ,int number,int price, ' F4 R1 e i3 F% C/ ~: Y
- String producer ) {
- `; H6 U. f- V/ K1 W$ T2 T- @ - super();
" ~+ v( G/ j4 g - this.id = id;
/ X5 b, \+ Q4 ]& f - this.name = name;% i; L2 o1 B$ V- {4 b
- this.number = number;8 y; ~9 `' Y2 D
- this.price = price;
: h# r |2 I5 E" Q# S& }5 t - this.producer = producer;( n4 Q+ Q" F4 r+ L7 W# H" V7 ~- }
- this.spec = spec;" [4 ?0 m0 z3 N8 m* n
- }4 b8 b% ^( m* t) I4 t
- /**
5 q2 M5 X1 ^! b: y7 W- e& z - * 无参构造函数1 T% K" G# E; N9 X5 n
- */
3 O4 n$ q8 R/ c/ ~6 i, X" A - public Materials() {" c" A j5 q2 L, y
- super();
L& P1 ^$ v$ F4 x2 s - }0 D% e" N" Z4 t$ D" J b
- /**
+ D( ?& u. q# P! q C/ p- l/ ` - * 编号
2 X" b% K5 ?5 Q; L& { - * @return& |. X* ]/ y: g7 y4 W
- */
3 x6 @$ h' M3 b5 Z8 F - public int getId() {% ?& X9 }5 k3 M# K. t" k
- return id;4 m8 ^; d3 R5 {0 N
- }
- p9 W" a0 q3 y* m& @9 j' M, \ - /**% x$ n9 n% G6 v0 Y% I
- * 编号! S& O9 e" O' p% O2 G
- * @return, a' Q7 g/ M( f1 i
- */# r( j7 z) z( i0 D
- public void setId(int id) {* ~7 a: }. K+ p
- this.id = id;
$ w9 f2 Y+ V2 [8 c8 o" B& K' E - }
6 j- V6 Q# g; J9 k) y, a! A8 n/ `4 J - /*** C" f9 W) L) v
- * 物资名称
1 t+ f: [5 P! ` - * @return
+ g% n \& W$ O9 H( @ - */
+ @5 B. m/ G3 x& d - public String getName() {
6 o4 X/ a6 T+ w* U& P - return name;+ Y3 E c2 G% {8 @; J* Z
- }
/ }3 [( j1 E' t0 a& P; o$ b - /**7 g6 n; Y* W; p; H N1 c5 k* p" M
- * 物资名称
* C9 F' J4 ^' Q: X' C' C* s; A& z. D: T - * @return% Z2 Z2 r3 e9 @6 [% V, K/ ` j( p' `
- */
0 m5 W7 u+ P* `% X; Z$ J - public void setName(String name) {
( h7 i: X5 T+ ^7 q$ }* w+ | - this.name = name;3 u5 i+ `5 O- r% E
- }. \: z+ _5 @# H8 Z# f
- /**
" o, K) F" ^! I( G - * 物资规格
' @9 Z5 P l- H+ H. \ - * @return
" b6 W. l: h0 O8 [ - */8 u- S* P4 Y7 W( t1 L
- public String getSpec() {, ?7 ?7 i: e2 D* K5 Y
- return spec;3 @2 u0 ~. C% o' Q) S- i
- }6 {8 Z$ m4 ~( U2 ]& b' n1 T
- /**
: I( k0 g) p; o' h! ^% k - * 物资规格* `5 k. m3 A) }' A) H
- * @return
1 G* m3 T, C5 ?# a - */. q( u" J x" j' t
- public void setSpec(String spec) {
8 Y9 _. i' J7 ^5 P: D - this.spec = spec;* }" Y6 ]! a" }1 I% D9 h# I
- }" Q( z! i' M' a" h! j' j7 p
- /**
* I3 Z/ T/ a- i4 W) { - * 物资数量" Z2 X4 S% Q5 i" J
- * @return
9 h: Y9 w/ z' V/ ~4 u - */
- _: o) M3 z/ |1 l/ S - public int getNumber() {# {, w7 W+ U) e$ `0 J1 o0 k
- return number;9 }. Z7 y b, L9 y# [9 y" f
- }' D9 E" @; G" x3 e
- /**
$ R- Z" f; t! b8 @ - * 物资数量8 t/ E% W/ j4 ~: m- i ~7 e+ O* @; }
- * @return
0 }4 L! x% E) w+ [1 J3 E1 q - */
- K+ O0 ^+ v' X7 _3 z2 M - public void setNumber(int number) {
& w2 U- B+ ]8 ?: W, |; v( X$ |2 m, _ - this.number = number;
' O* l; A* i$ W) \% a - }
) V0 E1 p4 [" p- U3 K& q - /**! d4 T1 W$ k, w) d( L
- * 物资单价
( v) F# c* b% F: Q1 o1 H- C& B - * @return
5 M" H3 ~. C& E - */
0 s1 X+ |$ W3 d1 E& M% N - public int getPrice() {
( S! D1 k1 U. Z( {. U: N0 ~" [+ ~( A - return price;
. L7 H4 Y' `5 C V) U; g/ V6 O4 g. v - }
4 _; z1 Z6 Y5 `5 Z [ - /**9 E8 Q! d; {6 W
- * 物资单价
$ B- ]1 H4 J- k6 {9 p* T - * @return5 N; B$ k7 d6 A9 F
- */' I' j2 z) b, H$ ~5 e( k3 M$ d
- public void setPrice(int price) {' C- ?. b1 I5 A% _& \
- this.price = price;
) s0 S, q% L9 j- _ - }$ A- `' H8 ?1 i$ Q' Q" n
- /** c7 S1 b0 F5 I# X; f$ e& l) B
- * 生产厂商
1 b$ @5 Z3 Z9 j6 W5 o2 I/ X6 L - * @return
1 A7 _" D6 M- I" @9 t: s - */
- x/ {( ]# l5 B7 y9 O, ^ - public String getProducer() {# ^! S/ D' R+ A) m$ q8 {- ^
- return producer;4 F: s" ^5 c% t/ Q& N7 m) X6 w# {
- }2 `5 s0 G. p* K& ?+ M' W
- /**4 X4 V% c6 `, N" v8 g6 ?3 ~8 b/ `( b. d
- * 生产厂商* l4 f2 Q8 D R! J8 d
- * @return
3 ?% k2 a/ }8 ]! d5 ~, z! T" ?5 T - */
# s* f A, H$ O t- \) @! t - public void setProducer(String producer) {
. `0 N+ G* Y B* |- e - this.producer = producer;
* V) P+ C- m& x! T; }8 ]7 ` - }
$ D# V1 h' J7 B* _3 | - 3 Y3 [& B3 T' i) H0 a) W; M
- }
& C& G5 I8 B7 f# Z7 H Q7 C- q4 k" k) Q [
复制代码- package s2.jsp.zhangxiao.daoImpl;9 N9 G- c3 Y# M/ B$ ]8 U
- import java.sql.PreparedStatement;1 d3 f4 f- V P& R6 |
- import java.sql.ResultSet;
+ K1 @; U2 v* u! |: m. N - import java.sql.Connection;( }' n, F0 L/ A- }2 w
- import java.sql.SQLException;: S2 C$ }$ h: v% I! u4 v# v2 [
- import java.util.ArrayList;
) z$ P6 t/ Z5 [2 d) t/ v; q7 m' M - import java.util.List;( F0 J1 E0 c% e c F
- ; I( D* w6 x- z+ |4 T
- import s2.jsp.zhangxiao.dao.MaterialsBase;
. f8 G. y" T9 u( W- |( U - import s2.jsp.zhangxiao.dao.MaterialsDao;
$ [- r z U. r4 N2 l - import s2.jsp.zhangxiao.entity.Materials;
2 @$ z" t' a; `- B. G3 s - /**
/ A. J! W# k$ W$ A9 l8 k3 L6 C( B - * 实现接口的方法, x2 K9 a2 F4 u1 U" k+ o" G
- * @author Administrator
* G3 T% v i3 H% y+ T0 ~ - * \' s# V" v- ^7 ?- m3 H/ p
- */
3 Z& e* D! P* M/ U8 B - public class MaterDaoImpl implements MaterialsDao {" V' J+ P2 D- l8 C4 U, n1 K) ]7 l4 b/ Y
- /**7 F0 [. }" d4 u+ w% M
- * 查询全部/ m/ z: t' h' e E, }3 L- U
- */
5 s9 z: ^7 t* \0 X% ~- ] - public List materialsAll() {
; T' m9 a1 [( F4 q - List list=new ArrayList();
) ?4 t' x$ n" n! k - Connection con=null;8 E/ p' t' a7 j: s
- PreparedStatement past=null;
; L' J3 _6 R/ P9 N - ResultSet rs=null;. O: _/ H* z# `% j
- //sql 语句
4 O; G% a( Z- |% H, F - String sql="select * from materials";
0 l+ Z1 F! J6 {4 ? - //连接数据库
. M/ {% }# t9 F- S4 u/ ^( E" g - con=MaterialsBase.GetConnection();. Q. j) L* G+ i; M
- Materials materials=new Materials();9 r! \- u3 y) s: c/ E N) m- D
- try {
0 I, l9 f B+ | - //传入sql
' n" l! Q2 `( \6 A; d" p - past=con.prepareStatement(sql);9 P; A0 `$ y* U. O; R
- //执行方法
1 ]: p3 V, _7 E/ k: o - rs=past.executeQuery();( Y. s9 f# h! p' q
- //循环读取数据
`) K5 t% @; e; G* F - while(rs.next()){
+ U* ], o; X# h% c1 y1 { - // id, name, spec, number, price, producer1 X7 {7 C; M, A
- //编号, ?' Y" H: f/ [$ R7 u7 m
- // int id=rs.getInt("id");
# L2 `) L. @* ~9 ~4 J- b0 n( k, M - // //名称7 X1 I8 A9 b& T" h' u
- // String name=rs.getString("name");
) I, \ T) ]6 n- ^ - // //规格# T) K; }1 a+ t% O/ ^ P2 N I* i
- // String spec=rs.getString("spec");2 N. o7 X* C% K# ~
- // //数量
+ n! e7 K0 l9 G! e# f) t - // int number=rs.getInt("number");1 o$ s7 _1 C) X E+ P7 y. \
- // //单价# W" d2 U) H: R/ v v) i5 j O
- // int price=rs.getInt("price");
/ s& `& l: C. k- t - // //生产厂商: R/ @0 d, R( j
- // String producer=rs.getString("producer");
% T4 H0 c* `/ J) W( O# D - // //添加到构造函数
( N- j6 I2 M' N5 P" I( } - // Materials materials=new Materials(id, name, spec, number, price, producer);0 g3 [) S' J: R. P g# \8 O; g
- // //添加到list 集合0 ^$ w1 p) ~' o, ` U4 \
- materials.setId(rs.getInt("id"));
$ e1 h2 k+ z4 C$ B, L% Y. c4 W- s) G+ T - materials.setName(rs.getString("name"));2 s6 E% `# u6 N/ j
- materials.setPrice(rs.getInt("price"));
- c- ~6 ]; g+ z1 n' F9 V - materials.setNumber(rs.getInt("number"));
6 u' j8 g/ |. _$ E$ T, P - materials.setSpec(rs.getString("spec"));( E& C& o. l/ K0 W
- list.add(materials);
8 A% @: J) V/ n. r6 I - }
5 T- r) W% c6 F/ @ - } catch (SQLException e) {
0 I9 X5 E& B/ x7 R6 V' U - System.out.println("materialsAll 方法出现异常");! P! m: w/ N7 S" e
- e.printStackTrace();5 Q& e( D' A8 J& U( m
- }
2 e2 M3 T& b4 I; b- r -
# [8 Z- I* f5 D5 K - return list;( L7 c/ N, j& l/ p y2 w3 x
- }* I7 q* @& ]* _
-
3 E( ^4 T; h4 i# {3 q6 V - /**
3 A7 Q6 g1 }+ [/ W7 X6 x s& I7 m - * 根据id 查找物资信息" ~ c( r2 q$ x
- */7 P1 B7 D: _' y4 j+ U; ]" R7 ^, q
- public Materials materialsID(int id) {
5 o) {' a' C' U) \% z - //声明物资类
8 e* c, ~ q; u" c: a5 a7 i3 f - Materials materials=null;
7 L& t' B# t2 O4 V8 H$ ` - Connection con=null;
; C' i! L( ~7 Z" t+ ? - PreparedStatement past=null;
2 D' K8 q6 ?% X6 u, ?% ~( H - ResultSet rs=null;5 x8 u! K' \$ _; U/ m
- //sql 语句
* m4 }3 Y$ B! p% q n& i - String sql="select * from materials where id="+id;
$ Y( D, M& @$ ]6 B - //数据库 连接
( P$ o' O2 R; G# Z' B" I9 s - con=MaterialsBase.GetConnection();
: @" v6 i1 r9 ?0 [" n0 {" E9 R - try {
3 u+ d1 {# |# I9 u$ [* T/ G% P - //传入sql
8 J' P. L! Q: Z$ D - past=con.prepareStatement(sql);
P6 U7 P* X! A8 N9 t! l" k - //执行方法/; n. W: _. p; `5 H1 O
- rs=past.executeQuery();
% D/ n# [# q9 X) E% `7 a6 c - materials=new Materials();3 {7 ^ P. n0 A. g0 v
- //读取数据
1 e' H! ?0 _- g - if (rs.next()) {
O& H6 p8 P3 L' |9 [ - //名称7 v+ Y+ ^' h, S7 S% B; Z T' p& y4 z
- materials.setName(rs.getString("name"));3 E# `& _" Q, v7 o% t, O6 q
- //规格3 t5 V }/ n3 w3 R* q; l
- materials.setSpec(rs.getString("spec"));
8 q& J2 x9 L$ m5 A - //数量
5 n4 l3 H. y+ X# f9 D9 D& p - materials.setNumber(rs.getInt("number"));' Z2 n* U' D, [) @! R. L+ L0 b* g; c
- //单价1 y. O& ?& B: M4 s2 A3 m! p, v% s, z- a
- materials.setPrice(rs.getInt("price"));. V# s; o: r3 W0 ]- p3 m) T$ v; B
- //生产厂商; n) K5 v$ J' t# {7 w8 `- D, V
- materials.setProducer(rs.getString("producer"));
# z+ f3 @" `9 V) J" [" }* F/ I - }
# [ E L4 ^0 {1 G' y& w- r3 I - } catch (SQLException e) {
/ ^1 Q3 o- R3 N - System.out.println("materialsID 方法异常");. h; r6 [6 w( ]$ S
- e.printStackTrace();
" d. E( c6 o6 c+ q d. j - }finally7 n2 W2 i; U+ O5 Z
- {1 ~6 t" W( f0 c% H6 {9 [) g
- MaterialsBase.CloseAll(con, past, rs);* Y8 l# j. `4 C* D% r9 @
- }) A' P1 H3 v: m
- return materials;
3 D L3 H: r5 R ?+ `) \ - }( j$ A2 @1 b5 T3 a
- /**3 Z# R/ N! r7 c( I+ p+ A3 T3 K
- * 更新物资信息6 k1 y; v9 D: E* J/ U0 r; a0 Y* E
- */0 T( A4 z* ?6 ]/ F
- public int materialsUpdate(Materials materid) {
; k3 f) N2 ^2 U6 t# z - //sql 语句# r9 j0 A* P3 V4 s5 O2 J
- String sql="update materials set number=?,price=? where id=?";; W( d! z! a5 A" N' U/ f
- //% y$ D2 X% ~1 N- a2 W- e0 t& D$ C
- String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};
9 g0 g7 s! V( p; I# @% g# y; Z; s5 @ - return MaterialsBase.ExecutUpdate(sql, getValues);
4 Q+ ?+ v W- h( a$ V - } ^" C* Z( S9 G! ]% M+ d5 z. Z
- N- o! G) @, w- }
# q+ I$ P2 z v8 W- P) E
复制代码 , @9 z# Q/ T% M J
代码案例下载:点击下载. u! ^+ z7 t; X/ m4 J }4 i( z, G4 V
) H2 |7 M* R/ x) C4 ?/ K u |
|