stumsjframe.java

java编写的与SQL数据连接的好例子~~功能很完善,可以做实训直接交

/*
 * stuMSJFrame.java
 *
 * Created on 2008年6月17日, 下午8:53
 */

package stuMS;
import java.awt.*;
import java.awt.event.*;
import java.net.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.event.TableModelEvent;
import javax.swing.event.TableModelListener;
import javax.swing.table.*;
/**
 *
 * @author  Administrator
 */
public class stuMSJFrame extends javax.swing.JFrame implements TableModelListener{
    DefaultTableModel defaultTableModel;
    Image icon;
    String []Sno;
    String manager = null;
    String code = null;
    //public static stuInformationJFrame stuInfo = new stuInformationJFrame();
    
    /** Creates new form stuMSJFrame */
    public stuMSJFrame() {
        icon = Toolkit.getDefaultToolkit().getImage( "icon.gif");
        initComponents();
        defaultTableModel = (DefaultTableModel)table.getModel();
        defaultTableModel.addTableModelListener(this);
        menuStuManagement.setEnabled(true);
        menuCourseManagement.setEnabled(true);
        menuScoreManagement.setEnabled(true);
        menuInformationInquiry.setEnabled(true);
        
        this.setLocationRelativeTo(null);
    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        jScrollPane1 = new javax.swing.JScrollPane();
        table = new javax.swing.JTable();
        mainMenu = new javax.swing.JMenuBar();
        menuSystemManagement = new javax.swing.JMenu();
        menuLogOn = new javax.swing.JMenuItem();
        itemExit = new javax.swing.JMenuItem();
        menuStuManagement = new javax.swing.JMenu();
        itemAddStu = new javax.swing.JMenuItem();
        itemAlterStu = new javax.swing.JMenuItem();
        itemDeleteStu = new javax.swing.JMenuItem();
        separator1 = new javax.swing.JSeparator();
        itemSC = new javax.swing.JMenuItem();
        menuCourseManagement = new javax.swing.JMenu();
        itemAddCourse = new javax.swing.JMenuItem();
        jSeparator3 = new javax.swing.JSeparator();
        itemAlterCourse = new javax.swing.JMenuItem();
        jSeparator4 = new javax.swing.JSeparator();
        itemDeleteCourse = new javax.swing.JMenuItem();
        jSeparator6 = new javax.swing.JSeparator();
        jSeparator5 = new javax.swing.JSeparator();
        menuScoreManagement = new javax.swing.JMenu();
        itemAddScore = new javax.swing.JMenuItem();
        itemAlterScore = new javax.swing.JMenuItem();
        itemDeleteScore = new javax.swing.JMenuItem();
        menuInformationInquiry = new javax.swing.JMenu();
        menuStuInquiry = new javax.swing.JMenu();
        itemInquiryBySid = new javax.swing.JMenuItem();
        itemInquiryBySname = new javax.swing.JMenuItem();
        itemInquiryBySsex = new javax.swing.JMenuItem();
        itemInquiryByScollege = new javax.swing.JMenuItem();
        itemInquiryBySspecialSubject = new javax.swing.JMenuItem();
        menuCourseInquiry = new javax.swing.JMenu();
        jMenuItem10 = new javax.swing.JMenuItem();
        jMenuItem11 = new javax.swing.JMenuItem();
        jMenuItem12 = new javax.swing.JMenuItem();
        menuScoreInquiry = new javax.swing.JMenu();
        jMenuItem13 = new javax.swing.JMenuItem();
        jMenuItem14 = new javax.swing.JMenuItem();
        viewAllStuInfo = new javax.swing.JMenuItem();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setIconImage(icon);

        table.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "学号", "姓名", "性别", "出生日期", "民族", "籍贯", "入学日期", "专业", "学院"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, true, true, true, true, true, true, true, true
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jScrollPane1.setViewportView(table);

        menuSystemManagement.setText("系统管理");

        menuLogOn.setText("登录");
        menuLogOn.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                menuLogOnActionPerformed(evt);
            }
        });
        menuSystemManagement.add(menuLogOn);

        itemExit.setText("退出");
        menuSystemManagement.add(itemExit);

        mainMenu.add(menuSystemManagement);

        menuStuManagement.setText("学生管理");
        menuStuManagement.setEnabled(false);

        itemAddStu.setText("增加");
        itemAddStu.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                itemAddStuActionPerformed(evt);
            }
        });
        menuStuManagement.add(itemAddStu);

        itemAlterStu.setText("修改");
        itemAlterStu.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                itemAlterStuActionPerformed(evt);
            }
        });
        menuStuManagement.add(itemAlterStu);

        itemDeleteStu.setText("删除");
        itemDeleteStu.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                itemDeleteStuActionPerformed(evt);
            }
        });
        menuStuManagement.add(itemDeleteStu);
        menuStuManagement.add(separator1);

        itemSC.setText("学生选课");
        menuStuManagement.add(itemSC);

        mainMenu.add(menuStuManagement);

        menuCourseManagement.setText("课程管理");
        menuCourseManagement.setEnabled(false);

        itemAddCourse.setText("课程添加");
        menuCourseManagement.add(itemAddCourse);
        menuCourseManagement.add(jSeparator3);

        itemAlterCourse.setText("课程修改 ");
        menuCourseManagement.add(itemAlterCourse);
        menuCourseManagement.add(jSeparator4);

        itemDeleteCourse.setText("删除删除");
        menuCourseManagement.add(itemDeleteCourse);
        menuCourseManagement.add(jSeparator6);
        menuCourseManagement.add(jSeparator5);

        mainMenu.add(menuCourseManagement);

        menuScoreManagement.setText("成绩管理");
        menuScoreManagement.setEnabled(false);

        itemAddScore.setText("成绩添加");
        menuScoreManagement.add(itemAddScore);

        itemAlterScore.setText("成绩修改");
        menuScoreManagement.add(itemAlterScore);

        itemDeleteScore.setText("删除");
        menuScoreManagement.add(itemDeleteScore);

        mainMenu.add(menuScoreManagement);

        menuInformationInquiry.setText("信息查询");
        menuInformationInquiry.setEnabled(false);

        menuStuInquiry.setText("学生查询");

        itemInquiryBySid.setText("按学号查询");
        itemInquiryBySid.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                itemInquiryBySidActionPerformed(evt);
            }
        });
        menuStuInquiry.add(itemInquiryBySid);

        itemInquiryBySname.setText("按姓名查询");