该用户从未签到
|
- package s2.jsp.zhangxiao.entity;3 U3 ?* t' L1 x' f" n6 F: d
- /**
* R$ m. ?( Q& K7 ^8 ^8 ^ - * 物资实体类# @9 R0 z0 }; i# `0 r. o6 D
- * @author Administrator
# C/ T% B0 E" T% \5 G+ V. ? - *
$ a) C) y! `" Z" P6 e, d' S - */
& v! n7 B% Q4 [7 V( D0 ` - public class Materials {- H+ t8 b; \4 r" p# v
- // id, name, spec, number, price, producer
/ H( M, X7 L G% p) [ - private int id;
6 X5 v& M: h$ y) Z5 a# n6 | - private String name;& J8 R- F- h$ d
- private String spec;1 f1 D& ^2 Z) ^$ N
- private int number;( n% I8 N: W8 R x
- private int price;
# S% E. E5 D% j: {5 c - private String producer;
4 N2 [( o( G. t& n, ? - /**
+ f' L4 N9 C+ u! J - * 有参构造函数: u5 y9 i+ R# A6 S, a6 v) N0 R
- * @param id
7 ^/ w. C" j% W/ ], x% ?5 g - * @param name
/ Q5 v$ R9 C6 k/ K - * @param spec
) L7 r S- ]% |/ t: A# V - * @param number2 P, S2 m- V5 ^6 v e
- * @param price# G8 `0 g& S8 v
- * @param producer
7 v8 i; I$ Z' c* L5 D; b1 y - */) H3 Q- t' ?# e, q
- public Materials(int id, String name,String spec ,int number,int price, ; s% M6 J; e3 U, n2 B
- String producer ) {
' S! P0 P% Q" `. ^9 A5 P4 F - super();% p, ^4 Y6 s; b
- this.id = id;2 c1 r1 M7 Q! S! S k: F
- this.name = name;
0 U! ` z2 W* o0 b. W! }0 s - this.number = number;
4 I6 ]: A' v0 m7 v1 L3 @. k/ k$ c - this.price = price;% x) I: K7 f- A9 U4 d% k# H' j
- this.producer = producer;
) M* A9 ~# |# _' S) k6 X - this.spec = spec;
- g6 X" m# Y3 l" M; Q5 Q; ` - }
! }! D, l: T* Z9 S7 b( M0 c - /**
7 ^; v9 G. I( C5 ?. Q- `. H9 ^% A - * 无参构造函数
8 q; f2 [% c/ `2 Q - */! |; s3 s/ {7 g/ {
- public Materials() {
% O, E& W' n0 N! x, R" S - super();
6 ]0 y* V E# ^6 U; { - }
+ ~* ^, i8 c( a/ f# J6 V3 g1 W - /*** Z' G$ t) Z8 O" B) R
- * 编号; Z! F7 x9 x( s& `5 ?
- * @return* d3 z, o/ |7 B. v; J' O
- */
: ]! C: I1 L0 V' @4 S, H8 ] - public int getId() {. p+ L) ]/ b8 j/ P. `# C: S
- return id;
/ s0 p% I+ u( e - }& W1 a) {# y9 N8 z6 {# ~# b
- /**
! `/ z" c( H* d' ^7 N* X5 o; s$ O" e5 | - * 编号
, ^4 S. {" Q+ N6 Y - * @return
8 n1 W4 J% t) u - */
; q) C, A* p4 s/ ? - public void setId(int id) {
, Q' u5 b, B# b+ H, g - this.id = id;" Y/ p. R; C5 [6 x' O" h3 C
- }, Y* c6 B' k( d. c! N: J0 n
- /**
, R4 y X: Y! g" f' j$ _' c - * 物资名称5 u) R* o$ f# D+ ]) l
- * @return
! I: y4 v" b* t v - */6 d: E# |! A) Z; U6 G) O
- public String getName() {
* T/ Q0 v" S% h/ W7 O - return name;$ R! _. I! U) p# V' t
- }
7 ?" a9 S# Q; q: ^ - /**) N G9 d( d+ B3 [6 j+ j7 C
- * 物资名称
; K) p* y% ?7 p Y0 A4 Y - * @return
6 Q6 a" G/ R; S4 w( c - */
7 F2 t5 \' g \& Z: P - public void setName(String name) {
* ~8 J% [9 x A5 z4 o# Z - this.name = name;& L9 ^. s, X9 C' {, ?3 _. k
- }
4 `) }1 o1 S! N: m* F - /**
3 t1 x6 F1 D8 S h( o3 Z2 S' [ - * 物资规格
4 P( G4 `. `) l0 k- g- x" L9 m9 A1 ^ - * @return4 i( J4 n7 J" e) Q4 f m, y
- */
& @+ V- X, v" K0 ` - public String getSpec() {
: X; E# _( ~7 k1 y" q8 c - return spec;
! I8 w+ Y" S1 |" S) I/ G+ W# x! V/ Q! V - }
9 _9 e5 q6 T R" k - /**2 K8 m. @; J5 L8 ^0 i; e: t# D
- * 物资规格! X: h2 `" O/ e3 Z& h
- * @return
& C$ e+ v& }; Q& q - */( h6 {$ m) J' P5 R
- public void setSpec(String spec) {+ @% c% F R+ X8 }( [ X
- this.spec = spec;
2 V- B3 `3 S- c - }
* c2 R/ _) B* O, O - /**
; q2 g. L4 S+ ~0 G6 X! [5 { - * 物资数量% ]. [/ x5 A. q. a
- * @return
# R1 P! M( ~& m! f( F" W - */
( B. w" T; e& A/ x9 m' L - public int getNumber() {
; F, @7 `/ U, X& h! v3 T5 G - return number;. M% w# i% b* X$ P1 J* F% p
- }! K7 c; {* A6 H
- /**& N. }1 P/ a/ s0 Y
- * 物资数量& r" _4 D: L) h3 g3 h
- * @return. k/ V" r; z; m" d6 J$ w
- */8 D# ]8 [) r0 | f
- public void setNumber(int number) {
) a3 u/ [" R2 e b; T. Y - this.number = number;& ], N E6 L% x+ Z" H' K9 U
- }
( u [5 s# |/ L# w7 U( V/ O - /**
$ i; S D8 N0 O* F7 }/ e" K - * 物资单价
6 k9 |- A# |7 @0 n' m - * @return
% _1 R# x( k, ] - */
/ x9 c% e9 o j' V - public int getPrice() {: _4 k, V, x3 g& ^* y7 q7 C
- return price;) H% A5 c; j/ l
- }3 H* E* O5 [; F, x9 X
- /**
0 A) A: A! w& g3 u, V - * 物资单价
/ \5 F" x% e5 y - * @return) \' z- }. }% f+ t6 K; Z: |# r6 L
- */2 d) U0 @; }1 [* _* k9 u& X
- public void setPrice(int price) {
9 l. \ \3 M5 v3 r+ q; S( T - this.price = price;0 S0 P4 j, C# k9 l# Z& E
- }0 [) c5 B, |8 x) @
- /**
# A) j4 A1 R8 ?( H# { - * 生产厂商
: T5 E! Y p' q7 `+ R/ N - * @return( r' M: H( B; R3 I8 K! k
- */
6 P ~8 Q* Z" H' q8 m - public String getProducer() {# @' J$ R }# h8 s7 v' }$ `6 j
- return producer;
7 Z7 G3 P9 x4 p' a. C5 g3 j - }
2 E8 i' T! E. B* ~; | - /**7 Q4 _7 [. w! M4 |: v
- * 生产厂商% \" k, i$ R4 g. Q; y3 m
- * @return
5 y( X! x; Z% b' p9 j - */1 }& n% q3 h/ l8 f8 [
- public void setProducer(String producer) {, g# e# Y1 `4 R2 d. O
- this.producer = producer;$ C3 M& r+ B4 k+ O
- }
$ O+ j8 W' i( q0 O% { - " L6 I, V" U7 w& D8 Y
- }
/ }6 H- J0 }2 |$ K# J v/ b
复制代码- package s2.jsp.zhangxiao.daoImpl;; v4 L% F* y! g" [4 n
- import java.sql.PreparedStatement;
) u2 k/ b" Z, y t/ l; k - import java.sql.ResultSet;+ Y `4 R. _0 I3 H
- import java.sql.Connection;
5 M# V( Y! d7 u) Q0 L0 P2 K( L - import java.sql.SQLException;0 k! }8 v- [( V
- import java.util.ArrayList;
) t# @% W4 C m% z - import java.util.List;
2 [8 t' ^' M) h6 y: ?+ e# ^4 h' V6 t) h
4 y: ~- k# j; ^# Q) q- import s2.jsp.zhangxiao.dao.MaterialsBase;, t1 R! ], S: Q2 N
- import s2.jsp.zhangxiao.dao.MaterialsDao;$ s" F/ t# ~; [5 c3 m
- import s2.jsp.zhangxiao.entity.Materials;+ r, T# w) |9 e/ P& w
- /**
; ~& x) K1 G4 F9 t* P) b. ~ - * 实现接口的方法
. [0 P: J1 }7 f; p6 B) d1 l. u0 P - * @author Administrator
& J& G2 L! w. v2 R/ F6 l1 a - *; |4 Z& l, L2 C& U2 }
- */
+ R( [% e) N" K - public class MaterDaoImpl implements MaterialsDao {
! n% v% @' Q- Y6 L' ~% N( v - /**, M! I2 r( d* O, G
- * 查询全部
% @, R( t: h* l' B j$ k - */7 T8 M9 I: P; }/ r# R6 @
- public List materialsAll() {
% ^% n/ j m- l9 g6 k% Z5 K) b1 t - List list=new ArrayList();: B2 d3 I) C4 T
- Connection con=null;1 \! J6 X" I/ c2 ^7 w1 L# n
- PreparedStatement past=null;
1 @* x1 f- n# Q7 P9 h! V - ResultSet rs=null;: T5 d ]8 z# r+ U: _
- //sql 语句4 T2 M4 L' {" Z
- String sql="select * from materials";
4 h, o3 C1 e$ b {: e |& M - //连接数据库
+ J* ~5 J d+ s5 _1 M* j* f; l - con=MaterialsBase.GetConnection();1 n' [; D2 m: V% E9 d$ D; y; W1 o
- Materials materials=new Materials();/ T' j8 {7 k3 K# _5 a8 S! c$ _+ K
- try {
0 _& F. g: n7 ~9 J6 I* l - //传入sql
1 f+ k4 ^7 l! G. J5 m! S. ]% ]3 g - past=con.prepareStatement(sql);
6 [( \& j' w& w) r+ n N. f: W. a: w% E - //执行方法
5 G' H/ d! t1 U9 m/ T - rs=past.executeQuery();
- O! w- F8 k o: } - //循环读取数据
! t! S' \ d; r7 x) O. U7 f - while(rs.next()){
7 l/ \' E; H. Q* A& F/ Y' R+ h, h" | - // id, name, spec, number, price, producer
9 N3 z* X2 u. e' z! w9 u - //编号8 F7 c! R! W% O# O5 A( j& X8 N
- // int id=rs.getInt("id");! g! _3 Q" u3 A/ o" Q
- // //名称
' L! @0 N1 m: u q g6 A5 E3 b( j - // String name=rs.getString("name");
, J9 O; P- b; m3 N( `6 E0 H5 W# F% | - // //规格! m9 v& Z, R, K" }# i
- // String spec=rs.getString("spec");& T: O4 o* M: x& C; _; k
- // //数量! O$ R# a/ }0 a: x& [! V7 p0 |' V
- // int number=rs.getInt("number");
( }8 |8 {& t {9 \1 m - // //单价
4 A8 ]! q0 i( n2 h9 T+ U! V - // int price=rs.getInt("price");5 X6 L" ~) X( N3 J2 D# f
- // //生产厂商
% o# C& {; w# [6 S+ | - // String producer=rs.getString("producer");
& v) h: e( m/ C2 B0 |5 y - // //添加到构造函数
$ O" C9 `5 }6 x$ b* {% M+ T( d7 X$ | - // Materials materials=new Materials(id, name, spec, number, price, producer);: S( Q2 m9 e( @) N) _3 e% x& x
- // //添加到list 集合
. z) m1 _1 M9 b9 T5 ^ - materials.setId(rs.getInt("id"));
: `" L) j) h2 V5 \ - materials.setName(rs.getString("name"));
% R: R9 C5 H0 B* v6 w% w7 | - materials.setPrice(rs.getInt("price"));, T- d+ t" J7 i
- materials.setNumber(rs.getInt("number"));
& y% h8 C- A5 T, s - materials.setSpec(rs.getString("spec"));
" d" |' x* V* c j0 y& V - list.add(materials);
2 ]/ w9 }* }. }0 X6 ] - }
. B9 m- I5 ?9 ?- e' v - } catch (SQLException e) {
* S) K$ k+ `* Y" G) V - System.out.println("materialsAll 方法出现异常");0 j- N! n) Z& Z! w' t
- e.printStackTrace();9 u$ ^! M1 `' ]( f
- }
2 H- ?0 P* @3 P( [. t - 5 _- A: A# ^. ?: S
- return list;: i3 W! D4 c! B) R
- }
+ T: f& ?5 i# h+ W$ P; G -
& l, ~, x2 F7 H% q6 K - /**
/ K4 l; z; l6 Q: O0 B - * 根据id 查找物资信息1 @! J; R) D( e+ u H
- */% ~9 P3 ~% Q& m V
- public Materials materialsID(int id) {3 m1 w5 s* X& Q5 M& W9 S' B
- //声明物资类
) R$ F9 x; [8 c5 z$ D - Materials materials=null;
# b3 x" ^1 r# ?- E8 V: v - Connection con=null;
! v/ l2 u- A$ w5 L( G - PreparedStatement past=null;
/ O. R* v# r. T& i; h - ResultSet rs=null;
; B8 v4 T6 F4 N+ x+ V$ A - //sql 语句0 x6 U) O& i {7 Y7 r" ~7 Q
- String sql="select * from materials where id="+id;( Z; q) @: O* [; f3 Z
- //数据库 连接: k# y% ~9 R6 b U
- con=MaterialsBase.GetConnection();9 N/ i* ^4 F; V0 O9 m
- try {
3 q2 L- \( G2 E - //传入sql5 \8 x& ^4 P+ w. H) X, a2 | d- H
- past=con.prepareStatement(sql);: c% S) X0 A: H% D* [
- //执行方法/6 f5 z' Q/ [4 f1 o7 _8 i! l
- rs=past.executeQuery();
! O: E7 J- p+ N# O+ P% {: E - materials=new Materials();$ x/ J% t6 q* A; n7 Z0 |8 Q$ ~/ C. f
- //读取数据
q( J$ l0 h- W, b- }0 E - if (rs.next()) {
" a2 ^0 e3 H& R+ ] m4 K4 g' ~ - //名称
9 {3 ?- y' y( j - materials.setName(rs.getString("name"));
1 G# ~& E$ y; j5 w4 }- { - //规格
+ U* d* d: ^% I8 D) y - materials.setSpec(rs.getString("spec"));
7 _( S. H! F: i# ^, M- p+ P - //数量9 m8 b6 G1 ?, T, a( P: Q
- materials.setNumber(rs.getInt("number"));' L9 ~- f& J. B9 |
- //单价
# I$ O+ ]3 Y: s3 m - materials.setPrice(rs.getInt("price"));9 M5 m. S* B& k9 P* D6 |
- //生产厂商; @$ ` W6 x9 U8 c- J
- materials.setProducer(rs.getString("producer")); w5 q: A1 k( U0 v
- }
3 Q7 O# Y9 W0 R: w2 f, [( R: p - } catch (SQLException e) {
+ a& L1 ^( M5 D' r1 V1 H/ [ - System.out.println("materialsID 方法异常");
; J' h5 C" l/ ?$ S - e.printStackTrace();* h# L8 j5 C0 ]
- }finally
$ F6 C2 u* t8 x - {$ i ?( B% x% s2 m! }
- MaterialsBase.CloseAll(con, past, rs);* l/ ~2 P+ I; _. W
- }
* @( m2 [4 T) ^9 m - return materials;
# F+ u4 e! G& V! G - }
. F9 v9 S2 m' p1 U' N - /**
$ n3 m. T! M3 U- f5 h; f; F - * 更新物资信息4 A- L4 o; J9 G5 \
- */
. N, e7 u8 c. G% N I - public int materialsUpdate(Materials materid) {
2 Q# X$ A, e2 Z- v - //sql 语句
$ Q2 w/ B0 G7 S5 C: j: Z. I - String sql="update materials set number=?,price=? where id=?";
! {* W8 |9 o+ W - //
U4 o# W& K5 [; l l1 G - String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};
7 z0 \2 ^ \5 v; Q - return MaterialsBase.ExecutUpdate(sql, getValues);
# l5 I+ n4 R+ O% q9 t& o - }6 h' Y' v1 j7 s
- `8 e0 j+ q7 o. ]* T" |6 g! G
- }
3 g+ y5 N% K, J7 m
复制代码 2 P& K6 o% `7 r! T
代码案例下载:点击下载1 t$ D" ]2 t0 J2 b' U
8 M0 Y' Q' k& j0 D) g |
|