医药销售系统java课程设计报告

1、 面向对象程序设计面向对象程序设计实验报告实验报告题题 目目 医药销售系统医药销售系统 学学 院院 商学院商学院 专专 业业 信息管理与信息系统信息管理与信息系统 班班 级级 *班班 学学 号号 201052275* 学生姓名学生姓名 * 指导教师指导教师 * 编写日期编写日期 2013 年年 1 月月 5 号号 目目 录录一、需求分析一、需求分析.11.1 功能需求.11.2 性能需求.11.3 数据需求.1二、系统运行环境二、系统运行环境.1三、系统总体设计三、系统总体设计.23.1 登录界面.23.2 系统功能.2四、数据库设计四、数据库设计.34.1 概念结构设计.34.2 逻辑结构设

2、计.34.3 物理结构设计.44.3.1 用户信息表 users.44.3.2 药品信息表 medicineinfos .44.3.3 订单信息表 wholesaleinfo.6五、程序模块设计五、程序模块设计.65.1 运行界面及其效果图.65.2 程序代码.8六、总结六、总结.22七、参考资料七、参考资料.220一、一、需求分析需求分析根据课题调查和分析用户的业务活动、信息和处理的需求，以及各种数据之间的约束条件关系，形成以下的系统的需求说明。1.11.1 功能需求功能需求（功能划分，功能描述）（功能划分，功能描述）login.java 实现注册和登录功能。注册，将用户姓名和密码写入数据库

3、用户表（users） ，并反馈给注册用户。登录，按照用户填写的用户名和密码，在数据库中查找相关信息，如果匹配则提示登录成功，并转至药品管理系统的管理界面。否则提示登录失败。managemain.java 实现用户管理界面功能选择。在功能选择界面中可以选择添加、删除、修改、查询和统计药品信息，并且可以选择售出药品。insmedicineinfo.java 实现添加药品信息功能。在这一模块中，可以将药品信息填写保存到数据库药品信息表（medicineinfo）中。并返回操作状态。delmedicineinfo.java 实现分别按药品编号或药品名称删除指定药品信息，被删除的药品信息将从药品信息表中

4、删除。并返回操作状态。updmedicineinfo.java 实现按药品编号更新药品信息功能。被修改的药品信息在数据库中也被相应修改。并返回操作状态。quemedicineinfo.java 实现分别按药品编号或药品进价范围查询药品信息。数据库中符合条件的药品信息将被显示在查询界面的文本域中。stamedicineinfo.java 实现统计数据库中药品信息。统计的药品信息将显示在统计药品信息界面，以表格的形式呈现。salmedicineinfo.java 实现出售药品功能。填写药品编号和售出数量，并生成订单信息。出售药品订单信息将被存入到数据库药品订单信息表（wholesaleinfo）中

5、。1.21.2 性能需求（性能需求（软件适应性和移植性等）软件适应性和移植性等）在 windows 平台测试无误。使用 sql server 2008 数据库。可用于一般的药品信息管理。1.31.3 数据需求数据需求（数据之间的依赖和约束关系）（数据之间的依赖和约束关系）本药品信息管理系统共有三张表，一张为独立的用户信息表（users） ，用于管理用户信息。其余两张为药品信息表（medicineinfo）和订单信息表（wholesaleinfo） 。二、系统运行环境二、系统运行环境 本课题是在 sql server 2008、netbeans6.9.1 环境下运行的。1三、系统总体设计三、系统

6、总体设计 3.13.1 登录界面登录界面注册信息用户登录登录界面2 3.23.2 系统功能系统功能药品管理系统药品管理功能添加药品信息删除药品信息修改药品信息查询药品信息统计药品信息出售药品功能34四、数据库设计四、数据库设计4.1 概念结构设计概念结构设计用户表用户名用户密码药品信息表药品编号药品名称药品通称药品规格药品类别药品进价药品批发价药品库存量药品订单表订单编号药品编号批发药品数量外键约束54.2 逻辑结构设计逻辑结构设计usersusernameuserpasswordmedicineinfomednumber mednamemedshortnamemednorsmedcateme

7、dinpricemedwholesalemedcountwholesaleinfowsnumbermednumberwsmedcount64.3 物理结构设计物理结构设计4.3.1 用户信息表 usessql：/*=*/* table: users */*=*/create table users ( username varchar(10) not null, userpassword varchar(20) null, constraint pk_users primary key (username)goinsert into users values(aa,bb);if exists

8、(select 1 from sysobjects where id = object_id(users) and type = u) drop table usersgo4.3.2 药品信息表 medicineinfosql：/*=*/* table: medicineinfo */*=*/7create table medicineinfo ( mednumber varchar(8) not null, medname varchar(40) not null, medshortname varchar(10) null, mednors varchar(4) null, medcate

9、 varchar(20) null, medinprice float not null, medwholesaleprice float not null, medcount int not null, constraint pk_medicineinfo primary key (mednumber)goinsert into medicineinfo values(95270001,葵花牌感冒灵颗粒,葵感,16*2,感冒药,24.7,25.8,1000);insert into medicineinfo values(95270002,双黄连口服液,双黄连液,12*1,感冒药,29.2,

10、30.1,1000);insert into medicineinfo values(95270003,阿莫西林,莫西,1*1,消炎药,30,32.1,1000);insert into medicineinfo values(95270004,吗丁啉,吗丁啉,1*1,胃肠道药,18.2,20,498);insert into medicineinfo values(95270005,对乙酰氨基酚 ,扑热息痛,1*1,感冒药,24.7,25.8,698);insert into medicineinfo values(95270006,川贝枇杷膏,枇杷膏,1*1,止咳药,21,22.8,900

11、);if exists (select 1 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = f) where r.fkeyid = object_id(wholesaleinfo) and = fk_wholesal_reference_medicine)alter table wholesaleinfo drop constraint fk_wholesal_reference_medicinegoif exists (select 1 from sysobject

12、s where id = object_id(medicineinfo) and type = u) drop table medicineinfogo84.3.3 订单信息表 wholesaleinfosql：/*=*/* table: wholeinfo */*=*/create table wholesaleinfo ( wsnumber varchar(8) not null, mednumber varchar(8) null, wsmedcount int not null, constraint pk_wholesaleinfo primary key (wsnumber)goi

13、f exists (select 1 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = f) where r.fkeyid = object_id(wholesaleinfo) and = fk_wholesal_reference_medicine)alter table wholesaleinfo drop constraint fk_wholesal_reference_medicinegoif exists (select 1 from sysobjects w

14、here id = object_id(wholesaleinfo) and type = u) drop table wholesaleinfogoalter table wholesaleinfo add constraint fk_wholesal_reference_medicine foreign key (mednumber) references medicineinfo (mednumber)go五、五、程序模块设计程序模块设计 5.1 运行界面及其效果图运行界面及其效果图1.功能选择界面点击“增加”按钮，跳转到增加药品信息界面；9点击“删除”按钮，跳转到删除药品信息界面；点击

15、“修改”按钮，跳转到修改药品信息界面；点击“查询”按钮，跳转到查询药品信息界面；点击“统计”按钮，跳转到统计药品信息界面；点击“出售”按钮，跳转到出售药品信息界面。 2.删除药品信息界面按药品编号删除药拼信息：按药品名称删除药品信息：3.查询药品信息界面10按药品编号查询药品信息：按药品进价范围查询药品信息： 4.出售药品信息界面 出售成功并生成订单写入到数据库药品订单信息表（wholesaleinfo）中：5.2 程序代码程序代码 managemain.javaimport java.awt.event.actionevent;import java.awt.event.actionlist

16、ener;import javax.swing.*;11public class managemain extends jframe private static final long serialversionuid = 1l;jlabel title=new jlabel(-请选择您的操作 -);jlabel insmedicineinfo=new jlabel(增加药品信息：);jbutton btinsinfo=new jbutton(增加);jlabel delmedicineinfo=new jlabel(删除药品信息：);jbutton btdelinfo=new jbutton

17、(删除);jlabel updmedicineinfo=new jlabel(修改药品信息：);jbutton btupdinfo=new jbutton(修改);jlabel quemedicineinfo=new jlabel(查询药品信息：);jbutton btqueinfo=new jbutton(查询);jlabel stamedicineinfo=new jlabel(统计药品信息：);jbutton btstainfo=new jbutton(统计);jlabel salmedicineinfo=new jlabel(出售药品管理：);jbutton btsalinfo=new

18、 jbutton(出售);public managemain() super(药店管理系统-功能);this.title.setsize(200, 30);this.title.setlocation(200,10);this.insmedicineinfo.setsize(100,30);this.insmedicineinfo.setlocation(80,50);this.btinsinfo.setsize(60,30);this.btinsinfo.setlocation(190,50);this.delmedicineinfo.setsize(100,30);this.delmedi

19、cineinfo.setlocation(260,50);this.btdelinfo.setsize(60,30);this.btdelinfo.setlocation(360,50);this.updmedicineinfo.setsize(100,30);this.updmedicineinfo.setlocation(80,90);this.btupdinfo.setsize(60,30);this.btupdinfo.setlocation(190,90);this.quemedicineinfo.setsize(100,90);this.quemedicineinfo.setloc

20、ation(260,60);this.btqueinfo.setsize(60,30);this.btqueinfo.setlocation(360,90);this.stamedicineinfo.setsize(100,30);this.stamedicineinfo.setlocation(80,130);this.btstainfo.setsize(60,30);this.btstainfo.setlocation(190,130);this.salmedicineinfo.setsize(100,30);this.salmedicineinfo.setlocation(260,130

21、);this.btsalinfo.setsize(60,30);this.btsalinfo.setlocation(360,130);12this.setlayout(null);this.getcontentpane().add(title);this.getcontentpane().add(insmedicineinfo);this.getcontentpane().add(btinsinfo);this.getcontentpane().add(delmedicineinfo);this.getcontentpane().add(btdelinfo);this.getcontentp

22、ane().add(updmedicineinfo);this.getcontentpane().add(btupdinfo);this.getcontentpane().add(quemedicineinfo);this.getcontentpane().add(btqueinfo);this.getcontentpane().add(stamedicineinfo);this.getcontentpane().add(btstainfo);this.getcontentpane().add(salmedicineinfo);this.getcontentpane().add(btsalin

23、fo);/-添加药品信息注册事件-/btinsinfo.addactionlistener(new actionlistener()overridepublic void actionperformed(actionevent e) / todo auto-generated method stubinsmedicineinfo insmedicineinfo=new insmedicineinfo();insmedicineinfo.show(););/-删除药品信息注册事件-/this.btdelinfo.addactionlistener(new actionlistener()over

24、ridepublic void actionperformed(actionevent e) / todo auto-generated method stubdelmedicineinfo delmedicineinfo=new delmedicineinfo();delmedicineinfo.show(););/-修改药品信息注册事件-/this.btupdinfo.addactionlistener(new actionlistener()overridepublic void actionperformed(actionevent e) / todo auto-generated m

25、ethod stubupdmedicineinfo updmedicineinfo=new updmedicineinfo();updmedicineinfo.show(););/-查询药品信息注册事件-/this.btqueinfo.addactionlistener(new actionlistener()override13public void actionperformed(actionevent e) / todo auto-generated method stubquemedicineinfo quemedicineinfo=new quemedicineinfo();quem

26、edicineinfo.show(););/-统计药品信息注册事件-/this.btstainfo.addactionlistener(new actionlistener()overridepublic void actionperformed(actionevent e) / todo auto-generated method stubstamedicineinfo stamedicineinfo=new stamedicineinfo();stamedicineinfo.show(););/-出售药品信息注册事件-/this.btsalinfo.addactionlistener(ne

27、w actionlistener()overridepublic void actionperformed(actionevent e) / todo auto-generated method stubsalmedicineinfo salmedicineinfo=new salmedicineinfo();salmedicineinfo.show(););this.setsize(550,230);this.setresizable(false);this.setdefaultcloseoperation(jframe.exit_on_close);this.setvisible(true

28、);public static void main(string args) new managemain();delmedicineinfo.javaimport java.awt.event.actionevent;import java.awt.event.actionlistener;import java.sql.connection;import java.sql.drivermanager;import java.sql.statement;import javax.swing.*;public class delmedicineinfo extends jframeprivat

29、e static final long serialversionuid = 1l;14jlabel labtitle=new jlabel(-请选择删除药品信息的方法-);jlabel labmednumber=new jlabel(请输入药品编号:);jtextfield txtmednumber=new jtextfield();jbutton btnmednumber=new jbutton(确定);jlabel labmedname=new jlabel(请输入药品名称：);jtextfield txtmedname=new jtextfield();jbutton btnmedna

30、me=new jbutton(确定);jbutton btnquit=new jbutton(取消);public delmedicineinfo()super(药店管理系统-删除);this.labtitle.setsize(200,30);this.labtitle.setlocation(80,10);this.labmednumber.setsize(110,30);this.labmednumber.setlocation(50,50);this.txtmednumber.setsize(100,30);this.txtmednumber.setlocation(160,50);th

31、is.btnmednumber.setsize(60,30);this.btnmednumber.setlocation(270,50);this.labmedname.setsize(110,30);this.labmedname.setlocation(50,90);this.txtmedname.setsize(100,30);this.txtmedname.setlocation(160,90);this.btnmedname.setsize(60,30);this.btnmedname.setlocation(270,90);this.btnquit.setsize(60,30);t

32、his.btnquit.setlocation(150,130);this.setlayout(null);this.getcontentpane().add(labtitle);this.getcontentpane().add(labmednumber);this.getcontentpane().add(txtmednumber);this.getcontentpane().add(btnmednumber);this.getcontentpane().add(labmedname);this.getcontentpane().add(txtmedname);this.getconten

33、tpane().add(btnmedname);this.getcontentpane().add(btnquit);/-按药品编号删除的注册事件处理-/this.btnmednumber.addactionlistener(new delnumberactionlistener(this);/-按药品名称删除的注册事件处理-/this.btnmedname.addactionlistener(new delnameactionlistener(this);/-取消按钮事件注册-/this.btnquit.addactionlistener(new quitdelactionlistener(

34、this);this.setsize(400,200);this.setresizable(false);this.setdefaultcloseoperation(jframe.exit_on_close);15this.setvisible(true);public static void main(string args) new delmedicineinfo();public void delnumberactionperformed(actionevent e)string mednumber=txtmednumber.gettext();tryclass.forname(com.

35、microsoft.sqlserver.jdbc.sqlserverdriver);catch (classnotfoundexception e1) joptionpane.showmessagedialog(null,驱动未找到！);trystring url=jdbc:sqlserver:/localhost:1433;databasename=medicinemanage;string dbname=sa;string dbpassword=pwd;string sql=delete from medicineinfo where mednumber= +mednumber+;conn

36、ection conn=drivermanager.getconnection(url,dbname,dbpassword);statement stmt=conn.createstatement();stmt.executeupdate(sql);joptionpane.showmessagedialog(null,药品编号为+mednumber+的药品删除成功！);this.setvisible(false);catch(exception e1)e1.printstacktrace();joptionpane.showmessagedialog(null,按编号删除药品信息有误！);pu

37、blic void delnameactionperformed(actionevent e)string medname=txtmedname.gettext();tryclass.forname(com.microsoft.sqlserver.jdbc.sqlserverdriver);catch (classnotfoundexception e1) joptionpane.showmessagedialog(null,驱动未找到！);trystring url=jdbc:sqlserver:/localhost:1433;databasename=medicinemanage;stri

38、ng dbname=sa;string dbpassword=pwd;string sql=delete from medicineinfo where medname like %+medname+%;16connection conn=drivermanager.getconnection(url,dbname,dbpassword);statement stmt=conn.createstatement();stmt.executeupdate(sql);joptionpane.showmessagedialog(null,药品名称为+medname+的药品删除成功！);this.set

39、visible(false);catch(exception e1)e1.printstacktrace();joptionpane.showmessagedialog(null,按名称删除药品信息有误！);public void quitdelactionperformed(actionevent e)this.setvisible(false);class delnumberactionlistener implements actionlistenerdelmedicineinfo delmedicineinfo;public delnumberactionlistener(delmed

40、icineinfo delmedicineinfo)this.delmedicineinfo=delmedicineinfo;overridepublic void actionperformed(actionevent e) / todo auto-generated method stubdelmedicineinfo.delnumberactionperformed(e);class delnameactionlistener implements actionlistenerdelmedicineinfo delmedicineinfo;public delnameactionlist

41、ener(delmedicineinfo delmedicineinfo)this.delmedicineinfo=delmedicineinfo;overridepublic void actionperformed(actionevent e) / todo auto-generated method stubdelmedicineinfo.delnameactionperformed(e);class quitdelactionlistener implements actionlistenerdelmedicineinfo delmedicineinfo;public quitdela

42、ctionlistener(delmedicineinfo delmedicineinfo)this.delmedicineinfo=delmedicineinfo;overridepublic void actionperformed(actionevent e) 17/ todo auto-generated method stubdelmedicineinfo.quitdelactionperformed(e);quemedicineinfo.javaimport java.awt.event.actionevent;import java.awt.event.actionlistene

43、r;import java.sql.*;import javax.swing.*;public class quemedicineinfo extends jframeprivate static final long serialversionuid = 1l;jlabel bymednumber=new jlabel(按药品编号查找：);jtextfield txtnumber=new jtextfield();jbutton btnnumber=new jbutton(确定);jlabel bymedinprice=new jlabel(按药品进价查找：);jtextfield txti

44、nprice=new jtextfield();jlabel labto=new jlabel(到);jtextfield txtinprice2=new jtextfield();jbutton btninprice=new jbutton(确定);jlabel msg=new jlabel(-下面是您查询的药品信息-);jtextarea txtarea=new jtextarea();jscrollpane scrollpane=new jscrollpane();jbutton btnquit=new jbutton(取消);public quemedicineinfo()super(

45、药店管理系统-查询);this.bymednumber.setsize(110,30);this.bymednumber.setlocation(170,10);this.txtnumber.setsize(100,30);this.txtnumber.setlocation(290, 10);this.btnnumber.setsize(60,30);this.btnnumber.setlocation(400,10);this.bymedinprice.setsize(110,30);this.bymedinprice.setlocation(500,10);this.txtinprice

46、.setsize(100,30);this.txtinprice.setlocation(620,10);this.labto.setsize(35,30);/this.labto.setlocation(740, 10);this.txtinprice2.setsize(100,30);this.txtinprice2.setlocation(780, 10);this.btninprice.setsize(60,30);this.btninprice.setlocation(890,10);this.msg.setsize(200,30);this.msg.setlocation(400,

47、50);this.scrollpane.setbounds(50,90,900,100);18/this.txtarea.setsize(900,100);/this.txtarea.setlocation(50,90);this.btnquit.setsize(60,30);this.btnquit.setlocation(500,200);this.setlayout(null);this.getcontentpane().add(bymednumber);this.getcontentpane().add(txtnumber);this.getcontentpane().add(btnn

48、umber);this.getcontentpane().add(bymedinprice);this.getcontentpane().add(txtinprice);this.getcontentpane().add(labto);this.getcontentpane().add(txtinprice2);this.getcontentpane().add(btninprice);this.getcontentpane().add(msg);this.getcontentpane().add(scrollpane);scrollpane.setviewportview(txtarea);

49、/this.getcontentpane().add(txtarea);this.getcontentpane().add(btnquit);/-按药品编号查询按钮的事件注册-/this.btnnumber.addactionlistener(new numberactionlistener(this);/-按药品进价查询按钮的事件注册-/this.btninprice.addactionlistener(new inpriceactionlistener(this);/-取消按钮事件注册-/this.btnquit.addactionlistener(new quitactionlisten

50、er(this);this.setsize(1100,300);this.setresizable(false);this.setdefaultcloseoperation(jframe.exit_on_close);this.setvisible(true);/主函数public static void main(string args) new quemedicineinfo();/-按药品编号查询的方法-/public void quebynumberactionperformed(actionevent arg0)string number=txtnumber.gettext();tr

51、yclass.forname(com.microsoft.sqlserver.jdbc.sqlserverdriver);catch(classnotfoundexception e)joptionpane.showmessagedialog(null,驱动未找到！);trystring url=jdbc:sqlserver:/localhost:1433;databasename=medicinemanage;19string dbname=sa;string dbpassword=pwd;string sql=select * from medicineinfo where mednumb

52、er=+number+;connection conn=drivermanager.getconnection(url,dbname,dbpassword);statement stmt=conn.createstatement();resultset rs=stmt.executequery(sql);while(rs.next()string mednumber=rs.getstring(mednumber);string medname=rs.getstring(medname);string medshortname=rs.getstring(medshortname);string

53、mednors=rs.getstring(mednors);string medcate=rs.getstring(medcate);float medinprice=rs.getfloat(medinprice);float medwholesaleprice=rs.getfloat(medwholesaleprice);int medcount=rs.getint(medcount);this.txtarea.settext(药品编号t 药品名称t 药品通称t 药品规格t 药品类别t 药品进价t 药品批发价t 药品库存n +mednumber+t+medname+t+medshortnam

54、e+t+mednors+t+medcate+t+medinprice+t+medwholesaleprice+t+medcount);catch(exception e)e.printstacktrace();public void quebyinpriceactionperformed(actionevent arg0)string inprice=txtinprice.gettext();string inprice2=txtinprice2.gettext();tryclass.forname(com.microsoft.sqlserver.jdbc.sqlserverdriver);c

55、atch(classnotfoundexception e)joptionpane.showmessagedialog(null,驱动未找到！);trystring url=jdbc:sqlserver:/localhost:1433;databasename=medicinemanage;string dbname=sa;string dbpassword=pwd;string sql=select * from medicineinfo where medinprice between +inprice+ and +inprice2+;connection conn=drivermanag

56、er.getconnection(url,dbname,dbpassword);statement stmt=conn.createstatement();resultset rs=stmt.executequery(sql);txtarea.settext(药品编号t 药品名称t 药品通称t 药品规格t 药品类别20t 药品进价t 药品批发价t 药品库存n);while(rs.next()string mednumber=rs.getstring(mednumber);string medname=rs.getstring(medname);string medshortname=rs.ge

57、tstring(medshortname);string mednors=rs.getstring(mednors);string medcate=rs.getstring(medcate);float medinprice=rs.getfloat(medinprice);float medwholesaleprice=rs.getfloat(medwholesaleprice);int medcount=rs.getint(medcount);/joptionpane.showmessagedialog(null,药品编号:+mednumber+n药品名称:+medname+n 药品通称:+

58、medshortname/+n 药品规格:+mednors+n 药品类别:+medcate+n 药品进价:+medinprice+n 药品批发价:+medwholesaleprice/+n 药品库存：+medcount);txtarea.append(mednumber+t+medname+t+medshortname+t+mednors+t+medcate+t+medinprice+t+medwholesaleprice+t+medcount+n);catch(exception e)e.printstacktrace();public void quitactionperformed(ac

59、tionevent e)this.setvisible(false);class numberactionlistener implements actionlistenerquemedicineinfo quebynum;numberactionlistener(quemedicineinfo quebynum)this.quebynum=quebynum;overridepublic void actionperformed(actionevent arg0) / todo auto-generated method stubquebynum.quebynumberactionperfor

60、med(arg0);class inpriceactionlistener implements actionlistenerquemedicineinfo quebyinprice;inpriceactionlistener(quemedicineinfo quebyinprice)this.quebyinprice=quebyinprice;public void actionperformed(actionevent arg0) 21/ todo auto-generated method stubquebyinprice.quebyinpriceactionperformed(arg0