该用户从未签到
|
- package s2.jsp.zhangxiao.entity;
4 C' ^2 m% T. M0 A* m( M - /**
8 y" o7 x. { g, E0 f3 _+ a3 E - * 物资实体类% T: b7 z5 e9 {+ ~ `& x
- * @author Administrator' X; q% a% _ t+ ]9 b, O; D4 W/ ]
- *
8 b7 w* v0 _- X* m' _1 X- A - */& T$ O0 A* p w/ \3 j; y) _6 O
- public class Materials {
) U/ a2 A# B" d0 L% | - // id, name, spec, number, price, producer9 \5 B8 d7 m0 S$ w
- private int id;
8 V* h( p6 H# _$ `/ k7 O3 j; I6 b - private String name;
' [2 ~/ ^; e& G - private String spec;
* k' J+ b& Y% K* c, L: Q( t3 k - private int number;. c& E6 r" n1 g8 J6 v( U* Y" q% ]
- private int price; r0 w/ A$ o* m" X5 b: w; N
- private String producer;
4 `- j1 m1 V- f0 A/ Q* J. r - /**
0 N% C' o# D+ [: j5 e+ [: D1 | - * 有参构造函数) F+ B" d% q( D7 o& ?( C
- * @param id- j& L8 w$ }4 m5 j7 C
- * @param name
5 A* W# v4 F5 ~2 ]1 { - * @param spec
0 S# R0 K4 G5 h2 o& k - * @param number: N1 u5 M/ f+ i% ~8 |5 D- j
- * @param price
( G% i5 ^" O* V; `# |! \ - * @param producer8 c* y" D3 q0 n) o
- */( m. E! T( {) j$ l2 Z, y9 ^
- public Materials(int id, String name,String spec ,int number,int price, & Z( s, I6 `: U% K: A) ~
- String producer ) {
- n! O9 E( l# o- O3 J3 J - super();0 w% w7 `( {6 W- ~" f% e g6 k
- this.id = id;
: l& \: v4 C- ^& G - this.name = name;% n6 o' C1 m& k& _
- this.number = number;0 N9 H5 V5 {2 V; M( U& ` {9 n
- this.price = price;
# {' m: q4 }, y* Y - this.producer = producer;0 K$ W) Y# o) F5 `+ O& L& m. ~
- this.spec = spec;
: d+ L( e. {! i! o8 }0 H( Z7 g - }$ m: S' Z+ \. d. m, v" o
- /**1 i3 n8 I) J; A; Q7 y9 a9 q8 G0 _
- * 无参构造函数" `: u% L+ s, u& G+ K- J" L
- */5 e, o: e+ L6 T; g3 @& E. C# w
- public Materials() {
' n1 j3 `, |0 i# I2 d$ T6 Z - super();
# N7 S; Z' E- P/ w7 P7 Y% B z - }+ F3 O' W* H4 h$ C9 v
- /**
1 ^8 w2 S1 m" a/ @; n - * 编号
8 H) h4 B; r! ^7 t - * @return
J# f* l1 J+ ?! x) M4 {3 V3 K* s7 G - */
8 Z0 L4 [2 H( W* F. D1 H - public int getId() {
8 Y9 X# T& F! R7 M - return id;: ]! a1 t$ F' j6 n, K; l
- }
; a! e3 _4 K. b, c - /**; {# u+ @ A0 w. L7 D1 D
- * 编号6 P& x4 g, {$ F0 x9 P
- * @return
0 i4 L0 o1 x8 @1 i8 z. P" ?. ] - */
: G5 j7 \$ ?2 K1 z. {" L - public void setId(int id) {7 M5 H" ]5 b6 \( D& M/ w5 }6 \
- this.id = id;
3 R' x6 g" N k+ r& e% P+ _( p - }
) g3 a. ^. ~" L9 u( T k& d+ Y - /**
% o, s) \) q! w' b2 y1 U0 A, _& } - * 物资名称
0 |5 ]( y' s/ H8 a2 ^3 @' \" O - * @return- e7 i U0 M& G2 h3 V* M
- */9 h' u4 q. ~# H
- public String getName() {; F6 b# B# G' j6 g( E+ K7 x
- return name;
: C! I# t# m: U - }
' L" i; N+ v. r! o4 n8 ` - /**' x! g6 F- h4 `- P0 U! [
- * 物资名称
; a+ s2 T5 M. }$ h% p" \* U, A - * @return9 u; l) x& T" M1 K' A* _
- */& T0 x+ o K) g `5 [
- public void setName(String name) {7 L l I) z' Z
- this.name = name;
9 H5 z1 u8 ^0 U+ \" L' { - }3 E# D4 B5 i8 D9 A1 O1 S8 L: m
- /**
: _8 r5 t7 P& C6 M( ?: @* \ - * 物资规格% d% A& b, y4 i# e
- * @return2 N a7 V) Q: {5 u& q: J' {
- */: D+ d* t' Y' ^! Y! A# f1 q5 N+ h) U
- public String getSpec() {
& u, C6 I" L5 P& X - return spec;
0 a8 D& A: \2 V0 v - }
2 x6 Y# G! v1 P) J - /** B9 N( ^. O! @& s7 o& e7 p
- * 物资规格1 Q8 u6 G! t! Z* t4 X' d* ^; D
- * @return
' s, _) y! Q6 _) d! m% G& t* \ - */
1 V( P% Q" U8 N+ M) r) O - public void setSpec(String spec) {
. c# ?# [' i+ n2 i, n/ J - this.spec = spec;5 ^8 c- b1 ]0 h- f* g
- }
3 I: @3 N7 g. d1 u9 z7 k4 X0 }# z - /**4 L4 @7 L1 n) {
- * 物资数量
W% Z4 A. |% _+ ^+ z# u - * @return
9 A1 H$ N8 R' T& z0 {0 }, \/ Y - */
1 A4 ^5 U% R9 ~: ?* j# G - public int getNumber() {8 y, R# J4 P K' @& S
- return number;
# g) x; Y# ~' u. V4 H3 ?; p - }/ \! g) ]7 Q3 U* l9 X9 _2 H% G
- /**$ p' U/ H1 U3 b# D
- * 物资数量/ Q% I! M4 m2 B( |" Z/ n& r
- * @return1 b1 R! x$ |8 g- s( [) ?
- */
2 F5 ~) K" O5 i; c7 u% V* |: i - public void setNumber(int number) {
; b" ]0 P, k9 f x' e4 {; m" b2 S* t - this.number = number;1 {3 n) B7 g4 ~; d: D& X9 {
- }
3 J) s) j4 z6 j2 `$ | - /**
5 e: B9 e9 D3 {8 Y/ a4 v* A - * 物资单价
& ?0 R7 f# F4 m$ z - * @return
' I* O6 g0 u# y; N* D& q1 e - */
& \( k0 R9 _- O - public int getPrice() {, `7 s2 r8 C( E8 e/ g: V
- return price;0 K, J C/ z9 ?% ~
- }
% P5 u# a8 c: T2 Q; b - /**
* l. @. X/ ~4 O) z9 q& p# ^- _ - * 物资单价
3 y: W; Y% i7 r - * @return
8 l5 N" Z2 u& D, m - */
9 R$ f( A, k- l - public void setPrice(int price) {
' Y) Y7 R F- ]5 n/ U - this.price = price;' d/ F( g/ |5 i9 n, g, i0 _! B9 R
- }" j/ D3 R. b E3 x5 W! ?
- /**
' v2 d9 J$ o6 A* A( ` - * 生产厂商" f( l9 F" ~. G+ p3 E' N& d
- * @return: f, z9 v- s; u+ o4 b
- */" [9 P2 S6 D1 d" s2 }
- public String getProducer() {! ^' K" ]' r q" E: Q9 L k
- return producer;
S/ l5 Q- Y ~5 d3 l2 P, x - }- _# J; \! H J; F3 f* d: T
- /**
& H8 C% j' l' o( U - * 生产厂商
3 t4 W! p! o( W/ Z5 E4 C - * @return. q( s" M2 w- l) B# i) R
- */. |- r- t0 @; S. O. _% w1 G
- public void setProducer(String producer) {& I) U! X: ^5 `' C3 }1 H
- this.producer = producer;: ?* @) u2 |- {2 F9 r! Z- D
- }1 s! J7 |, L) ]8 N5 t2 [5 @
-
5 m: n2 }5 _& u& e9 }+ s - }9 \9 Y/ P5 A1 n# z
复制代码- package s2.jsp.zhangxiao.daoImpl;
8 X. T9 J8 x+ W% D2 S" D( c - import java.sql.PreparedStatement;( v V, S9 H5 k, ?! I
- import java.sql.ResultSet;
- T) r$ x- n- m7 C+ _ - import java.sql.Connection;
$ w+ {- d5 \- u8 P h7 r - import java.sql.SQLException;
" v8 l7 W; d* I/ \ - import java.util.ArrayList;9 K! B; W- \/ }9 M) i
- import java.util.List;
+ H/ T5 h/ U {, I8 S
# e8 `$ x2 B, a+ x- import s2.jsp.zhangxiao.dao.MaterialsBase;% P' h6 N: g" B' Z. q
- import s2.jsp.zhangxiao.dao.MaterialsDao;
6 u+ W" \! l5 W+ d - import s2.jsp.zhangxiao.entity.Materials;9 q" c- C% C7 l
- /**
) k, z# \4 Y j" W* T - * 实现接口的方法, ?- J c8 `5 ]% ]6 R- {
- * @author Administrator6 E8 l: q0 N# d& e* D/ `4 e! a
- *
! {' B" ^+ d: _$ D2 y/ b* S - *// P2 X9 S0 T, b. Y& }7 U& c
- public class MaterDaoImpl implements MaterialsDao {2 @: H+ l, ^2 [
- /**1 N$ C( `9 i0 V6 d
- * 查询全部( i% F$ r$ c& G' ^; G
- */) M" B% l8 _ J. u F
- public List materialsAll() {
. M E! t# l$ [ - List list=new ArrayList();
' Q5 n' d6 h, R5 K7 H% | - Connection con=null;
% W- z4 ?% p3 H - PreparedStatement past=null;8 [( F, n1 ?) E) t3 S5 L3 v
- ResultSet rs=null;2 v, F! t0 q- }" m5 V
- //sql 语句
' ^3 e- _# |. O+ B& \ - String sql="select * from materials";
! e) _$ x: Q' |" f6 e+ X& N1 Z - //连接数据库
+ d7 S: x5 Z7 t' [. z* K" T - con=MaterialsBase.GetConnection();- y4 C O1 L; O6 X- R
- Materials materials=new Materials();
$ x4 G0 D. M5 a, T8 t - try {
- D! U) A1 e" X9 K: ~ W - //传入sql
: }5 ~: p0 _; b4 _# W& W - past=con.prepareStatement(sql);
, D/ N' E3 q' S+ F - //执行方法' O# c* l" Q% U
- rs=past.executeQuery();
* R, U- a. f- J, D4 F0 j - //循环读取数据* o" O* Z# ?+ s& G$ r
- while(rs.next()){) ~ p9 S g& y% G6 C, ~: B) b
- // id, name, spec, number, price, producer1 x& a: w% _- v! d4 d
- //编号
4 I# \! M2 |9 o* d- L7 L - // int id=rs.getInt("id");
7 `# B# q$ U- v% U& d+ i - // //名称8 ]8 Y& A( d& }% g+ N, z, o
- // String name=rs.getString("name");
3 m) q$ H8 ]$ y2 u - // //规格
1 u, L( S: L$ @3 q- ~$ ? - // String spec=rs.getString("spec");
; @3 s+ B& F6 P, B7 K2 q6 x - // //数量( \3 e. a7 H. Z( u/ Y% H( y
- // int number=rs.getInt("number");8 A3 x U& y2 F9 R
- // //单价$ L! o0 ]" ^$ N' n0 O
- // int price=rs.getInt("price");$ b2 |, M7 `( A9 S3 a' C
- // //生产厂商0 ^- X# A/ v$ G: B
- // String producer=rs.getString("producer");' _2 D j: n" u* V3 G* U/ [
- // //添加到构造函数. n% J0 I$ v, M+ u
- // Materials materials=new Materials(id, name, spec, number, price, producer);' F! C2 ?" C$ r6 ?' j+ Q
- // //添加到list 集合
6 w5 s) l6 r5 J1 \& K - materials.setId(rs.getInt("id"));3 E! A- G, X) D9 [! d
- materials.setName(rs.getString("name"));7 J& N* Z- E6 u4 m" Q
- materials.setPrice(rs.getInt("price"));0 r. `$ q$ ^" w4 @
- materials.setNumber(rs.getInt("number"));
' Y8 R! h, ~9 c - materials.setSpec(rs.getString("spec"));0 z4 m1 L. v/ y3 @, [/ b9 n
- list.add(materials);* {+ s6 C' {1 W( \6 U0 h/ b. f
- } 2 m3 f& O' ]. o% E, m0 F* C
- } catch (SQLException e) {/ v" `+ z% x) e5 _$ V
- System.out.println("materialsAll 方法出现异常");# @6 d+ ?4 P$ A; D6 P
- e.printStackTrace();
9 W- K1 @5 m- y! t; r - }) e6 D8 z) Q, R: W3 K* X @
-
5 u* W3 i, \, g - return list;
1 g& X# j$ E) Z/ W, V4 q2 L) z2 E - }9 A# o7 C0 [" f! `0 W, d
-
+ a5 @, B' Y0 V9 h - /**
5 x0 m2 O0 P5 e8 R4 f - * 根据id 查找物资信息6 j5 l+ K$ ]6 b9 J% I. Z
- */- i/ d8 ?: X. L
- public Materials materialsID(int id) {' S2 ]5 C5 T$ ]; l0 c" k" O% @
- //声明物资类
8 R6 B& l3 |2 f5 H! X6 t5 k - Materials materials=null;
" [' l2 E0 B# X, Y - Connection con=null;
7 y; {8 d/ ~5 y/ S2 u - PreparedStatement past=null;, j& f/ l- z0 }7 q7 \9 r' H# @
- ResultSet rs=null;7 X) l% |: n$ k0 \1 D; n
- //sql 语句7 v+ I6 c$ [, p- Q+ A
- String sql="select * from materials where id="+id;; R. p1 n0 A! K, @7 @; w
- //数据库 连接 i+ {4 _: K. U! {6 p/ [
- con=MaterialsBase.GetConnection();
5 f$ o# P7 r" d. G; M/ u) F - try {
; r5 w: m; k* [: T$ j; F: K$ _8 V - //传入sql* _( E( g' R: I( w0 s0 z
- past=con.prepareStatement(sql);4 u# P/ m9 R3 [ p: |* \8 m1 u+ _
- //执行方法/
0 e! N: L$ `- H4 t - rs=past.executeQuery();7 S- [% p- Y4 h8 ^
- materials=new Materials();- {, b2 G% {: P2 b# l. i1 I" v
- //读取数据
^5 P# ]% a0 F. | - if (rs.next()) {
% M7 ?5 X/ {5 K" Z - //名称: U; O1 |7 {5 p, U0 ?3 r
- materials.setName(rs.getString("name"));
4 Y2 `9 E( O1 D: g1 H! g- c0 B - //规格) P7 d3 d, q- L
- materials.setSpec(rs.getString("spec"));
/ \. c! i5 e) o6 M- @; i$ P - //数量
: v4 S; d _1 E2 u* F: R) l. ^ - materials.setNumber(rs.getInt("number"));$ v3 }& D1 j+ _" Y9 P$ t5 y: `- j
- //单价
0 O9 j: v7 K- e - materials.setPrice(rs.getInt("price"));: j) `7 L. X( I) X; o, [
- //生产厂商: N3 m% r1 M$ Y; Q
- materials.setProducer(rs.getString("producer"));
$ W0 v3 q$ I' R. S' `: q% q - }
* {" o! K" L! \% j4 j - } catch (SQLException e) {
; T' k, L: l! A3 \, K6 _ - System.out.println("materialsID 方法异常");9 l2 t4 S& n) h! y" Q! V0 S w( q
- e.printStackTrace();
3 ?, l8 x7 {. {" e" \# V6 [ - }finally
# z; ~6 b: Q! a, L - {
% s! k) Z8 V) Y2 ]# ^ - MaterialsBase.CloseAll(con, past, rs);) o/ _5 F6 ` `0 C: M
- }
) s9 ^: w9 m% n d2 G8 S6 X - return materials;
6 L, r. a- w2 L, X$ K - }0 d! ]( @8 G- a# G
- /**
) U$ r" D- ?7 E) G3 O \ - * 更新物资信息0 K/ s9 I) `: x4 T4 j1 [5 |8 W8 |% A
- */" A1 r- b6 S" ]$ p
- public int materialsUpdate(Materials materid) {
/ ~! ?4 Y7 X2 \ - //sql 语句
' P6 I1 X* ^, K% ?! l# P' t - String sql="update materials set number=?,price=? where id=?";
" U2 }, B% O; i( B- D, P( I: N - //
! q' g$ N# V! a: _, `$ T - String[]getValues={materid.getNumber()+"",materid.getPrice()+"",materid.getId()+""};. u/ y- N; ~% Q9 T" O6 E \
- return MaterialsBase.ExecutUpdate(sql, getValues);
+ d0 d$ v+ q2 `; | - }. C6 C; g( m- P; W0 u
+ Q. y8 z$ c2 R; A1 n( A6 P% H% }- }9 P$ C# U) u$ ^" H
复制代码
; Y7 c8 ]- R" f$ \: P代码案例下载:点击下载
3 A" P, c; b$ ?2 U6 L& [5 W3 r) C. q" @( \. r
|
|