informpanel.java~83~

来自「银行信用评估系统」· JAVA~83~ 代码 · 共 233 行

package management;

import java.awt.*;
import javax.swing.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.*;
import java.awt.event.*;
import java.sql.*;
import com.borland.dx.dataset.*;
import com.borland.jbcl.layout.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class informPanel extends JPanel {
  JLabel jLabel2 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  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();

   PreparedStatement pstmt;
   Connection con;
   String query;
   ResultSet rs;
   String str;
  JLabel jLabel3 = new JLabel();
  QueryDataSet queryDataSet2 = new QueryDataSet();
  Column column1 = new Column();
  Column column2 = new Column();
  Column column3 = new Column();
  Column column4 = new Column();
  Column column5 = new Column();
  Column column6 = new Column();
  GridBagLayout gridBagLayout1 = new GridBagLayout();
  JLabel jLabel4 = new JLabel();

  public informPanel() {
    try {
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }
  void jbInit() throws Exception {
    this.setLayout(gridBagLayout1);
    jLabel2.setFont(new java.awt.Font("Dialog", 1, 22));
    jLabel2.setText("输入学号:");
    jTextField1.setText("");
    jButton1.setText("确定");
    jButton1.addActionListener(new informPanel_jButton1_actionAdapter(this));
    jButton2.setText("重置");
    jButton2.addActionListener(new informPanel_jButton2_actionAdapter(this));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student", "sa", "lomf8244", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    database1.setUseTransactions(false);
    queryDataSet1.setResolver(queryResolver1);
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from student", null, true, Load.ALL));
    queryResolver1.setDatabase(database1);
    queryResolver1.setUpdateMode(com.borland.dx.dataset.UpdateMode.KEY_COLUMNS);
    jdbNavToolBar1.setFont(new java.awt.Font("Dialog", 0, 10));
    jdbNavToolBar1.setDataSet(queryDataSet1);
    jdbStatusLabel1.setText(" ");
    jdbStatusLabel1.setDataSet(queryDataSet1);
    tableScrollPane1.getViewport().setBackground(SystemColor.info);
    tableScrollPane1.setAutoscrolls(true);
    jdbTable1.setBackground(Color.cyan);
    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_LAST_COLUMN);
    jdbTable1.setDataSet(queryDataSet1);
    jLabel3.setText("");
    queryDataSet2.setResolver(queryResolver1);

    column1.setCaption("学号");
    column1.setColumnName("STUDENTNO");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setPrecision(8);
    column1.setRowId(true);
    column1.setTableName("student");
    column1.setServerColumnName("STUDENTNO");
    column1.setSqlType(1);
    column2.setCaption("姓名");
    column2.setColumnName("STUDENTNAME");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setPrecision(10);
    column2.setTableName("student");
    column2.setServerColumnName("STUDENTNAME");
    column2.setSqlType(12);
    column3.setCaption("年龄");
    column3.setColumnName("STUDENTAGE");
    column3.setDataType(com.borland.dx.dataset.Variant.SHORT);
    column3.setTableName("student");
    column3.setServerColumnName("STUDENTAGE");
    column3.setSqlType(5);
    column4.setCaption("性别");
    column4.setColumnName("STUDENTSEX");
    column4.setDataType(com.borland.dx.dataset.Variant.STRING);
    column4.setPrecision(2);
    column4.setTableName("student");
    column4.setServerColumnName("STUDENTSEX");
    column4.setSqlType(1);
    column5.setCaption("民族");
    column5.setColumnName("STUENTRACE");
    column5.setDataType(com.borland.dx.dataset.Variant.STRING);
    column5.setPrecision(10);
    column5.setTableName("student");
    column5.setServerColumnName("STUENTRACE");
    column5.setSqlType(12);
    column6.setCaption("专业");
    column6.setColumnName("STUDENTSPECIATION");
    column6.setDataType(com.borland.dx.dataset.Variant.STRING);
    column6.setPrecision(10);
    column6.setTableName("student");
    column6.setServerColumnName("STUDENTSPECIATION");
    column6.setSqlType(12);
    jLabel4.setFont(new java.awt.Font("Dialog", 1, 40));
    jLabel4.setForeground(Color.pink);
    jLabel4.setText("      学 生 信 息 管 理");
    this.add(jTextField1,    new GridBagConstraints(2, 1, 1, 1, 1.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(19, 7, 0, 108), 130, 3));
    this.add(jLabel2,    new GridBagConstraints(1, 1, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(16, 84, 0, 17), 5, -1));
    this.add(tableScrollPane1,    new GridBagConstraints(1, 4, 2, 1, 1.0, 1.0
            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(0, 0, 0, 0), -17, -249));
    tableScrollPane1.getViewport().add(jdbTable1, null);
    this.add(jButton1,    new GridBagConstraints(1, 2, 1, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(10, 138, 0, 0), 11, 2));
    this.add(jButton2,    new GridBagConstraints(2, 2, 1, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(8, 39, 0, 140), 15, 2));
    this.add(jdbStatusLabel1,    new GridBagConstraints(1, 3, 2, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(32, 60, 0, 53), 268, -2));
    this.add(jdbNavToolBar1,    new GridBagConstraints(0, 3, 3, 1, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(0, -7, 15, 18), 79, 0));
    this.add(jLabel3,    new GridBagConstraints(1, 1, GridBagConstraints.REMAINDER, GridBagConstraints.REMAINDER, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 0, 0));
    this.add(jLabel4,           new GridBagConstraints(1, 0, 2, 1, 0.0, 0.0
            ,GridBagConstraints.SOUTHEAST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 223, 0));

     Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
     String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student";
     String username= "sa";
     String password= "lomf8244";
     con = DriverManager.getConnection(url,username,password);
     query="select * from student where STUDENTNO=?";
     pstmt = con.prepareStatement(query);
     jLabel3.setVisible(false);
     queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6});
  }

  void jButton2_actionPerformed(ActionEvent e) {
     jTextField1.setText("");
     queryDataSet2.close();
     queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from student", null, true, Load.ALL));
     queryDataSet2.refresh();
     jdbNavToolBar1.setDataSet(queryDataSet2);
     jdbStatusLabel1.setDataSet(queryDataSet2);
     jdbTable1.setDataSet(queryDataSet2);
     jdbTable1.repaint();

  }

  void jButton1_actionPerformed(ActionEvent e) {
   try{
   str=jTextField1.getText();
   pstmt.setString(1,str);
   rs=pstmt.executeQuery();

    if(jTextField1.getText().length()==0 || str.equals("学号不存在!"))
    {  jTextField1.setText("请输入学号!");
    }
    else
    {

       if(rs.next()){
         queryDataSet2.close();
         jLabel3.setText(rs.getString("STUDENTNO"));
         str=jLabel3.getText();

        queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from student where STUDENTNO="+str, null, true, Load.ALL));

        queryDataSet2.refresh();

        jdbNavToolBar1.setDataSet(queryDataSet2);
        jdbStatusLabel1.setDataSet(queryDataSet2);
        jdbTable1.setDataSet(queryDataSet2);
        jdbTable1.repaint();
       }
       else{
       jTextField1.setText("学号不存在!");
        queryDataSet2.close();
        queryDataSet2.refresh();
       jdbTable1.setDataSet(null);
        jdbTable1.repaint();
       }
    }
     }
     catch(SQLException ex) {
      System.out.print("系统错误，请重新运行。");
     }
  }
}

class informPanel_jButton2_actionAdapter implements java.awt.event.ActionListener {
  informPanel adaptee;

  informPanel_jButton2_actionAdapter(informPanel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class informPanel_jButton1_actionAdapter implements java.awt.event.ActionListener {
  informPanel adaptee;

  informPanel_jButton1_actionAdapter(informPanel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}