xqxx_list.java~18~

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

package basecode.xqsz;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;


import com.zdsoft.datacenter.*;
import com.zdsoft.datastore.*;
import com.zdsoft.gui.*;

public class XQXX_list extends ASPanel{


  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  JPanel jPanel4 = new JPanel();
  JPanel jPanel5 = new JPanel();
  JPanel jPanel6 = new JPanel();
  JPanel jPanel7 = new JPanel();
  JPanel jPanel8 = new JPanel();
  BorderLayout borderLayout1 = new BorderLayout();
  JLabel jLabel1 = new JLabel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JScrollPane jScrollPane1 = new JScrollPane();
  ASDatacenter dc;
  ASDatastore ds;
  ASTableView asTableView;
  ASTable jTable1;


  public XQXX_list() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
     OperDate op=new OperDate();
     ds= op.findallXQ_info();
     asTableView = new ASTableView(ds);
     jTable1 = new ASTable(asTableView);

     jPanel1.setLayout(borderLayout1);
    jLabel1.setFont(new java.awt.Font("Serif", 0, 20));
    jLabel1.setText("学期信息维护");
    jButton1.setFont(new java.awt.Font("Serif", 0, 12));
    jButton1.setText("删除");
    jButton1.addActionListener(new XQXX_list_jButton1_actionAdapter(this));
    jButton2.setFont(new java.awt.Font("Serif", 0, 12));
    jButton2.setText("修改");
    jButton2.addActionListener(new XQXX_list_jButton2_actionAdapter(this));
    jButton3.setFont(new java.awt.Font("Serif", 0, 12));
    jButton3.setText("增加");
    jButton3.addActionListener(new XQXX_list_jButton3_actionAdapter(this));
    jScrollPane1.setPreferredSize(new Dimension(560, 480));
    this.setPreferredSize(new Dimension(400, 400));
    this.add(jPanel1, BorderLayout.CENTER);
    jPanel1.add(jPanel8, BorderLayout.NORTH);
    jPanel8.add(jLabel1, null);
    jPanel1.add(jPanel7,  BorderLayout.SOUTH);
    jPanel7.add(jButton3, null);
    jPanel7.add(jButton2, null);
    jPanel7.add(jButton1, null);
    jPanel1.add(jPanel6, BorderLayout.CENTER);
    jPanel6.add(jScrollPane1, null);

    this.add(jPanel2, BorderLayout.SOUTH);
    this.add(jPanel3, BorderLayout.WEST);
    this.add(jPanel4, BorderLayout.EAST);
    this.add(jPanel5, BorderLayout.NORTH);

    jScrollPane1.getViewport().add(jTable1, null);
  }

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

  void jButton2_actionPerformed(ActionEvent e) {
    if (jTable1.getSelectedRow() == -1) {
      JOptionPane.showMessageDialog(this, "请选择要修改的数据", "错误",
                                    JOptionPane.ERROR_MESSAGE);
    }
    else {
      XQXX_add_mod mod = new XQXX_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, "xq_id").intValue(); //根据选中行行号在相应ASdatastore对象的相应行中得到"id"列的值
             OperDate od = new OperDate();
             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();
       }
     }
}

class XQXX_list_jButton3_actionAdapter implements java.awt.event.ActionListener {
  XQXX_list adaptee;

  XQXX_list_jButton3_actionAdapter(XQXX_list adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class XQXX_list_jButton2_actionAdapter implements java.awt.event.ActionListener {
  XQXX_list adaptee;

  XQXX_list_jButton2_actionAdapter(XQXX_list adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class XQXX_list_jButton1_actionAdapter implements java.awt.event.ActionListener {
  XQXX_list adaptee;

  XQXX_list_jButton1_actionAdapter(XQXX_list adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}