codemaintainframe.java~1~

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

package basedata;

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

import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.*;
import javax.swing.JList;
import javax.swing.table.*;
import javax.swing.event.*;
import javax.swing.border.*;
import com.zdsoft.datacenter.*;
import com.zdsoft.datastore.*;
import com.zdsoft.gui.*;
import basedata.*;
import util.*;

public class CodeMaintainFrame
    extends JInternalFrame
    implements ListSelectionListener {
  private JPanel jPanel1 = new JPanel();
  private TitledBorder titledBorder1;
  private TitledBorder titledBorder2;

  ASDatacenter dc;
  ASDatastore ds;
  ASTable asTable1;
  ASTableView asTableView;
  String tableName = "";
  GetData GD = new GetData();
  String[] zytitleName = {
      "专业ID", "专业代码", "专业名称", "xz_id","学制","cc_id", "层次", "xxxs_id","学习形式"};
  String[] kclxtitleName = {
      "课程类型代码", "课程类型名称"};
  String[] kslxtitleName = {
      "考试类型代码", "考试类型名称"};
  String[] cjlxtitleName = {
      "成绩类型代码", "成绩类型名称"};
  String[] kctitleName = {
      "课程ID", "课程代码", "课程名称"};
  String[] xqtitleName = {
      "学期代码", "学期名称"};
  String[] mztitleName = {
      "民族代码", "民族名称"};
  String[] jxdtitleName = {
      "教学点代码", "教学点名称", "地址", "邮编", "联系人", "电话"};
  String[] bjtitleName = {
      "班级ID", "班级代码", "班级名称","jxdid", "教学点", "班主任", "电话"};
  String[] xxxstitleName = {
      "学习形式代码", "学习形式名称"};
  String[] cctitleName = {
      "层次代码", "层次名称"};
  String[] xztitleName = {
      "学制代码", "学制名称"};
  String[] zzmmtitleName = {
      "政治面貌代码", "政治面貌名称"};
  private GridBagLayout gridBagLayout1 = new GridBagLayout();
  private JPanel jPanel3 = new JPanel();
  private GridBagLayout gridBagLayout2 = new GridBagLayout();
  private JSplitPane jSplitPane1 = new JSplitPane();
  private JPanel jPanel4 = new JPanel();
  private JButton addButton = new JButton();
  private JButton modiButton = new JButton();
  private JButton delButton = new JButton();
  private JScrollPane jScrollPane1 = new JScrollPane();
  private JScrollPane jScrollPane2 = new JScrollPane();
  String[] code = {
      "(kclx_dm)课程类型代码", "(kslx_dm)考试类型代码", "(cjlx_dm)成绩类型代码", "(xq_dm)学期代码",
      "(mz_dm)民族代码", "(xxxs_dm)学习形式代码", "(cc_dm)层次代码", "(xz_dm)学制代码",
      "(zzmm_dm)政治面貌代码", "(jxd_dm)教学点代码", "(bj_dm)班级代码", "(kc_dm)课程代码",
      "(zy_dm)专业代码"};
  private JList jList1 = new JList(code);
  private JLabel jLabel1 = new JLabel();
  private JButton jButton1 = new JButton();

  public CodeMaintainFrame() {
    super("代码维护", true, true, true, true);
    setSize(750, 550);

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

  private void jbInit() throws Exception {
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    this.setTitle("代码维护");
    this.getContentPane().setBackground(SystemColor.white);
    this.setFont(new java.awt.Font("Dialog", 0, 12));
    this.setSize(new Dimension(770, 610));
    jPanel1.setLayout(gridBagLayout2);
    jPanel1.setBorder(BorderFactory.createEtchedBorder());

    jList1.setFont(new java.awt.Font("Dialog", 0, 13));
    jList1.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
    jList1.addListSelectionListener(this);

    addButton.setFont(new java.awt.Font("Dialog", 0, 13));
    addButton.setText("增加");
    addButton.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        addButton_actionPerformed(e);
      }
    });
    modiButton.setFont(new java.awt.Font("Dialog", 0, 13));
    modiButton.setText("修改");
    modiButton.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        modiButton_actionPerformed(e);
      }
    });
    delButton.setFont(new java.awt.Font("Dialog", 0, 13));
    delButton.setText("删除");
    delButton.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        delButton_actionPerformed(e);
      }
    });
    jScrollPane2.setFont(new java.awt.Font("Dialog", 0, 13));
    jScrollPane2.setPreferredSize(new Dimension(535, 450));
    jScrollPane1.setPreferredSize(new Dimension(200, 450));
    jPanel4.setBorder(BorderFactory.createEtchedBorder());
    jLabel1.setText(
        "                                                                 " +
        "  ");
    jSplitPane1.setPreferredSize(new Dimension(742, 500));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton1.setText("取消");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton1_actionPerformed(e);
      }
    });
    this.getContentPane().add(jPanel1, BorderLayout.CENTER);
    jPanel1.add(jSplitPane1, new GridBagConstraints(0, 0, 2, 1, 0.0, 0.0
        , GridBagConstraints.CENTER, GridBagConstraints.NONE,
        new Insets(0, 0, 0, 0), 0, 0));
    jSplitPane1.setDividerLocation(200);
    jSplitPane1.add(jScrollPane1, JSplitPane.LEFT);
    jScrollPane1.getViewport().add(jList1, null);
    jSplitPane1.add(jScrollPane2, JSplitPane.RIGHT);

    jPanel1.add(jPanel4, new GridBagConstraints(1, 1, 1, 1, 0.0, 0.0
                                                , GridBagConstraints.CENTER,
                                                GridBagConstraints.NONE,
                                                new Insets(10, 0, 0, 0), 0, 0));
    jPanel4.add(addButton, null);
    jPanel4.add(modiButton, null);
    jPanel4.add(delButton, null);
    jPanel4.add(jButton1, null);
    jPanel1.add(jLabel1, new GridBagConstraints(0, 1, 1, 1, 0.0, 0.0
                                                , GridBagConstraints.CENTER,
                                                GridBagConstraints.NONE,
                                                new Insets(0, 0, 0, 0), 0, 0));
    this.getContentPane().add(jPanel3, BorderLayout.NORTH);

  }

  public void valueChanged(ListSelectionEvent evt) {
    try {
      if (evt.getValueIsAdjusting())
        return;
      JList theList = (JList) evt.getSource();
      int index = theList.getSelectedIndex();
      String sql = "";
      tableName = "";

      for (int i = 0; i < code[index].length(); i++) { //得到表名
        if (code[index].charAt(i) == '(') {}
        else {
          if (code[index].charAt(i) == ')') {
            break;
          }
          else {
            tableName = tableName + code[index].charAt(i);
          }
        }
      }
      if (tableName.equals("bj_dm"))
        ds = GD.findallBj_info();
      else if (tableName.equals("zy_dm"))
        ds = GD.findallZy_info();
      else ds = GD.findall(tableName);

      if (tableName.equals("zy_dm"))
        ds.setTitleLable(zytitleName);
      else if (tableName.equals("kclx_dm"))
        ds.setTitleLable(kclxtitleName);
      else if (tableName.equals("kslx_dm"))
        ds.setTitleLable(kslxtitleName);
      else if (tableName.equals("cjlx_dm"))
        ds.setTitleLable(cjlxtitleName);
      else if (tableName.equals("kc_dm"))
        ds.setTitleLable(kctitleName);
      else if (tableName.equals("xq_dm"))
        ds.setTitleLable(xqtitleName);
      else if (tableName.equals("mz_dm"))
        ds.setTitleLable(mztitleName);
      else if (tableName.equals("jxd_dm"))
        ds.setTitleLable(jxdtitleName);
      else if (tableName.equals("bj_dm"))
        ds.setTitleLable(bjtitleName);
      else if (tableName.equals("xxxs_dm"))
        ds.setTitleLable(xxxstitleName);
      else if (tableName.equals("cc_dm"))
        ds.setTitleLable(cctitleName);
      else if (tableName.equals("xz_dm"))
        ds.setTitleLable(xztitleName);
      else if (tableName.equals("zzmm_dm"))
        ds.setTitleLable(zzmmtitleName);

      asTableView = new ASTableView(ds);

      if (tableName.equals("bj_dm"))
        asTable1 = new ASTable(asTableView,new String[]{"jxd_id","bj_id"});
      else if (tableName.equals("jxd_dm"))
        asTable1 = new ASTable(asTableView,new String[] {"jxd_id"});
      else if (tableName.equals("kc_dm"))
        asTable1 = new ASTable(asTableView,new String[] {"kc_id"});
      else if (tableName.equals("zy_dm"))
        asTable1 = new ASTable(asTableView,new String[] {"xxxs_id","cc_id","xz_id","zy_id"});
      else
        asTable1 = new ASTable(asTableView);

    }
    catch (Exception ex) {

    }

    jScrollPane2.getViewport().add(asTable1, null);
    jSplitPane1.setDividerLocation(200);
    jSplitPane1.add(jScrollPane2, JSplitPane.RIGHT);
//  jSplitPane1.setRightComponent(jScrollPane2);
  }

  void addButton_actionPerformed(ActionEvent e) {
    if (tableName.equals("zy_dm")) {
      ZyCodeAddAndMod dm = new ZyCodeAddAndMod(this, "add"); //调用另一页面,给定"add"参数,表明将进行数据增加操作
      dm.show(); //页面显示
    }
    else if (tableName.equals("kc_dm")) {
      KCCodeAddAndMod dm = new KCCodeAddAndMod(this, "add"); //调用另一页面,给定"add"参数,表明将进行数据增加操作
      dm.show(); //页面显示
    }
    else if (tableName.equals("bj_dm")) {
      BjCodeAddAndMod dm = new BjCodeAddAndMod(this, "add"); //调用另一页面,给定"add"参数,表明将进行数据增加操作
      dm.show(); //页面显示
    }
    else if (tableName.equals("jxd_dm")) {
      JxdCodeAddAndMod dm = new JxdCodeAddAndMod(this, "add"); //调用另一页面,给定"add"参数,表明将进行数据增加操作
      dm.show(); //页面显示
    }
    else {
      CodeAddAndMod dm = new CodeAddAndMod(this, "add"); //调用另一页面,给定"add"参数,表明将进行数据增加操作
      dm.show(); //页面显示
    }
  }

  void modiButton_actionPerformed(ActionEvent e) {
    if (asTable1.getSelectedRow() == -1) { //相应表格未进行选择
      JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                    JOptionPane.ERROR_MESSAGE);
    }
    else {
      if (tableName.equals("zy_dm")) {
        ZyCodeAddAndMod dm = new ZyCodeAddAndMod(this, "modi"); //调用另一页面,给定"add"参数,表明将进行数据增加操作
        dm.show(); //页面显示
      }
      else if (tableName.equals("kc_dm")) {
        KCCodeAddAndMod dm = new KCCodeAddAndMod(this, "modi"); //调用另一页面,给定"add"参数,表明将进行数据增加操作
        dm.show(); //页面显示
      }
      else if (tableName.equals("bj_dm")) {
        BjCodeAddAndMod dm = new BjCodeAddAndMod(this, "modi"); //调用另一页面,给定"add"参数,表明将进行数据增加操作
        dm.show(); //页面显示
      }
      else if (tableName.equals("jxd_dm")) {
        JxdCodeAddAndMod dm = new JxdCodeAddAndMod(this, "modi"); //调用另一页面,给定"add"参数,表明将进行数据增加操作
        dm.show(); //页面显示
      }
      else {
        CodeAddAndMod dm = new CodeAddAndMod(this, "modi"); //调用另一页面,给定"add"参数,表明将进行数据增加操作
        dm.show(); //页面显示
      }
    }
  }

  void delButton_actionPerformed(ActionEvent e) {
    String msg[] = null;
    try {
      if (asTable1.getSelectedRow() == -1) //相应表格未进行选择
        JOptionPane.showMessageDialog(this, "请选择要删除的数据!", "输入错误",
                                      JOptionPane.ERROR_MESSAGE);
      else {
        int i = JOptionPane.showConfirmDialog(this, "确认要删除该条记录吗？");
        if (i == 0) {
          String columnName[] = ds.getTitleName();
          int row = asTable1.getSelectedRow(); //得到相应表格的选中行行号
          int id = ds.getItemInteger(row, columnName[0] + "").intValue(); //根据选中行行号在相应ASdatastore对象的相应行中得到"id"列的值
          GetData gd = new GetData();
          msg = gd.DeldataInfo(id, tableName); //后台方法调用,执行数据库删除操作
          if (!msg[0].equals("true"))
            JOptionPane.showMessageDialog(this, msg[1], "错误",
                                          JOptionPane.ERROR_MESSAGE);
          else { //数据库删除成功,相应ASdatastore对象中也要将选中行删除掉
            ds.removeRow(row); //ASdatastore对象中删除相应行
            asTable1.ASTableRepant();
          }
        }
      }
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  void jButton1_actionPerformed(ActionEvent e) {
    this.dispose();
  }
}