panelstudents.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.DialogUpdateStudents;
import com.javasme.longs.LookAndFeel;
import com.javasme.longs.ObjectClasses;
import com.javasme.util.FormChecked;

public class PanelStudents extends javax.swing.JPanel {

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

    private JButton           buttonUpdate;

    private JTable            tableStudents    = ObjectClasses.tableStudents;

    private JButton           buttonDelete;

    private JPanel            panelDown;

    public JScrollPane        scrollPane;

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

    private String            valueID;

    private String            sqlStr;

    private Statement         st;

    public PanelStudents() {
        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 tableStudentModel = new DefaultTableModel();
                    tableStudents.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
                    scrollPane.setViewportView(tableStudents);
                    tableStudents.setModel(tableStudentModel);
                    tableStudents.getTableHeader().setReorderingAllowed(false);
                    tableStudents.getTableHeader().setBackground(new java.awt.Color(236, 233, 216));
                    tableStudents.addMouseListener(new MouseAdapter() {
                        public void mouseClicked(MouseEvent evt) {
                            tableStudentsMouseClicked(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() {
        // System.out.println("初始化方法被调用");
        SQLOperate.selectAllFromData("Students", tableStudents);
        // System.out.println("查询所有数据获取行数结束!");
        ObjectClasses.tableStudentsRowCountFile = ObjectClasses.tableStudentsRowFile.setTableRowFile(ObjectClasses.tableStudentsRowCount);
        this.scrollPane.setRowHeaderView(ObjectClasses.tableStudentsRowCountFile);
        // System.out.println("结束");
    }

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

    /**
     * 《删除所选信息》按钮事件处理方法
     * 
     * @param evt
     */
    public void buttonDeleteActionPerformed(ActionEvent evt) {
        sqlStr = "Delete * from Students where ID = " + valueID;
        st = SQLOperate.getStatement();
        try {
            st.executeUpdate(sqlStr);
        } catch (SQLException e) {
            SQLOperate.closeST();
            FormChecked.lose("删除学生", "删除失败！数据库访问错误！");
            e.printStackTrace();
            return;
        }
        FormChecked.success("删除学生", "成功删除学生信息！");
        initial();
    }

    /**
     * 鼠标点击表格事件处理
     */
    private void tableStudentsMouseClicked(MouseEvent evt) {
        rowCount = tableStudents.rowAtPoint(evt.getPoint());
        valueID = tableStudents.getValueAt(rowCount, 0).toString();

        // System.out.println(valueID);
        // System.out.println(rowCount + " " + columnCount);
    }
}