package com.javasme.panel;/** * 主程序中《課程信息》的主窗體 *  * 開發(fā)時(shí)間：07年03月07日 *  * 開發(fā)人員：邊疆 *  * 應(yīng)用技術(shù)：基本控件、事件監(jiān)聽、數(shù)據(jù)庫操作 */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;    /**     * 數(shù)據(jù)操作用到的字段與對(duì)象     */    private int               rowCount;    private String            valueID;    private String            sqlStr;    private Statement         st;    public PanelCourses() {        super();        initGUI();        /**         * 風(fēng)格設(shè)置         */        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("刪除課程", "刪除失敗！數(shù)據(jù)庫訪問錯(cuò)誤！");            e.printStackTrace();            return;        }        FormChecked.success("刪除課程", "成功刪除課程信息！");        initial();    }    /**     * 鼠標(biāo)點(diǎn)擊表格事件處理     */    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);    }}