frame6.java~12~

这是用VB编写的一个图书馆管理系统,很好用,特别是对初学者有很好的引导作用.

package test1;

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

/**
 * <p>Title: 图书管理系统</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2007</p>
 * <p>Company: </p>
 * @author koma
 * @version 1.0
 */

public class Frame6 extends JFrame {
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  JButton jButton5 = new JButton();
  JButton jButton6 = new JButton();
  JButton jButton7 = new JButton();
  JButton jButton8 = new JButton();

  public Frame6() {
    this.setTitle("图书管理");
    this.setSize(500,500);
    this.setLocation(300,150);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }

  }
  private void jbInit() throws Exception {
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from book", null, true, Load.ALL));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:student1", "koma", "koma", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    this.getContentPane().setLayout(null);
    tableScrollPane1.setBounds(new Rectangle(4, 21, 622, 316));
    jdbTable1.setDataSet(queryDataSet1);
    jButton1.setBounds(new Rectangle(13, 356, 107, 46));
    jButton1.setFont(new java.awt.Font("DialogInput", 1, 20));
    jButton1.setText("第一条");
    jButton1.addActionListener(new Frame6_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(129, 351, 106, 48));
    jButton2.setFont(new java.awt.Font("DialogInput", 1, 20));
    jButton2.setText("前一条");
    jButton2.addActionListener(new Frame6_jButton2_actionAdapter(this));
    jButton3.setBounds(new Rectangle(232, 348, 98, 52));
    jButton3.setFont(new java.awt.Font("DialogInput", 1, 20));
    jButton3.setText("下一条");
    jButton3.addActionListener(new Frame6_jButton3_actionAdapter(this));
    jButton4.setBounds(new Rectangle(329, 345, 130, 56));
    jButton4.setFont(new java.awt.Font("DialogInput", 1, 20));
    jButton4.setText("最后一条");
    jButton4.addActionListener(new Frame6_jButton4_actionAdapter(this));
    jButton5.setBounds(new Rectangle(17, 422, 112, 51));
    jButton5.setFont(new java.awt.Font("DialogInput", 1, 20));
    jButton5.setText("添加");
    jButton5.addActionListener(new Frame6_jButton5_actionAdapter(this));
    jButton6.setBounds(new Rectangle(124, 428, 118, 46));
    jButton6.setFont(new java.awt.Font("DialogInput", 1, 20));
    jButton6.setText("删除");
    jButton6.addActionListener(new Frame6_jButton6_actionAdapter(this));
    jButton7.setBounds(new Rectangle(216, 435, 120, 41));
    jButton7.setFont(new java.awt.Font("DialogInput", 1, 20));
    jButton7.setText("修改");
    jButton8.setBounds(new Rectangle(345, 424, 121, 50));
    jButton8.setFont(new java.awt.Font("DialogInput", 1, 20));
    jButton8.setText("保存");
    jButton8.addActionListener(new Frame6_jButton8_actionAdapter(this));
    this.getContentPane().add(tableScrollPane1, null);
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jButton5, null);
    this.getContentPane().add(jButton2, null);
    this.getContentPane().add(jButton6, null);
    this.getContentPane().add(jButton3, null);
    this.getContentPane().add(jButton4, null);
    this.getContentPane().add(jButton8, null);
    this.getContentPane().add(jButton7, null);
    tableScrollPane1.getViewport().add(jdbTable1, null);
  }

  void jButton1_actionPerformed(ActionEvent e) {
    queryDataSet1.first();
  }

  void jButton2_actionPerformed(ActionEvent e) {
    queryDataSet1.prior();
  }

  void jButton3_actionPerformed(ActionEvent e) {
    queryDataSet1.next();
  }

  void jButton4_actionPerformed(ActionEvent e) {
    queryDataSet1.last();
  }

  void jButton5_actionPerformed(ActionEvent e) {
    queryDataSet1.insertRow(true);
  }

  void jButton6_actionPerformed(ActionEvent e) {
    queryDataSet1.deleteRow();
  }

  void jButton8_actionPerformed(ActionEvent e) {
    queryDataSet1.saveChanges();
  }
}

class Frame6_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame6 adaptee;

  Frame6_jButton1_actionAdapter(Frame6 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Frame6_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Frame6 adaptee;

  Frame6_jButton2_actionAdapter(Frame6 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class Frame6_jButton3_actionAdapter implements java.awt.event.ActionListener {
  Frame6 adaptee;

  Frame6_jButton3_actionAdapter(Frame6 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class Frame6_jButton4_actionAdapter implements java.awt.event.ActionListener {
  Frame6 adaptee;

  Frame6_jButton4_actionAdapter(Frame6 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class Frame6_jButton5_actionAdapter implements java.awt.event.ActionListener {
  Frame6 adaptee;

  Frame6_jButton5_actionAdapter(Frame6 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class Frame6_jButton6_actionAdapter implements java.awt.event.ActionListener {
  Frame6 adaptee;

  Frame6_jButton6_actionAdapter(Frame6 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton6_actionPerformed(e);
  }
}

class Frame6_jButton8_actionAdapter implements java.awt.event.ActionListener {
  Frame6 adaptee;

  Frame6_jButton8_actionAdapter(Frame6 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton8_actionPerformed(e);
  }
}