modifymenu.java

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

                       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){}
                 
                 for (int i=1; i<Names_mod.length; i++)
                 ta_mod.append(Names_mod[i] + "  ");
                 ta_mod.append("\n");
             }
       },
       
       al5_mod = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                ta_mod.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();

                    String v = "select * from Routes";
                    PreparedStatement s = conn.prepareStatement(v);
                    ResultSet rs= s.executeQuery();
                    int j = 0;
                    while (rs.next())
                    {
                        Edges_mod[j][0]=rs.getInt("start_station");
                        Edges_mod[j][1]=rs.getInt("end_station");
                        Edges_mod[j][2]=rs.getInt("weight");
                        j++;
                    }
                    
                    for (int k=0; k<j; k++)
                    {
                        for (int i=0; i<2; i++)
                        {
                            int a = Edges_mod[k][i];
                            v = "select Name from Stations where Num = "+a+"";
                            s = conn.prepareStatement(v);
                            rs= s.executeQuery();
                            while (rs.next())
                            {
                                if ( i == 0 )
                                ta_mod.append(rs.getString("Name").trim() + " --> ");
                                if ( i == 1 )
                                ta_mod.append(rs.getString("Name").trim());
                            }
                        }
                        int b = Edges_mod[k][2];
                        String p = Integer.toString(b);
                        ta_mod.append("    Time Consuming: " + p + "\n");
                    }
                }catch(Exception e1){}
            }
       },
       
       al1_modStation = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                 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();

                    String s1 = (String)c1_modStation.getSelectedItem();
                    String s2 = t1_modStation.getText();
                    boolean goodID = true;
                    if ( s1.equals("") )
                    {
                        goodID = false;
                        JOptionPane.showMessageDialog(null, 
                          "Please select a station", 
                          "Error!", JOptionPane.ERROR_MESSAGE);
                    }
                    
                    if ( !s1.equals("") && s2.equals("") )
                    {
                        goodID = false;
                        JOptionPane.showMessageDialog(null, 
                          "Please specify a name", 
                          "Error!", JOptionPane.ERROR_MESSAGE);
                    }
                    
                    if ( goodID )
                    {
                        String v = "update Stations set Name = '"+s2+"'where Name = '"+s1+"'";
                        PreparedStatement s = conn.prepareStatement(v);
                        s.executeUpdate();
                        ta_mod.append("Station " + s1 + " is modified to " + s2 + "\n");
                    }
               }catch(Exception e1){}
           }
       },
       
       al2_modStation = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                 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){}
                
                t1_modStation.selectAll();
                t1_modStation.cut();
                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);
                }
            }
       },
       
       al1_modCon = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                 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();

                    String s1 = (String)c1_modCon.getSelectedItem();
                    String s2 = (String)c2_modCon.getSelectedItem();
                    
                    String v = "select Num from Stations where Name = '"+s1+"'";
                    PreparedStatement s = conn.prepareStatement(v);
                    ResultSet rs = s.executeQuery();
                    while (rs.next())
                    {
                        NumStart_mod = rs.getInt("Num");
                    }
                   
                    v = "select Num from Stations where Name = '"+s2+"'";
                    s = conn.prepareStatement(v);
                    rs = s.executeQuery();
                    while (rs.next())
                    {
                        NumEnd_mod = rs.getInt("Num");
                    }
                    
                    int a = NumStart_mod;
                    int b = NumEnd_mod;
                    String s3 = t1_modCon.getText();
                    int c = Integer.parseInt(s3);
                    
                    boolean goodID = false;
                    
                    v = "select end_station from Routes where start_station = "+NumStart_mod+"";
                    s = conn.prepareStatement(v);
                    rs = s.executeQuery();
                    while (rs.next())
                    {
                        if ( NumEnd_mod == rs.getInt("end_station") )
                        goodID = true;
                    }
                                        
                    if (goodID)
                    {
                        if ( c == 0 )
                        {
                             JOptionPane.showMessageDialog(null, 
                               "Please specify the Time Consuming", 
                               "Error!", JOptionPane.ERROR_MESSAGE);
                        }
                            
                        else
                        {
                             v = "update Routes set weight = "+c+" where start_station = "+a+" and end_station = "+b+""; 
                             s = conn.prepareStatement(v);
                             s.executeUpdate();
                             ta_mod.append("The Time Consuming of Connection from " + s1 + " to " + 
                             s2 + " is modified to " + t1_modCon.getText() + "\n");
                        }
                     }
                    
                     else
                     JOptionPane.showMessageDialog(null, 
                       "The Connection you choosed is not in the database!", 
                       "Error!", JOptionPane.ERROR_MESSAGE);
                }catch(Exception e1){}
           }
       },
       
       al2_modCon = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                 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){}
                
                t1_modCon.selectAll();
                t1_modCon.cut();
                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);
                    }
                }
            }
        };
}