mainfrm.java

java 数据库编程源代码

package train_table;
import java.sql.ResultSet;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import javax.swing.border.*;
import javax.swing.table.*;
import javax.swing.event.*;
import com.borland.dbswing.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.dataset.*;

public class mainfrm extends JFrame {
  private JPanel contentPane;
  private JMenuBar jMenuBar1 = new JMenuBar();
  private JMenu jMenuFile = new JMenu();
  private JMenuItem jMenuFileExit = new JMenuItem();
  private JMenu jMenuHelp = new JMenu();
  private JMenu jMenu1 = new JMenu();
  private JMenuItem jMenuItem2 = new JMenuItem();
  private JMenuItem jMenuItem3 = new JMenuItem();
  private XYLayout xYLayout1 = new XYLayout();
  private JTabbedPane jTabbedPane1 = new JTabbedPane();
  private JPanel start_panel = new JPanel();
  private JPanel end_panel = new JPanel();
  private XYLayout xYLayout2 = new XYLayout();
  private JPanel jPanel1 = new JPanel();
  private JLabel jLabel1 = new JLabel();
  private Border border1;
  private Border border2;
  private Border border3;

  private JPanel jPanel3 = new JPanel();
  private Border border4;
  String[] s_QueryMode={"车次","车站"};       //定义一数组，加载到jComboBox中
  private JComboBox querymode_CmbBx1 = new JComboBox(s_QueryMode);
  private XYLayout xYLayout5 = new XYLayout();
  private JButton query_btn1 = new JButton();
  private JTextField query_txt1 = new JTextField();
  private Border border5;
  private JPanel jPanel4 = new JPanel();
  private Border border6;
  private JLabel noteLabel1 = new JLabel();
  private JMenuItem jMenuItem4 = new JMenuItem();
  private JMenu jMenu2 = new JMenu();
  private JMenuItem passwordMenu = new JMenuItem();
  private TableScrollPane tableScrollPane1 = new TableScrollPane();
  private Database database1 = new Database();
  private JdbTable jdbTable1 = new JdbTable();
  private QueryDataSet queryDataSet1 = new QueryDataSet();
  private Column column1 = new Column();
  private Column column3 = new Column();
  private TitledBorder titledBorder1;
  private TitledBorder titledBorder2;
  private TitledBorder titledBorder3;
  private TitledBorder titledBorder4;
  private XYLayout xYLayout3 = new XYLayout();
  private JLabel jLabel2 = new JLabel();
  private JLabel jLabel3 = new JLabel();
  private JLabel jLabel4 = new JLabel();
  private JLabel jLabel5 = new JLabel();
  private Column column2 = new Column();
  private Column column4 = new Column();
  private Column column5 = new Column();
  private Column column6 = new Column();
  private TitledBorder titledBorder5;
  private Column column8 = new Column();
  private Column column12 = new Column();
  private JButton jButton1 = new JButton();

  private JMenuItem jMenuItem5 = new JMenuItem();

  private XYLayout xYLayout4 = new XYLayout();
  private JLabel jLabel6 = new JLabel();
  private JLabel jLabel7 = new JLabel();
  private JLabel jLabel8 = new JLabel();
  private JLabel jLabel9 = new JLabel();
  private JPanel jPanel2 = new JPanel();
  private JLabel jLabel10 = new JLabel();
  private XYLayout xYLayout6 = new XYLayout();
  private TitledBorder titledBorder6;
  private TitledBorder titledBorder7;
  private JScrollPane jScrollPane1 = new JScrollPane();
  private JdbTable jdbTable2 = new JdbTable();
  private JPanel jPanel5 = new JPanel();
  private TitledBorder titledBorder8;
  private JLabel note_label2 = new JLabel();
  private JPanel jPanel6 = new JPanel();
  private TitledBorder titledBorder9;
  private JComboBox query_com2 = new JComboBox(s_QueryMode);
  private JTextField query_txt2 = new JTextField();
  private JButton jButton2 = new JButton();
  private JButton jButton3 = new JButton();
  private XYLayout xYLayout7 = new XYLayout();
  private Database database2 = new Database();
  private QueryDataSet queryDataSet4 = new QueryDataSet();
  private Column column20 = new Column();
  private Column column21 = new Column();
  private Column column7 = new Column();
  private Column column9 = new Column();
  private Column column11 = new Column();
  private Column column13 = new Column();

  public mainfrm() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
 private void jbInit() throws Exception  {

//setIconImage(Toolkit.getDefaultToolkit().createImage(mainfrm.class.getResource("[Your Icon]")));
    contentPane = (JPanel) this.getContentPane();
    border1 = BorderFactory.createLineBorder(SystemColor.desktop,1);
    border2 = BorderFactory.createEmptyBorder();
    border3 = BorderFactory.createLineBorder(new Color(92, 98, 0),1);
    border4 = BorderFactory.createLineBorder(new Color(131, 105, 0),1);
    border5 = BorderFactory.createLineBorder(new Color(138, 144, 177),1);
    border6 = BorderFactory.createLineBorder(new Color(131, 79, 0),1);
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    titledBorder3 = new TitledBorder("");
    titledBorder4 = new TitledBorder("");
    titledBorder5 = new TitledBorder("");
    titledBorder6 = new TitledBorder("");
    titledBorder7 = new TitledBorder("");
    titledBorder8 = new TitledBorder("");
    titledBorder9 = new TitledBorder("");
    contentPane.setLayout(xYLayout1);
    this.setForeground(Color.pink);
    this.setSize(new Dimension(560,400));
    this.setTitle("北京西客站火车时刻表");

    jMenuFile.setText("文件");
    jMenuFileExit.setText("退出");
    jMenuFileExit.addActionListener(new ActionListener()  {
      public void actionPerformed(ActionEvent e) {
        jMenuFileExit_actionPerformed(e);
      }
    });
    jMenuHelp.setText("票务");
    jMenu1.setText("帮助");
    jMenuItem2.setText("关于");
    jMenuItem3.setText("帮助");
    jTabbedPane1.setTabPlacement(JTabbedPane.BOTTOM);
    start_panel.setLayout(xYLayout2);
    jPanel1.setLayout(xYLayout3);
    jLabel1.setForeground(Color.blue);
    jLabel1.setText("北京西客站始发列车时刻表");
    jPanel1.setBorder(titledBorder4);
    jPanel3.setBorder(titledBorder3);
    jPanel3.setLayout(xYLayout5);
    query_btn1.setText("查询");
    query_btn1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        query_btn1_actionPerformed(e);
      }
    });
    jPanel4.setBorder(titledBorder1);
    noteLabel1.setText("欢迎进入本系统");
    jMenuItem4.setText("订票");
    jMenuItem4.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jMenuItem4_actionPerformed(e);
      }
    });
    jMenu2.setText("管理");
    passwordMenu.setActionCommand("用户管理");
    passwordMenu.setText("用户管理");
    passwordMenu.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        passwordMenu_actionPerformed(e);
      }
    });
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:traindb", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    queryDataSet1.setReadOnly(true);
    queryDataSet1.setEditable(false);
    queryDataSet1.setEnableInsert(false);
    queryDataSet1.setEnableUpdate(false);
    queryDataSet1.setEnableDelete(false);
    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));
    queryDataSet1.addNavigationListener(new com.borland.dx.dataset.NavigationListener() {
      public void navigated(NavigationEvent e) {
        queryDataSet1_navigated(e);
      }
    });
    jdbTable1.setBorder(border2);
    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_NEXT_COLUMN);
    jdbTable1.setDataSet(queryDataSet1);
    jdbTable1.setEditable(false);
    column1.setColumnName("发车时间");
    column1.setDataType(com.borland.dx.dataset.Variant.TIME);
    column1.setReadOnly(true);
    column1.setWidth(10);
    column1.setServerColumnName("发车时间");
    column1.setSqlType(93);
    column3.setColumnName("到站时间");
    column3.setDataType(com.borland.dx.dataset.Variant.TIME);
    column3.setReadOnly(true);
    column3.setServerColumnName("到站时间");
    column3.setSqlType(93);
    start_panel.setBorder(titledBorder2);
    jLabel2.setText("P----普通列车");
    jLabel3.setText("K----快速列车");
    jLabel4.setText("T----特快列车");
    jLabel5.setText("L----临时列车");

    column2.setColumnName("车次");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setPrecision(6);
    column2.setReadOnly(true);
    column2.setServerColumnName("车次");
    column2.setSqlType(12);
    column4.setColumnName("车种");
    column4.setDataType(com.borland.dx.dataset.Variant.STRING);
    column4.setPrecision(7);
    column4.setReadOnly(true);
    column4.setServerColumnName("车种");
    column4.setSqlType(12);
    column5.setColumnName("终点站");
    column5.setDataType(com.borland.dx.dataset.Variant.STRING);
    column5.setPrecision(8);
    column5.setReadOnly(true);
    column5.setServerColumnName("终点站");
    column5.setSqlType(12);
    column6.setColumnName("备注");
    column6.setDataType(com.borland.dx.dataset.Variant.STRING);
    column6.setPrecision(16);
    column6.setReadOnly(true);
    column6.setTableName("");
    column6.setServerColumnName("备注");
    column6.setSqlType(12);


    jButton1.setText("返回主表");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton1_actionPerformed(e);
      }
    });


    jMenuItem5.setText("退票");
    jMenuItem5.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jMenuItem5_actionPerformed(e);
      }
    });

    end_panel.setLayout(xYLayout4);
    jLabel6.setText("P----普通列车");
    jLabel7.setText("T----特快列车");
    jLabel8.setText("K----快速列车");
    jLabel9.setText("L----临时列车");
    jLabel10.setText("北京西客站到站时刻表");
    jPanel2.setLayout(xYLayout6);
    jPanel2.setBorder(titledBorder6);
    end_panel.setBorder(titledBorder7);
    jPanel5.setBorder(titledBorder8);
    note_label2.setText("欢迎进入到站表查询");
    jPanel6.setBorder(titledBorder9);
    jPanel6.setLayout(xYLayout7);
    jButton2.setText("返回主表");
    jButton2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton2_actionPerformed(e);
      }
    });
    jButton3.setText("查询");
    jButton3.addActionListener(new java.awt.event.ActionListener() {