stugrademodify.java

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

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class StuGradeModify extends JFrame implements ActionListener {
	DataBaseManager db = new DataBaseManager();
	ResultSet rs;
	JPanel panel1, panel2, panel3;
	JLabel TipLabel = new JLabel("输入学号点确定，将调出此学生相关成绩的信息!");
	JLabel StuCourseIDLabel, CourseNuLabel, XuNameLable,CourseNameLabel,
			CourseLabel,DLabel;
	JTextField StuCourseIDTextField, CourseNuTextField,XuNameTextField,
	CourseNameTextField,	CourseTextField,DTextField;
	Container c;
	JButton ClearBtn, YesBtn, UpdateBtn, ExitBtn, CancelBtn;

	public StuGradeModify() {
		super("修改成绩");
		c = getContentPane();
		c.setLayout(new BorderLayout());
		this.setResizable(false);
		panel3 = new JPanel();
		panel3.add(TipLabel);
		c.add(panel3, BorderLayout.NORTH);
		StuCourseIDLabel = new JLabel("学号", JLabel.CENTER);
		CourseNuLabel = new JLabel("课程编号", JLabel.CENTER);
		XuNameLable=new JLabel("学期名称", JLabel.CENTER);
		CourseNameLabel = new JLabel("科目名称", JLabel.CENTER);
		CourseLabel = new JLabel("成绩", JLabel.CENTER);
		DLabel=new JLabel("等级", JLabel.CENTER);
		StuCourseIDTextField = new JTextField(15);
		CourseNuTextField = new JTextField(15);
		XuNameTextField=new JTextField(15);
		CourseNameTextField = new JTextField(15);
		CourseTextField = new JTextField(15);
		DTextField = new JTextField(15);
		panel1 = new JPanel();
		panel1.setLayout(new GridLayout(6, 4));
		panel1.add(StuCourseIDLabel);
		panel1.add(StuCourseIDTextField);
		panel1.add(CourseNuLabel);
		panel1.add(CourseNuTextField);
		panel1.add(XuNameLable);
		panel1.add(XuNameTextField);
		panel1.add(CourseNameLabel);
		panel1.add(CourseNameTextField);
		panel1.add(CourseLabel);
		panel1.add(CourseTextField);
		panel1.add(DLabel);
		panel1.add(DTextField);
		panel2 = new JPanel();
		panel2.setLayout(new GridLayout(1, 5));
		ClearBtn = new JButton("清空");
		YesBtn = new JButton("确定");
		UpdateBtn = new JButton("修改");
		CancelBtn = new JButton("取消");
		ExitBtn = new JButton("退出");
		panel2.add(ClearBtn);
		panel2.add(YesBtn);
		panel2.add(UpdateBtn);
		panel2.add(CancelBtn);
		panel2.add(ExitBtn);
		ClearBtn.addActionListener(this); //事件监听
		YesBtn.addActionListener(this);
		UpdateBtn.addActionListener(this);
		CancelBtn.addActionListener(this);
		ExitBtn.addActionListener(this);
		UpdateBtn.setEnabled(false);
		CancelBtn.setEnabled(false);
		c.add(panel1, BorderLayout.CENTER);
		c.add(panel2, BorderLayout.SOUTH);
	}

	public void actionPerformed(ActionEvent e) {
		if (e.getSource() == ExitBtn) {
			this.dispose();
		} else if (e.getSource() == ClearBtn) {
			StuCourseIDTextField.setText("");
			CourseNuTextField.setText("");
			XuNameTextField.setText("");
			CourseNameTextField.setText("");
			CourseTextField.setText("");
			DTextField.setText("");
		} else if (e.getSource() == CancelBtn) {
			StuCourseIDTextField.setText("");
			CourseNuTextField.setText("");
			XuNameTextField.setText("");
			CourseNameTextField.setText("");
			CourseTextField.setText("");
			DTextField.setText("");
			YesBtn.setEnabled(true);
			UpdateBtn.setEnabled(false);
			CancelBtn.setEnabled(false);
			ClearBtn.setEnabled(true);
			StuCourseIDTextField.setEnabled(true);
		} else if (e.getSource() == YesBtn) {
			try {
				String strSQL = "select * from cj  where  学号 like '%"
						+ StuCourseIDTextField.getText().trim() + "%'";
				if (StuCourseIDTextField.getText().trim().equals("")) {
					JOptionPane.showMessageDialog(null, "请输入学号：");
				} else if (!db.getResult(strSQL).first()) {
					JOptionPane.showMessageDialog(null, "此成绩没有在成绩库中...!");
				} else {
					rs = db.getResult(strSQL);
					rs.first();
					StuCourseIDTextField.setText(rs.getString(1));
					CourseNuTextField.setText(rs.getString(2));
					XuNameTextField.setText(rs.getString(3));
					CourseNameTextField.setText(rs.getString(4));
					CourseTextField.setText(rs.getString(5));
					DTextField.setText(rs.getString(6));
					StuCourseIDTextField.setEnabled(false);
					UpdateBtn.setEnabled(true);
					CancelBtn.setEnabled(true);
					YesBtn.setEnabled(false);
					ClearBtn.setEnabled(false);
				}
			} catch (NullPointerException upe) {
				System.out.println(upe.toString());
			} catch (SQLException sqle) {
				System.out.println(sqle.toString());
			} catch (Exception ex) {
				System.out.println(ex.toString());
			}
		} else if (e.getSource() == UpdateBtn) {
		try {
					String strSQL = "update cj set 课程编号='"+CourseNuTextField.getText().trim()+ "',学期名称='"+XuNameTextField.getText().trim()+ "',科目名称='" +CourseNameTextField.getText().trim()+ "',成绩='"+CourseTextField.getText().trim()+ "',等级='"+DTextField.getText().trim()+ "' where 学号='"+ StuCourseIDTextField.getText().trim() + "'";
					if (db.updateSql(strSQL)) {
						JOptionPane.showMessageDialog(null, "修改成绩信息成功！");
						db.closeConnection();
						this.dispose();
					} else {
						JOptionPane.showMessageDialog(null, "修改成绩信息失败！");
						db.closeConnection();
						this.dispose();
					}
				} catch (Exception ex) {
					JOptionPane.showMessageDialog(null, "修改成绩信息失败！");
				}
		}
	}
}