databaseframe.java~16~

jbuilder2006一书的所有源代码

package dataexpress;

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

public class DatabaseFrame extends JFrame {
  JPanel contentPane;
  BorderLayout borderLayout1 = new BorderLayout();
  Database database1 = new Database();

  public DatabaseFrame() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }

  private void jbInit() throws Exception  {
    contentPane = (JPanel) this.getContentPane();
    contentPane.setLayout(borderLayout1);
    this.setSize(new Dimension(400, 300));
    this.setTitle("Database示例");
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor(
        "jdbc:microsoft:sqlserver://bemyfriend:1433;DatabaseName=books", "sa",
        "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    //将Database的数据库连接转换为java.sql.Connection连接
    Connection conn = database1.getJdbcConnection();
    Statement stmt = conn.createStatement();
    //创建数据表的查询SQL语句
    String sql = "select * from bookcategory";
    //取得返回的数据集
    ResultSet rs = stmt.executeQuery(sql);
    //显示数据表的标题
    System.out.println("序列号   " + "公司的名字       " + "电话号码");
    //显示数据表的每一条记录
    while (rs.next()) {
      System.out.println(rs.getString(1) + "     " + rs.getString(2) + " " + rs.getString(3));
    }

  }

  protected void processWindowEvent(WindowEvent e) {
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      System.exit(0);
    }
  }
}