mainfrm.java

java 数据库编程源代码

      public void actionPerformed(ActionEvent e) {
        jButton3_actionPerformed(e);
      }
    });
    database2.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:traindb", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    jdbTable2.setAutoResizeMode(JTable.AUTO_RESIZE_NEXT_COLUMN);
    jdbTable2.setDataSet(queryDataSet4);

    queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database2, "SELECT daozhanbiao.\"车次\",daozhanbiao.\"车种\",daozhanbiao.\"发车车站\",daozhanbiao.\"发车时间\",daozhanbiao.\"到达时间\",dao" +
      "zhanbiao.\"备注\" FROM daozhanbiao", null, true, Load.ALL));
    queryDataSet4.addNavigationListener(new com.borland.dx.dataset.NavigationListener() {
      public void navigated(NavigationEvent e) {
        queryDataSet4_navigated(e);
      }
    });
    column20.setColumnName("发车时间");
    column20.setDataType(com.borland.dx.dataset.Variant.TIME);
    column20.setServerColumnName("发车时间");
    column20.setSqlType(93);
    column21.setColumnName("到达时间");
    column21.setDataType(com.borland.dx.dataset.Variant.TIME);
    column21.setServerColumnName("到达时间");
    column21.setSqlType(93);


    column7.setAgg(new com.borland.dx.dataset.AggDescriptor(new String[] {"车次"}, "车次", new com.borland.dx.dataset.CountAggOperator()));
    column7.setColumnName("车次");
    column7.setDataType(com.borland.dx.dataset.Variant.STRING);
    column7.setPrecision(6);
    column7.setServerColumnName("车次");
    column7.setSqlType(12);
    column9.setAgg(new com.borland.dx.dataset.AggDescriptor(new String[] {"车种"}, "车次", new com.borland.dx.dataset.CountAggOperator()));
    column9.setColumnName("车种");
    column9.setDataType(com.borland.dx.dataset.Variant.STRING);
    column9.setPrecision(8);
    column9.setServerColumnName("车种");
    column9.setSqlType(12);
    column11.setAgg(new com.borland.dx.dataset.AggDescriptor(new String[] {"发车车站", "备注"}, "车次", new com.borland.dx.dataset.CountAggOperator()));
    column11.setColumnName("发车车站");
    column11.setDataType(com.borland.dx.dataset.Variant.STRING);
    column11.setPrecision(12);
    column11.setServerColumnName("发车车站");
    column11.setSqlType(12);
    column13.setAgg(new com.borland.dx.dataset.AggDescriptor(new String[] {"备注"}, "车次", new com.borland.dx.dataset.CountAggOperator()));
    column13.setColumnName("备注");
    column13.setDataType(com.borland.dx.dataset.Variant.STRING);
    column13.setPrecision(20);
    column13.setServerColumnName("备注");
    column13.setSqlType(12);
    jMenuFile.add(jMenuFileExit);
    jMenuHelp.add(jMenuItem4);
    jMenuHelp.add(jMenuItem5);
    jMenuBar1.add(jMenuFile);
    jMenuBar1.add(jMenuHelp);
    jMenuBar1.add(jMenu2);
    jMenuBar1.add(jMenu1);
    jMenu1.add(jMenuItem2);
    jMenu1.add(jMenuItem3);
    contentPane.add(jTabbedPane1,                                                               new XYConstraints(6, 4, 538, 344));
    jPanel3.add(querymode_CmbBx1,  new XYConstraints(84, 1, 70, -1));
    jPanel3.add(query_txt1, new XYConstraints(163, 1, 65, -1));
    jPanel3.add(jButton1, new XYConstraints(321, 0, 84, 23));
    jPanel3.add(query_btn1, new XYConstraints(236, 0, 76, 23));
    start_panel.add(jLabel3, new XYConstraints(147, 280, -1, -1));
    start_panel.add(jLabel2, new XYConstraints(42, 280, -1, -1));
    start_panel.add(jLabel4,  new XYConstraints(256, 280, -1, -1));
    start_panel.add(jLabel5,  new XYConstraints(352, 280, -1, -1));
    start_panel.add(jPanel1,    new XYConstraints(137, 2, 218, 33));
    jPanel1.add(jLabel1, new XYConstraints(27, 2, 158, -1));
    start_panel.add(tableScrollPane1,      new XYConstraints(3, 40, 516, 148));
    start_panel.add(jPanel4, new XYConstraints(3, 193, 516, 36));
    jPanel4.add(noteLabel1, null);
    start_panel.add(jPanel3, new XYConstraints(3, 232, 516, 36));
    tableScrollPane1.getViewport().add(jdbTable1, null);
  //  jScrollPane1.getViewport().add(jTable1, null);
      jTabbedPane1.add(start_panel, "始发表");
    jTabbedPane1.add(end_panel,   "到站表");
    end_panel.add(jLabel9,   new XYConstraints(352, 280, -1, -1));
    end_panel.add(jLabel6,  new XYConstraints(42, 280, -1, -1));
    end_panel.add(jLabel8,  new XYConstraints(147, 280, -1, -1));
    end_panel.add(jLabel7,   new XYConstraints(256, 280, -1, -1));
    end_panel.add(jPanel2,   new XYConstraints(137, 2, 218, 33));
    jPanel2.add(jLabel10,    new XYConstraints(27, 2, 158, -1));
    end_panel.add(jScrollPane1,  new XYConstraints(3, 40, 516, 148));
    jScrollPane1.getViewport().add(jdbTable2, null);
    end_panel.add(jPanel5,  new XYConstraints(3, 193, 516, 36));
    jPanel5.add(note_label2, null);
    end_panel.add(jPanel6,  new XYConstraints(3, 232, 516, 36));
    jPanel6.add(jButton2,       new XYConstraints(321, 0, 84, 23));
    jPanel6.add(query_txt2,   new XYConstraints(163, 1, 65, -1));
    jPanel6.add(query_com2,   new XYConstraints(84, 1, 70, -1));
    jPanel6.add(jButton3,  new XYConstraints(236, 0, 76, 23));


    jMenu2.add(passwordMenu);
    this.setJMenuBar(jMenuBar1);
    queryDataSet1.setColumns(new Column[] {column2, column4, column5, column1, column3, column6});
    queryDataSet4.setColumns(new Column[] {column7, column9, column11, column20, column21, column13});

  }
  //File | Exit action performed
  public void jMenuFileExit_actionPerformed(ActionEvent e) {
    System.exit(0);
  }
  //Help | About action performed
  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      jMenuFileExit_actionPerformed(null);
    }
  }
 void query_btn1_actionPerformed(ActionEvent e) {
  dbBean db=new dbBean();       //实例化dbBean
  ResultSet rs=null;              //定义一结果集
 String s_txt=query_txt1.getText();
 String s_cmbbx=(String)querymode_CmbBx1.getSelectedItem();
 errormessage em=new errormessage();  //出错处理
 if (!em.isEmpty(s_txt))            //判断输入是否为空
   {
     if(s_cmbbx.equals("车次"))      //按车次查询方式查询
     {
         try{
                                      //查询输入车次
         rs=db.executeQuery("select \"车次\" from main_db where main_db.\"车次\"='"+s_txt+"'");
         if(rs.next()){               //判断是否存在
           queryDataSet1.close();     //清空jdbTable1中存放的结果集queryDataSet1
                                      //按车次查询得到的新的结果集，放入queryDataSet1中
           queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT main_db.\"车次\",main_db.\"车种\",main_db.\"终点站\",main_db.\"发车时间\",main_db.\"到站时间\",main_db.\"备注\" " +
 "FROM main_db where main_db.\"车次\"='"+s_txt+"'", null, true, Load.ALL));

      jdbTable1.setDataSet(queryDataSet1);  //将queryDataSet1装入jdbTable中
      noteLabel1.setText("单击右键，选择查询内容");
       rs.close();
         }
         else{
         noteLabel1.setText("查无此项纪录");
         }
         }catch(Exception ee){}

      }
     else{                   //按车站查询模式查询
       try{
                             //查询输入的车站
       rs=db.executeQuery("select \"车次\" from daodachezhan where \"到达车站\"='"+s_txt+"'");
      if(rs.next()){         //判断查询的车站是否存在
       queryDataSet1.close();     //将结果集queryDataSet1清空
                             //按输入的车站查询并返回结果集存入queryDataSet1中
       queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT main_db.\"车次\",main_db.\"车种\",main_db.\"终点站\",main_db.\"发车时间\",main_db.\"到站时间\",main_db.\"备注\" " +
             "FROM main_db where main_db.\"车次\" in (select daodachezhan.\"车次\" from daodachezhan where daodachezhan.\"到达车站\"='"+s_txt+"') ", null, true, Load.ALL));
          jdbTable1.setDataSet(queryDataSet1);   ////将queryDataSet1装入jdbTable中
          noteLabel1.setText("首项请击右键选择查询内容");
          rs.close();
           }else{
           noteLabel1.setText("查无此项纪录");
           }
       }
           catch(Exception ee){}
                 }
   }
   else{
 noteLabel1.setText("查询不能为空，请按查询方式输入相应的查询条件");
   }
 }

void queryDataSet1_navigated(NavigationEvent e) {   //queryDataSet被点击的事件
                  //根据被选中的信息显示分表的更多信息
  fenbiaoshow1 dlg=new fenbiaoshow1(queryDataSet1.getString("车次"));
  dlg.setLocation(350,200);
  dlg.setSize(450,240);
  dlg.show();
 }

  void passwordMenu_actionPerformed(ActionEvent e) {
            //显示用户管理对话框，其为非模式对话框
  userDialog frm=new userDialog(this,"用户信息",true);
  frm.setLocation(200,150);
  frm.show();
   }

  void jButton1_actionPerformed(ActionEvent e) {//查询结果后，返回主表
    queryDataSet1.close();            //清空
                                     //进行新的查询
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT main_db.\"车次\",main_db.\"车种\",main_db.\"终点站\",main_db.\"发车时间\",main_db.\"到站时间\",main_db.\"备注\" " +
                 "FROM main_db ", null, true, Load.ALL));
      jdbTable1.setDataSet(queryDataSet1);
          noteLabel1.setText("欢迎您的使用");
  }

  void jMenuItem4_actionPerformed(ActionEvent e) {//进入订票对话框
    dingpiaoFrm frm=new dingpiaoFrm();
    GetFrmLocation gfl=new GetFrmLocation();
    gfl.get_location(frm);       //frm的位置在中心
    frm.show();

  }

  void jMenuItem5_actionPerformed(ActionEvent e) {//进入退票对话框
   tuipiaoFrm frm=new tuipiaoFrm();
   GetFrmLocation gfl=new GetFrmLocation();
   gfl.get_location(frm);

   frm.show();
  }

  void queryDataSet4_navigated(NavigationEvent e) {   //到站表的分表显示
    jdbTable1.setDataSet(queryDataSet4);
    fenbiaoshow2 dlg=new fenbiaoshow2(queryDataSet4.getString("车次"));
    dlg.setLocation(350,200);
    dlg.setSize(450,240);
    dlg.show();
  }

  void jButton3_actionPerformed(ActionEvent e) {    //到站表的查询处理
  String s_txt=query_txt2.getText();
  dbBean db=new dbBean();
  ResultSet rs=null;
  errormessage em=new errormessage();              //处理出错
  if(!em.isEmpty(s_txt)){                          //判断是否为空
                                                   //按车次的查询
          if(query_com2.getSelectedItem().equals("车次")){

            try{                                    //查询输入的车次
              rs=db.executeQuery("select daozhanbiao.\"车次\" from daozhanbiao where daozhanbiao.\"车次\"='"+s_txt+"'");
              if(rs.next()){                        //判断输入的车次是否存在
              queryDataSet4.close();                //结果集的清空
                                                    //按输入车次的查询
              queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database2, "SELECT daozhanbiao.\"车次\",daozhanbiao.\"车种\",daozhanbiao.\"发车车站\",daozhanbiao.\"发车时间\",daozhanbiao.\"到达时间\",daozhanbiao.\"备注\" " +
              "FROM daozhanbiao where daozhanbiao.\"车次\"='"+s_txt+"'", null, true, Load.ALL));

            jdbTable2.setDataSet(queryDataSet4);    //发送结果
            rs.close();
            note_label2.setText("单击右键，选择查询内容");
        }
        else{
            note_label2.setText("数据库中无此项纪录！");
        }
            }
          catch(Exception eii){

          }
          }
          else{                                    //按车站的查询
          try{
                                                   //查询输入的车站
      rs=db.executeQuery("select \"车次\" from daozhanfenbiao where \"发车车站\"='"+s_txt+"'");
       if(rs.next()){                              //判断输入车站的存在与否
             queryDataSet4.close();                       //清空结果集
                                                   //将新的查询结果存入queryDataSet4
              queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database2, "SELECT daozhanbiao.\"车次\",daozhanbiao.\"车种\",daozhanbiao.\"发车车站\",daozhanbiao.\"发车时间\",daozhanbiao.\"到达时间\",daozhanbiao.\"备注\" " +
              "FROM daozhanbiao where daozhanbiao.\"车次\" in (select \"车次\" from daozhanfenbiao where \"发车车站\"='"+s_txt+"')", null, true, Load.ALL));

              jdbTable2.setDataSet(queryDataSet4);          //将查询结果集载入jdbTable2
              note_label2.setText("查询成功，首项右击选择查询内容");
              rs.close();
       }else{
               note_label2.setText("查无次站请重新输入");
           }
       }catch(Exception eee){}

          }
      }  else{
        note_label2.setText("查询不能为空，请输入合理数据！");
   }
  }

  void jButton2_actionPerformed(ActionEvent e) {       //返回主表
   queryDataSet4.close();
   queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database2, "SELECT daozhanbiao.\"车次\",daozhanbiao.\"车种\",daozhanbiao.\"发车车站\",daozhanbiao.\"发车时间\",daozhanbiao.\"到达时间\",dao" +
      "zhanbiao.\"备注\" FROM daozhanbiao", null, true, Load.ALL));
   jdbTable2.setDataSet(queryDataSet4);
  note_label2.setText("欢迎您的使用！查看首项请击右键");
  }
}