网上花店后台管理系统设计报告1.概述现如今网上购物越来越趋于大众化，购物种类应有尽有，方便又不受地域的限制，所以我们小组本次的课程设计决定做一个网上花店的管理系统，把在这个系统里的管理员模块详细的展示出来。
本系统以网上花店日常工作为起点，把管理员模块通过对花店的管理表现出来。
管理员管理模块包括查询模块和更新模块。
管理员可以对鲜花，供应商，货物的出入记录进行更新，也可以查询供应商的信息，鲜花的信息，以及顾客的信息。
本次课程设计用SQL 2008、eclipse 等工具开发。
2.设计内容网上花店管理系统主要功能是用于查询、保存和编辑添加鲜花，供应商的资料、工作人员信息和统计资金、货物的信息，包括供应商、顾客、资金及鲜花等。
用于查询和编辑供应商的基本信息，包括供应商的厂商名、地址和电话等；用于查询和编辑鲜花的基本信息，包括鲜花的名称、颜色、成本价、零售价、送花对象、适用季节以及花的用途等；用于查询和编辑顾客的基本信息，包括顾客的姓名、登陆账号、年龄、联系电话和性别等。
模式图表示如下：总体设计依据的表格表2：flower鲜花表5：customer顾客表9：netorder网上订购3.具体设计关系图：n1各类，函数，成员鲜花总框架class FlowerManage是否已登录 flag与数据库的链接成员 Connection conStatement stPreparedStatement pResultSet reprivate static String DBUrl;登录面板 JPanel pdenglu=new JPanel();菜单栏 JMenuItem[] dengluMenuItemJMenuItem[] checkMenuItemJMenuItem[] gengxinMenuItemJMenuItem[] tuichuMenuItem构造函数 public FlowerManage()所有面板 public void sevenoperation(){登录面板 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(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 Gongyingshangg鲜花查询面板的具体设置 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.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;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;//管理框架@SuppressWarnings("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.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("密码");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 JLabel();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 Gongyingshangg 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("更新"),new JMenu("退出")};JMenuItem[] dengluMenuItem={new JMenuItem("登陆管理界面"),};JMenuItem[] checkMenuItem={new JMenuItem("供应商信息查询"),new JMenuItem("顾客信息查询"),new JMenuItem("订单信息查询"),new JMenuItem("鲜花信息查询")};JMenuItem[] gengxinMenuItem={new JMenuItem("供应商信息更新"),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().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);gongyingshangc.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(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.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);this.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.meidenglu.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//src//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(new 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(lyanzhengma);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.addActionListener(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.tjianyanshu.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++){menu[0].add(dengluMenuItem[i]);dengluMenuItem[i].addActionListener(this);}for(int i=0;i<checkMenuItem.length;i++){menu[1].add(checkMenuItem[i]);checkMenuItem[i].addActionListener(this);}for(int i=0;i<gengxinMenuItem.length;i++){ menu[2].add(gengxinMenuItem[i]);gengxinMenuItem[i].addActionListener(this);}for(int i=0;i<tuichuMenuItem.length;i++){menu[3].add(tuichuMenuItem[i]);tuichuMenuItem[i].addActionListener(this);}for(int i=0;i<menu.length;i++){mymenu.add(menu[i]);}}//事件监听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(false);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.nextInt(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)+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.tjianyanshu.setText(str);}else{DBUrl= "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.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.setVisible(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);this.xianhuag.setVisible(false);this.huowug.setVisible(false);if(flag==0){this.meidenglu.setVisible(true);}else{pdenglu.setVisible(false);this.gongyingshangc.setVisible(true);}}else if(s.equals("退出管理界面")==true){ this.dispose();}else if(s.equals("顾客信息查询")==true){ this.xianhuac.setVisible(false);this.dingdanc.setVisible(false);this.gongyingshangc.setVisible(false);this.gongyingshangg.setVisible(false);this.xianhuag.setVisible(false);this.huowug.setVisible(false);this.meidenglu.setVisible(true);}else{pdenglu.setVisible(false);this.gukec.setVisible(true);}}else if(s.equals("鲜花信息查询")==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);}else{this.xianhuac.setVisible(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);this.meidenglu.setVisible(true);}else{pdenglu.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(flag==0){this.meidenglu.setVisible(true);}else{pdenglu.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.setVisible(false);this.huowug.setVisible(false);if(flag==0){this.meidenglu.setVisible(true);}else{pdenglu.setVisible(false);this.xianhuag.setVisible(true);}}else if(s.equals("货物信息更新")==true){this.xianhuac.setVisible(false);this.dingdanc.setVisible(false);this.gukec.setVisible(false);this.gongyingshangg.setVisible(false);this.xianhuag.setVisible(false);this.gongyingshangc.setVisible(false);if(flag==0){this.meidenglu.setVisible(true);}else{pdenglu.setVisible(false);this.huowug.setVisible(true);}}}public void rebuild(){this.dispose();FlowerManage flowerManage1=new FlowerManage();flowerManage1.setDefaultCloseOperation(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);}//供应商查询的面板具体设置@SuppressWarnings("serial")public class Gongyingshangc extends JPanel implements ActionListener{ private String s1;private String no;private String address;private String changming;private String tel;private JLabel gc=new JLabel("供应商信息查询");private JButton tjcx=new JButton("条件查询");private 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("供应查询");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("联系电话");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(mod1);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 DefaultTableModel 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,120,20);this.tj.add(cx);cx.setBounds(250,0,80,20);cx.addActionListener(this);this.tj.add(gx);gx.setBounds(10,25,300,30);gx.setFont(new Font("隶书",Font.BOLD,22));this.tj.add(gb2);gb2.setBounds(10,58,90,20);this.tj.add(gb3);gb3.setBounds(110,58,90,20);this.tj.add(cm1);cm1.setBounds(210,58,90,20);this.tj.add(cm2);cm2.setBounds(310,58,90,20);this.tj.add(dz1);dz1.setBounds(10,80,90,20);this.tj.add(dz2);dz2.setBounds(110,80,90,20);this.tj.add(lxdh1);lxdh1.setBounds(210,80,90,20);this.tj.add(lxdh2);lxdh2.setBounds(310,80,90,20);this.tj.add(year);year.setBounds(220,105,80,20);year.addItem("2012年");year.addItem("2013年");year.addItem("2014年");this.tj.add(month);month.setBounds(300,105,50,20);for(int i=1;i<=12;i++){month.addItem(String.valueOf(i)+"月");}this.tj.add(day);day.setBounds(350,105,50,20);for(int i=1;i<=30;i++){day.addItem(String.valueOf(i)+"日");}this.tj.add(gyb);gyb.setBounds(150,130,100,25);this.tj.add(gybc);gybc.setBounds(300,130,100,25);gybc.addActionListener(this);this.tj.add(gb1);gb1.setBounds(10,160,380,190);mod1.setValueAt("鲜花编号", 0,0 );mod1.setValueAt("鲜花名", 0,1 );mod1.setValueAt("数量", 0,2 );mod1.setValueAt("金额", 0,3 );gb1.setOpaque(false);this.tj.setOpaque(false);this.tj.setVisible(false);this.tj.setLayout(null);this.tj.setBounds(0,50,400,350);}public void panel2(){this.qb.add(gyjb);gyjb.setBounds(10,0,200,28);gyjb.setFont(new Font("隶书",Font.BOLD,22));mod2.setValueAt("供应商编号", 0,0 );mod2.setValueAt("供应商名", 0,1 );mod2.setValueAt("地址", 0,2 );mod2.setValueAt("联系电话", 0,3 );this.qb.add(gyb1);gyb1.setBounds(10,30,380,115);gyb1.setOpaque(false);this.qb.add(gygh);gygh.setBounds(10,150,190,30);gygh.setFont(new Font("隶书",Font.BOLD,22));this.qb.add(year1);year1.setBounds(220,180,80,25);year1.addItem("2012年");year1.addItem("2013年");year1.addItem("2014年");this.qb.add(month1);month1.setBounds(300,180,50,25);for(int i=1;i<=12;i++){month1.addItem(String.valueOf(i)+"月");}this.qb.add(day1);day1.setBounds(350,180,50,25);for(int i=1;i<=30;i++){day1.addItem(String.valueOf(i)+"日");}mod3.setValueAt("供应商编号", 0,0 );mod3.setValueAt("鲜花编号", 0,1 );mod3.setValueAt("鲜花名", 0,2 );mod3.setValueAt("数量", 0,3 );mod3.setValueAt("金额", 0,4);this.qb.add(gyb2);gyb2.setBounds(10,205,380,110);gyb2.setOpaque(false);this.qb.add(qbcg);qbcg.setBounds(310,320,100,25);qbcg.addActionListener(this);this.qb.setOpaque(false);this.qb.setVisible(false);this.qb.setLayout(null);this.qb.setBounds(0,50,400,350);}public Gongyingshangc(){this.add(gc);gc.setFont(new Font("隶书",Font.BOLD,22));gc.setBounds(100, 0, 300,25);this.add(tjcx);tjcx.setBounds(200,25,95,20);tjcx.addActionListener(this);this.add(qbcx);qbcx.setBounds(300,25,100,20);qbcx.addActionListener(this);this.add(tj);panel1();this.add(qb);panel2();}public void actionPerformed(ActionEvent event){ s1=event.getActionCommand();try{if(s1.equals("条件查询")==true){qb.setVisible(false);tj.setVisible(true);}else if(s1.equals("全部查询")==true){tj.setVisible(false);qb.setVisible(true);st=con.createStatement();re=st.executeQuery("select * from supplier");int i=1;while(re.next()){mod2.setValueAt(re.getString("Suno"),i,0 );mod2.setValueAt(re.getString("Suname"),i,1 );mod2.setValueAt(re.getString("Suaddress"),i,2);mod2.setValueAt(re.getString("Sutel"),i,3 );i++;}}else if(s1.equals("查询")==true){p=con.prepareStatement("select * from supplier where Suno=?");p.setString(1,tgb.getText());re=p.executeQuery();while(re.next()){no=re.getString("Suno");gb3.setText(no);changming=re.getString("Suname");cm2.setText(changming);address=re.getString("Suaddress");dz2.setText(address);tel=re.getString("Sutel");lxdh2.setText(tel);}}else if(s1.equals("供应查询")==true){p=con.prepareStatement("selectFlower.Flno,Flower.Flname,Supqulity,Flretailprice from Supply,flower where Suno=?and Suptime=? and Supply.Flno=Flower.Flno");p.setString(1,tgb.getText());p.setString(2,(String)year.getSelectedItem()+month.getSelectedItem()+day.g etSelectedItem());re=p.executeQuery();int i=1;int shuliang;while(re.next()){mod1.setValueAt(re.getString("Flno"),i,0 );mod1.setValueAt(re.getString("Flname"),i,1 );shuliang=re.getInt("Supqulity");mod1.setValueAt(shuliang,i,2);mod1.setValueAt(re.getDouble("Flretailprice")*shuliang,i,3 );i++;}}else if(s1.equals("全部供应查询")==true){p=con.prepareStatement("selectSuno,Flower.Flno,Flower.Flname,Supqulity,Flretailprice from Supply,flower where Suptime=? and Supply.Flno=Flower.Flno");p.setString(1,(String)year1.getSelectedItem()+month1.getSelectedItem()+day 1.getSelectedItem());re=p.executeQuery();int i=1;int shuliang;while(re.next()){mod3.setValueAt(re.getString("Suno"),i,0 );mod3.setValueAt(re.getString("Flno"),i,1 );mod3.setValueAt(re.getString("Flname"),i,2);shuliang=re.getInt("Supqulity");mod3.setValueAt(shuliang,i,3);mod3.setValueAt(re.getDouble("Flretailprice")*shuliang,i,4 );i++;}}}catch(SQLException e){e.printStackTrace();}}}//供应商的更新面板设置@SuppressWarnings("serial")public class Gongyingshangg extends JPanel implements ActionListener{ private String s1;private String no;private String name;private String address;private String changming;private String tel="";private JLabel lgysglt=new JLabel("供应商管理");private JLabel lgysbht=new JLabel("供应商编号");private JTextField tgysbht=new JTextField();private JLabel lcsmt=new JLabel("厂商名");private JTextField tcsmt=new JTextField();private JLabel ldizhit=new JLabel("地址");private JTextField tdizhit=new JTextField();private JLabel llianxidianhuat=new JLabel("联系电话"); private JTextField tlianxidianhuat=new JTextField(); private JButton tianjia=new JButton("添加");private JLabel gysglsx=new JLabel("修改与删除");private JLabel lgysbhc=new JLabel("供应商编号");private JTextField tgysbhc=new JTextField();private JButton chaxun=new JButton("查询");private JLabel lgysbhc1=new JLabel("供应商编号"); private JTextField tgysbhc2=new JTextField();private JLabel lcsmc1=new JLabel("厂商名");private JTextField tcsmc2=new JTextField();private JLabel ldizhic1=new JLabel("地址");private JTextField tdizhic2=new JTextField();private JLabel llianxidianhuac1=new JLabel("联系电话"); private JTextField tlianxidianhuac2=new JTextField(); private JButton xiugai1=new JButton("修改");private JButton shanchu1=new JButton("删除");//Tongzhi xiugai=new Tongzhi("修改成功");//Tongzhi shanchu=new Tongzhi("删除成功");public Gongyingshangg(){this.add(lgysglt);lgysglt.setFont(new Font("隶书",Font.BOLD,22));lgysglt.setBounds(150, 0, 200,25);this.add(lgysbht);lgysbht.setBounds(0,70,100,25);this.add(tgysbht);tgysbht.setBounds(100,70,100,25);this.add(lcsmt);lcsmt.setBounds(210,70,60,25);this.add(tcsmt);tcsmt.setBounds(270,70,100,25);this.add(ldizhit);ldizhit.setBounds(0,105,100,25);this.add(tdizhit);tdizhit.setBounds(100,105,100,25);this.add(llianxidianhuat);llianxidianhuat.setBounds(210,105,60,25);this.add(tlianxidianhuat);tlianxidianhuat.setBounds(270,105,100,25);this.add(tianjia);tianjia.setBounds(300,135,80,25);tianjia.addActionListener(this);/*this.add(tianjia1);this.tianjia1.setOpaque(false);this.tianjia1.setVisible(false);tianjia1.setBounds(0, 0, 200, 200);*/this.add(gysglsx);gysglsx.setFont(new Font("隶书",Font.BOLD,22));gysglsx.setBounds(20, 168, 200,33);this.add(lgysbhc);lgysbhc.setBounds(50, 200, 100,25);this.add(tgysbhc);tgysbhc.setBounds(160, 200, 140,25);this.add(chaxun);chaxun.setBounds(320, 200, 70,25);chaxun.addActionListener(this);this.add(lgysbhc1);lgysbhc1.setBounds(50, 240,100,25);this.add(tgysbhc2);tgysbhc2.setBounds(160, 240, 140,25);this.add(lcsmc1);lcsmc1.setBounds(50, 270, 100,25);this.add(tcsmc2);tcsmc2.setBounds(160, 270, 140,25);this.add(ldizhic1);ldizhic1.setBounds(50, 300, 100,25);this.add(tdizhic2);tdizhic2.setBounds(160, 300, 140,25);this.add(llianxidianhuac1);llianxidianhuac1.setBounds(50, 330, 100,25);this.add(tlianxidianhuac2);tlianxidianhuac2.setBounds(160, 330, 140,25);this.add(xiugai1);xiugai1.setBounds(100, 360, 90,25);xiugai1.addActionListener(this);this.add(shanchu1);shanchu1.setBounds(250, 360, 90,25);shanchu1.addActionListener(this);}public void paintComponent(Graphics g){super.paintComponent(g);g.drawLine(5, 165, 395, 165);}public void actionPerformed(ActionEvent event){ s1=event.getActionCommand();try{if(s1.equals("添加")==true){p=con.prepareStatement("insert into supplier (Suno,Suname,Suaddress,Sutel) values(?,?,?,?)");p.setString(1,tgysbht.getText());p.setString(2,tcsmt.getText());p.setString(3,tdizhit.getText());p.setString(4,tlianxidianhuat.getText());p.executeUpdate();tgysbht.setText("");tcsmt.setText("");tdizhit.setText("");tlianxidianhuat.setText("");}else if(s1.equals("查询")==true){p=con.prepareStatement("select * from supplier where Suno=?");p.setString(1,tgysbhc.getText());re=p.executeQuery();while(re.next()){no=re.getString("Suno");tgysbhc2.setText(no);changming=re.getString("Suname");tcsmc2.setText(changming);address=re.getString("Suaddress");tdizhic2.setText(address);tel=re.getString("Sutel");tlianxidianhuac2.setText(tel);}}else if(s1.equals("删除")==true){p=con.prepareStatement("delete from supplier where Suno=?");p.setString(1,tgysbhc.getText());p.executeUpdate();tgysbhc.setText("");tgysbhc2.setText("");tcsmc2.setText("");tdizhic2.setText("");tlianxidianhuac2.setText("");}else if(s1.equals("修改")==true){if(tcsmc2.getText().equals(name)==false){p=con.prepareStatement("update supplier set Suname=? where Suno=?");p.setString(1,tcsmc2.getText());p.setString(2,tgysbhc2.getText());p.executeUpdate();}else if(tdizhic2.getText().equals(address)==false){p=con.prepareStatement("update supplier set Suaddress=? where Suno=?");p.setString(1,tdizhic2.getText());p.setString(2,tgysbhc2.getText());p.executeUpdate();}else if(tlianxidianhuac2.getText().equals(tel)==false){p=con.prepareStatement("update supplier set Sutel=? where Suno=?");p.setString(1,tlianxidianhuac2.getText());p.setString(2,tgysbhc2.getText());。
