该用户从未签到
|
- package s2.jsp.zhangxiao.entity;
0 C" ]2 n% O. k - /**% F% h8 Q; E, h% M: f8 i* F0 k! K
- * 物资实体类
5 Q& t2 i( O* r8 b - * @author Administrator4 |, b) {$ X9 E7 e A4 a
- *9 T1 ~" X; g; f
- */' q# H" E" A% X" w1 I3 J2 Q8 t
- public class Materials {1 H" |( _. z- D7 X5 V; H
- // id, name, spec, number, price, producer
4 S+ [9 {' C) A' | - private int id; ]. A7 G. Z0 A6 I' R) Z
- private String name;
8 a! G7 a" i2 b0 [, p& _ - private String spec; F6 t" M- ^8 y: O' }: v6 [
- private int number;) [$ ^ C' X8 j6 p. p5 O! g& a
- private int price;
5 u' Z1 q2 u4 ?4 d1 W- a - private String producer;; o3 K0 Z* k0 h3 b8 |
- /**
. a5 u/ V. p* Y0 N - * 有参构造函数, }9 c4 v" `) a) R! ^& J& j- X3 l
- * @param id
0 s- C+ m, \3 j- l) M/ c - * @param name& }; R0 D7 w a
- * @param spec
+ C) ?0 H7 b B Q4 d' j. M$ c - * @param number* ~5 y. p1 A) N! o: @) Z! M- P- c
- * @param price
! _9 _( |% B% @: l) E! N - * @param producer6 {! P7 d" a9 J" S8 @" M& M
- */
! |5 T4 d% P1 e# W) e - public Materials(int id, String name,String spec ,int number,int price, 1 X0 l) D7 m5 \. X0 @
- String producer ) {' j; R6 d& {9 f: @7 x7 j5 Q x9 [
- super();
/ b+ r: ?5 f; E' H - this.id = id;6 `8 y! ?; L/ ~0 J
- this.name = name;( y- d* A. q$ m8 o+ [
- this.number = number;
/ F4 w& Y& g+ V8 s% D) Y - this.price = price;. B3 s. `: }/ F
- this.producer = producer;* o, M; i6 {! i6 s
- this.spec = spec;( E( S1 \6 ?) T( o- n
- }: b8 [& s: A' I/ H3 I4 f8 w$ q
- /**
8 a% b) p$ v9 i - * 无参构造函数; L9 s9 O1 w6 s, Q. R# y; ?" U
- */! q& O) r7 |, ~: `& h/ h
- public Materials() {
S& ^0 \5 W; `& L7 a& W5 ] - super();
[2 p+ S! j7 ^5 k/ I" } - } R% a# e7 a; x3 [0 P
- /**" x! h6 t: v; p+ y4 p& E# `
- * 编号) m9 W# E9 b' I7 c: a# E% Q0 P, [4 L
- * @return; I& M- F5 e/ l( Y! |8 C
- */$ s* ]5 I" e, q) }% P
- public int getId() {; ]1 h7 W b7 {# W
- return id;4 u& A7 m) o8 ~: A8 O
- }* D% x2 x' @/ k/ d" [0 \, C' `
- /**
. H8 \- `. @/ {/ b5 p4 t% ]+ e# ` - * 编号" ]5 H" R6 Y4 y0 q3 k
- * @return
, [3 i% K7 s9 d% }% p8 }* G$ S) D - */( }: R1 c$ v/ r) h
- public void setId(int id) {
7 s7 ?4 ^3 l) Z - this.id = id;5 E8 e, N$ L5 A" l
- }, x$ c* R, K7 ?8 J7 i: I/ x) S
- /**! r: l8 b* ~$ S! F% v5 s4 l
- * 物资名称! v: ^. Q. Z* B8 _! l
- * @return' C2 Q- w/ Z' C8 ^
- *// i- c6 C, c Y/ g2 e* i' F
- public String getName() {
9 q5 S* v9 N+ G - return name;
# T4 @& a1 k% T% Q1 n4 Y - }
6 t* r9 d: Y: L. Y' @. T# i' a - /**2 \+ S7 Q/ U+ ]* W. @7 @ X
- * 物资名称7 e# r ? o" M2 }2 F+ {/ M _- \) l4 w
- * @return$ b2 o* r# Z* B8 N( |$ F+ X
- */" c- R% @3 f3 B& n
- public void setName(String name) {
: }: f" L5 v" h7 B R1 z - this.name = name;2 s# x4 L% v8 s8 `) Z! f
- }
/ G, ]' q3 f- M - /**' O' M/ n$ D* C. f
- * 物资规格
0 R( z# B+ X' u8 @; E - * @return! S. e1 D' W( N# ~) j
- */+ D8 I7 b9 b' P2 Q0 ~
- public String getSpec() {4 S) p, H" s6 h; `( P
- return spec;
; N$ w: ~- J# U0 Y - }0 i# O' g# |5 l7 l1 M* h, x
- /**$ l7 D2 c+ Q3 l0 i
- * 物资规格/ q% c1 E' {) p. w, C
- * @return
8 n, X% j5 u& J2 c9 [# a& F - */' @0 F6 c1 |' I2 u
- public void setSpec(String spec) {
% Z) p: k6 T: B+ K. p- {# K - this.spec = spec;* u, y& p; b. I3 `' u1 ^- y# O
- }7 q0 @6 V& f) f& m
- /**
+ t, @9 x4 _- d: r - * 物资数量6 C7 |, ?1 x7 m4 E
- * @return" ^/ Q0 _8 j K" Q- ~1 O
- */
( Y0 z3 L9 Y4 U+ M - public int getNumber() {5 c4 i3 Z# @& S
- return number;& l5 G% E2 R7 C3 ^; R* t# n
- }- l6 m+ a& g6 D& m C
- /**
- h- E4 z' H! M - * 物资数量: }/ b6 r! u. y8 r8 J
- * @return
- h! w" {' D! ]% b# h2 Z1 k - */
2 e3 n, x8 Y; y - public void setNumber(int number) {
! }: o: q5 p2 B& b - this.number = number;2 _; y% x* ?* D4 ~# O p5 d% c
- } l( m& [; l* f
- /**
! S" M/ i x/ k- s - * 物资单价, Z: l9 _7 }# r
- * @return
5 {" _& k2 @# I1 s% t - */
2 k# k: ~" s' t5 ~5 O% q, U - public int getPrice() {
2 {6 Z6 {2 V$ ~5 i - return price;2 ?: B& z1 @5 [& P$ T$ R1 I8 E
- }: o P' p8 N8 n9 |1 L
- /**
/ t8 R/ u( S" [' k. P' V! c - * 物资单价2 J; Q* m) @! b
- * @return7 ^* V: F5 F# A' B6 Q; o% C
- */* K C7 N2 A/ `& S8 f4 Y, l
- public void setPrice(int price) {
, P5 q9 J' W7 C( `& b5 f3 g* g: O/ v - this.price = price;
% |% o' x& T3 n3 J* O7 @6 Z3 w - }
. H8 [* S0 p7 B1 T0 q, x - /**
8 m& X, [9 D0 N - * 生产厂商
9 B# W0 U# ^! C) `, [ - * @return
) Y$ b. e+ q9 n: @0 Y - */
$ G& A: P. Y8 _3 p7 X - public String getProducer() {+ V3 ], B m$ f2 `. y
- return producer;) \5 }( ] Z. h8 ~! r2 d8 l* R8 `4 e
- }1 s& y$ T) F/ Y, m4 T7 U7 u
- /**
3 v, l. G% |$ d4 U - * 生产厂商0 H: L: F; G* G! {- z1 O- i+ l
- * @return% j- }7 R3 S# k4 Q- s* a8 b8 f
- */. t' u' q" P s/ v) o& C- B7 e
- public void setProducer(String producer) {
+ q4 @# v* Z' _ - this.producer = producer;+ a: e6 _3 L) B' x2 d$ y
- }6 M. R% ~" m% f- o Y
- * l% b5 n3 W6 @$ p/ S* e
- }
; \9 R4 A* P5 ^) l2 t# C
复制代码- package s2.jsp.zhangxiao.daoImpl;
, w6 J# A w; i5 K+ z - import java.sql.PreparedStatement;
% P, s( j4 M1 e( Z0 D - import java.sql.ResultSet;
3 A u' t+ j" v; E/ l$ I - import java.sql.Connection;/ W: U% U- v, L6 Y' @5 @6 n, `
- import java.sql.SQLException;* k; |' a, a* i7 l3 a. {6 h
- import java.util.ArrayList;5 D$ }( l9 z- o2 g$ o2 y
- import java.util.List;7 t% `/ @# e% u! P2 a
0 @0 R5 o# H" |& M( C9 _# H) e- import s2.jsp.zhangxiao.dao.MaterialsBase;
5 e# K, x; f2 N4 o, l' z - import s2.jsp.zhangxiao.dao.MaterialsDao; r8 B1 H9 C* ^$ G1 Q, O# x. A9 Q, a1 o
- import s2.jsp.zhangxiao.entity.Materials;6 o& q5 q; Z# D) f+ \
- /**
- ] B0 t' X4 a3 `& y - * 实现接口的方法4 z, k2 N# c8 c
- * @author Administrator
' `* m! g, B7 }) [1 ` - *3 M: ?+ q% e$ T- ~* N0 r# ~
- */
) X8 q4 S8 {# C7 Y V+ y S - public class MaterDaoImpl implements MaterialsDao {3 r0 L1 `( n7 I
- /**
' ]" m8 R% s4 B5 W4 t( O. t6 I - * 查询全部, M- M; Y6 C* v; P. c
- */" A- f" c& [. X. V8 a! x; D
- public List materialsAll() {4 L; c* V3 U0 f1 h2 `5 f o
- List list=new ArrayList();7 ?) K2 ]' f; P T! [ J
- Connection con=null;; q) G \/ m# K6 k- U8 S
- PreparedStatement past=null;: ^) q" |1 n9 ]4 q
- ResultSet rs=null;( T' A- j4 X6 \; E. d. T
- //sql 语句
3 j. ?, }6 }! d - String sql="select * from materials";# t" n) N+ W r+ H' a4 O$ }: H! L# w
- //连接数据库2 N& j6 X: Q6 T& Q
- con=MaterialsBase.GetConnection();
( F8 Z* L4 `4 L* l - Materials materials=new Materials();6 g) j6 ]; q; ?" p* {, |( @- p6 O" t
- try {# K/ a: d5 i2 S6 Q. C! n
- //传入sql ' S1 a1 J q1 T0 S' B
- past=con.prepareStatement(sql);" |/ y( F$ x5 n3 \
- //执行方法6 r4 N8 P# [3 c9 H' \
- rs=past.executeQuery();
! I7 }* v* |6 }3 {* m+ f - //循环读取数据
7 {; }4 z+ B, ^" I - while(rs.next()){9 R0 z C0 A7 V& ]
- // id, name, spec, number, price, producer; ]7 T6 W1 S0 W& n' v( i8 X" b# r
- //编号) L' w7 M( R3 O. ^ t7 i
- // int id=rs.getInt("id");8 `- j0 W0 S1 H: t. o' m5 P
- // //名称
7 t/ A+ s2 ]& A! Q) k7 { - // String name=rs.getString("name");
+ [; E/ T" }' s& k7 ~ - // //规格
5 J' o# `" y# W3 Y, ?' f - // String spec=rs.getString("spec");
) c; q4 _( E% P8 H - // //数量
6 X% M! P& k/ N- t7 Y+ n" T( r - // int number=rs.getInt("number");
6 T6 {" l& A! c: s - // //单价
6 q; B4 x# ~# C1 t/ H! r - // int price=rs.getInt("price");8 f/ D$ x: `9 C2 S8 v' t% ]- \
- // //生产厂商 f' `* b* v* o! O
- // String producer=rs.getString("producer");- r( L3 S& O2 E
- // //添加到构造函数
! T7 F/ F7 i% w: [: W - // Materials materials=new Materials(id, name, spec, number, price, producer);& Y- Q/ Y3 @: |6 b: [
- // //添加到list 集合
7 Q H% c d" D: z0 R - materials.setId(rs.getInt("id"));
6 M4 ?' K1 H4 w6 U0 U- K, e - materials.setName(rs.getString("name"));
+ o, s4 h9 s# I9 M. ^( M - materials.setPrice(rs.getInt("price"));
+ ?6 K+ v9 G( M( I- O' g$ |+ f - materials.setNumber(rs.getInt("number"));
* I; S8 _; f9 J - materials.setSpec(rs.getString("spec"));' n" O4 N+ a4 ]: S/ k: G
- list.add(materials);- l4 U$ E# _$ c! j& ^
- }
0 S, l" X: t; z; v3 l - } catch (SQLException e) {7 [" E! H, k6 N/ g4 C
- System.out.println("materialsAll 方法出现异常");9 H* Z3 I$ w9 V9 I9 v* D7 E* N
- e.printStackTrace();
- W+ S4 D P0 X; {; D9 s- M - }3 a8 N7 x2 X- H" F4 G7 F5 S
-
r$ d2 \# P8 D% _% J - return list;2 H; X$ N" l! l. {
- }5 _2 b" X% T& G
- # q2 f/ g1 ?8 B, k7 j
- /**8 e0 F, c1 e. |! u6 c4 [7 u9 A
- * 根据id 查找物资信息7 S: J' F' d; ^9 `/ \$ v
- */
* x. x$ g* |7 n1 R - public Materials materialsID(int id) {
; o) M& G- _7 H( j - //声明物资类: i0 `6 D5 a2 y% k9 T7 n1 r
- Materials materials=null;
: e7 y- e& |- {; `; }* V( N - Connection con=null;
+ Y- `( |) Q6 \- u5 o2 [4 s/ l4 e7 Z - PreparedStatement past=null;
9 x+ c& F- v; q9 v6 M - ResultSet rs=null;% M$ z5 n- ?9 q1 |
- //sql 语句9 S( D* A/ m. \% \5 Y, h/ b
- String sql="select * from materials where id="+id;
' [% H" A- Z2 a9 T# Z) e8 u - //数据库 连接
( f; l; Z$ }+ I2 w: p& R - con=MaterialsBase.GetConnection();6 o" A. o: Y' `9 U8 r$ p! q
- try {
: J( Z J- Y% s* ~0 D - //传入sql
8 c3 F' @3 s! q8 S8 U2 T3 O% q - past=con.prepareStatement(sql);
: K- r/ z* q2 p. u, B - //执行方法/8 Z+ @2 R8 P& e0 g
- rs=past.executeQuery();: R+ G8 A7 q; s: O
- materials=new Materials();
& \5 `0 y: Z) A- a& i - //读取数据
* y6 i( o4 \& L5 } - if (rs.next()) {( c5 W5 P! }; u# S1 X! U- n# A9 h
- //名称
( S+ L6 z5 N& b9 _% g4 Q - materials.setName(rs.getString("name"));
5 ?9 [+ v8 H$ n( e6 _, m4 q - //规格
, o5 A& W. L2 ]2 b" P# G - materials.setSpec(rs.getString("spec"));* b3 b* y! N7 W
- //数量/ D* b2 u5 B+ F+ n
- materials.setNumber(rs.getInt("number"));, L3 a6 d7 l2 M' x6 D! J+ l
- //单价
4 o6 ^3 O& H, J9 r - materials.setPrice(rs.getInt("price"));
4 B5 Y' L6 l& _! o& q# |6 R0 S - //生产厂商( ?1 C+ K, \0 t, m/ }. E$ F
- materials.setProducer(rs.getString("producer"));
: l. f+ u; X7 x8 b - }
/ R7 ]% j) H \" H8 W$ a' h$ d - } catch (SQLException e) {" S* L: G, x; W! ^, r# ?
- System.out.println("materialsID 方法异常");
4 P4 o! \* w% ^, K9 F: O - e.printStackTrace();
4 L( h% Y) m2 {, r+ ^2 L* W! v - }finally+ Z; }* f2 F3 y+ M. M. a. k5 }
- {
6 N& e4 C. { q9 v& c: w2 P8 a# P* Y - MaterialsBase.CloseAll(con, past, rs);; Z0 F2 X/ R+ q3 F( H% h! o
- }) [' b& R2 o( F6 Z6 f1 G: Q0 [
- return materials;
: X. I! h' Y9 g9 ^% L7 ]3 A - }3 D% i+ H% U0 _
- /*** Q9 P1 e8 K# S$ r2 [( \
- * 更新物资信息$ x \7 j B) E3 _8 q/ e
- */- p7 W1 ^2 I# ~7 h% @# A% F
- public int materialsUpdate(Materials materid) {
, w. Q: i g: C3 Y5 U+ ^ Q - //sql 语句
8 d3 {2 `3 g) y2 U2 [ - String sql="update materials set number=?,price=? where id=?";
0 V) L! A7 v7 J' v. U5 u - //
" R% N5 {9 m/ b8 s# q0 \ - String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};
) a% y7 i7 n3 {8 w - return MaterialsBase.ExecutUpdate(sql, getValues);
, n$ u; J' s5 y E - }
/ q$ \/ U3 c9 R9 O; O - / B7 `. R$ U) z) k: w
- }
, h: G2 a/ B5 i& n3 z; v3 w
复制代码
3 M" L& b* @, O3 T代码案例下载:点击下载4 e- K$ r k0 w8 O, H
; f) h" g# U2 Z8 v |
|