modifymenu.java

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

/**
 * creating Modify 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 ModifyMenu extends JApplet
{
    String[] Names_mod = new String[50];
    String[] description_mod = new String[50];
    int[][] Edges_mod = new int[50][3];
    int[] Nums_mod = new int[50];
    int
      NumStart_mod,
      NumEnd_mod;
    
    String[] Menu_mod = {"Modify Network"};
    JTabbedPane tabs_mod = new JTabbedPane();
    JPanel 
      panel_mod = new JPanel();
    JTextField 
      t_mod = new JTextField(20),
      t1_modStation = new JTextField(15),
      t1_modCon = new JTextField(5);
    JTextArea
      ta_mod = new JTextArea(20,40);
    ButtonGroup 
      g_mod = new ButtonGroup();
    JRadioButton 
      rb1_mod = new JRadioButton("MODIFY STATIONS", false),
      rb2_mod = new JRadioButton("MODIFY CONNECTIONS", false);
    JLabel
      l1_modStation = new JLabel("Modify station:"),
      l2_modStation = new JLabel("To"),
      l1_modCon = new JLabel("Modify Connection from:"),
      l2_modCon = new JLabel("to:"),
      l3_modCon = new JLabel("New Time Consuming:");
    JComboBox
      c1_modStation = new JComboBox(),
      c1_modCon = new JComboBox(),
      c2_modCon = new JComboBox();
    JButton
      b1_modStation = new JButton("Confirm"),
      b2_modStation = new JButton("Modify new"),
      b1_modCon = new JButton("Confirm"),
      b2_modCon = new JButton("Modify new"),
      b1_mod = new JButton("Reset"),
      b2_mod = new JButton("Display Stations"),
      b3_mod = new JButton("Display Connections");
      
    public void init() 
    {
        try
        {
            Arrays.fill(Names_mod,"");
            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_mod[i] = rs.getString("Name").trim();
                i++;
            }
        }catch(Exception e1){}
        
        description_mod = Names_mod;
        for(int i=0; i<description_mod.length; i++)
        {
            String s = description_mod[i];
            if ( !s.equals("") || i==0 )
            {
                c1_modStation.addItem(s);
                c1_modCon.addItem(s);
                c2_modCon.addItem(s);
            }
        }
        
        c1_modStation.setEnabled(false);
        c1_modCon.setEnabled(false);
        c2_modCon.setEnabled(false);     
        
        Container cp = getContentPane();
        cp.add(tabs_mod);
        
        panel_mod.setBorder( BorderFactory.createEmptyBorder(10,10,10,10) );
        panel_mod.add(rb1_mod); 
        panel_mod.add(rb2_mod); 
        panel_mod.add(t_mod);
        panel_mod.add(l1_modStation);
        panel_mod.add(c1_modStation);
        panel_mod.add(l2_modStation);
        panel_mod.add(t1_modStation);
        panel_mod.add(b1_modStation);
        panel_mod.add(b2_modStation);
        panel_mod.add(l1_modCon);
        panel_mod.add(c1_modCon);
        panel_mod.add(l2_modCon);
        panel_mod.add(c2_modCon);
        panel_mod.add(l3_modCon);
        panel_mod.add(t1_modCon);
        panel_mod.add(b1_modCon);
        panel_mod.add(b2_modCon);
        panel_mod.add(ta_mod);
        panel_mod.add(b2_mod);
        panel_mod.add(b3_mod);
        panel_mod.add(b1_mod);
        g_mod.add(rb1_mod); 
        g_mod.add(rb2_mod);
        t_mod.setEditable(false);
        t_mod.setForeground(Color.blue);
        t1_modStation.setEditable(false);
        t1_modCon.setEditable(false);
        ta_mod.setForeground(Color.blue);
                
        rb1_mod.addActionListener(al1_mod);
        rb2_mod.addActionListener(al2_mod);
        b1_mod.addActionListener(al3_mod);
        b2_mod.addActionListener(al4_mod);
        b3_mod.addActionListener(al5_mod);
        b1_modStation.addActionListener(al1_modStation);
        b2_modStation.addActionListener(al2_modStation);
        b1_modCon.addActionListener(al1_modCon);
        b2_modCon.addActionListener(al2_modCon);
        
        tabs_mod.addTab(Menu_mod[0], panel_mod);
    }
    
    ActionListener 
      al1_mod = new ActionListener()
      {
          public void actionPerformed(ActionEvent e)
          {
              c1_modStation.setEnabled(true);
              t1_modStation.setEditable(true);
              c1_modCon.setEnabled(false);
              c2_modCon.setEnabled(false);
              t1_modCon.setEditable(false);
              t_mod.setText("STATUS: Modifying Stations");
              try
              {
                  Arrays.fill(Names_mod,"");
                  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_mod[i] = rs.getString("Name").trim();
                      i++;
                  }
               }catch(Exception e1){}
              
               description_mod = Names_mod;
               c1_modStation.removeAllItems();
               for(int i=0; i<description_mod.length; i++)
               {
                   String s = description_mod[i];
                   if ( !s.equals("") || i==0 )
                   c1_modStation.addItem(s);
               }

           }
       },
       
       al2_mod = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                c1_modCon.setEnabled(true);
                c2_modCon.setEnabled(true);
                c1_modStation.setEnabled(false);
                t1_modStation.setEditable(false);
                t_mod.setText("STATUS: Modifying Connections");
                t1_modCon.setEditable(true);
                try
                {
                    Arrays.fill(Names_mod,"");
                    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_mod[i] = rs.getString("Name").trim();
                        i++;
                    }
               }catch(Exception e1){}
               
               description_mod = Names_mod;
               c1_modCon.removeAllItems();
               c2_modCon.removeAllItems();
               for(int i=0; i<description_mod.length; i++)
               {
                    String s = description_mod[i];
                    if ( !s.equals("") || i==0 )
                    {
                        c1_modCon.addItem(s);
                        c2_modCon.addItem(s);
                    }
               }
               
           }
       },
       
       al3_mod = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                t_mod.setEditable(true);
                t_mod.selectAll();
                t_mod.cut();
                t_mod.setEditable(false);
                t1_modStation.selectAll();
                t1_modStation.cut();
                t1_modCon.selectAll();
                t1_modCon.cut();
                ta_mod.selectAll();
                ta_mod.cut();
                c1_modStation.setSelectedItem(description_mod[0]);
                c1_modCon.setSelectedItem(description_mod[0]);
                c2_modCon.setSelectedItem(description_mod[0]);
                c1_modStation.setEnabled(false);
                c1_modCon.setEnabled(false);
                c2_modCon.setEnabled(false);
                t1_modStation.setEditable(false);
                t1_modCon.setEditable(false);
            }
       },
                
       al4_mod = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                  ta_mod.append("All Stations:" + "\n");
                  try
                  {
                       Arrays.fill(Names_mod,"");
                       Driver driver = (Driver) Class.forName("com.jnetdirect.jsql.JSQLDriver").newInstance();