frame9.java~3~

这是用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 Frame9 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();

  public Frame9() {
    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 userInfo", null, true, Load.ALL));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:图书管理系统", "koma", "koma", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    this.getContentPane().setLayout(null);
    tableScrollPane1.setBounds(new Rectangle(9, 10, 381, 224));
    jdbTable1.setDataSet(queryDataSet1);
    jButton1.setBounds(new Rectangle(27, 254, 109, 33));
    jButton1.setFont(new java.awt.Font("DialogInput", 0, 20));
    jButton1.setText("第一条");
    jButton1.addActionListener(new Frame9_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(222, 255, 124, 33));
    jButton2.setFont(new java.awt.Font("DialogInput", 0, 21));
    jButton2.setText("前一条");
    jButton2.addActionListener(new Frame9_jButton2_actionAdapter(this));
    jButton3.setBounds(new Rectangle(29, 315, 115, 35));
    jButton3.setFont(new java.awt.Font("DialogInput", 0, 20));
    jButton3.setText("后一条");
    jButton3.addActionListener(new Frame9_jButton3_actionAdapter(this));
    jButton4.setBounds(new Rectangle(225, 315, 127, 38));
    jButton4.setFont(new java.awt.Font("DialogInput", 0, 20));
    jButton4.setText("最后一条");
    this.getContentPane().add(tableScrollPane1, null);
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jButton3, null);
    this.getContentPane().add(jButton4, null);
    this.getContentPane().add(jButton2, 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();
  }
}

class Frame9_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame9 adaptee;

  Frame9_jButton1_actionAdapter(Frame9 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Frame9_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Frame9 adaptee;

  Frame9_jButton2_actionAdapter(Frame9 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class Frame9_jButton3_actionAdapter implements java.awt.event.ActionListener {
  Frame9 adaptee;

  Frame9_jButton3_actionAdapter(Frame9 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}