deletemenu.java

学生project 火车时刻查询系统 软件工程文档-英文。对需要软件工程文档的朋友有写帮助

/**
 * creating Delelte network Menu (Administrators only) with Swing
 */
import javax.swing.*;
import javax.swing.event.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;

import java.sql.*;
import java.util.Properties;
import java.net.*;

public class DeleteMenu extends JApplet
{
    String[] Names_del = new String[50];
    String[] description_del = new String[50];
    int[][] Edges_del = new int[50][3];
    int[] Nums_del = new int[50];
    int
      NumStart_del,
      NumEnd_del;
    
    String[] Menu_del = {"Delete Network"};
    JTabbedPane tabs_del = new JTabbedPane();
    JPanel 
      panel_del = new JPanel();
    JTextField 
      t_del = new JTextField(20);
    JTextArea
      ta_del = new JTextArea(20,40);
    ButtonGroup 
      g_del = new ButtonGroup();
    JRadioButton 
      rb1_del = new JRadioButton("DELETE STATIONS", false),
      rb2_del = new JRadioButton("DELETE CONNECTIONS", false);
    JLabel
      l1_delStation = new JLabel("Delete station:"),
      l1_delCon = new JLabel("Delete Connection from:"),
      l2_delCon = new JLabel("to:");
    JComboBox
      c1_delStation = new JComboBox(),
      c1_delCon = new JComboBox(),
      c2_delCon = new JComboBox();
    JButton
      b1_delStation = new JButton("Confirm"),
      b2_delStation = new JButton("Delete new"),
      b1_delCon = new JButton("Confirm"),
      b2_delCon = new JButton("Delete new"),
      b1_del = new JButton("Reset"),
      b2_del = new JButton("Display Stations"),
      b3_del = new JButton("Display Connections");
      
    public void init() 
    {
        try
        {
            Arrays.fill(Names_del,"");
            Driver driver = (Driver) Class.forName("com.jnetdirect.jsql.JSQLDriver").newInstance();
            String connectStr = "jdbc:JSQLConnect://127.0.0.1/database=G6/user=sa";
            Connection  conn = driver.connect(connectStr, new Properties());
            Statement stmt = conn.createStatement();    
            DatabaseMetaData db = conn.getMetaData();

            String v = "select * from Stations";
            PreparedStatement s = conn.prepareStatement(v);
            ResultSet rs = s.executeQuery();
                    
            int i = 1;
            while( rs.next())
            {
                Names_del[i] = rs.getString("Name").trim();
                i++;
            }
        }catch(Exception e1){}
        
        description_del = Names_del;
        
        for(int i=0; i<description_del.length; i++)
        {
            String s = description_del[i];
            if ( !s.equals("") || i==0 )
            {
                c1_delStation.addItem(s);
                c1_delCon.addItem(s);
                c2_delCon.addItem(s);
            }
        }
 
        c1_delStation.setEnabled(false);
        c1_delCon.setEnabled(false);
        c2_delCon.setEnabled(false);
 
        Container cp = getContentPane();
        cp.add(tabs_del);
        
        panel_del.setBorder( BorderFactory.createEmptyBorder(10,10,10,10) );
        panel_del.add(rb1_del); 
        panel_del.add(rb2_del); 
        panel_del.add(t_del);
        panel_del.add(l1_delStation);
        panel_del.add(c1_delStation);
        panel_del.add(b1_delStation);
        panel_del.add(b2_delStation);
        panel_del.add(l1_delCon);
        panel_del.add(c1_delCon);
        panel_del.add(l2_delCon);
        panel_del.add(c2_delCon);
        panel_del.add(b1_delCon);
        panel_del.add(b2_delCon);
        panel_del.add(ta_del);
        panel_del.add(b2_del);
        panel_del.add(b3_del);
        panel_del.add(b1_del);
        g_del.add(rb1_del); 
        g_del.add(rb2_del);
        t_del.setEditable(false);
        t_del.setForeground(Color.blue);
        ta_del.setForeground(Color.blue);
                
        rb1_del.addActionListener(al1_del);
        rb2_del.addActionListener(al2_del);
        b1_del.addActionListener(al3_del);
        b2_del.addActionListener(al4_del);
        b3_del.addActionListener(al5_del);
        b1_delStation.addActionListener(al1_delStation);
        b2_delStation.addActionListener(al2_delStation);
        b1_delCon.addActionListener(al1_delCon);
        b2_delCon.addActionListener(al2_delCon);
        
        tabs_del.addTab(Menu_del[0], panel_del);
    }
    
    ActionListener 
      al1_del = new ActionListener()
      {
          public void actionPerformed(ActionEvent e)
          {
              c1_delStation.setEnabled(true);
              c1_delCon.setEnabled(false);
              c2_delCon.setEnabled(false);
              t_del.setText("STATUS: Deleting Stations");
              try
              {
                  Arrays.fill(Names_del,"");
                  Driver driver = (Driver) Class.forName("com.jnetdirect.jsql.JSQLDriver").newInstance();
                  String connectStr = "jdbc:JSQLConnect://127.0.0.1/database=G6/user=sa";
                  Connection  conn = driver.connect(connectStr, new Properties());
                  Statement stmt = conn.createStatement();    
                  DatabaseMetaData db = conn.getMetaData();

                  String v = "select * from Stations";
                  PreparedStatement s = conn.prepareStatement(v);
                  ResultSet rs = s.executeQuery();
                    
                  int i = 1;
                  while( rs.next())
                  {
                      Names_del[i] = rs.getString("Name").trim();
                      i++;
                  }
               }catch(Exception e1){}
              
               description_del = Names_del;
               c1_delStation.removeAllItems();
               for(int i=0; i<description_del.length; i++)
               {
                   String s = description_del[i];
                   if ( !s.equals("") || i==0 )
                   c1_delStation.addItem(s);
               }

           }
       },
       
       al2_del = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                c1_delCon.setEnabled(true);
                c2_delCon.setEnabled(true);
                c1_delStation.setEnabled(false);
                try
                {
                    Arrays.fill(Names_del,"");
                    Driver driver = (Driver) Class.forName("com.jnetdirect.jsql.JSQLDriver").newInstance();
                    String connectStr = "jdbc:JSQLConnect://127.0.0.1/database=G6/user=sa";
                    Connection  conn = driver.connect(connectStr, new Properties());
                    Statement stmt = conn.createStatement();    
                    DatabaseMetaData db = conn.getMetaData();

                    String v = "select * from Stations";
                    PreparedStatement s = conn.prepareStatement(v);
                    ResultSet rs = s.executeQuery();
                    
                    int i = 1;
                    while( rs.next())
                    {
                        Names_del[i] = rs.getString("Name").trim();
                        i++;
                    }
               }catch(Exception e1){}
               
               description_del = Names_del;
               c1_delCon.removeAllItems();
               c2_delCon.removeAllItems();
               for(int i=0; i<description_del.length; i++)
               {
                    String s = description_del[i];
                    if ( !s.equals("") || i==0 )
                    {
                        c1_delCon.addItem(s);
                        c2_delCon.addItem(s);
                    }
               }
               t_del.setText("STATUS: Deleting Connections");
           }
       },
       
       al3_del = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                t_del.setEditable(true);
                t_del.selectAll();
                t_del.cut();
                t_del.setEditable(false);
                ta_del.selectAll();
                ta_del.cut();
                c1_delStation.setSelectedItem(description_del[0]);
                c1_delCon.setSelectedItem(description_del[0]);
                c2_delCon.setSelectedItem(description_del[0]);
                c1_delStation.setEnabled(false);
                c1_delCon.setEnabled(false);
                c2_delCon.setEnabled(false);

            }
       },
                
       al4_del = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                  ta_del.append("All Stations:" + "\n");
                  try
                  {
                       Arrays.fill(Names_del,"");
                       Driver driver = (Driver) Class.forName("com.jnetdirect.jsql.JSQLDriver").newInstance();