deletemenu.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_del[i] = rs.getString("Name").trim();
                           i++;
                       }
                 }catch(Exception e1){}
                 
                 for (int i=1; i<Names_del.length; i++)
                 ta_del.append(Names_del[i] + "  ");
                 ta_del.append("\n");
             }
       },
       
       al5_del = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                ta_del.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_del[j][0]=rs.getInt("start_station");
                        Edges_del[j][1]=rs.getInt("end_station");
                        Edges_del[j][2]=rs.getInt("weight");
                        j++;
                    }
                    
                    for (int k=0; k<j; k++)
                    {
                        for (int i=0; i<2; i++)
                        {
                            int a = Edges_del[k][i];
                            v = "select Name from Stations where Num = "+a+"";
                            s = conn.prepareStatement(v);
                            rs= s.executeQuery();
                            while (rs.next())
                            {
                                if ( i == 0 )
                                ta_del.append(rs.getString("Name").trim() + " --> ");
                                if ( i == 1 )
                                ta_del.append(rs.getString("Name").trim());
                            }
                        }
                        int b = Edges_del[k][2];
                        String p = Integer.toString(b);
                        ta_del.append("    Time Consuming: " + p + "\n");
                    }
                }catch(Exception e1){}
            }
       },
       
       al1_delStation = 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_delStation.getSelectedItem();
                    if ( s1.equals("") )
                    JOptionPane.showMessageDialog(null, 
                      "Please select a station", 
                      "Error!", JOptionPane.ERROR_MESSAGE);
                    else
                    {
                        String v = "select Num from Stations where Name = '"+s1+"'";
                        PreparedStatement s = conn.prepareStatement(v);
                        ResultSet rs = s.executeQuery();
                        while (rs.next())
                        {
                            NumStart_del = rs.getInt("Num");
                        }
                   
                        ta_del.append("Station " + s1 + " removed" + "\n");
                        v = "delete from Stations where Name = '"+s1+"'";
                        s = conn.prepareStatement(v);
                        s.executeUpdate();
                    
                        int a = NumStart_del;
                        v = "delete Routes where start_station = "+a+" or end_station = "+a+""; 
                        s = conn.prepareStatement(v);
                        s.executeUpdate();
                    }
               }catch(Exception e1){}
           }
       },
       
       al2_delStation = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                 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);
                }
            }
       },
       
       al1_delCon = 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_delCon.getSelectedItem();
                    String s2 = (String)c2_delCon.getSelectedItem();
                    String v = "select Num from Stations where Name = '"+s1+"'";
                    
                    PreparedStatement s = conn.prepareStatement(v);
                    ResultSet rs = s.executeQuery();
                    while (rs.next())
                    {
                        NumStart_del = rs.getInt("Num");
                    }
                   
                    v = "select Num from Stations where Name = '"+s2+"'";
                    s = conn.prepareStatement(v);
                    rs = s.executeQuery();
                    while (rs.next())
                    {
                        NumEnd_del = rs.getInt("Num");
                    }
                    
                    int a = NumStart_del;
                    int b = NumEnd_del;
                    
                    boolean goodID = false;
                    v = "select end_station from Routes where start_station = "+NumStart_del+"";
                    s = conn.prepareStatement(v);
                    rs = s.executeQuery();
                    while (rs.next())
                    {
                        if ( NumEnd_del == rs.getInt("end_station") )
                        goodID = true;
                    }
                    
                    if (goodID)
                    {
                        v = "delete Routes where start_station = "+a+" and end_station = "+b+""; 
                        s = conn.prepareStatement(v);
                        s.executeUpdate();
                        ta_del.append("Connection from " + s1 + " to " + s2 + " removed" + "\n");
                    }
                    
                    else
                    JOptionPane.showMessageDialog(null, 
                      "The Connection you choosed is not in the database!", 
                      "Error!", JOptionPane.ERROR_MESSAGE);
               }catch(Exception e1){}
           }
       },
       
       al2_delCon = new ActionListener()
       {
            public void actionPerformed(ActionEvent e)
            {
                 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);
                    }
                }
            }
        };
}