panelcourses.java

学员信息管理系统

package com.javasme.panel;

/**
 * 主程序中《课程信息》的主窗体
 * 
 * 开发时间：07年03月07日
 * 
 * 开发人员：边疆
 * 
 * 应用技术：基本控件、事件监听、数据库操作
 */

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

public class PanelCourses extends javax.swing.JPanel {

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

    private JButton           buttonUpdate;

    private JTable            tableCourses     = ObjectClasses.tableCourses;

    private JButton           buttonDelete;

    private JPanel            panelDown;

    private JScrollPane       scrollPane;

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

    private String            valueID;

    private String            sqlStr;

    private Statement         st;

    public PanelCourses() {
        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 tableCoursesModel = new DefaultTableModel();
                    tableCourses.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
                    scrollPane.setViewportView(tableCourses);
                    tableCourses.setModel(tableCoursesModel);
                    tableCourses.getTableHeader().setReorderingAllowed(false);
                    tableCourses.getTableHeader().setBackground(new java.awt.Color(236, 233, 216));
                    tableCourses.addMouseListener(new MouseAdapter() {
                        public void mouseClicked(MouseEvent evt) {
                            tableCoursesMouseClicked(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("Courses", tableCourses);
        ObjectClasses.tableCoursesRowCountFile = ObjectClasses.tableCoursesRowFile.setTableRowFile(ObjectClasses.tableCoursesRowCount);
        this.scrollPane.setRowHeaderView(ObjectClasses.tableCoursesRowCountFile);
    }

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

    /**
     * 《删除所选信息》按钮事件处理
     * 
     * @param evt
     */

    private void buttonDeleteActionPerformed(ActionEvent evt) {
        sqlStr = "Delete * from Courses 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 tableCoursesMouseClicked(MouseEvent evt) {
        rowCount = tableCourses.rowAtPoint(evt.getPoint());
        valueID = tableCourses.getValueAt(rowCount, 0).toString();

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