kclx_list.java~4~

这是一个图书和学生信息的管理系统,它可以在数据库里面增加,修改,删除数据来管理图书和学生信息

package basecode.kclx;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.zdsoft.gui.*;
import javax.swing.border.*;
import com.zdsoft.datacenter.*;
import com.zdsoft.datastore.*;
import com.zdsoft.gui.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */

public class KCLX_list extends ASPanel {
  private BorderLayout borderLayout1 = new BorderLayout();
  private TitledBorder titledBorder1;
  private TitledBorder titledBorder2;
  private TitledBorder titledBorder3;

  ASDatacenter dc;
  ASDatastore ds;
  ASTableView asTableView;
  private TitledBorder titledBorder4;
  private JPanel jPanel1 = new JPanel();
  private TitledBorder titledBorder5;
  private JPanel jPanel2 = new JPanel();
  private JPanel jPanel3 = new JPanel();
  private TitledBorder titledBorder6;
  private JPanel jPanel4 = new JPanel();
  private JPanel jPanel5 = new JPanel();
  private BorderLayout borderLayout2 = new BorderLayout();
  private JPanel jPanel6 = new JPanel();
  private JPanel jPanel7 = new JPanel();
  private JPanel jPanel8 = new JPanel();
  private JButton jButton1 = new JButton();
  private JButton jButton2 = new JButton();
  private TitledBorder titledBorder7;
  private JLabel jLabel1 = new JLabel();
  private TitledBorder titledBorder8;
  private JScrollPane jScrollPane1 = new JScrollPane();
  ASTable jTable1;
  private TitledBorder titledBorder9;
  private JButton jButton3 = new JButton();

  public KCLX_list() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception  {
//    try {
//      dc = new ASDatacenter();
//      dc.connect();
//      String sql = "select a.zy_id,a.zy_code,a.zy_name,a.xz_id,b.xz_name,a.cc_id,c.cc_name,a.xxxs_id,d.xxxs_name " +
//          "from zy_dm a,xz_dm b,cc_dm c,xxxs_dm d where a.xz_id = b.xz_id and a.cc_id = c.cc_id and a.xxxs_id = d.xxxs_id";
//      ds = dc.retrieve(sql);
//      ds.setTitleLable(new String[]{
//      "专业ID", "专业代码", "专业名称", "xz_id","学制","cc_id", "层次", "xxxs_id","学习形式"});
      asTableView = new ASTableView(ds);
      jTable1 = new ASTable(asTableView);
//    }
//    catch (Exception ex) {
//
//    }
//    finally {
//      dc.disconnect();
//    }
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    titledBorder3 = new TitledBorder("");
    titledBorder4 = new TitledBorder("");
    titledBorder5 = new TitledBorder("");
    titledBorder6 = new TitledBorder("");
    titledBorder7 = new TitledBorder("");
    titledBorder8 = new TitledBorder("");
    titledBorder9 = new TitledBorder("");
    this.setLayout(borderLayout1);
    jPanel2.setLayout(borderLayout2);
    jButton1.setFont(new java.awt.Font("Serif", 0, 12));
    jButton1.setText("删除");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton1_actionPerformed(e);
      }
    });
    jButton2.setFont(new java.awt.Font("Serif", 0, 12));
    jButton2.setText("增加");
    jButton2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton2_actionPerformed(e);
      }
    });
    jLabel1.setFont(new java.awt.Font("Serif", 0, 20));
    jLabel1.setText("课程类型维护");
    jScrollPane1.setPreferredSize(new Dimension(760, 480));
    jButton3.setFont(new java.awt.Font("Serif", 0, 12));
    jButton3.setText("修改");
    jButton3.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton3_actionPerformed(e);
      }
    });
    this.add(jPanel1, BorderLayout.SOUTH);
    this.add(jPanel2, BorderLayout.CENTER);
    jPanel2.add(jPanel6, BorderLayout.CENTER);
    jPanel6.add(jScrollPane1, null);
    jScrollPane1.getViewport().add(jTable1, null);
    jPanel2.add(jPanel7, BorderLayout.SOUTH);
    jPanel7.add(jButton2, null);
    jPanel7.add(jButton3, null);
    jPanel7.add(jButton1, null);
    jPanel2.add(jPanel8, BorderLayout.NORTH);
    jPanel8.add(jLabel1, null);
    this.add(jPanel3, BorderLayout.WEST);
    this.add(jPanel4, BorderLayout.EAST);
    this.add(jPanel5, BorderLayout.NORTH);
  }

  void jButton2_actionPerformed(ActionEvent e) {
    KCLX_add_mod add = new KCLX_add_mod(this,"add");
    add.show();
  }

  void jButton3_actionPerformed(ActionEvent e) {
    if (jTable1.getSelectedRow() == -1) //相应表格未进行选择
       JOptionPane.showMessageDialog(this, "请选择要删除的数据!", "输入错误",
                                     JOptionPane.ERROR_MESSAGE);
    else{
      KCLX_add_mod mod = new KCLX_add_mod(this,"mod");
      mod.show();
    }
  }

  void jButton1_actionPerformed(ActionEvent e) {
    String msg[] = null;
    try {
      if (jTable1.getSelectedRow() == -1) //相应表格未进行选择
        JOptionPane.showMessageDialog(this, "请选择要删除的数据!", "输入错误",
                                      JOptionPane.ERROR_MESSAGE);
      else {
        int i = JOptionPane.showConfirmDialog(this, "确认要删除该条记录吗？");
        if (i == 0) {
          int row = jTable1.getSelectedRow(); //得到相应表格的选中行行号
          int id = ds.getItemInteger(row, "zy_id").intValue(); //根据选中行行号在相应ASdatastore对象的相应行中得到"id"列的值
          OperData od = new OperData();
          msg = od.DelByZyid(id); //后台方法调用,执行数据库删除操作
          if (!msg[0].equals("true"))
            JOptionPane.showMessageDialog(this, msg[1], "错误",
                JOptionPane.ERROR_MESSAGE);
          else { //数据库删除成功,相应ASdatastore对象中也要将选中行删除掉
            //ASdatastore对象中删除相应行
            ds.removeRow(row);
            //通知相应表格视图,其数据源已发生改变
            jTable1.ASTableRepant();
          }
        }
      }
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }
}