网上花店后台管理系统

1、 网上花店后台管理系统设计报告1.概述 现如今网上购物越来越趋于大众化，购物种类应有尽有，方便又不受地域的限制，所以我们小组本次的课程设计决定做一个网上花店的管理系统，把在这个系统里的管理员模块详细的展示出来。本系统以网上花店日常工作为起点，把管理员模块通过对花店的管理表现出来。管理员管理模块包括查询模块和更新模块。管理员可以对鲜花，供应商，货物的出入记录进行更新，也可以查询供应商的信息，鲜花的信息，以及顾客的信息。本次课程设计用SQL 2008、eclipse 等工具开发。2.设计内容网上花店管理系统主要功能是用于查询、保存和编辑添加鲜花，供应商的资料、工作人员信息和统计资金、货物的信息，包

2、括供应商、顾客、资金及鲜花等。用于查询和编辑供应商的基本信息，包括供应商的厂商名、地址和电话等；用于查询和编辑鲜花的基本信息，包括鲜花的名称、颜色、成本价、零售价、送花对象、适用季节以及花的用途等；用于查询和编辑顾客的基本信息，包括顾客的姓名、登陆账号、年龄、联系电话和性别等。模式图表示如下：总体设计依据的表格表1：supplier供应商序号列名数据类型长度是否为空默认值说明1SUnochar10Not null供应商编号(主键)2SUnamechar20Not null厂商名3SUaddresschar20Not null地址4SUtelchar11Not null电话表2：flower鲜花

3、序号列名数据类型长度是否为空默认值说明1FLnoChar10not null鲜花编号 (主键)2FLnamechar 10not null花名3FLcolorchar 20not null颜色4FLcostpricenumeric(3,2) not null成本价5FLretailpricenumeric(3,2) not null零售价6FLobjectChar 4not null对象7FLfestivalchar 6not null适用节日8FLfunctionschar 20not null用途表5：customer顾客序号列名数据类型长度是否为空默认值说明1CUnoChar6not n

4、ull顾客编号（主键）2CUnameChar8not null姓名3CUaccountChar8not null登陆账号4CUageTinyint年龄5CUtelchar11not null联系电话6CUsexchar2男或女性别表6：supply供应序号列名数据类型长度是否为空默认值说明1DinoChar10Not null订单号1SUnochar10not null供应商编号（外键参照表supplier的SUno）2FLnochar10not null鲜花编号（外键参照表flower的FLno）3SUPtimeChar 15not null供应时间4SUPqulitydouble not

5、null供应量表9：netorder网上订购序号列名数据类型长度是否为空默认值说明1CUnoChar6Not null顾客编号（外键参照表customer的CUno）2FLnoChar10Not null鲜花编号（外键参照表flower的FLno）3NETsaletimeChar15Not null订货时间4NETqulityintNot null订货数量5NETaddresschar50Not null送货地点6NETtaketimeChar 15Not null送货时间7NETremarkchar50Not null备注3. 具体设计关系图：各类，函数，成员鲜花总框架 class Flow

6、erManage 是否已登录 flag与数据库的链接成员 Connection con Statement stPreparedStatement pResultSet reprivate static String DBUrl;登录面板 JPanel pdenglu=new JPanel();菜单栏 JMenuItem dengluMenuItemJMenuItem checkMenuItemJMenuItem gengxinMenuItemJMenuItem tuichuMenuItem构造函数 public FlowerManage()所有面板 public void sevenoper

7、ation()登录面板 this.dengLuPanel();供应商查询面板 this.gongyingshangc.setOpaque(false);顾客查询面板 this.gukec.setOpaque(false);鲜花查询面板 this.xianhuac.setOpaque(false);订单查询面板 this.dingdanc.setOpaque(false); 货物更新面板 this.huowug.setOpaque(false);供应商更新面板 this.gongyingshangg.setOpaque(false);鲜花更新面板 this.xianhuag.setOpaque(

8、false); 提醒登录面板 this.meidenglu.setOpaque(false);设置背景public void setBack() 登录面板具体设置public void dengLuPanel()管理框架的菜单设置public void operationmenu()事件监听public void actionPerformed(ActionEvent event) 总框架的重新构建 public void rebuild()供应商查询的面板具体设置 public class Gongyingshangc 供应商的更新面板设置 public class Gongyingshan

9、gg鲜花查询面板的具体设置 public class Xianhuac 鲜花更新面板的具体设置 public class Xianhuag 货物更新面板的具体设置 public class Huowug 顾客查询面板的具体设置 public class Gukec 订单查询面板的具体设置 public class Dingdanc 4. 设计结果 代码import java.awt.Color;import java.awt.Font;import java.awt.Graphics;import java.awt.event.ActionEvent;import java.awt.event

10、.ActionListener;import java.sql.Statement;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.Random;import javax.swing.BorderFactory;import javax.swing.ImageIcon;import javax.swing.JButton

11、;import javax.swing.JComboBox;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JMenu;import javax.swing.JMenuBar;import javax.swing.JMenuItem;import javax.swing.JPanel;import javax.swing.JTable;import javax.swing.JTextField;import javax.swing.table.DefaultTableModel;/管理框架Suppre

12、ssWarnings("serial")public class FlowerManage extends JFrame implements ActionListener private int flag=0;private Connection con=null;private Statement st=null;private PreparedStatement p=null;private ResultSet re=null;private static String DBDriverStr = "com.microsoft.sqlserver.jdbc.

13、SQLServerDriver"private static String DBUrl;/登录面板 private JPanel pdenglu=new JPanel(); private String s; private JLabel ldenglu=new JLabel("管理员登录"); private JLabel lyonghuming=new JLabel("用户名"); private JTextField tyonghuming=new JTextField(); private JLabel lmima=new JLabel

14、("密码"); private JTextField tmima=new JTextField(); private JLabel lyanzhengma=new JLabel("验证码"); private JTextField tyanzhengma=new JTextField(); private JLabel tjianyanshu=new JLabel(); private JButton bchange=new JButton("看不清，换一张"); private JLabel tixingjian=new JLabe

15、l(); private JButton bdenglu=new JButton("登录"); private JButton btuichu=new JButton("退出"); private Gongyingshangc gongyingshangc=new Gongyingshangc(); private Xianhuac xianhuac=new Xianhuac(); private Gukec gukec=new Gukec(); private Dingdanc dingdanc=new Dingdanc(); private Gong

16、yingshangg gongyingshangg=new Gongyingshangg(); private Xianhuag xianhuag=new Xianhuag(); private Huowug huowug=new Huowug(); private Tongzhi meidenglu=new Tongzhi("请先登录"); JMenuBar mymenu=new JMenuBar();JMenu menu=new JMenu("登陆"),new JMenu("查询"),new JMenu("更新"

17、;),new JMenu("退出");JMenuItem dengluMenuItem=new JMenuItem("登陆管理界面"),;JMenuItem checkMenuItem=new JMenuItem("供应商信息查询"),new JMenuItem("顾客信息查询"),new JMenuItem("订单信息查询"),new JMenuItem("鲜花信息查询");JMenuItem gengxinMenuItem=new JMenuItem("供应商信

18、息更新"),new JMenuItem("鲜花信息更新"),new JMenuItem("货物信息更新");JMenuItem tuichuMenuItem=new JMenuItem("退出管理界面");public FlowerManage()this.setSize(500, 500);this.setTitle("网上鲜花后台管理");this.setBack();this.operationmenu();this.setJMenuBar(mymenu);this.getContentPane()

19、.setLayout(null);sevenoperation();/所有面板public void sevenoperation()/登录面板this.dengLuPanel();this.pdenglu.setOpaque(false);pdenglu.setBounds(25,25,400,400);this.getContentPane().add(pdenglu);this.pdenglu.setLayout(null);this.pdenglu.setVisible(false);/供应商查询面板this.gongyingshangc.setOpaque(false);gongyi

20、ngshangc.setBounds(25,25,400,400); this.getContentPane().add(gongyingshangc);this.gongyingshangc.setLayout(null);this.gongyingshangc.setVisible(false);/顾客查询面板this.gukec.setOpaque(false);gukec.setBounds(25,25,400,400); this.getContentPane().add(gukec);this.gukec.setLayout(null);this.gukec.setVisible(

21、false);/鲜花查询面板this.xianhuac.setOpaque(false);xianhuac.setBounds(25,25,400,400); this.getContentPane().add(xianhuac);this.xianhuac.setLayout(null);this.xianhuac.setVisible(false);/订单查询面板this.dingdanc.setOpaque(false);dingdanc.setBounds(25,25,400,400); this.getContentPane().add(dingdanc);this.dingdanc

22、.setLayout(null);this.dingdanc.setVisible(false); /货物更新面板this.huowug.setOpaque(false);huowug.setBounds(25,25,400,400); this.getContentPane().add(huowug);this.huowug.setLayout(null);this.huowug.setVisible(false); /供应商更新面板this.gongyingshangg.setOpaque(false);gongyingshangg.setBounds(25,25,400,400); th

23、is.getContentPane().add(gongyingshangg);this.gongyingshangg.setLayout(null);this.gongyingshangg.setVisible(false); /鲜花更新面板this.xianhuag.setOpaque(false);xianhuag.setBounds(25,25,400,400); this.getContentPane().add(xianhuag);this.xianhuag.setLayout(null);this.xianhuag.setVisible(false);/提醒登录面板this.me

24、idenglu.setOpaque(false);meidenglu.setBounds(100,100,200,200); this.getContentPane().add(meidenglu);this.meidenglu.setLayout(null);this.meidenglu.setVisible(false);/设置背景public void setBack() (JPanel)this.getContentPane().setOpaque(false);ImageIcon img = new ImageIcon("F:/workspace for book/BB/s

25、rc/1.jpg"); JLabel background = new JLabel(img);this.getLayeredPane().add(background, new Integer(Integer.MIN_VALUE); background.setBounds(0, 0,img.getIconWidth(), img.getIconHeight(); /登录面板具体设置public void dengLuPanel()this.pdenglu.add(ldenglu);ldenglu.setBounds(150,25,200,50);ldenglu.setFont(n

26、ew Font("隶书",Font.BOLD,22); this.pdenglu.add(lyonghuming);lyonghuming.setBounds(50,100,50,30);this.pdenglu.add(tyonghuming);tyonghuming.setBounds(150,100,200,30);this.pdenglu.add(lmima);lmima.setBounds(50,150,50,30);this.pdenglu.add(tmima);tmima.setBounds(150,150,200,30);this.pdenglu.add(l

27、yanzhengma);lyanzhengma.setBounds(50,200,50,30);this.pdenglu.add(tyanzhengma);tyanzhengma.setBounds(150,200,60,30);this.pdenglu.add(tjianyanshu);tjianyanshu.setBounds(220,200,40,30); this.pdenglu.add(bchange); bchange.setBounds(270,200,130,30); bchange.setBackground(Color.PINK); this.bchange.addActi

28、onListener(this); this.pdenglu.add(tixingjian); tixingjian.setBounds(110,250,200,30); this.pdenglu.add(bdenglu); bdenglu.setBounds(100,300,100,30); this.bdenglu.addActionListener(this); this.pdenglu.add(btuichu); btuichu.setBounds(250,300,100,30); this.btuichu.addActionListener(this); this.tjianyans

29、hu.setOpaque(true); this.tjianyanshu.setBorder(BorderFactory.createLineBorder(Color.pink); this.tjianyanshu.setBackground(Color.pink); this.tjianyanshu.setText("47258");/管理框架的菜单设置public void operationmenu()for(int i=0;i<dengluMenuItem.length;i+)menu0.add(dengluMenuItemi);dengluMenuItemi

30、.addActionListener(this);for(int i=0;i<checkMenuItem.length;i+)menu1.add(checkMenuItemi);checkMenuItemi.addActionListener(this);for(int i=0;i<gengxinMenuItem.length;i+)menu2.add(gengxinMenuItemi);gengxinMenuItemi.addActionListener(this);for(int i=0;i<tuichuMenuItem.length;i+)menu3.add(tuich

31、uMenuItemi);tuichuMenuItemi.addActionListener(this);for(int i=0;i<menu.length;i+)mymenu.add(menui);/事件监听public void actionPerformed(ActionEvent event)s=event.getActionCommand();Random r=new Random();int a;String str=""if(flag=1)this.xianhuac.setVisible(false);this.dingdanc.setVisible(fa

32、lse);this.gukec.setVisible(false);this.gongyingshangg.setVisible(false);this.xianhuag.setVisible(false);this.huowug.setVisible(false);this.gongyingshangg.setVisible(false);tyonghuming.setText("");tmima.setText("");tyanzhengma.setText("");for(int i=0;i<=4;i+)a=r.nextI

33、nt(9);str=String.valueOf(a)+str;this.tjianyanshu.setText(str);if(s.equals("登陆管理界面")=true)this.meidenglu.setVisible(false);this.pdenglu.setVisible(true);if(s.equals("看不清，换一张")=true) this.tyanzhengma.setText("");for(int i=0;i<=4;i+)a=r.nextInt(9);str=String.valueOf(a)+

34、str;this.tjianyanshu.setText(str);else if(s.equals("登录")=true)if(tyanzhengma.getText().equals(tjianyanshu.getText()=false)this.tixingjian.setText("验证码不正确，请重新输入！");this.tyanzhengma.setText("");for(int i=0;i<=4;i+)a=r.nextInt(9);str=String.valueOf(a)+str; this.tjianyan

35、shu.setText(str);elseDBUrl= "jdbc:sqlserver:/localhost:1433;" + "databaseName=huadian;user="+tyonghuming.getText()+"password="+tmima.getText()+""try Class.forName(DBDriverStr); con=DriverManager.getConnection(DBUrl); catch(ClassNotFoundException e) System.err.

36、println("ClassNotFoundException: "+e.getMessage(); catch(SQLException e)JFrame tishi=new JFrame("提示");tishi.setSize(400, 100);JLabel tishil=new JLabel("您的用户名或密码不正确，请重新输入");tishi.getContentPane().add(tishil);tishi.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); tishi.set

37、Visible(true); System.out.println("SQLException: "+e.getMessage(); rebuild();flag=1;this.pdenglu.setVisible(false);else if(s.equals("供应商信息查询")=true)this.xianhuac.setVisible(false);this.dingdanc.setVisible(false);this.gukec.setVisible(false);this.gongyingshangg.setVisible(false);t

38、his.xianhuag.setVisible(false);this.huowug.setVisible(false);if(flag=0)this.meidenglu.setVisible(true);elsepdenglu.setVisible(false);this.gongyingshangc.setVisible(true);else if(s.equals("退出管理界面")=true)this.dispose();else if(s.equals("顾客信息查询")=true)this.xianhuac.setVisible(false)

39、;this.dingdanc.setVisible(false);this.gongyingshangc.setVisible(false);this.gongyingshangg.setVisible(false);this.xianhuag.setVisible(false);this.huowug.setVisible(false);if(flag=0)this.meidenglu.setVisible(true);elsepdenglu.setVisible(false);this.gukec.setVisible(true);else if(s.equals("鲜花信息查询

40、")=true)this.gongyingshangc.setVisible(false);this.dingdanc.setVisible(false);this.gukec.setVisible(false);this.gongyingshangg.setVisible(false);this.xianhuag.setVisible(false);this.huowug.setVisible(false);if(flag=0)pdenglu.setVisible(false);this.meidenglu.setVisible(true);elsethis.xianhuac.se

41、tVisible(true);else if(s.equals("订单信息查询")=true)this.xianhuac.setVisible(false);this.gongyingshangc.setVisible(false);this.gukec.setVisible(false);this.gongyingshangg.setVisible(false);this.xianhuag.setVisible(false);this.huowug.setVisible(false);if(flag=0)this.meidenglu.setVisible(true);el

42、sepdenglu.setVisible(false);this.dingdanc.setVisible(true);else if(s.equals("供应商信息更新")=true)this.xianhuac.setVisible(false);this.dingdanc.setVisible(false);this.gongyingshangc.setVisible(false);this.gukec.setVisible(false);this.xianhuag.setVisible(false);this.huowug.setVisible(false);if(fl

43、ag=0)this.meidenglu.setVisible(true);elsepdenglu.setVisible(false);this.gongyingshangg.setVisible(true);else if(s.equals("鲜花信息更新")=true)this.xianhuac.setVisible(false);this.dingdanc.setVisible(false);this.gukec.setVisible(false);this.gongyingshangg.setVisible(false);this.gongyingshangc.set

44、Visible(false);this.huowug.setVisible(false);if(flag=0)this.meidenglu.setVisible(true);elsepdenglu.setVisible(false);this.xianhuag.setVisible(true);else if(s.equals("货物信息更新")=true)this.xianhuac.setVisible(false);this.dingdanc.setVisible(false);this.gukec.setVisible(false);this.gongyingshan

45、gg.setVisible(false);this.xianhuag.setVisible(false);this.gongyingshangc.setVisible(false);if(flag=0)this.meidenglu.setVisible(true);elsepdenglu.setVisible(false);this.huowug.setVisible(true); public void rebuild() this.dispose(); FlowerManage flowerManage1=new FlowerManage(); flowerManage1.setDefau

46、ltCloseOperation(JFrame.EXIT_ON_CLOSE); flowerManage1.setVisible(true); public static void main(String args) / TODO Auto-generated method stubFlowerManage flowerManage=new FlowerManage();flowerManage.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); flowerManage.setVisible(true);/供应商查询的面板具体设置SuppressW

47、arnings("serial")public class Gongyingshangc extends JPanel implements ActionListenerprivate String s1;private String no;private String address;private String changming;private String tel;private JLabel gc=new JLabel("供应商信息查询");private JButton tjcx=new JButton("条件查询");p

48、rivate JButton qbcx=new JButton("全部查询");private JPanel tj=new JPanel();private JLabel lgb1=new JLabel("供应商编号");private JTextField tgb=new JTextField();private JButton cx=new JButton("查询");private JLabel gx=new JLabel("供应商基本详情");private JButton gybc=new JButton

49、("供应查询");private JLabel gb2=new JLabel("供应商编号");private JLabel gb3=new JLabel();private JLabel cm1=new JLabel("供应商名称");private JLabel cm2=new JLabel();private JLabel dz1=new JLabel("地址");private JLabel dz2=new JLabel();private JLabel lxdh1=new JLabel("联系电

50、话");private JComboBox year=new JComboBox();private JComboBox month=new JComboBox();private JComboBox day=new JComboBox();private JLabel lxdh2=new JLabel();private JLabel gyb=new JLabel("供应商供应表");private DefaultTableModel mod1=new DefaultTableModel(9,4);private JTable gb1=new JTable(mo

51、d1); private JPanel qb=new JPanel();private JLabel gyjb=new JLabel("全部供应商基本表");private JButton qbcg=new JButton("全部供应查询");private DefaultTableModel mod2=new DefaultTableModel(7,4);private JTable gyb1=new JTable(mod2);private JLabel gygh=new JLabel("全部供应商供货单");private De

52、faultTableModel mod3=new DefaultTableModel(7,5);private JTable gyb2=new JTable(mod3);private JComboBox year1=new JComboBox();private JComboBox month1=new JComboBox();private JComboBox day1=new JComboBox();public void panel1()this.tj.add(lgb1);lgb1.setBounds(10,0,80,20);this.tj.add(tgb);tgb.setBounds(95,0,12