醫(yī)藥銷售系統(tǒng)java課程設(shè)計報告

1、 面向?qū)ο蟪绦蛟O(shè)計面向?qū)ο蟪绦蛟O(shè)計實(shí)驗(yàn)報告實(shí)驗(yàn)報告題題 目目 醫(yī)藥銷售系統(tǒng)醫(yī)藥銷售系統(tǒng) 學(xué)學(xué) 院院 商學(xué)院商學(xué)院 專專 業(yè)業(yè) 信息管理與信息系統(tǒng)信息管理與信息系統(tǒng) 班班 級級 *班班 學(xué)學(xué) 號號 201052275* 學(xué)生姓名學(xué)生姓名 * 指導(dǎo)教師指導(dǎo)教師 * 編寫日期編寫日期 2013 年年 1 月月 5 號號 目目 錄錄一、需求分析一、需求分析.11.1 功能需求.11.2 性能需求.11.3 數(shù)據(jù)需求.1二、系統(tǒng)運(yùn)行環(huán)境二、系統(tǒng)運(yùn)行環(huán)境.1三、系統(tǒng)總體設(shè)計三、系統(tǒng)總體設(shè)計.23.1 登錄界面.23.2 系統(tǒng)功能.2四、數(shù)據(jù)庫設(shè)計四、數(shù)據(jù)庫設(shè)計.34.1 概念結(jié)構(gòu)設(shè)計.34.2 邏輯結(jié)構(gòu)設(shè)

2、計.34.3 物理結(jié)構(gòu)設(shè)計.44.3.1 用戶信息表 users.44.3.2 藥品信息表 medicineinfos .44.3.3 訂單信息表 wholesaleinfo.6五、程序模塊設(shè)計五、程序模塊設(shè)計.65.1 運(yùn)行界面及其效果圖.65.2 程序代碼.8六、總結(jié)六、總結(jié).22七、參考資料七、參考資料.220一、一、需求分析需求分析根據(jù)課題調(diào)查和分析用戶的業(yè)務(wù)活動、信息和處理的需求，以及各種數(shù)據(jù)之間的約束條件關(guān)系，形成以下的系統(tǒng)的需求說明。1.11.1 功能需求功能需求（功能劃分，功能描述）（功能劃分，功能描述）login.java 實(shí)現(xiàn)注冊和登錄功能。注冊，將用戶姓名和密碼寫入數(shù)據(jù)庫

3、用戶表（users） ，并反饋給注冊用戶。登錄，按照用戶填寫的用戶名和密碼，在數(shù)據(jù)庫中查找相關(guān)信息，如果匹配則提示登錄成功，并轉(zhuǎn)至藥品管理系統(tǒng)的管理界面。否則提示登錄失敗。managemain.java 實(shí)現(xiàn)用戶管理界面功能選擇。在功能選擇界面中可以選擇添加、刪除、修改、查詢和統(tǒng)計藥品信息，并且可以選擇售出藥品。insmedicineinfo.java 實(shí)現(xiàn)添加藥品信息功能。在這一模塊中，可以將藥品信息填寫保存到數(shù)據(jù)庫藥品信息表（medicineinfo）中。并返回操作狀態(tài)。delmedicineinfo.java 實(shí)現(xiàn)分別按藥品編號或藥品名稱刪除指定藥品信息，被刪除的藥品信息將從藥品信息表中

4、刪除。并返回操作狀態(tài)。updmedicineinfo.java 實(shí)現(xiàn)按藥品編號更新藥品信息功能。被修改的藥品信息在數(shù)據(jù)庫中也被相應(yīng)修改。并返回操作狀態(tài)。quemedicineinfo.java 實(shí)現(xiàn)分別按藥品編號或藥品進(jìn)價范圍查詢藥品信息。數(shù)據(jù)庫中符合條件的藥品信息將被顯示在查詢界面的文本域中。stamedicineinfo.java 實(shí)現(xiàn)統(tǒng)計數(shù)據(jù)庫中藥品信息。統(tǒng)計的藥品信息將顯示在統(tǒng)計藥品信息界面，以表格的形式呈現(xiàn)。salmedicineinfo.java 實(shí)現(xiàn)出售藥品功能。填寫藥品編號和售出數(shù)量，并生成訂單信息。出售藥品訂單信息將被存入到數(shù)據(jù)庫藥品訂單信息表（wholesaleinfo）中

5、。1.21.2 性能需求（性能需求（軟件適應(yīng)性和移植性等）軟件適應(yīng)性和移植性等）在 windows 平臺測試無誤。使用 sql server 2008 數(shù)據(jù)庫。可用于一般的藥品信息管理。1.31.3 數(shù)據(jù)需求數(shù)據(jù)需求（數(shù)據(jù)之間的依賴和約束關(guān)系）（數(shù)據(jù)之間的依賴和約束關(guān)系）本藥品信息管理系統(tǒng)共有三張表，一張為獨(dú)立的用戶信息表（users） ，用于管理用戶信息。其余兩張為藥品信息表（medicineinfo）和訂單信息表（wholesaleinfo） 。二、系統(tǒng)運(yùn)行環(huán)境二、系統(tǒng)運(yùn)行環(huán)境 本課題是在 sql server 2008、netbeans6.9.1 環(huán)境下運(yùn)行的。1三、系統(tǒng)總體設(shè)計三、系統(tǒng)

6、總體設(shè)計 3.13.1 登錄界面登錄界面注冊信息用戶登錄登錄界面2 3.23.2 系統(tǒng)功能系統(tǒng)功能藥品管理系統(tǒng)藥品管理功能添加藥品信息刪除藥品信息修改藥品信息查詢藥品信息統(tǒng)計藥品信息出售藥品功能34四、數(shù)據(jù)庫設(shè)計四、數(shù)據(jù)庫設(shè)計4.1 概念結(jié)構(gòu)設(shè)計概念結(jié)構(gòu)設(shè)計用戶表用戶名用戶密碼藥品信息表藥品編號藥品名稱藥品通稱藥品規(guī)格藥品類別藥品進(jìn)價藥品批發(fā)價藥品庫存量藥品訂單表訂單編號藥品編號批發(fā)藥品數(shù)量外鍵約束54.2 邏輯結(jié)構(gòu)設(shè)計邏輯結(jié)構(gòu)設(shè)計usersusernameuserpasswordmedicineinfomednumber mednamemedshortnamemednorsmedcateme

7、dinpricemedwholesalemedcountwholesaleinfowsnumbermednumberwsmedcount64.3 物理結(jié)構(gòu)設(shè)計物理結(jié)構(gòu)設(shè)計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五、五、程序模塊設(shè)計程序模塊設(shè)計 5.1 運(yùn)行界面及其效果圖運(yùn)行界面及其效果圖1.功能選擇界面點(diǎn)擊“增加”按鈕，跳轉(zhuǎn)到增加藥品信息界面；9點(diǎn)擊“刪除”按鈕，跳轉(zhuǎn)到刪除藥品信息界面；點(diǎn)擊

15、“修改”按鈕，跳轉(zhuǎn)到修改藥品信息界面；點(diǎn)擊“查詢”按鈕，跳轉(zhuǎn)到查詢藥品信息界面；點(diǎn)擊“統(tǒng)計”按鈕，跳轉(zhuǎn)到統(tǒng)計藥品信息界面；點(diǎn)擊“出售”按鈕，跳轉(zhuǎn)到出售藥品信息界面。 2.刪除藥品信息界面按藥品編號刪除藥拼信息：按藥品名稱刪除藥品信息：3.查詢藥品信息界面10按藥品編號查詢藥品信息：按藥品進(jìn)價范圍查詢藥品信息： 4.出售藥品信息界面 出售成功并生成訂單寫入到數(shù)據(jù)庫藥品訂單信息表（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(統(tǒng)計藥品信息：);jbutton btstainfo=new jbutton(統(tǒng)計);jlabel salmedicineinfo=new jlabel(出售藥品管理：);jbutton btsalinfo=new

18、 jbutton(出售);public managemain() super(藥店管理系統(tǒng)-功能);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(););/-統(tǒng)計藥品信息注冊事件-/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(藥店管理系統(tǒng)-刪除);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,驅(qū)動未找到！);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,驅(qū)動未找到！);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(按藥品進(jìn)價查找：);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、藥店管理系統(tǒng)-查詢);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);/-按藥品進(jìn)價查詢按鈕的事件注冊-/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);/主函數(shù)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,驅(qū)動未找到！);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 藥品規(guī)格t 藥品類別t 藥品進(jìn)價t 藥品批發(fā)價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,驅(qū)動未找到！);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 藥品規(guī)格t 藥品類別20t 藥品進(jìn)價t 藥品批發(fā)價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 藥品規(guī)格:+mednors+n 藥品類別:+medcate+n 藥品進(jìn)價:+medinprice+n 藥品批發(fā)價:+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