1、精選優(yōu)質(zhì)文檔-傾情為你奉上Java程序設(shè)計(jì)期末課程設(shè)計(jì)報(bào)告題 目 超市進(jìn)銷存管理系統(tǒng) 班 級： 13級信息安全班 學(xué) 號： 姓 名： 成 績： 完成時(shí)間： 2014 年 12 月目 錄一.需求分析企業(yè)進(jìn)銷存管理系統(tǒng)的主要工作，是對企業(yè)的進(jìn)貨、銷售和庫存以信息化的方式進(jìn)行管理，最大限度的減少各個(gè)環(huán)境中可能出現(xiàn)的錯(cuò)誤，有效減少盲目采購，降低采購成本、合理控制庫存、減少資金占用并提高市場靈敏度，使企業(yè)能夠合理安排進(jìn)、銷、存的每個(gè)關(guān)鍵步驟，替身企業(yè)市場競爭力。針對經(jīng)營管理中存在的問題，蘭州華聯(lián)超市對產(chǎn)品的進(jìn)銷存合理化提出了更高的要求。 通過實(shí)際調(diào)查，要求企業(yè)進(jìn)銷存管理系統(tǒng)具有以下功能。 界面設(shè)計(jì)美觀大

2、方，方便、快捷、操作靈活。實(shí)現(xiàn)強(qiáng)大的進(jìn)銷存管理，包括基本信息、進(jìn)貨、銷售和庫存管理。能夠在不同的操作系統(tǒng)下運(yùn)行，不局限于特定的平臺(tái)。提供數(shù)據(jù)庫備份與恢復(fù)功能。提供庫存盤點(diǎn)功能。提供技術(shù)支持的聯(lián)系方式，可以使用郵件進(jìn)行溝通，或者直接連接到技術(shù)網(wǎng)站。二.分析與設(shè)計(jì)：(1)功能模塊劃分:本進(jìn)銷存管理系統(tǒng)劃分為六個(gè)模塊，分別為系統(tǒng)登陸模塊，系統(tǒng)主窗體設(shè)計(jì)模塊，進(jìn)貨單模塊，銷售單模塊，庫存盤點(diǎn)模塊和數(shù)據(jù)庫備份與恢復(fù)模塊，(2)數(shù)據(jù)庫結(jié)構(gòu)描述:企業(yè)進(jìn)銷存管理系統(tǒng)需要使用數(shù)據(jù)庫存儲(chǔ)和管理進(jìn)銷存過程中的所有信息，本企業(yè)進(jìn)銷存管理系統(tǒng)使用Access數(shù)據(jù)庫系統(tǒng)作為后臺(tái)數(shù)據(jù)庫，數(shù)據(jù)庫名稱為db_database2

3、8。其中包含了14張數(shù)據(jù)表兩個(gè)視圖。以下是系統(tǒng)主要涉及的六個(gè)數(shù)據(jù)庫表：1 供應(yīng)商信息表：主要用于存儲(chǔ)供應(yīng)商詳細(xì)信息，其結(jié)構(gòu)如下表所示：User表：Handle表：Product表：Stuff表：Yield表：空表等待插入數(shù)據(jù)。三.系統(tǒng)詳細(xì)設(shè)計(jì)文檔：1.系統(tǒng)流程圖： (1)系統(tǒng)功能結(jié)構(gòu)圖： (2)系統(tǒng)業(yè)務(wù)流程圖： (3)系統(tǒng)中的主要類及功能： 1.Item公共類：Item公共類是對數(shù)據(jù)表最常用的ID和name屬性的封裝，屬于swing列表，表格，下拉列表框等組件的賦值。該類重寫了toString()方法，在該方法中只輸出name屬性。但是在獲取組件的內(nèi)容時(shí)，獲取的是Item類的對象，從該對象中可

4、以獲取ID的屬性，然后通過該屬性到數(shù)據(jù)庫中獲取唯一的數(shù)據(jù)。 2.數(shù)據(jù)模型公共類： 數(shù)據(jù)模型公共類對應(yīng)著數(shù)據(jù)庫中不同的數(shù)據(jù)表，這些模型將被訪問數(shù)據(jù)庫的Dao類和程序中各個(gè)模塊甚至各個(gè)組件使用，數(shù)據(jù)模型是對數(shù)據(jù)表所有字段的封裝，它是純粹的模型類，他也要重寫toString()方法，另外還要重寫hashCode()方法和equal()方法。它主要用于存貯數(shù)據(jù)，并通過相應(yīng)的getXXX()方法和setXXX()實(shí)現(xiàn)不同屬性的訪問原則。 3.Dao公共類： Dao類實(shí)現(xiàn)了數(shù)據(jù)庫的驅(qū)動(dòng)，連接，關(guān)閉和多個(gè)操作數(shù)據(jù)庫的方法，Dao類不需要?jiǎng)?chuàng)建對象，可以直接調(diào)用類中的所有數(shù)據(jù)庫操作方法。Dao類自定義的主要方法

5、有g(shù)etKhlnfo(Item item)方法，主要是獲取客戶信息，方法的返回值是tKhlnfo的對象，及客戶信息的數(shù)據(jù)模型。getGyslnfo(Item item)方法，主要是獲取供應(yīng)商信息，返回值是Gyslnfo類的對象，及供應(yīng)商數(shù)據(jù)表的模型對象。getSplnfo(Item item)方法，主要用于獲取商品信息，返回值是Splnfo類的對象，及商品數(shù)據(jù)表的數(shù)據(jù)模型。getLogin(String name,String password)方法主要適用于判斷登錄用戶的用戶名與密碼是否正確，返回值是boolean類型。insertSelllnfo(TbSellMain sellMain)方

6、法，主要是添加銷售信息到數(shù)據(jù)庫中。restoreOrBackup(String sql)方法，此方法是設(shè)置數(shù)據(jù)庫的模式為單用戶連接模式，這樣可以避免數(shù)據(jù)庫恢復(fù)或備份時(shí)失敗。checkLogin(String userStr,String passStr)方法，用于判斷登錄用戶與密碼是否正確。(2)各個(gè)模塊實(shí)現(xiàn)方法描述： 1.系統(tǒng)登錄模塊 實(shí)現(xiàn)該模塊的主要代碼如下 package src;import java.awt.AlphaComposite;import java.awt.GradientPaint;import java.awt.Graphics;import java.awt.Gra

7、phics2D;import java.awt.GridBagConstraints;import java.awt.GridBagLayout;import java.awt.Image;import java.awt.RenderingHints;import java.awt.Toolkit;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.KeyEvent;import java.awt.event.KeyListener;import javax.s

8、wing.JComponent;import javax.swing.JFrame;import javax.swing.JOptionPane;import javax.swing.UIManager;public class AddUser private static final String logoon = "添加用戶"private static final String helpt = "添加"private static final String logooff ="退出"private static final St

9、ring user = "用 戶:"private static final String password = "密 碼:"private static final String enterpwd ="再次輸入密碼:"private javax.swing.JTextField userText=null;private javax.swing.JPasswordField userpwd=null;private javax.swing.JPasswordField enterpassword=null;private javax

10、.swing.JPanel jp = new javax.swing.JPanel()final static long serialVersionUID = L;public void paintComponent(Graphics g)super.paintComponent(g);if(!isOpaque()return;Graphics2D g2d = (Graphics2D) g;/int rule = AlphaComposite.SRC_OVER;AlphaComposite opaque = AlphaComposite.SrcOver;/AlphaComposite blen

11、d = AlphaComposite.getInstance(rule, 0.6f);/AlphaComposite set = AlphaComposite.Src;int width = getWidth();int height = getHeight();GradientPaint gradientPaint = new GradientPaint(0,0,java.awt.Color.green,width/2,height/2,java.awt.Color.yellow,false);g2d.setComposite(opaque);g2d.setPaint(gradientPai

12、nt);g2d.fillRect(0, 0, width,height);g2d.setRenderingHint(RenderingHints.KEY_ANTIALIASING,RenderingHints.VALUE_ANTIALIAS_OFF);private javax.swing.JButton add = new javax.swing.JButton(helpt);private javax.swing.JButton cancle = new javax.swing.JButton(logooff);private JFrame logo_Frame = new JFrame(

13、logoon);public AddUser() / TODO 自動(dòng)生成構(gòu)造函數(shù)存根tryUIManager.setLookAndFeel(UIManager.getCrossPlatformLookAndFeelClassName();catch(Exception exe)System.err.print(exe.getMessage();JFrame.setDefaultLookAndFeelDecorated(true);Toolkit tools = logo_Frame.getToolkit();Image logo = tools.getImage("res/logo.

14、jpg");logo_Frame = new JFrame(logoon);logo_Frame.setIconImage(logo);jp.setLayout(new GridBagLayout();javax.swing.ImageIcon pic = new javax.swing.ImageIcon("res/logo1.jpg");javax.swing.JLabel picture = new javax.swing.JLabel(pic);setupComponent(picture,0,0,GridBagConstraints.ABOVE_BASE

15、LINE_LEADING,1,true);javax.swing.JLabel users = new javax.swing.JLabel(user);setupComponent(users,0,1,1,1,false);javax.swing.JLabel pas = new javax.swing.JLabel(password);setupComponent(pas,0,2,1,1,false);javax.swing.JLabel enpas = new javax.swing.JLabel(enterpwd);setupComponent(enpas,0,3,1,1,false)

16、;userText = new javax.swing.JTextField(12);userText.requestFocus();userText.addKeyListener(new KeyListener()public void keyTyped(KeyEvent e)public void keyReleased(KeyEvent e)public void keyPressed(KeyEvent e)if(e.getKeyChar() = KeyEvent.VK_ENTER )&&(userText.getText().trim() != ""

17、)userpwd.requestFocus(););setupComponent(userText,1,1,1,1,false);userpwd = new javax.swing.JPasswordField(12);userpwd.addKeyListener(new KeyListener()public void keyTyped(KeyEvent e)public void keyPressed(KeyEvent e)if(e.getKeyChar() = KeyEvent.VK_ENTER) && (! userpwd.getPassword().toString(

18、).trim().isEmpty()enterpassword.requestFocus();elseuserpwd.requestFocus();public void keyReleased(KeyEvent e);setupComponent(userpwd,1,2,1,1,false);enterpassword = new javax.swing.JPasswordField(12);enterpassword.addKeyListener(new KeyListener()public void keyTyped(KeyEvent e)public void keyReleased

19、(KeyEvent e)public void keyPressed(KeyEvent e)/String pwd = userpwd.getPassword().toString().trim();/String epwd = enterpassword.getPassword().toString().trim();if(e.getKeyChar()=KeyEvent.VK_ENTER) && (userpwd.getPassword().toString().trim()=(enterpassword.getPassword().toString().trim()add.

20、requestFocus();else if(e.getKeyChar()=(KeyEvent.VK_ENTER) && (userpwd.getPassword().toString().trim()!=(enterpassword.getPassword().toString().trim()userpwd.setText("");enterpassword.setText("");userpwd.requestFocus(););setupComponent(enterpassword,1,3,1,1,false);/logoin

21、= new javax.swing.JButton(logoon);add.addKeyListener(new KeyListener()public void keyTyped(KeyEvent e)public void keyReleased(KeyEvent e)public void keyPressed(KeyEvent e)if(e.getKeyChar()=KeyEvent.VK_ENTER )String users =userText.getText().trim();String pwd =userpwd.getPassword().toString().trim();

22、String epwd =enterpassword.getPassword().toString().trim();if(users.isEmpty()javax.swing.JOptionPane.showMessageDialog(logo_Frame, "必須輸入用戶名！","輸入用戶名",JOptionPane.ERROR_MESSAGE);userText.requestFocus();if(pwd.isEmpty()javax.swing.JOptionPane.showMessageDialog(logo_Frame, "必須輸

23、入密碼！","輸入密碼",JOptionPane.ERROR_MESSAGE);userpwd.requestFocus();if(epwd.isEmpty()javax.swing.JOptionPane.showMessageDialog(logo_Frame, "第二個(gè)輸入密碼必須與第一個(gè)密碼相同！","密碼不一致",JOptionPane.ERROR_MESSAGE);enterpassword.requestFocus();boolean b = DBUtil.isExist("select user_n

24、ame from user where user_name="+"'"+users+"'");if(b)javax.swing.JOptionPane.showMessageDialog(logo_Frame, "用戶已經(jīng)存在,請另外輸入！","不能添加",JOptionPane.ERROR_MESSAGE);userText.setText("");userpwd.setText("");enterpassword.setText("&q

25、uot;);userText.requestFocus();int vale = DBUtil.getValue("select user_name from user where user_name='"+users+"'")+1;if(vale>0)String sql = "insert into user values('"+vale+",'"+users+"','"+pwd+"')"boolean bo

26、= USeDB.Update(sql);if(bo)JOptionPane.showConfirmDialog(logo_Frame, "用戶名添加成功！"););add.addActionListener(new ActionListener()public void actionPerformed(ActionEvent e)String users =userText.getText().trim();String pwd =userpwd.getPassword().toString().trim();String epwd =enterpassword.getPa

27、ssword().toString().trim();if(users.isEmpty()javax.swing.JOptionPane.showMessageDialog(null, "必須輸入用戶名！","輸入用戶名",JOptionPane.ERROR_MESSAGE);userText.requestFocus();if(pwd.isEmpty()javax.swing.JOptionPane.showMessageDialog(null, "必須輸入密碼！","輸入密碼",JOptionPane.ERRO

28、R_MESSAGE);userpwd.requestFocus();if(epwd.isEmpty()javax.swing.JOptionPane.showMessageDialog(null, "第二個(gè)輸入密碼必須與第一個(gè)密碼相同！","密碼不一致",JOptionPane.ERROR_MESSAGE);enterpassword.requestFocus();boolean b = DBUtil.isExist("select user_name from user where user_name='"+users+&q

29、uot;'");if(b)javax.swing.JOptionPane.showMessageDialog(logo_Frame, "用戶已經(jīng)存在,請另外輸入！","不能添加",JOptionPane.ERROR_MESSAGE);userText.setText("");userpwd.setText("");enterpassword.setText("");userText.requestFocus();int vale = DBUtil.getValue("

30、select user_name from user where user_name='"+users+"'")+1;if(vale>0)String sql = "insert into user values('"+vale+",'"+users+"','"+pwd+"')"USeDB.UpdateDB(sql);boolean bo = DBUtil.isExist("select user_name fro

31、m user where id=vale");if(bo)JOptionPane.showConfirmDialog(null, "用戶名添加成功！");JOptionPane.showConfirmDialog(null, "用戶名已經(jīng)存在！");userText.setText("");userpwd.setText("");enterpassword.setText("");userText.requestFocus(););setupComponent(add,0,4,1,1,

32、true);/javax.swing.JButton exit = new javax.swing.JButton(logooff);cancle.addActionListener(new ActionListener()public void actionPerformed(ActionEvent e2)logo_Frame.dispose();/System.exit(0););setupComponent(cancle,1,4,1,1,true);java.awt.Dimension d = tools.getScreenSize();int width = (int)(d.getWi

33、dth()-350) /2;int height = (int)(d.getHeight()-240)/2;logo_Frame.add(jp);logo_Frame.setAlwaysOnTop(true);logo_Frame.setLocation(width, height);logo_Frame.setSize(350, 240);logo_Frame.pack();logo_Frame.validate();logo_Frame.setVisible(true);private void setupComponent(JComponent component,int gridx,i

34、nt gridy,int gridwidth,int ipadx,boolean fill)final GridBagConstraints gridBagConstrains = new GridBagConstraints();gridBagConstrains.gridx = gridx;gridBagConstrains.gridy = gridy;gridBagConstrains.insets = new java.awt.Insets(5,3,3,3);if(gridwidth>1)gridBagConstrains.gridwidth = gridwidth;if(ipa

35、dx > 0)gridBagConstrains.ipadx = ipadx;if(fill)gridBagConstrains.fill = GridBagConstraints.HORIZONTAL;jp.add(component,gridBagConstrains);package src;import java.awt.AlphaComposite;import java.awt.GradientPaint;import java.awt.Graphics;import java.awt.Graphics2D;import java.awt.GridBagConstraints

36、;import java.awt.GridBagLayout;import java.awt.RenderingHints;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.KeyEvent;import java.awt.event.KeyListener;import java.util.regex.Matcher;import java.util.regex.Pattern;import javax.swing.JPanel;import javax.s

37、wing.JComponent;public class createStuffQuitInterFace extends JPanelprivate final static long serialVersionUID = 3L;private javax.swing.JTextField stuff_id = null;private javax.swing.JTextField stuff_name = null;private javax.swing.JTextField stuff_company = null;private javax.swing.JTextField stuff

38、_people = null;private javax.swing.JTextField check_people = null;private javax.swing.JTextField stuff_unit = null;private javax.swing.JTextField stuff_value = null;private javax.swing.JTextField stuff_spec = null;private javax.swing.JTextField stuff_color = null;private javax.swing.JTextField stuff

39、_place = null;private javax.swing.JTextField stock_date = null;private javax.swing.JTextField stuff_text = null;private javax.swing.JButton enter = null;private javax.swing.JButton clean = null;private javax.swing.JButton cancle = null;private String sql = null;public createStuffQuitInterFace() / TO

40、DO 自動(dòng)生成構(gòu)造函數(shù)存根this.setLayout(new GridBagLayout();this.setBackground(java.awt.Color.PINK);javax.swing.JLabel stuff_id_label = new javax.swing.JLabel("編 號:");setupComponent(stuff_id_label,0,0,1,1,true);stuff_id = new javax.swing.JTextField(10);stuff_id.requestFocus();stuff_id.addKeyListener(n

41、ew KeyListener()public void keyReleased(KeyEvent e)if(e.getKeyChar() = KeyEvent.VK_ENTER) && (stuff_id.getText().trim() != "")stuff_name.requestFocus();public void keyTyped(KeyEvent e)public void keyPressed(KeyEvent e);setupComponent(stuff_id,1,0,1,1,true);javax.swing.JLabel stuff_

42、name_label = new javax.swing.JLabel("原料名：");setupComponent(stuff_name_label,2,0,1,1,true);stuff_name = new javax.swing.JTextField(10);stuff_name.addKeyListener(new KeyListener()public void keyTyped(KeyEvent e)public void keyPressed(KeyEvent e)public void keyReleased(KeyEvent e)if(e.getKeyC

43、har()=KeyEvent.VK_ENTER) && (stuff_name.getText().trim() != "")stuff_company.requestFocus(););setupComponent(stuff_name,3,0,1,1,true);javax.swing.JLabel stuff_company_label = new javax.swing.JLabel("生產(chǎn)商：");setupComponent(stuff_company_label,4,0,1,1,true);stuff_company = n

44、ew javax.swing.JTextField(10);stuff_company.addKeyListener(new KeyListener()public void keyTyped(KeyEvent e)public void keyPressed(KeyEvent e)public void keyReleased(KeyEvent e)if(e.getKeyChar()=KeyEvent.VK_ENTER) && (stuff_company.getText().trim() != "")stuff_people.requestFocus()

45、;);setupComponent(stuff_company,5,0,1,1,true);javax.swing.JLabel stuff_people_label = new javax.swing.JLabel("收貨員：");setupComponent(stuff_people_label,6,0,1,1,true);stuff_people = new javax.swing.JTextField(10);stuff_people.addKeyListener(new KeyListener()public void keyTyped(KeyEvent e)pu

46、blic void keyPressed(KeyEvent e)public void keyReleased(KeyEvent e)if(e.getKeyChar()=KeyEvent.VK_ENTER) && (stuff_people.getText().trim() != "")check_people.requestFocus(););setupComponent(stuff_people,7,0,1,1,true);javax.swing.JLabel check_people_label = new javax.swing.JLabel(&qu

47、ot;檢驗(yàn)員：");setupComponent(check_people_label,0,1,1,1,true);check_people = new javax.swing.JTextField(10);check_people.addKeyListener(new KeyListener()public void keyTyped(KeyEvent e)public void keyPressed(KeyEvent e)public void keyReleased(KeyEvent e)if(e.getKeyChar()=KeyEvent.VK_ENTER) &&am

48、p; (check_people.getText().trim() != "")stuff_unit.requestFocus(););setupComponent(check_people,1,1,1,1,true);javax.swing.JLabel stuff_unit_label = new javax.swing.JLabel("單 位：");setupComponent(stuff_unit_label,2,1,1,1,true);stuff_unit = new javax.swing.JTextField(10);stuff_unit.

49、addKeyListener(new KeyListener()public void keyTyped(KeyEvent e)public void keyPressed(KeyEvent e)public void keyReleased(KeyEvent e)if(e.getKeyChar()=KeyEvent.VK_ENTER) && (stuff_unit.getText().trim() != "")stuff_value.requestFocus(););setupComponent(stuff_unit,3,1,1,1,true);javax

50、.swing.JLabel stuff_value_label = new javax.swing.JLabel("數(shù) 量：");setupComponent(stuff_value_label,4,1,1,1,true);stuff_value = new javax.swing.JTextField(10);stuff_value.addKeyListener(new KeyListener()public void keyTyped(KeyEvent e)public void keyPressed(KeyEvent e)public void keyReleased

51、(KeyEvent e)if(e.getKeyChar()=KeyEvent.VK_ENTER) && (stuff_value.getText().trim() != "")if(CheckValue(stuff_value.getText().trim()stuff_spec.requestFocus();elsejavax.swing.JOptionPane.showMessageDialog(null,"你的錄入有誤，請錄入0-9的數(shù)值！","錄入錯(cuò)誤",javax.swing.JOptionPane.ERRO

52、R_MESSAGE);stuff_value.setText("");stuff_value.requestFocus(););setupComponent(stuff_value,5,1,1,1,true);javax.swing.JLabel stuff_spec_label = new javax.swing.JLabel("規(guī) 格：");setupComponent(stuff_spec_label,6,1,1,1,true);stuff_spec = new javax.swing.JTextField(10);stuff_spec.addKe

53、yListener(new KeyListener()public void keyTyped(KeyEvent e)public void keyPressed(KeyEvent e)public void keyReleased(KeyEvent e)if(e.getKeyChar()=KeyEvent.VK_ENTER) && (stuff_spec.getText().trim() != "")stuff_color.requestFocus(););setupComponent(stuff_spec,7,1,1,1,true);javax.swin

54、g.JLabel stuff_color_label = new javax.swing.JLabel("顏 色：");setupComponent(stuff_color_label,0,2,1,1,true);stuff_color = new javax.swing.JTextField(10);stuff_color.addKeyListener(new KeyListener()public void keyTyped(KeyEvent e)public void keyPressed(KeyEvent e)public void keyReleased(KeyEvent e)if(e.getKeyChar()=KeyEvent.VK_ENTER) && (stuff_color.getText().trim() != "")stuff_place.requestFocus(););setupComponent(stuff_color,1,2,1,1,true);javax.swi