createmenu.java

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

/**
 * creating Create 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 CreateMenu extends JApplet
{
    String[] Names_create = new String[50];
    int[][] Edges_create = new int[50][3];
    int[] Nums_create = new int[50];
    String[] description_create = new String[50];
    int
      NumStart_create,
      NumEnd_create;
    
    String[] Menu_create = {"Creating Network"};
    
    JTabbedPane tabs_create = new JTabbedPane();
    
    JPanel 
      panel_create = new JPanel();
    
    JRadioButton 
      rb1_create = new JRadioButton("CREATE STATIONS", false),
      rb2_create = new JRadioButton("CREATE CONNECTIONS", false);
    
    ButtonGroup 
      g_create = new ButtonGroup();
    
    JLabel 
      l1_addStation = new JLabel("Add Station:"),
      l1_addCon = new JLabel("Add connections"),
      l2_addCon = new JLabel("From:"),
      l3_addCon = new JLabel("to:"),
      l4_addCon = new JLabel("Time Consuming:"),
      l5_addCon = new JLabel("mins");

    JTextField 
      t_create = new JTextField(20),
      t1_addStation = new JTextField(15),
      t1_addCon = new JTextField(10);
 
    JTextArea
      ta_create = new JTextArea(20, 40);
      
    JButton
      b1_addStation = new JButton("Add"),
      b2_addStation = new JButton("Add New"),
      b1_addCon = new JButton("Add"),
      b2_addCon = new JButton("Add new"),
      b1_create = new JButton("Display Stations"),
      b2_create = new JButton("Display Connection"),
      b3_create = new JButton("Reset");
      
    JComboBox
      c1_addCon = new JComboBox(),
      c2_addCon = new JComboBox();

    public void init()
    {
        try
        {
            Arrays.fill(Names_create,"");
            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_create[i] = rs.getString("Name").trim();
                i++;
            }
        }catch(Exception e1){}
        
        description_create = Names_create;
        
        for(int i=0; i<description_create.length; i++)
        {
            String s = description_create[i];
            if ( !s.equals("") || i==0 )
            {
                c1_addCon.addItem(s);
                c2_addCon.addItem(s);
            }
        }
        
        t1_addStation.setEditable(false);
        t1_addCon.setEditable(false);
        c1_addCon.setEnabled(false);
        c2_addCon.setEnabled(false);
        
        Container cp = getContentPane();
        cp.add(tabs_create);
        
        panel_create.setBorder( BorderFactory.createEmptyBorder(10,10,10,10));
        panel_create.add(rb1_create); 
        panel_create.add(rb2_create); 
        panel_create.add(t_create);
        panel_create.add(l1_addStation);
        panel_create.add(t1_addStation);
        panel_create.add(b1_addStation);
        panel_create.add(b2_addStation);
        panel_create.add(l1_addCon);
        panel_create.add(l2_addCon);
        panel_create.add(c1_addCon);
        panel_create.add(l3_addCon);
        panel_create.add(c2_addCon);
        panel_create.add(l4_addCon);
        panel_create.add(t1_addCon);
        panel_create.add(b1_addCon);
        panel_create.add(b2_addCon);
        panel_create.add(ta_create);
        panel_create.add(b1_create);
        panel_create.add(b2_create);
        panel_create.add(b3_create);
        ta_create.setForeground(Color.blue);
        g_create.add(rb1_create); 
        g_create.add(rb2_create);
        t_create.setEditable(false);
        t_create.setForeground(Color.blue);
        
        rb1_create.addActionListener(al1_create);
        rb2_create.addActionListener(al2_create);
        b1_create.addActionListener(al3_create);
        b2_create.addActionListener(al4_create);
        b3_create.addActionListener(al5_create);
        b1_addStation.addActionListener(al1_addStation);
        b2_addStation.addActionListener(al2_addStation);
        b1_addCon.addActionListener(al1_addCon);
        b2_addCon.addActionListener(al2_addCon);
        
        tabs_create.addTab(Menu_create[0], panel_create);
    }
    
    ActionListener 
      al1_create = new ActionListener()
      {
          public void actionPerformed(ActionEvent e)
          {
              t1_addStation.setEditable(true);
              t_create.setText("STATUS: Creating Stations");
              c1_addCon.setEnabled(false);
              c2_addCon.setEnabled(false);
              t1_addCon.setEditable(false);
          }
      },
      
      al2_create = new ActionListener()
      {
          public void actionPerformed(ActionEvent e)
          {
              c1_addCon.setEnabled(true);
              c2_addCon.setEnabled(true);
              t1_addCon.setEditable(true);
              t1_addStation.setEditable(false);
              t_create.setText("STATUS: Creating Connections");
              try
              {
                    Arrays.fill(Names_create,"");
                    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_create[i] = rs.getString("Name").trim();
                        i++;
                    }
               }catch(Exception e1){}
               
               description_create = Names_create;
               c1_addCon.removeAllItems();
               c2_addCon.removeAllItems();
               for(int i=0; i<description_create.length; i++)
               {
                    String s = description_create[i];
                    if ( !s.equals("") || i==0 )
                    {
                        c1_addCon.addItem(s);
                        c2_addCon.addItem(s);
                    }
               }
          }
      },
              
      al3_create = new ActionListener()
      {
          public void actionPerformed(ActionEvent e)
          {
                  ta_create.append("All Stations:" + "\n");
                  try
                  {
                       Arrays.fill(Names_create,"");
                       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_create[i] = rs.getString("Name").trim();
                           i++;
                       }
                 }catch(Exception e1){}
                 
                 for (int i=1; i<Names_create.length; i++)
                 ta_create.append(Names_create[i] + "  ");
                 ta_create.append("\n");
             }
      },
      
      al4_create = new ActionListener()
      {
            public void actionPerformed(ActionEvent e)
            {
                ta_create.append("All Connections:" + "\n");
                try
                {
                    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();