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.*;

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

public class databaseAppFrame extends JFrame {
  JPanel contentPane;
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  JdbLabel jdbLabel1 = new JdbLabel();
  JdbTextField jdbTextField1 = new JdbTextField();
  JdbLabel jdbLabel2 = new JdbLabel();
  JdbTextField jdbTextField2 = new JdbTextField();
  JdbTextField jdbTextField3 = new JdbTextField();
  JdbTextField jdbTextField4 = new JdbTextField();
  JdbLabel jdbLabel3 = new JdbLabel();
  JdbLabel jdbLabel4 = new JdbLabel();
  JdbTextField jdbTextField5 = new JdbTextField();
  JdbLabel jdbLabel5 = new JdbLabel();
  JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();

  /**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", null, 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(null);
    this.setSize(new Dimension(400, 300));
    this.setTitle("JBuilder组件操纵数据库");
    jdbNavToolBar1.setDataSet(queryDataSet1);
    jdbNavToolBar1.setBounds(new Rectangle(0, 0, 400, 43));
    jdbLabel1.setText("学号：");
    jdbLabel1.setBounds(new Rectangle(78, 49, 50, 28));
    jdbTextField1.setText("学号");
    jdbTextField1.setColumnName("学号");
    jdbTextField1.setDataSet(queryDataSet1);
    jdbTextField1.setBounds(new Rectangle(156, 49, 164, 31));
    jdbLabel2.setBounds(new Rectangle(75, 85, 50, 28));
    jdbLabel2.setText("姓名：");
    jdbTextField2.setBounds(new Rectangle(156, 84, 164, 31));
    jdbTextField2.setDataSet(queryDataSet1);
    jdbTextField2.setColumnName("姓名");
    jdbTextField2.setText("学号");
    jdbTextField3.setText("学号");
    jdbTextField3.setColumnName("年龄");
    jdbTextField3.setDataSet(queryDataSet1);
    jdbTextField3.setBounds(new Rectangle(156, 120, 164, 31));
    jdbTextField4.setText("学号");
    jdbTextField4.setColumnName("性别");
    jdbTextField4.setDataSet(queryDataSet1);
    jdbTextField4.setBounds(new Rectangle(156, 155, 164, 31));
    jdbLabel3.setText("年龄：");
    jdbLabel3.setBounds(new Rectangle(72, 127, 50, 28));
    jdbLabel4.setText("性别：");
    jdbLabel4.setBounds(new Rectangle(71, 162, 50, 28));
    jdbTextField5.setBounds(new Rectangle(157, 193, 164, 31));
    jdbTextField5.setDataSet(queryDataSet1);
    jdbTextField5.setColumnName("系名");
    jdbTextField5.setText("学号");
    jdbLabel5.setBounds(new Rectangle(69, 193, 50, 28));
    jdbLabel5.setText("系别：");
    jdbStatusLabel1.setText("jdbStatusLabel1");
    jdbStatusLabel1.setDataSet(queryDataSet1);
    jdbStatusLabel1.setBounds(new Rectangle(2, 234, 399, 36));
    contentPane.add(jdbNavToolBar1, null);
    contentPane.add(jdbTextField5, null);
    contentPane.add(jdbTextField4, null);
    contentPane.add(jdbTextField3, null);
    contentPane.add(jdbTextField2, null);
    contentPane.add(jdbTextField1, null);
    contentPane.add(jdbLabel1, null);
    contentPane.add(jdbLabel2, null);
    contentPane.add(jdbLabel4, null);
    contentPane.add(jdbStatusLabel1, null);
    contentPane.add(jdbLabel5, null);
    contentPane.add(jdbLabel3, 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);
    }
  }
}