shop試驗(yàn)報(bào)告

1、實(shí)驗(yàn)報(bào)告實(shí)驗(yàn)日期：2015年12月30 0 星期三實(shí)驗(yàn)項(xiàng)目名稱任務(wù)九：使用圖形界面完成淘寶shopping"購(gòu)物管理系統(tǒng)購(gòu)物結(jié)算模塊和 客戶管理模塊實(shí)驗(yàn)項(xiàng)目類型演示型驗(yàn)證型基本訓(xùn)練型綜合型設(shè)計(jì)型提高型實(shí)驗(yàn)指導(dǎo)教師劉風(fēng)華實(shí)驗(yàn)地點(diǎn)實(shí)驗(yàn)樓碾件機(jī)房424是否分組否小組其他成員一、實(shí)驗(yàn)?zāi)康募耙?. 需要完成的任務(wù):開(kāi)發(fā)“淘寶Shopping購(gòu)物管理系統(tǒng)”：（D實(shí)現(xiàn)系統(tǒng)數(shù)據(jù)傳遞（2）實(shí)現(xiàn)自動(dòng)計(jì)算會(huì)員折扣（3）完善購(gòu)物結(jié)算程序（4）實(shí)現(xiàn)從購(gòu)物結(jié)算程序返回上一級(jí)主菜單2. 技能訓(xùn)練（D會(huì)使用String的相關(guān)方法（2）會(huì)使用帶參數(shù)的方法二、實(shí)驗(yàn)使用的主要設(shè)備（含軟件系統(tǒng)）三、實(shí)驗(yàn)操作過(guò)程及內(nèi)容數(shù)據(jù)

2、庫(kù)曰J sh o p曰去SJ I "丄O "1 citoioi. Goods1 王Ird b o 21 曰廠i 91 e廠匡1 rl dbo. 21 embe廠 r ' i rw' iCUBtlOcustorthcuDtScorc'cuutNo1623521g102728293031323345464349NULL3545g/0822002/101003020933/515501G298/81623888312/30631013099/1465266666/152SO12379/1566045555/257B59887VS£S88a2016

3、VI78000138712/135-4C8O3s08134512/121473NULLNULLNULLTIAN-usernamemanagerNULLpassword0000NULLTIAN-PC.shop - dbo.Member TTAN-PC.S-hop dbo.GoodnogoodsNamegoodsPrice1addidas運(yùn)動(dòng)鞋8802addidasT'bfi420.733Nike廷動(dòng)鞋900來(lái)NULLNULLNULL主要窗體及其代碼：登錄界面：private void logjButtonlActionPerformed(javaawtevent.ActionEvent

4、evt) DBconnection dbc = new DBconnection();ResultSet rs = null;St ring sql = "selec t * from Man ager1'rs = dbc.Select(sql);try while (rs.next() if (rs get Str in g( ,usernameH) equals(username get Tex t ()&& rs.getString("password")equals(passwordgetText() new MenuJFame()

5、.setVisible(true); thishide();else JOptionPaneshoi/MessageDiaLog(null"用戶名或密碼輸入錯(cuò)誤""警告" DOptionPane.INFORMATIONMESSAGE);break; catch (SQLException e) e.printStackTrace(); private void canceljButtonlActionPerformed(java.awt.event.ActionEvent evt) username .set Tex t(n ull); password

6、 .setTex t(null); public static void main(S tring a“gs) tryfor(javax swing UIManage廣 LookAndFeellnfoinfo :javax swing UIManagen getlnsta LLedLookAndFeeLs()if(H Nimbus".equals(info.getName()j avax.swing.UIManager. setLookAndFeeL(info.getClassName();break; catch(ClassNotFoundExceptionex) java uti

7、llogging Logger getLogger (loginJFrame class getName()log(javautillogging.LevelSEVERE, null， ex); catch (InstantiationException ex) java utillogging Logger getLogger(loginJFame class getName()log(java util logging.Leve1SEVERE, null ex); catch (IllegalAccessException ex) java utillogging Logger getLo

8、ggerloginJFrame class getName()log(java util logging.Leve1SEVERE, null ex); catch (javax.swingUnsupportedLookAndFeelException ex) java utillogging Logger getLoggerloginJFrame class getName()log(java util logging.Leve1SEVERE， null ex); java.awt.EventQueue.invo/?eLater(new Runnable() public void nunO

9、new loginJFrame().setVisible(true); );輸入用戶名和密碼客戶信息管理界面:顯示客戶信息:容戶值忌瞌理 購(gòu)物箝磔 耳恬回曲注訥丘示瀕48custid| custNo | custBirth | custScor©0789010-34508910 223333444441623372521154150 4/082200128G27101003018&3375163016298/81623QQQB12/3082(3413"9/14652GGQGG71S2*5012379/15660455552578596074JSQQQQQ201 61

10、/17890013S71 2/13G54980i99/899134512/121473/點(diǎn)擊按鈕時(shí)的事件處理public void btnShow_ActionPerformed(ActionEvent ae) /以下是連接數(shù)據(jù)去和顯示數(shù)據(jù)的具體處理方法，請(qǐng)注意下try /獲得連接/建立査詢條件/執(zhí)行査詢DBconnection dbc = new DBconnection();ResultSet rs = null;String sql = "select * from Member"rs = dbc.Select(sql);/PreparedStatement pstm

11、 = dbcprepaneStatement(sql); /計(jì)算有多少條記錄int count = 0;while (rs.next() count+;rs = dbc.Select(sql);/將查詢獲得的記錄數(shù)據(jù)，轉(zhuǎn)換成適合生成JTable的數(shù)據(jù)形式Object info = new Objectcount4; count = 0;while (rs.next() infocount0 = Integer.vaLueOf(rs.getlnt("custld"); infocount1 = Integer.vaLueOf(rs.getlnt("custNo&qu

12、ot;);infocount2 =rs.getString("custBirth");infocount3 = Integer.vaLueOf(rsgetlnt("custScore"); count+;String title = "custld""custNo""custBirth""custScore" ; / 創(chuàng)建JTablethis.tabDemo = new 3Table(inio, titie);/顯示表頭this jth = this t abDemo.ge

13、tTableHeaderO;/將JTable加入到帶滾動(dòng)條的面板中this scpDemo.getViewport() add(tabDemo); catch (SQLException sqle) 30ptiorPane.shoiyfMessageDiaLog(nullJ ”數(shù)據(jù)操作錯(cuò)誤"，"錯(cuò)誤J JOptionPane.ERROR_MESSAGE);public static void main(String args) new showcust3Frame();添加會(huì)員：12CF戶RAISES 曲吻兌輕 M'WEtW注仙* I - I'奮戶MMVWE

14、S胸物鎚其鼻嘯回曲嚴(yán)斛査詢要修改的信息:修改會(huì)員信息:修改積分:private void xugaihuixxButton2MouseClicked(java.awt.eventMouseEvent evt) DBconnection dbc = new DBconnection();ResultSet rs = null;String sqll = "update Member setcustBirth二'"+xigaihoudexixinxijTextField2.getText()+ "' where custNo二"+ shruj

15、TextFieldl.getText();int n二 dbc.update(sql：l);if(n=l)JOpti onPane. shoi(MessageDiaLog(null,”生日信息已更改！“，“修改生日J(rèn)OptionPane. IN FORMA TION MESSAGE); private void xiugaijifjButton3MouseClicked(java.awt.event.MouseEvent evt) /GEN-FIRST:event_xiugaijifjButton3MouseClickedDBconnection dbc = new DBconnection(

16、);ResultSet rs = null;String sqll = "update Member setcustScore='n+jxigaihouifenjTextFieldlgetText()+ "' where custNo二"+ shrujTextFieldl getText();int n二 dbc.update(sqJ.l);if(n=l)JOpti onPane. shoiyfMessageDiaLog(null,”積分已更改！”，”修改積分”，JOptionPane.INFORMATION_MESSAGE);/ TODO add

17、 your handling code here:/GEN-LAST:event_xiugaijifjButton3MouseClickedprivate void jButtonlActionPerformed(java.awt.event.ActionEvent evt) / GEN-FIRST:event_jButtonlActionPerformed/ TODO add your handling code here:DBconnection dbc = new DBconnection();ResultSet rs = null;String sql = "select *

18、 from Member wherecustNo="+shrujTextFieldl.getText();rs = dbc.Select(sql);try while (rs.next() try JOpt ionPane. shoMMessageDiaLog (null "會(huì)員號(hào)：11 +rs. getlnt ("custNo") + 11 生日,+ rs. getString( "custBirth") + " 積分"+ rs.getlnt("custScore"),"查看要修改的

19、信息"， 30ptiorPane.INFORMATIONMESSAGE); catch (SQLException ex) LoggergetLogger(odityJFnameclassgetName().log( Level.SEVEREnull ex); catch (SQLException ex)LoggergetLogger(tAodityJFrame class.getName()log(LevelSEVERE,null ex); catch (Exception e) e.pnintStackTrace();private void jButtonlActionPer

20、formed(javaawteventActionEvent evt)DBconnection dbc = new DBconnection();ResultSet rs = null;String sql = "select * from Member wherecustNo="+searchjTextFieldl.getText();rs = dbc.Select(sql);try while (rsnext()tryJOptionPane shoMessageDiaLog(null,"會(huì)員號(hào)："+ rs. getlnt ("custNo1

21、1) + " 生日"+ rs. getString( "cust Birth") + 11 積分, + rs-getlntC'castScore'1), ”查看 H, DOptionPane. INFORMATION_MESSAGE); catch(SQLExceptionex)Logger getLoggerModityJFrame class getName()log(Leve1SEVE REnull ex); catch (SQLException ex)LoggergetLogger'(ModityJFrame.class

22、getName()log(Leve1SEVEREex); 査詢客戶：戶(*廂*wua(I湘紙面g 注仙private void jButtonlActionPerformed(javaawteventActionEvent evt) DBconnection dbc = new DBconnection();ResultSet rs = null;String sql = "select * from Member wherecustNo=,+searchjTextFieldl.getText();rs = dbc.Select(sql);try while (rs.next() t

23、ry JOpt ionP ane. showMessageDia Log (null j "會(huì)員號(hào):11 +rs. getlnt ( McustNo") + 11 生日'*+ rs. getString( "custBirth") + " 積分, + rs getlnt(,custScoreH),"查看”,JOptionPaneINFORMTI0NJ1ESSAGE); catch (SQLException ex) LoggergetLoggerodityJPcameclassgetName().log(LevelSEVERE

24、, null ex); catch (SQLException ex)Logger.getLoggeTCModityJFrame.class getName()log(Leve1SEVERE, nu11, ex);購(gòu)物結(jié)算：消費(fèi)清單: _ 一亠二回22容戶信忌管理 晰結(jié)算真情回遇注請(qǐng)private void jButton2MouseCJ.icked(java.awteventMouseEvent evt) jiazaishangpin();int gNo = Integer .parselnt(gNojTextFieldl. getText(); /買(mǎi)的是第兒個(gè)商品 int gnum二 In

25、tegernumjTextField2.getText();/!)溝買(mǎi)數(shù)量 float gsum = 0;gsum=spgNo-l.price*gnum;/金額DBconnection dbc = new DBconnection();ResuItSet rs = null;String sql = "select * from Member where custNo="+cunojTextField?.getText(); rs = dbcSelect(sql);try while(rs.next()30ptionPane.s/)oiessageDiafog(null,

26、M * * 次消 費(fèi)清單 * * n,+"物品："+spgNo-l .good name+>,個(gè)數(shù)："+gnum+" 金額 "+gsum +"n"+"折扣： "+getDiscount(rs .getFloat( "custScore") )+H 實(shí)付： ¥,+gsum*getDiscount(rs .get Float ("custScore" ) + H 本次積分:M+(int) (gsum*getDiscount(rs. getFloat (&

27、quot;'custScore" )/100*3" 消費(fèi)清單H, JOptionPane IN FORMA TI0NJ1ESSAGE);intscore=(int)(gsum*getDiscount(rs.getFloat("custScore")/100*3+rs.getlnt("custS core”)；String sqll = "update Member set custScone ='n4- score+H' where custNo二"+cunojTextField3.getText()

28、;dbc.update(sqll); catch (SQLException e) e.pintStackTrace(); 真情回饋幸運(yùn)大放送:幸運(yùn)抽獎(jiǎng):A生日問(wèn)候:private void jMenu8MouseClicked(javaawtevent.MouseEvent evt) / GEN-FIRST:event_jMenu8MouseClickedint max = 0;dbc = new DBconnection(); =null;"select * from Member"DBconnectionResultSet rsString sql = rs = db

29、c.Select(sql);try while (rs.next() if (rs.getlnt("custScore") > max) max = rs.getInt("custScone"); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();30ptionPane.shoiessageDiaLog(null,"具有最高積分的會(huì)員是："+ max,"幸運(yùn) 大放送”，DOptionPane.INFORMATIONM

30、ESSAGE);private void jMenu9MouseClicked(java.awt.event.MouseEvent evt) /GEN-FIRST:event_jMenu9MouseClickedint i = (int) (Math.rando/n() * 10D);boolean flag = false;DBconnection dbc = new DBconnection();ResultSet rs = null;String sql = "select * from Member"rs = dbc.Select(sql);while (rs.ne

31、xt() int j = (rs.getlnt("custNo'1) / 100) % 10; if (j = i) JOptionPane.sho剛essageDiaLog(null,“幸運(yùn)客戶是：” + rgetStrdng(“custNo”)+ H t”+ rs.getString("custBirth") + "t"+ rs .getString( "custScore11) + 11 獲贈(zèng)MP3"， ”幸運(yùn)抽獎(jiǎng), DOptionPane.INFORMTIONMESSAGE);flag = true; cat

32、ch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();if (Iflag)30ptiorP ane. shoitMessageDia Log (null "無(wú)幸運(yùn)客戶"，"幸運(yùn)抽獎(jiǎng)"， JOptionPane. IN FORMA TI ON-MESSAGE); private void jMenul0MouseCJ.icked(java.awt.event.MouseEvent evt) Date date = new Date();/SimpleDateFor

33、mat sdf = new SimpleDateFormat(''MM/dd1');String st” = sdf.forTnat(date); Boolean b = true;String si = "' DBconnection dbc = new DBconnection();ResultSet rs = null;String sql = "select * from Member"rs = dbcSelect(sql); try while (rs.next() if (rs.getStringCustBirth&qu

34、ot;).equals(str)JOptionPane.shoMMessageDiaLog(null,11 生日的會(huì)員是:"+ rs.getString("custNo") + 11 tH+ rs. getString( "custBirth11) + 11 tM+ rs.getString(McustScoreH)+ "恭喜！獲贈(zèng)MP3個(gè)! ”)；b = false; catch (SQLException e) e.pnintStackTrace();if (b) JOptionPane. shoi/MessageDiaLog(rull,"今夭沒(méi)有過(guò)生日的會(huì)員！ ”)； private javax.swing.JMenu custjMenul; private javax.swing.JMenu jMenul;private javax.swing.J