该用户从未签到
|
- package s2.jsp.zhangxiao.entity;
) T0 [/ O4 |9 D2 P - /**
2 ^' o6 \, v. C1 _/ ^) g0 Q. } - * 物资实体类
6 |) @) @3 m! G( j - * @author Administrator
2 o8 N5 K# E$ L& U - *7 }) c4 P+ w6 X9 g
- */
, r% w: d: O- i4 L" _/ @2 w( P - public class Materials {
! l* ?9 M9 ?# q" Y# e6 Y - // id, name, spec, number, price, producer
# R4 Y7 G$ D8 M y& I1 z9 r( J/ M. m - private int id;8 K8 i9 Y0 B% b, m
- private String name;
$ `* O1 [7 T2 `5 k8 H( ]" c - private String spec;
3 w7 `0 |3 r; g4 @) M. j$ q - private int number;
) ?8 M: n, D: @; \/ Y5 w; F" Z3 F, y - private int price;# p, S& E( u9 i5 W0 V8 ?
- private String producer;4 r/ I& a a& ~
- /**0 i. x* X8 f3 g P% L1 l
- * 有参构造函数$ G0 s( r; t6 t& p9 n1 d
- * @param id
* Y" d9 W. p3 \7 C$ A$ X, N - * @param name
5 o. J6 q9 I# l$ E: [ c - * @param spec
; A% ]( K0 R& G& V' z" F - * @param number
$ s6 Y+ ]) G8 `3 S - * @param price% W9 {7 v* a4 H8 ~* u
- * @param producer
% y3 u W4 z, ~9 L - */5 F; M' u5 |4 s' N b, Y
- public Materials(int id, String name,String spec ,int number,int price, 3 N8 `* q% [! r& R' F" j4 c3 F! S
- String producer ) {( H3 z, Y3 y* h8 ]0 O
- super(); d, u( h' [" ^. ^$ A
- this.id = id;
# }% T0 A2 A7 w! E4 J6 ~5 I - this.name = name;' o; a$ k( j- d$ Q( w; ?2 y
- this.number = number;
$ \! z$ f* L7 d" @! Q, B, j - this.price = price;$ y1 J n' M6 J9 U9 v0 L9 s# I4 r6 T
- this.producer = producer;1 U/ b$ D( P) h0 V( e( t2 K
- this.spec = spec;6 M+ t% }' w, [' c+ G$ ^) n
- }" m% x2 N5 v V8 N' L$ o0 H2 {8 i
- /**
4 j3 b) o+ g z& E( [/ } - * 无参构造函数
: U6 _0 V8 m, Z# k& U" x5 ~ - */& [8 Z( X3 ~7 n% E8 ~
- public Materials() {
$ |2 S1 e9 t7 x - super();# D9 n0 r( Q/ y8 O
- }, @( F* w% z0 d& H, f. \
- /**
# i# f7 U7 c, N9 {; s - * 编号
' ?+ p* S& c0 o9 k6 q - * @return
& [& ^8 F/ \: A5 O9 d- L1 }! f - */
1 [+ x5 n6 F' g* b1 K+ g4 q - public int getId() {! x) d! y+ h6 n; g9 x r, X- \
- return id;# u- q/ S. S# s; B% Q
- }/ f7 B" e+ Z, X! ?
- /**) n1 ~; Q7 w% {; c: M! W+ t
- * 编号
! a7 s* z2 c1 x$ h( {7 B" H - * @return
$ j: U2 h' M1 f2 X! i; | - */
: l9 v! _- _! S/ Z9 ~# O1 i - public void setId(int id) {: ~9 N9 k/ r/ n# m L" o) L2 d
- this.id = id;
( L; r3 x1 @7 x4 Q- e! w! v - }, C% W1 L" i8 y# h) V7 e
- /**
) X4 _. r3 O( E0 d- E - * 物资名称 B2 i! m0 \1 e$ Q& `
- * @return
" p% L! i+ G; k2 d3 z! ?, a$ B - */
8 P& w2 C6 h7 y# k% } - public String getName() {6 d4 U- U% ~# i
- return name;
5 t1 |2 b" w/ M. j3 A% A - }3 C, V6 g% x& M0 W% Q+ _
- /**
! q# ~" }* s1 F9 | - * 物资名称2 [& {% H" }6 n
- * @return
! o6 C2 q- S1 Q# P! V - */4 U9 |. j; ?9 m' O- f) a6 R
- public void setName(String name) {6 R$ _9 R a& F- R" e- c7 o' j* b1 \
- this.name = name;
* u9 K# ~: H$ K - }
3 Q: c( ^+ v/ c/ `3 S - /**: p4 S5 m! x: G6 {7 o. ?1 v
- * 物资规格1 P# G+ g6 @8 c8 J
- * @return
* y/ ]" k* l1 p7 Z9 N/ q - */
1 H8 O: _( Q( ` - public String getSpec() {
4 y5 ^) g* X/ c: S+ c9 `- S2 J7 b - return spec;" X1 p8 v7 R1 X7 n8 b/ A5 t5 ~
- }
* J' m1 Z I6 h- E - /**$ H m1 O: o- y0 j% o+ p$ |
- * 物资规格5 b# u% J2 T$ J
- * @return
! U H$ t" O, c0 e% R) ~6 B/ A' R - */
; Q* ?$ g( g) N: T: p- q) J2 P - public void setSpec(String spec) {
: {3 V. B( ?9 v# k! g+ b/ q - this.spec = spec;/ ?8 [* F; p3 Y* f# q8 L% E
- }: M2 }, O: ]$ ]# ~ ~- r
- /**0 u+ g+ y1 W" r" _& w2 x. x
- * 物资数量
; z+ `/ N, \% X G - * @return
7 h: k) q, X$ j3 g* ` - */7 d0 K$ ^. m6 |3 g% |) K8 s
- public int getNumber() {# F3 E* n' P3 V$ B: ]* u; k2 o
- return number;8 u, u- ]0 ]" e: w/ K
- }" n7 I1 o7 _% B4 t, s+ L+ O
- /**
5 L1 a/ m1 E- A' @& n/ ^- @ - * 物资数量9 p- s8 C* U- O3 d# d
- * @return1 L! z0 ?4 f1 y
- */; _- S+ `- c* z' w+ k0 Q! b
- public void setNumber(int number) {
?( Z6 ^; o, e4 R9 J - this.number = number;
% P: D% I( Z/ W+ f9 @9 m - }
8 A4 ^% q ?7 B) h R - /**
8 A* A8 a2 ~- P - * 物资单价
* o7 D, K+ l5 `0 D: W% p - * @return
8 `) q6 W- O. C& i - */
, C" t- x2 d* p- o; m$ Z$ q4 L - public int getPrice() {
: F G' s4 s, l4 ~, z1 l1 I - return price;) c' b: x6 l+ X [4 @, S: I7 f
- }- n+ b6 I r( \* F
- /**
" }$ C+ W" }" R1 |2 G' X5 ~: d - * 物资单价3 r1 @' u0 c* j2 ? L
- * @return
' M. K- ~; O& m& s+ j2 O3 c - */: R" q( d8 f1 z; F' `' n
- public void setPrice(int price) {/ @6 i# m7 U: j8 {9 q( ^. D
- this.price = price;# Q! B" n. F% B/ Q
- }
7 w) p6 ]3 x- v# L" ~) H! q" X1 C - /**9 j, ` z! S6 |: z
- * 生产厂商
. ] b$ u) T) T5 v6 O; I! x/ ~6 m - * @return0 Y( J8 ]+ H# V! L6 Y
- */
4 i) i8 q" \3 C7 w/ I" l0 c. D( N - public String getProducer() {
% W- j- ^2 ^& Z9 ~' M - return producer;- y$ H( E0 {8 K3 k( K
- }
A$ ?7 V0 t- a - /**
8 F$ @$ s$ o7 ~ R - * 生产厂商
8 X8 [7 h! Q8 {+ v W1 Y+ w- j6 M1 P - * @return
8 f" o: H# Y4 C* v4 e - */
' P5 J+ b6 K+ m6 U7 C1 w - public void setProducer(String producer) {, o& D N- c. @; b {( O
- this.producer = producer;
& q# Y4 Y- l7 l: a - }
$ ]8 y3 M( J9 f1 k3 O' `$ Z3 K. R$ k -
. F' T' ]9 U5 g( `9 a" Q - }2 M# k0 P( H) v5 ~
复制代码- package s2.jsp.zhangxiao.daoImpl;
8 H$ x/ n" u" W* [ - import java.sql.PreparedStatement;
* g6 y8 u% N: C0 b2 Y - import java.sql.ResultSet;/ V5 F; B; D% s
- import java.sql.Connection;
+ X' r. |6 H. l* w& z% L - import java.sql.SQLException;
, Z7 {# |- R/ F& M0 R) x# I - import java.util.ArrayList;
* v# E5 D/ v S+ I! ]: Y - import java.util.List;
6 L7 n* Q1 u* A* w5 g - P/ N X6 U% F/ @9 J5 p1 A1 d
- import s2.jsp.zhangxiao.dao.MaterialsBase;5 {" v2 |& F7 C) F1 `
- import s2.jsp.zhangxiao.dao.MaterialsDao;
4 M4 B$ h: }8 C1 ]/ X - import s2.jsp.zhangxiao.entity.Materials;+ a* V1 F" g* X$ z
- /**0 w% y' |( P V- j; g& e
- * 实现接口的方法
2 M9 D) f" J# [& z - * @author Administrator
7 q* }! ~5 u. o - *3 o* f' ^5 F* u2 y# d
- */
. w \6 E" U* X7 ^0 C7 t& k - public class MaterDaoImpl implements MaterialsDao {9 i% m$ s- X$ W- a2 A/ r
- /** W: W! Z N9 }% C( U* ?; f$ v7 B
- * 查询全部# o# F3 U f9 F" A
- */& b- [9 b0 ?4 _6 z4 g( \- Y
- public List materialsAll() {
8 D% U6 }& N" G$ o3 b. q6 K1 L - List list=new ArrayList();8 R) f( a6 P1 X% h2 h+ [1 F
- Connection con=null;9 [ L, `! L- v1 m2 I! g
- PreparedStatement past=null;
* i) ~# g4 h& Q2 I0 E - ResultSet rs=null;
/ K4 K# |* }: _( [- k2 @: f' U1 Y - //sql 语句* g2 T+ J, j4 a- w# _
- String sql="select * from materials";
* {- P9 c: E+ _9 z+ Q - //连接数据库
; r& ^8 J }) z* g. V( o& ]% I - con=MaterialsBase.GetConnection();
1 w* {4 q9 c% y! e h: @3 I - Materials materials=new Materials();
8 g8 d5 ?, Y8 e0 z - try {! r$ F D4 F3 o0 D) g. l, c1 Z0 u
- //传入sql
( W. ^6 G6 L* E# q! ]% m- h4 a1 A6 K - past=con.prepareStatement(sql);
# W: n5 I( v+ Q* d - //执行方法3 O/ x, L4 ~5 Z5 o
- rs=past.executeQuery();, _& \+ z7 c: H9 x; b) [2 G
- //循环读取数据
& G1 a) D4 u& V! @ V - while(rs.next()){
/ I( U# j$ Y) q% r$ X" I - // id, name, spec, number, price, producer' Z% y% k! R" U2 C
- //编号6 r% j, w$ s9 }' j" l- W) Q0 `
- // int id=rs.getInt("id");6 \7 \# a3 ~. X! |* O. h; ` ~" |
- // //名称
0 X+ b1 D5 c& j/ t) T - // String name=rs.getString("name");
6 l9 C c% n6 S" ~4 D7 v - // //规格- f% L" {5 t! ?# j/ q' D
- // String spec=rs.getString("spec");
4 s% @# L# Y! n4 r, k1 U& l6 n2 T6 F - // //数量
, y5 l+ M2 W4 x" b5 j, s3 [ - // int number=rs.getInt("number");! r% W$ W9 v/ x! D1 V
- // //单价+ x1 {+ R4 C+ Z& d. {) Q
- // int price=rs.getInt("price");
& K: Z7 ~: M. z1 J8 s& s. N - // //生产厂商7 M |+ w1 ?( G. v7 m9 T' S
- // String producer=rs.getString("producer");/ m C& h, Q; J2 j8 R
- // //添加到构造函数
" V$ D- x! s+ s! b% B - // Materials materials=new Materials(id, name, spec, number, price, producer);
. q2 i; |% g" p3 V; H - // //添加到list 集合( w8 o* j4 D4 O w' k
- materials.setId(rs.getInt("id"));
* O; k9 F9 i: Y - materials.setName(rs.getString("name"));
! D- _1 H& O0 E0 x; R# g% c2 v - materials.setPrice(rs.getInt("price"));
: ]* j$ S& t9 E% ~) j1 Q/ I - materials.setNumber(rs.getInt("number"));
/ M4 r T3 y" w/ w! q% o - materials.setSpec(rs.getString("spec"));
1 [9 P: E; u. M - list.add(materials);- c5 z* p4 d6 z Q7 r2 m
- } 6 t* i+ K8 g4 _# C' C) E
- } catch (SQLException e) {
3 j* M, j# P. L, q# ^# D - System.out.println("materialsAll 方法出现异常");
0 C7 m; I# J' y0 D4 u - e.printStackTrace();3 O$ k6 C1 X9 b! l6 b+ o0 n7 o! K
- }
+ r. Q; W4 p- ?5 m5 s" o. g -
9 b8 Q7 X' u3 Z: b* y+ ] - return list;
. k4 w, d' ]8 D% s" ~2 t - }
3 @: t$ I( @: d4 w - z. t5 `8 b7 `: X' W0 L
- /** I7 T) x/ G% F1 y
- * 根据id 查找物资信息
% }1 u: C- k7 i - */
8 g6 [' u3 x. R - public Materials materialsID(int id) {1 {$ }) c( H4 t
- //声明物资类
9 Y0 @% b/ [7 ] - Materials materials=null;
3 s; R' A9 o7 ]" \9 W, M. J - Connection con=null;0 c8 _ p) b6 k K1 d
- PreparedStatement past=null;
! r$ I3 I3 S' h- ^6 m# I - ResultSet rs=null;* C( w; z# O: P* | D% d7 a
- //sql 语句9 ~8 ~1 y! b+ D( Z/ B
- String sql="select * from materials where id="+id;+ A9 u* h- k; s7 @, x/ ?
- //数据库 连接
" ~( \2 Z. `! ]6 R* ] - con=MaterialsBase.GetConnection();
; ]- y# m+ K+ g+ R' _7 M. V - try {& c- d1 z% J; u8 n$ O6 e3 _& g/ f% `
- //传入sql
n% F% N6 z/ j0 m$ A+ @* w) N9 m; T - past=con.prepareStatement(sql);
1 b2 w7 W! l2 q" _" l$ i) }; a" u - //执行方法/, P- j: S% T1 o( |5 z& t
- rs=past.executeQuery();
! m; J& a" z: g& k% n' _ - materials=new Materials();4 d2 @2 D; i, P' {
- //读取数据
% i- D* e3 S) k" e: ~7 T - if (rs.next()) {
+ g: m( K1 `6 i9 k( d( n+ ?* T - //名称
, B# _# P) S! ?) R5 i( f - materials.setName(rs.getString("name"));
6 H: l% R; x1 f/ y" {, ~ T& a' l - //规格
5 G- Z9 N* N8 q5 Y9 j3 T$ ? - materials.setSpec(rs.getString("spec"));
O0 {; F' N# A3 | - //数量9 O6 j9 a& K% a0 i4 X! E" n# i2 k
- materials.setNumber(rs.getInt("number"));0 I7 X; i' ~9 c: w/ Y9 k
- //单价7 ?" M* p m8 R P
- materials.setPrice(rs.getInt("price"));# z. v% A1 ~0 P- y+ w% |
- //生产厂商; `. u+ I/ a, h. L5 O0 B$ B8 `
- materials.setProducer(rs.getString("producer"));
3 j9 P" @/ D7 z1 ?+ c - }3 n8 D* M4 e2 s& y: C, i7 A8 l2 [
- } catch (SQLException e) {( O9 ~' O' |3 S
- System.out.println("materialsID 方法异常");
0 t5 I$ Q5 v/ m$ }( U2 m7 T7 b% v - e.printStackTrace();
3 ]; v u3 I- P8 m d6 x: c - }finally/ j" I1 D: D, k6 b' u( y
- {
+ B& g. D" ]9 r, r* P - MaterialsBase.CloseAll(con, past, rs);& @" J+ @7 b! \6 T. F
- }
* r/ y, m& V- t, s4 w' A( m' L - return materials;
; c$ L3 C* A: {+ A# l, } - }1 P3 z3 b; [& L0 `
- /**
6 k7 g9 c$ V9 Z! `: _ - * 更新物资信息
) i B ~- ]7 o2 K& s: R - */, G. ~1 ?# @0 R1 I& ^6 v: R ]' J
- public int materialsUpdate(Materials materid) {! n& j+ w D) n4 H
- //sql 语句
! f$ @! e8 a# k R. b. D - String sql="update materials set number=?,price=? where id=?"; _! B6 {; v, @1 Z, _
- //
2 y0 A. U" L# M- q! r - String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};
# i" {/ V. J' S$ u9 B - return MaterialsBase.ExecutUpdate(sql, getValues);
/ W1 v" O. t2 f# Q# c - }
* }" j& Y: b/ j' C" Q z- X - ( O' S# a8 e8 q3 {$ [7 H" F& J
- }* }) e+ m# B( D8 Z2 k
复制代码
0 t" y8 [: M; u& C代码案例下载:点击下载
. j( x! O$ ~" Y: }1 [
$ I* O3 V- h4 ]# x# c8 U7 ~ |
|