cjgldialog.java

简单的学生管理系统。。用JBUILER和SQL2000。

package studentgl;

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

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class CJGLDialog extends JDialog {
  JPanel panel1 = new JPanel();
  BorderLayout borderLayout1 = new BorderLayout();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  QueryResolver queryResolver1 = new QueryResolver();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  Column column2 = new Column();
  Column column3 = new Column();
  Column column4 = new Column();
  Column column5 = new Column();

  public CJGLDialog(Frame frame, String title, boolean modal) {
    super(frame, title, modal);
     this.setLocation(309,239);
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public CJGLDialog() {
    this(null, "", false);
  }
  private void jbInit() throws Exception {
    panel1.setLayout(borderLayout1);
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://Issac:1433;DatabaseName=studentgl", "sa", "123456", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select a.stid,a.stname,b.coname,c.score  from studentinfo a,courseinfo b,score c where a.stid=c.stid and b.coid=c.coid", null, true, Load.ALL));
    queryResolver1.setDatabase(database1);
    queryResolver1.setUpdateMode(com.borland.dx.dataset.UpdateMode.ALL_COLUMNS);
    jdbNavToolBar1.setButtonStateDelete(JdbNavToolBar.DISABLED);
    jdbStatusLabel1.setText("jdbStatusLabel1");
    jdbStatusLabel1.setDataSet(queryDataSet1);
    jdbTable1.setFont(new java.awt.Font("Serif", 0, 12));
    jdbTable1.setDataSet(queryDataSet1);

    column2.setCaption("学生名字");
    column2.setColumnName("StName");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setPrecision(20);
    column2.setTableName("studentinfo");
    column2.setWidth(5);
    column2.setServerColumnName("StName");
    column2.setSqlType(1);
    column3.setCaption("课程名称");
    column3.setColumnName("CoName");
    column3.setDataType(com.borland.dx.dataset.Variant.STRING);
    column3.setPrecision(10);
    column3.setTableName("courseinfo");
    column3.setWidth(5);
    column3.setServerColumnName("CoName");
    column3.setSqlType(12);

    column4.setCaption("成绩");
    column4.setColumnName("Score");
    column4.setDataType(com.borland.dx.dataset.Variant.INT);
    column4.setTableName("Score");
    column4.setWidth(3);
    column4.setServerColumnName("Score");
    column4.setSqlType(4);

    column5.setCaption("学号");
    column5.setColumnName("stid1");
    column5.setDataType(com.borland.dx.dataset.Variant.STRING);
    column5.setPrecision(8);
    column5.setTableName("studentinfo");
    column5.setServerColumnName("stid");
    column5.setSqlType(1);
    queryDataSet1.setColumns(new Column[] {column5, column2, column3, column4});
    getContentPane().add(panel1);
    panel1.add(jdbNavToolBar1, BorderLayout.NORTH);
    panel1.add(jdbStatusLabel1, BorderLayout.SOUTH);
    panel1.add(tableScrollPane1, BorderLayout.CENTER);
    tableScrollPane1.getViewport().add(jdbTable1, null);
  }
}