anewgradeinput.java

学生成绩管理系统,可以修改

import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
import java.awt.*;
import java.awt.event.*;
import java.sql.ResultSet;
import java.sql.SQLException;

public class AnewGradeInput extends JFrame implements ActionListener{
	DataBaseManager db = new DataBaseManager();
	ResultSet rs;
	 JList jList1;
     JLabel jLabel4;
     JComboBox jComboBox3;
     JLabel jLabel2;
     JComboBox jComboBox2;
     JComboBox jComboBox1;
	 JTextField jTextField5;
     JLabel jLabel3;
	 JButton jButton2;
	 JButton jButton1;
	 JLabel jLabel5;
	 JTextField jTextField1;
     JLabel jLabel1;
                           public AnewGradeInput (){
                        	    this.setBounds(431, 223,  387, 267);
                        	    this.setVisible(true);
                        	    this.setLayout(null);
                        	    this.setTitle("录入重修成绩");
                        	    this.setResizable(false);
                        	    {
                        	    	jLabel1 = new JLabel();
                        	    	getContentPane().add(jLabel1);
                        	    	jLabel1.setText("学号:");
                        	    	jLabel1.setBounds(41, 30, 50, 21);
                        	    }
                        	    {
                        	    	jTextField1 = new JTextField();
                        	    	getContentPane().add(jTextField1);
                        	    	jTextField1.setText("");
                        	    	jTextField1.setBounds(119, 27, 136, 27);
                        	    }
                        	    {
                        	    	jLabel4 = new JLabel();
                        	    	getContentPane().add(jLabel4);
                        	    	jLabel4.setText("科目名称:");
                        	    	jLabel4.setBounds(35, 150, 71, 23);
                        	    }
                        	    {
                        	    	jLabel5 = new JLabel();
                        	    	getContentPane().add(jLabel5);
                        	    	jLabel5.setText("成绩:");
                        	    	jLabel5.setBounds(36, 196, 48, 21);
                        	    }
                        	    {
                        	    	jTextField5 = new JTextField();
                        	    	getContentPane().add(jTextField5);
                        	    	jTextField5.setText("" );
                        	    	jTextField5.setBounds(119, 194, 136, 25);
                        	    }
                        	    {
                        	    	jButton1 = new JButton();
                        	    	jButton1.addActionListener(this);
                        	    	getContentPane().add(jButton1);
                        	    	jButton1.setText("录入");
                        	    	jButton1.setBounds(286, 28, 71, 25);
                        	    }
                        	    {
                        	    	jButton2 = new JButton();
                        	    	jButton2.addActionListener(this);
                        	    	getContentPane().add(jButton2);
                        	    	jButton2.setText("关闭");
                        	    	jButton2.setBounds(286, 79, 71, 27);
                        	    }
                        	    {
                        	    	jLabel3 = new JLabel();
                        	    	getContentPane().add(jLabel3);
                        	    	jLabel3.setText("课程编号:");
                        	    	jLabel3.setBounds(35, 79, 56, 19);
                        	    }
                        	    {
                        	    	ComboBoxModel jComboBox1Model = 
                        	    		new DefaultComboBoxModel(
                        	    				new String[] {  "java程序设计", "日语" ,"操作系统","专业英语","体育","数据库" });
                        	    	jComboBox1 = new JComboBox();
                        	    	getContentPane().add(jComboBox1);
                        	    	jComboBox1.setModel(jComboBox1Model);
                        	    	jComboBox1.setBounds(119, 147, 136, 29);
                        	    }
                        	    {
                        	    	ComboBoxModel jComboBox2Model = 
                        	    		new DefaultComboBoxModel(
                        	    				new String[] { "1", "2" ,"3","4","5","6"});
                        	    	jComboBox2 = new JComboBox();
                        	    	getContentPane().add(jComboBox2);
                        	    	jComboBox2.setModel(jComboBox2Model);
                        	    	jComboBox2.setBounds(119, 66, 136, 26);
                        	    }
                        	    {
                        	    	jLabel2 = new JLabel();
                        	    	getContentPane().add(jLabel2);
                        	    	jLabel2.setText("学期名称:");
                        	    	jLabel2.setBounds(35, 117, 56, 15);
                        	    }
                        	    {
                        	    	ComboBoxModel jComboBox3Model = 
                        	    		new DefaultComboBoxModel(
                        	    				new String[] { "2008-2009上学期", "2008-2009下学期" });
                        	    	jComboBox3 = new JComboBox();
                        	    	getContentPane().add(jComboBox3);
                        	    	jComboBox3.setModel(jComboBox3Model);
                        	    	jComboBox3.setBounds(119, 104, 136, 28);
                        	    }

                           }
   public void actionPerformed(ActionEvent e){
	    if(e.getSource()==jButton2){
 	        this.dispose();
	        }

  		else if(e.getSource()==jButton1)
  		{
  			try
  			{
  				String strSQL="select * from cj where 学号='"+
  				jTextField1.getText().trim()+"'";
  				if(jTextField1.getText().trim().equals(""))
  				{
  					JOptionPane.showMessageDialog(null,"学号不能为空！");
  				}
  				else if(jTextField5.getText().trim().equals(""))
  				{
  					JOptionPane.showMessageDialog(null,"成绩不能为空！");
  				}
  				else
  				{
  				    if(db.getResult(strSQL).absolute(10));
  				         	strSQL="insert into cj (学号,课程编号,学期名称,科目名称,成绩) values ('"+jTextField1.getText().trim()+"','" +jComboBox2.getSelectedItem()+"','" +jComboBox3.getSelectedItem()+"','" +jComboBox1.getSelectedItem()+"','"+jTextField5.getText().trim()+"')";
  				         	if(db.updateSql(strSQL))
  				         	{
  				         	 int result=JOptionPane.showOptionDialog(null, "此学号的重修成绩录入完毕是否要继续输入其他学生的成绩?", "系统提示", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE, null, new String[] {"是","否"}, "否");
					         if(result==JOptionPane.YES_OPTION){
					                 new AnewGradeInput();
					                 this.dispose();
					         }
					         else{
					        	    db.closeConnection();
					    	        this.dispose();
					          }
  				         	}
  				         	else {
  	  				    	JOptionPane.showMessageDialog(null,"此学号的重修成绩录入已经存在，请重新录入其他学生的重修成绩！");
  	  				        this.dispose();
  	  				        }
  				         }
  				}
  			catch(SQLException sqle)
  			{
  				System.out.println(sqle.toString());
  			}
  			catch(Exception ex)
  			{
  				System.out.println(ex.toString());
  			}
  		}
  	}    
 }