luxian.java~1~

cs结构的一个公交车系统好有使用价值啊下吧--- --- ---

package bus;
import java.awt.*;
import javax.swing.*;
import javax.swing.border.*;
import java.awt.Rectangle;
import java.awt.BorderLayout;
import java.awt.Dimension;
import javax.swing.table.*;
import java.awt.event.*;
import javax.swing.event.*;
import java.util.Vector;
class luxian extends JPanel {
  DefaultTableModel model = new DefaultTableModel();
  DefaultTableModel model3 = new DefaultTableModel();
  DefaultTableModel model4 = new DefaultTableModel();
  DefaultTableModel model5 = new DefaultTableModel();
  DefaultTableModel model6 = new DefaultTableModel();
  Vector head = new Vector();
  Vector head3 = new Vector();
  Vector head4 = new Vector();
  Vector head5 = new Vector();
  Vector head6 = new Vector();
  JTabbedPane tp = new JTabbedPane();
  JPanel p1 = new JPanel();
  JPanel p2 = new JPanel();
  JPanel p3 = new JPanel();
  JPanel p4 = new JPanel();
  JPanel p5 = new JPanel();
  JPanel jPanel1 = new JPanel();
  BorderLayout borderLayout1 = new BorderLayout();
  JLabel jLabel1 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JButton bt1 = new JButton();
  JButton bt2 = new JButton();
  JScrollPane jScrollPane1 = new JScrollPane();
  JTable jTable5p2 = new JTable();
  JPanel jPanel2 = new JPanel();
  BorderLayout borderLayout2 = new BorderLayout();
  JLabel jLabel3p3 = new JLabel();
  JTextField jTextField2p3 = new JTextField();
  JButton p3qurding = new JButton();
  JButton p3quxiao = new JButton();
  JScrollPane jScrollPane2p3 = new JScrollPane();
  JTable jTable1p1 = new JTable();
  BorderLayout borderLayout3 = new BorderLayout();
  JPanel jPanel3 = new JPanel();
  JLabel jLabel4p4 = new JLabel();
  JTextField jTextField3p4 = new JTextField();
  JButton p4save = new JButton();
  JButton p4quxiao = new JButton();
  JScrollPane jScrollPane3p4 = new JScrollPane();
  JTable jTable2p4 = new JTable();
  BorderLayout borderLayout4 = new BorderLayout();
  JPanel jPanel4 = new JPanel();
  JLabel jLabel2p5 = new JLabel();
  JTextField jTextField4p5 = new JTextField();
  JButton p5query = new JButton();
  JButton p5quxiao = new JButton();
  JScrollPane jScrollPane4p5 = new JScrollPane();
  JTable jTable3p5 = new JTable();
  BorderLayout borderLayout5 = new BorderLayout();
  JPanel jPanel5 = new JPanel();
  JLabel jLabel5p2 = new JLabel();
  JTextField jTextField5p2 = new JTextField();
  JButton addp2 = new JButton();
  JButton jButton10p2 = new JButton();
  JScrollPane jScrollPane5p2 = new JScrollPane();
  BusManager bm = new BusManager();
  JTable jTable1p3 = new JTable();
  public luxian() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {
    this.setLayout(new BorderLayout());
    this.setBackground(SystemColor.control);
    this.setDebugGraphicsOptions(0);
    //jTabbedPane1.add(pe6, "站点更改");
    p1.setFont(new java.awt.Font("Dialog", 0, 22));
    p1.setLayout(borderLayout1);
    p2.setFont(new java.awt.Font("Dialog", 0, 22));
    p2.setLayout(borderLayout5);
    p3.setFont(new java.awt.Font("Dialog", 0, 22));
    p3.setLayout(borderLayout2);
    p4.setFont(new java.awt.Font("Dialog", 0, 22));
    p4.setLayout(borderLayout3);
    p5.setFont(new java.awt.Font("Dialog", 0, 22));
    p5.setLayout(borderLayout4);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel1.setPreferredSize(new Dimension(105, 25));
    jLabel1.setText("请输入线路名称：");
    bt1.setFont(new java.awt.Font("Dialog", 0, 12));
    bt1.setPreferredSize(new Dimension(60, 25));
    bt1.setText("查询");
    bt1.setBorder(BorderFactory.createBevelBorder(BevelBorder.RAISED));
    jTextField1.setPreferredSize(new Dimension(120, 25));
    jTextField1.setText("");
    bt2.setFont(new java.awt.Font("Dialog", 0, 13));
    bt2.setPreferredSize(new Dimension(60, 25));
    bt2.setText("取消");
    bt2.setBorder(BorderFactory.createBevelBorder(BevelBorder.RAISED));
    tp.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel3p3.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel3p3.setPreferredSize(new Dimension(130, 25));
    jLabel3p3.setText("请输入删除线路的名称");
    p3qurding.setFont(new java.awt.Font("Dialog", 0, 13));
    p3qurding.setPreferredSize(new Dimension(60, 25));
    p3qurding.setToolTipText("");
    p3qurding.setText("确定");
    p3qurding.addActionListener(new luxian_p3qurding_actionAdapter(this));
    p3quxiao.setFont(new java.awt.Font("Dialog", 0, 13));
    p3quxiao.setPreferredSize(new Dimension(60, 25));
    p3quxiao.setText("取消");
    p3quxiao.addActionListener(new luxian_p3quxiao_actionAdapter(this));
    jLabel4p4.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel4p4.setPreferredSize(new Dimension(110, 25));
    jLabel4p4.setText("请输入站点的名称");
    jTextField3p4.setPreferredSize(new Dimension(100, 25));
    jTextField3p4.setText("");
    p4save.setFont(new java.awt.Font("Dialog", 0, 13));
    p4save.setPreferredSize(new Dimension(60, 25));
    p4save.setText("保存");
    p4quxiao.setFont(new java.awt.Font("Dialog", 0, 13));
    p4quxiao.setPreferredSize(new Dimension(60, 25));
    p4quxiao.setText("取消");
    jLabel2p5.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel2p5.setPreferredSize(new Dimension(120, 25));
    jLabel2p5.setText("请输入要查询的站点");
    p5query.setFont(new java.awt.Font("Dialog", 0, 13));
    p5query.setPreferredSize(new Dimension(60, 25));
    p5query.setText("查询");
    p5quxiao.setFont(new java.awt.Font("Dialog", 0, 13));
    p5quxiao.setPreferredSize(new Dimension(60, 25));
    p5quxiao.setText("取消");
    p5quxiao.addActionListener(new luxian_p5quxiao_actionAdapter(this));
    jLabel5p2.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel5p2.setPreferredSize(new Dimension(130, 25));
    jLabel5p2.setText("请输入新增路线的名称");
    addp2.setFont(new java.awt.Font("Dialog", 0, 13));
    addp2.setPreferredSize(new Dimension(60, 25));
    addp2.setText("添加");
    jButton10p2.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton10p2.setPreferredSize(new Dimension(60, 25));
    jButton10p2.setText("删除");
    jTextField2p3.setPreferredSize(new Dimension(120, 25));
    jTextField2p3.setText("");
    jTextField4p5.setPreferredSize(new Dimension(120, 25));
    jTextField4p5.setText("");
    jTextField5p2.setOpaque(true);
    jTextField5p2.setPreferredSize(new Dimension(100, 25));
    jTextField5p2.setText("");
    head.add("公交车路数");
    head.add("公交车站点");
    head3.add("新增的公交车路数");
    head3.add("新增的路线");
    head4.add("删除的公交车路数");
    head4.add("删除的公交车线路");
    head5.add("新增的路线的地点");
    //head5.add("新增的公交车路数");
    head6.add("站点名称");
    head6.add("站点位置");
    tp.add(p1, "线路查询");
    tp.add(p3, "删除线路");
    p3.add(jPanel2, BorderLayout.NORTH);
    jPanel2.add(jLabel3p3, null);
    jPanel2.add(jTextField2p3, null);
    jPanel2.add(p3qurding, null);
    jPanel2.add(p3quxiao, null);
    p3.add(jScrollPane2p3, BorderLayout.CENTER);
    jScrollPane2p3.getViewport().add(jTable1p3, null);
    jScrollPane2p3.getViewport().add(jTable1p1, null);
    tp.add(p4, "新增站点");
    p4.add(jPanel3, BorderLayout.NORTH);
    jPanel3.add(jLabel4p4, null);
    jPanel3.add(jTextField3p4, null);
    jPanel3.add(p4save, null);
    jPanel3.add(p4quxiao, null);
    p4.add(jScrollPane3p4, BorderLayout.CENTER);
    jScrollPane3p4.getViewport().add(jTable2p4, null);
    tp.add(p5, "站点查询");
    p5.add(jPanel4, BorderLayout.NORTH);
    jPanel4.add(jLabel2p5, null);
    jPanel4.add(jTextField4p5, null);
    jPanel4.add(p5query, null);
    jPanel4.add(p5quxiao, null);
    p5.add(jScrollPane4p5, BorderLayout.CENTER);
    jScrollPane4p5.getViewport().add(jTable3p5, null);
    jPanel1.add(jLabel1, null);
    jPanel1.add(jTextField1, null);
    jPanel1.add(bt1, null);
    jPanel1.add(bt2, null);
    p1.add(jScrollPane1, BorderLayout.CENTER);
    jScrollPane1.getViewport().add(jTable1p1, null);
    tp.add(p2, "新增线路");
    p2.add(jPanel5, BorderLayout.NORTH);
    jPanel5.add(jLabel5p2, null);
    jPanel5.add(jTextField5p2, null);
    jPanel5.add(addp2, null);
    jPanel5.add(jButton10p2, null);
    p2.add(jScrollPane5p2, BorderLayout.CENTER);
    //jScrollPane5p2.getViewport().add(jTable4p2, null);
    p1.add(jPanel1, BorderLayout.NORTH);
    this.add(tp, BorderLayout.NORTH);

    model.setColumnIdentifiers(head);
    model3.setColumnIdentifiers(head3);
    model4.setColumnIdentifiers(head4);
    model5.setColumnIdentifiers(head5);
    model6.setColumnIdentifiers(head6);
    jTable1p1.setModel(model);
    bt1.addActionListener(new AL());
    bt2.addActionListener(new AL());
    p3qurding.addActionListener(new AL());
    p4save.addActionListener(new AL());
    p5query.addActionListener(new AL());
    //this.setSize(600, 550);
  }

  class AL implements ActionListener {
    public void actionPerformed(ActionEvent e) {
      if (e.getSource().equals(bt2)) {
        bt2.removeAll();
        bt2.validate();
      } //查询路线
      if (e.getSource() == bt1) {
        String s2="";
        String s1 = jTextField1.getText().toString();
        if(s1.equals(""))
        {
          s2="select LineName,LineState from BusLine";
        }
        else
        {
          s2 ="select LineName,LineState from BusLine where LineName ='" +
              s1 + "'";
        }
        Vector vt = bm.selectBus(s2);

        for (int i = 0; i < vt.size(); i++) {
          System.out.println(vt.get(i));

        }
        model.setDataVector(vt, head);
        jTable1p1.setModel(model);
 //       vt.removeAllElements();
      }
      if(e.getSource().equals(p5query)){
        //System.out.println("fbhnjinjmko,k,o");
         String query=jTextField4p5.getText().toString();
         String place="select LineState from BusLine";
         Vector vtquery=bm.selectBus(place);
         for (int i = 0; i < vtquery.size(); i++) {
          System.out.println(vtquery.get(i));

        }
          model5.setDataVector(vtquery,head5);
          jTable3p5.setModel(model5);
      }

 //删除
      if (e.getSource().equals(p3qurding)) {
        String sp3 = jTextField2p3.getText().toString();
        String sp4 = "delete from BusLine where LineName='" + sp3 + "'";
        boolean bool = bm.delectedBus(sp4);
        if (bool) {
          System.out.print("删除成功");
        }
        else {
          System.out.print("删除失败");
        }

      } //保存
      if (e.getSource().equals(p4save)) {
           System.out.println("jhjhjfgggggd");
           String sp5 = jTextField3p4.getText().toString();
           String sp6 = "insert into BusLine values('"+sp5+"','洪家楼-华龙路-山大北路东段-洪家楼西路-山大路北段-花园庄东路?山大南路?山大路-中心医院-解放桥东-青龙桥-贵和购物中心-芙蓉街-西门-共青团路-市法院-经二纬一-市政府-万紫巷商场-经二纬六-经二纬八-华联商厦-经二纬十二-经四纬十二-经四路西口　(返程：经四路西口→经二纬十二→华联商厦→')";
           Vector add=bm.selectBus(sp6);
           //boolean bool1 = bm.insertBus(sp6);
      }
    }
    void p3quxiao_actionPerformed(ActionEvent e) {
    }

    void p5quxiao_actionPerformed(ActionEvent e) {
    }

    void p3qurding_actionPerformed(ActionEvent e) {

    }
  }

  class luxian_p3quxiao_actionAdapter
      implements java.awt.event.ActionListener {
    luxian adaptee;

    luxian_p3quxiao_actionAdapter(luxian adaptee) {
      this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
    }
  }

  class luxian_p5quxiao_actionAdapter
      implements java.awt.event.ActionListener {
    luxian adaptee;

    luxian_p5quxiao_actionAdapter(luxian adaptee) {
      this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

    }
  }

  class luxian_p3qurding_actionAdapter
      implements java.awt.event.ActionListener {
    luxian adaptee;

    luxian_p3qurding_actionAdapter(luxian adaptee) {
      this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

    }
  }
}