databaseappframe.java

JAVA数据库编程实例随书源码 JAVA数据库编程实例随书源码

package mydatabaseapp;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.*;
import com.borland.dx.dataset.*;

/**
 * Title:        JBuilder组件操纵数据库
 * Description:  Java语言演示程序：JBuilder组件操纵数据库，用于北京师范大学计算机系Java课程教学示范。
 * Copyright:    Copyright (c) 2002
 * Company:      北京师范大学计算机系
 * @author 孙一林
 * @version 1.0
 */

public class databaseAppFrame extends JFrame {
  JPanel contentPane;
  BorderLayout borderLayout1 = new BorderLayout();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  ParameterRow parameterRow1 = new ParameterRow();
  Column column1 = new Column();
  Column column2 = new Column();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  JPanel jPanel1 = new JPanel();
  JdbLabel jdbLabel1 = new JdbLabel();
  JdbLabel jdbLabel2 = new JdbLabel();
  JdbTextField jdbTextField1 = new JdbTextField();
  JdbTextField jdbTextField2 = new JdbTextField();
  JButton jButton1 = new JButton();

  /**Construct the frame*/
  public databaseAppFrame() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  /**Component initialization*/
  private void jbInit() throws Exception  {
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from studentbase where 学号 >= :Student_No_min and 学号 <= :Student_No_max", parameterRow1, true, Load.ALL));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:student", "student", "123456", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    //setIconImage(Toolkit.getDefaultToolkit().createImage(databaseAppFrame.class.getResource("[Your Icon]")));
    contentPane = (JPanel) this.getContentPane();
    contentPane.setLayout(borderLayout1);
    this.setSize(new Dimension(400, 300));
    this.setTitle("JBuilder组件操纵数据库");
    column1.setColumnName("Student_No_min");
    column1.setDataType(com.borland.dx.dataset.Variant.INT);
    column1.setDefault("200166001");
    column1.setPreferredOrdinal(0);
    column1.setServerColumnName("NewColumn1");
    column1.setSqlType(0);
    column2.setColumnName("Student_No_max");
    column2.setDataType(com.borland.dx.dataset.Variant.INT);
    column2.setDefault("200166003");
    column2.setPreferredOrdinal(1);
    column2.setServerColumnName("NewColumn2");
    column2.setSqlType(0);
    parameterRow1.setColumns(new Column[] {column1, column2});
    jdbTable1.setDataSet(queryDataSet1);
    jPanel1.setPreferredSize(new Dimension(200, 100));
    jPanel1.setLayout(null);
    jdbLabel1.setText("学号最小值：");
    jdbLabel1.setBounds(new Rectangle(29, 13, 75, 25));
    jdbLabel2.setBounds(new Rectangle(29, 49, 75, 25));
    jdbLabel2.setText("学号最大值：");
    jdbTextField1.setText("200166001");
    jdbTextField1.setColumns(10);
    jdbTextField1.setBounds(new Rectangle(114, 13, 132, 28));
    jdbTextField2.setBounds(new Rectangle(115, 45, 132, 28));
    jdbTextField2.setText("200166003");
    jdbTextField2.setColumns(10);
    jButton1.setText("更新显示");
    jButton1.setBounds(new Rectangle(275, 21, 94, 41));
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton1_actionPerformed(e);
      }
    });
    contentPane.add(tableScrollPane1, BorderLayout.CENTER);
    contentPane.add(jPanel1, BorderLayout.NORTH);
    jPanel1.add(jdbLabel1, null);
    jPanel1.add(jdbLabel2, null);
    jPanel1.add(jButton1, null);
    jPanel1.add(jdbTextField2, null);
    jPanel1.add(jdbTextField1, null);
    tableScrollPane1.getViewport().add(jdbTable1, null);
  }
  /**Overridden so we can exit when window is closed*/
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      System.exit(0);
    }
  }

  void jButton1_actionPerformed(ActionEvent e) {
    try {                         // 通过输入改变查询参数值
      parameterRow1.setInt("Student_No_min",Integer.parseInt(jdbTextField1.getText()));
      parameterRow1.setInt("Student_No_max",Integer.parseInt(jdbTextField2.getText()));
      queryDataSet1.refresh();      // 更新显示
    }
    catch (Exception ex) {
       ex.printStackTrace();
    }
  }
}