panelteachers.java

学员信息管理系统

package com.javasme.panel;

/**
 * 主程序中《教师信息》的主窗体
 * 
 * 开发时间：07年03月07日
 * 
 * 开发人员：边疆
 * 
 * 应用技术：基本控件、Socket传输、线程应用
 */

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.BorderFactory;
import javax.swing.JButton;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.border.BevelBorder;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;

import com.javasme.data.SQLOperate;
import com.javasme.dialog.DialogUpdateTeachers;
import com.javasme.longs.LookAndFeel;
import com.javasme.longs.ObjectClasses;
import com.javasme.util.FormChecked;

public class PanelTeachers extends javax.swing.JPanel {

    /**
     * 
     */
    private static final long serialVersionUID = 1L;

    private JButton           buttonUpdate;

    private JTable            tableTeachers    = ObjectClasses.tableTeachers;

    private JButton           buttonDelete;

    private JPanel            panelDown;

    private JScrollPane       scrollPane;

    /**
     * 数据操作用到的字段与对象
     */
    private int               rowCount;

    private String            valueID;

    private String            teacherID;

    private String            teacherName;

    private String            sqlStr;

    private Statement         st;

    public PanelTeachers() {
        super();
        initGUI();
        /**
         * 风格设置
         */
        LookAndFeel.UpdateLookAndFeel(this);
        initial();
    }

    private void initGUI() {
        try {
            BorderLayout thisLayout = new BorderLayout();
            this.setLayout(thisLayout);
            setPreferredSize(new Dimension(700, 500));
            this.setBorder(BorderFactory.createTitledBorder("教师信息"));
            this.setBackground(new java.awt.Color(236, 233, 216));
            {
                scrollPane = new JScrollPane();
                this.add(scrollPane, BorderLayout.CENTER);
                scrollPane.setBorder(BorderFactory.createEtchedBorder(BevelBorder.LOWERED));
                scrollPane.setBackground(new java.awt.Color(236, 233, 216));
                {
                    TableModel tableTeacherModel = new DefaultTableModel();
                    tableTeachers.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
                    scrollPane.setViewportView(tableTeachers);
                    tableTeachers.setModel(tableTeacherModel);
                    tableTeachers.getTableHeader().setReorderingAllowed(false);
                    tableTeachers.getTableHeader().setBackground(new java.awt.Color(236, 233, 216));
                    tableTeachers.addMouseListener(new MouseAdapter() {
                        public void mouseClicked(MouseEvent evt) {
                            tableTeachersMouseClicked(evt);
                        }
                    });
                }
            }
            {
                panelDown = new JPanel();
                this.add(panelDown, BorderLayout.SOUTH);
                panelDown.setBackground(new java.awt.Color(236, 233, 216));
                {
                    buttonUpdate = new JButton();
                    panelDown.add(buttonUpdate);
                    buttonUpdate.setText("修改所选信息");
                    buttonUpdate.setFont(new java.awt.Font("宋体", 0, 12));
                    buttonUpdate.addActionListener(new ActionListener() {
                        public void actionPerformed(ActionEvent evt) {
                            buttonUpdateActionPerformed(evt);
                        }
                    });
                }
                {
                    buttonDelete = new JButton();
                    panelDown.add(buttonDelete);
                    buttonDelete.setText("删除所选信息");
                    buttonDelete.setFont(new java.awt.Font("宋体", 0, 12));
                    buttonDelete.addActionListener(new ActionListener() {
                        public void actionPerformed(ActionEvent evt) {
                            buttonDeleteActionPerformed(evt);
                        }
                    });
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * 页面初始化方法
     */
    private void initial() {
        SQLOperate.selectAllFromData("Teachers", tableTeachers);
        ObjectClasses.tableTeachersRowCountFile = ObjectClasses.tableTeachersRowFile.setTableRowFile(ObjectClasses.tableTeachersRowCount);
        this.scrollPane.setRowHeaderView(ObjectClasses.tableTeachersRowCountFile);
    }

    /**
     * 《修改所选信息》按钮事件处理方法
     * 
     * @param evt
     */
    private void buttonUpdateActionPerformed(ActionEvent evt) {
        new DialogUpdateTeachers(null, valueID).show();
    }

    /**
     * 《删除所选信息》按钮事件处理方法
     * 
     * @param evt
     */
    private void buttonDeleteActionPerformed(ActionEvent evt) {
        st = SQLOperate.getStatement();
        try {
            sqlStr = "Delete * from Teachers where ID = " + valueID;
            st.executeUpdate(sqlStr);
            sqlStr = "Update Classes set Class_Teacher = '<已删除>' where Class_Teacher = '[" + teacherID + "]" + teacherName + "'";
            st.executeUpdate(sqlStr);
        } catch (SQLException e) {
            SQLOperate.closeST();
            FormChecked.lose("删除教师", "删除失败！数据库访问错误！");
            e.printStackTrace();
            return;
        }
        FormChecked.success("删除教师", "成功删除教师信息！");
        initial();
    }

    /**
     * 鼠标点击表格事件处理
     */
    private void tableTeachersMouseClicked(MouseEvent evt) {
        rowCount = tableTeachers.rowAtPoint(evt.getPoint());
        valueID = tableTeachers.getValueAt(rowCount, 0).toString();
        teacherID = tableTeachers.getValueAt(rowCount, 1).toString();
        teacherName = tableTeachers.getValueAt(rowCount, 2).toString();
        // System.out.println(valueID);
        // System.out.println(rowCount + " " + columnCount);
    }
}