inputselectedlessoninfo.java~382~

Tt s a good book ,if you want to learn java good

package sos;

//选课信息录入
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.awt.event.ActionEvent;
import java.awt.Rectangle;
import java.awt.Font;
import java.awt.Color;
import java.sql.*;

public class InputSelectedLessonInfo extends JDialog {
    String[] haveSelected = new String[15]; //记录已选课程的课程名称
    String[] haveSelectedScore = new String[15]; //记录已选课程的学分
    String[] haveSelectedResult = new String[15]; //记录已选课程的成绩
    String[] haveSelectedNature = new String[15]; //记录已选课程的性质
    int haveSelectedScoreAll = 0; //记录已选课的总学分，显示在TextField中
    int haveSelectedCount = 0; //记录已选课程的数目
    int blankSubject = 0; //记录Result_Info中第一个空的课程列的列号
    String strNumber = "", strName = "", strStatus = ""; //学生的基本信息，strNumber是从TextField中获得的
    String strLessonNumber = "", strLessonName = "", strLessonNature = ""; //记录从推荐选课和号码选课获得的课程学分,课程名和课程属性
    boolean hasInput = false, canInputSelectedInfo = false; //canInput提示是否能录入信息
    public InputSelectedLessonInfo(Frame frame, boolean modal) {
        super(frame, true);
        setTitle("选课信息录入");
        setSize(410, 400);
        setResizable(false);
        try {
            jbInit();
        } catch (Exception ex) {}
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = getSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        setLocation((screenSize.width - frameSize.width) / 2,
                    (screenSize.height - frameSize.height) / 2 + 150);
        setVisible(true);
    }

    JLabel jLabel_Prompt = new JLabel();
    JLabel jLabel_SN = new JLabel();
    JTextField jTextField_SN = new JTextField();
    JLabel jLabel_Name = new JLabel();
    JTextField jTextField_Name = new JTextField();
    JLabel jLabel_Status = new JLabel();
    JTextField jTextField_Status = new JTextField();
    JLabel jLabel_LessonPrompt = new JLabel();
    JComboBox jComboBox_CanBeSelected = new JComboBox();
    JButton jButton_LookMore = new JButton();
    JButton jButton_GoOn = new JButton();
    JButton jButton_Cancel = new JButton();
    JLabel jLabel_HasSelect = new JLabel();
    JComboBox jComboBox_HaveSelected = new JComboBox();
    JTextField jTextField_SelectedAll = new JTextField();
    JLabel jLabel_SelectedAll = new JLabel();
    JButton jButton_SelectedAllLookMore = new JButton();
    JButton jButton_DeleteSelected = new JButton();
    JLabel jLabel1 = new JLabel();
    JTextField jTextField_CanBeSelected = new JTextField();
    JButton jButton_InputSelected = new JButton();
    JComboBox jComboBox_ScoreHad = new JComboBox();
    JLabel jLabel_ScoreHad = new JLabel();
    JLabel jLabel_NumberInMen = new JLabel();
    JLabel jLabel_NumberInScore = new JLabel();
    JTextField jTextField_Score = new JTextField();
    JButton jButton_More = new JButton();
    JButton jButton_InputOther = new JButton();
    JTextField jTextField_ScoreHad = new JTextField();
    JLabel jLabel_Total = new JLabel();
    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        jLabel_Prompt.setFont(new java.awt.Font("隶书", Font.BOLD | Font.ITALIC,
                                                25));
        jLabel_Prompt.setForeground(Color.blue);
        jLabel_Prompt.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel_Prompt.setText("正在进行选课信息录入");
        jLabel_Prompt.setBounds(new Rectangle(5, 3, 390, 33));
        jLabel_SN.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
        jLabel_SN.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel_SN.setText("学号:");
        jLabel_SN.setBounds(new Rectangle(3, 38, 39, 25));
        jTextField_SN.setHorizontalAlignment(SwingConstants.CENTER);
        jTextField_SN.setBounds(new Rectangle(44, 38, 88, 24));
        jTextField_SN.addActionListener(new
                                        InputSelectedLessonInfo_jTextField_SN_actionAdapter(this));
        jLabel_Name.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
        jLabel_Name.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel_Name.setText("姓名:");
        jLabel_Name.setBounds(new Rectangle(132, 38, 39, 25));
        jTextField_Name.setHorizontalAlignment(SwingConstants.CENTER);
        jTextField_Name.setEditable(false);
        jTextField_Name.setBounds(new Rectangle(171, 38, 61, 24));
        jLabel_Status.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
        jLabel_Status.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel_Status.setText("在读:");
        jLabel_Status.setBounds(new Rectangle(233, 38, 39, 25));
        jTextField_Status.setHorizontalAlignment(SwingConstants.CENTER);
        jTextField_Status.setBounds(new Rectangle(272, 38, 125, 23));
        jTextField_Status.setEditable(false);
        jLabel_LessonPrompt.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
        jLabel_LessonPrompt.setText("本学期必修课课程:");
        jLabel_LessonPrompt.setBounds(new Rectangle(3, 174, 145, 31));
        jComboBox_CanBeSelected.setBounds(new Rectangle(152, 174, 230, 30));
        jComboBox_CanBeSelected.setEnabled(false);
        jComboBox_CanBeSelected.addItem("高级计算机编程语言JAVA(A)"); //还有很多要完善的地方！！
        jComboBox_CanBeSelected.addItem("高等数学(一)"); //还有很多要完善的地方！！
        jComboBox_CanBeSelected.addItem("大学英语(一)"); //还有很多要完善的地方！！
        jComboBox_CanBeSelected.addItem("高级计算机编程语言JAVA(B)"); //还有很多要完善的地方！！
        jButton_LookMore.setBounds(new Rectangle(44, 213, 155, 28));
        jButton_LookMore.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
        jButton_LookMore.setText("查看该课详情");
        jButton_LookMore.setEnabled(false);
        jButton_LookMore.addActionListener(new
                                           InputSelectedLessonInfo_jButton_LookMore_actionAdapter(this));
        jButton_GoOn.setBounds(new Rectangle(45, 328, 154, 28));
        jButton_GoOn.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
        jButton_GoOn.setText("继续选课录入");
        jButton_GoOn.setEnabled(false);
        jButton_GoOn.addActionListener(new
                                       InputSelectedLessonInfo_jButton_GoOn_actionAdapter(this));
        jButton_Cancel.setBounds(new Rectangle(218, 328, 155, 28));
        jButton_Cancel.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
        jButton_Cancel.setText("退出选课录入");
        jButton_Cancel.addActionListener(new
                                         InputSelectedLessonInfo_jButton_Cancel_actionAdapter(this));
        jLabel_HasSelect.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
        jLabel_HasSelect.setText("本学期已选修课程:");
        jLabel_HasSelect.setBounds(new Rectangle(3, 67, 145, 33));
        jComboBox_HaveSelected.setBounds(new Rectangle(152, 68, 230, 30));
        jComboBox_HaveSelected.setEnabled(false);
        jTextField_SelectedAll.setEditable(false);
        jTextField_SelectedAll.setHorizontalAlignment(SwingConstants.CENTER);
        jTextField_SelectedAll.setBounds(new Rectangle(164, 142, 58, 23));
        jLabel_SelectedAll.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
        jLabel_SelectedAll.setText("本学期已选课程共计:");
        jLabel_SelectedAll.setBounds(new Rectangle(3, 137, 173, 33));
        jButton_SelectedAllLookMore.setBounds(new Rectangle(44, 105, 155, 28));
        jButton_SelectedAllLookMore.setFont(new java.awt.Font("楷体_GB2312",
                Font.BOLD, 15));
        jButton_SelectedAllLookMore.setText("查看选定课程");
        jButton_SelectedAllLookMore.setEnabled(false);
        jButton_SelectedAllLookMore.addActionListener(new
                InputSelectedLessonInfo_jButton_SelectedAllLookMore_actionAdapter(this));
        jButton_DeleteSelected.setBounds(new Rectangle(218, 105, 155, 28));
        jButton_DeleteSelected.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD,
                15));
        jButton_DeleteSelected.setText("删除选定课程");
        jButton_DeleteSelected.addActionListener(new
                                                 InputSelectedLessonInfo_jButton_DeleteSelected_actionAdapter(this));
        jButton_DeleteSelected.setEnabled(false);
        jLabel1.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
        jLabel1.setText("其它课程课程号录入:");
        jLabel1.setBounds(new Rectangle(3, 248, 173, 33));
        jTextField_CanBeSelected.setHorizontalAlignment(SwingConstants.CENTER);
        jTextField_CanBeSelected.setBounds(new Rectangle(158, 252, 80, 23));
        jTextField_CanBeSelected.addMouseListener(new
                                                  InputSelectedLessonInfo_jTextField_CanBeSelected_mouseAdapter(this));
        jTextField_CanBeSelected.addActionListener(new
                InputSelectedLessonInfo_jTextField_CanBeSelected_actionAdapter(this));
        jTextField_CanBeSelected.setEnabled(false);
        jButton_InputSelected.setBounds(new Rectangle(218, 213, 155, 28));
        jButton_InputSelected.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD,
                15));
        jButton_InputSelected.setText("录入选定课程");
        jButton_InputSelected.setEnabled(false);
        jButton_InputSelected.addActionListener(new
                                                InputSelectedLessonInfo_jButton_InputSelected_actionAdapter(this));
        jComboBox_ScoreHad.setBounds(new Rectangle(269, 289, 113, 28));
        jComboBox_ScoreHad.addActionListener(new
                                             InputSelectedLessonInfo_jComboBox_ScoreHad_actionAdapter(this));
        jComboBox_ScoreHad.setEnabled(false);
        jLabel_ScoreHad.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
        jLabel_ScoreHad.setText("该生已修学分:");
        jLabel_ScoreHad.setBounds(new Rectangle(3, 286, 106, 30));
        jComboBox_ScoreHad.addItem("必修课:" + "0" + "分");
        jComboBox_ScoreHad.addItem("限选课:" + "0" + "分");
        jComboBox_ScoreHad.addItem("任选课:" + "0" + "分");
        jLabel_NumberInMen.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
        jLabel_NumberInMen.setText("门");
        jLabel_NumberInMen.setBounds(new Rectangle(229, 141, 24, 22));
        jLabel_NumberInScore.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
        jLabel_NumberInScore.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel_NumberInScore.setText("学分");
        jLabel_NumberInScore.setBounds(new Rectangle(330, 141, 45, 22));
        jTextField_Score.setEditable(false);
        jTextField_Score.setHorizontalAlignment(SwingConstants.CENTER);
        jTextField_Score.setBounds(new Rectangle(252, 141, 73, 23));
        jButton_More.setBounds(new Rectangle(248, 249, 68, 28));
        jButton_More.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
        jButton_More.setText("详情");
        jButton_More.addActionListener(new
                                       InputSelectedLessonInfo_jButton_More_actionAdapter(this));
        jButton_More.setEnabled(false);
        jButton_InputOther.setBounds(new Rectangle(326, 249, 68, 28));
        jButton_InputOther.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
        jButton_InputOther.setText("录入");
        jButton_InputOther.addActionListener(new
                                             InputSelectedLessonInfo_jButton_InputOther_actionAdapter(this));
        jButton_InputOther.setEnabled(false);
        jTextField_ScoreHad.setEditable(false);
        jTextField_ScoreHad.setHorizontalAlignment(SwingConstants.CENTER);
        jTextField_ScoreHad.setBounds(new Rectangle(113, 289, 73, 23));
        jLabel_Total.setFont(new java.awt.Font("华文新魏", Font.BOLD, 15));
        jLabel_Total.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel_Total.setText("学分");
        jLabel_Total.setBounds(new Rectangle(203, 290, 45, 22));
        this.getContentPane().add(jLabel_SN);
        this.getContentPane().add(jTextField_SN);
        this.getContentPane().add(jComboBox_HaveSelected);
        this.getContentPane().add(jTextField_Status);
        this.getContentPane().add(jLabel_Prompt);
        this.getContentPane().add(jLabel_Name);
        this.getContentPane().add(jTextField_Name);
        this.getContentPane().add(jLabel_Status);
        this.getContentPane().add(jButton_SelectedAllLookMore);
        this.getContentPane().add(jButton_DeleteSelected);
        this.getContentPane().add(jTextField_SelectedAll);
        this.getContentPane().add(jTextField_Score);
        this.getContentPane().add(jLabel_NumberInScore);
        this.getContentPane().add(jLabel_NumberInMen);
        this.getContentPane().add(jComboBox_CanBeSelected);
        this.getContentPane().add(jButton_InputSelected);
        this.getContentPane().add(jButton_LookMore);
        this.getContentPane().add(jTextField_CanBeSelected);
        this.getContentPane().add(jButton_GoOn);
        this.getContentPane().add(jButton_InputOther);
        this.getContentPane().add(jButton_More);
        this.getContentPane().add(jButton_Cancel);
        this.getContentPane().add(jLabel_ScoreHad);
        this.getContentPane().add(jLabel_HasSelect);
        this.getContentPane().add(jLabel_SelectedAll);
        this.getContentPane().add(jLabel_LessonPrompt);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jTextField_ScoreHad);
        this.getContentPane().add(jLabel_Total);
        this.getContentPane().add(jComboBox_ScoreHad);
        for (int i = 0; i < haveSelectedScore.length; i++) { //初始化四个数组
            haveSelected[i] = haveSelectedNature[i] = null;
            haveSelectedResult[i] = haveSelectedScore[i] = "0";
        }
    }

    public void inputOther() { //通过课程号录入课程的方法
        String tempNumber = jTextField_CanBeSelected.getText().trim();
        try { //从数据库中得到与课程名称相匹配的学分信息
            String temp1, temp2, temp3, temp4; //分别暂时保存课程号，课程名称,学分,课程性质
            Statement stmt;
            ResultSet rs;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:db_STU",
                    "",
                    "");
            stmt = con.createStatement();
            rs = stmt.executeQuery("select * from LessonInfo");
            while (rs.next()) {