stugradedelete.java

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

import javax.swing.*;

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

public class StuGradeDelete extends JFrame implements ActionListener {
	    DataBaseManager db = new DataBaseManager();
	     JButton jButton2;
	     JLabel jLabel2;
	     JTextField jTextField2;
	     JLabel jLabel1;
	     JToolBar jToolBar1;
	     JTextField jTextField1;
	     JLabel jLabel3;
	     JButton jButton3;
	     JButton jButton1;
	     ResultSet rs;
        public StuGradeDelete(){
            this.setTitle("删除成绩");
            this.setLayout(null);
            this.setBounds(431, 223, 365, 190);
            this.setResizable(false);
            this.setVisible(true);
            {
            	jButton1 = new JButton();
                jButton1.addActionListener(this);
            	getContentPane().add(jButton1);
            	jButton1.setText("删除");
            	jButton1.setBounds(46, 117, 66, 22);
            }
            {
            	jButton2 = new JButton();
            	jButton2.addActionListener(this);
            	getContentPane().add(jButton2);
            	jButton2.setText("查看");
            	jButton2.setBounds(137, 117, 64, 22);
            }
            {
            	jButton3 = new JButton();
                jButton3.addActionListener(this);
            	getContentPane().add(jButton3);
            	jButton3.setText("取消");
            	jButton3.setBounds(226, 117, 64, 22);
            }
            {
            	jLabel3 = new JLabel();
            	getContentPane().add(jLabel3);
           	    jLabel3 .setForeground(Color.RED);
            	jLabel3.setText("按学号和课程编号进行删除!");
            	jLabel3.setBounds(27, 6, 139, 24);
            }
            {
            	jTextField1 = new JTextField();
            	getContentPane().add(jTextField1);
            	jTextField1.setText("");
            	jTextField1.setBounds(115, 73, 129, 23);
            }
            {
            	jToolBar1 = new JToolBar();
            	getContentPane().add(jToolBar1);
            	jToolBar1.setBounds(2, 0, 355, 28);
            }
            {
            	jLabel1 = new JLabel();
            	getContentPane().add(jLabel1);
            	jLabel1.setText("学号:");
            	jLabel1.setBounds(40, 41, 41, 15);
            }
            {
            	jTextField2 = new JTextField();
            	getContentPane().add(jTextField2);
            	jTextField2.setText("");
            	jTextField2.setBounds(115, 36, 130, 25);
            }
            {
            	jLabel2 = new JLabel();
            	getContentPane().add(jLabel2);
            	jLabel2.setText("课程编号:");
            	jLabel2.setBounds(33, 77, 59, 15);
            }
        }
  public void actionPerformed(ActionEvent e){     
	     if(e.getSource()==jButton3){
	    	 this.dispose();
	       }
	     else if(e.getSource()==jButton2){
	    	    StuGradeList CourseListFrame=new StuGradeList();
				Dimension FrameSize=CourseListFrame.getPreferredSize();
				Dimension MainFrameSize=getSize();
				Point loc=getLocation();
				CourseListFrame.setLocation((MainFrameSize.width-FrameSize.width)/2+loc.x,
				(MainFrameSize.height-FrameSize.height)/2+loc.y);
				CourseListFrame.pack();
				CourseListFrame.show();
	         }
	     else if(e.getSource()==jButton1){
	    		try
	    		{
       			String strSQL="select * from cj where 学号='"+
       		     jTextField2.getText().trim()+"' and 课程编号='"+ jTextField1.getText().trim()+"'";
	    	 if (jTextField2.getText().trim().equals("")) {
					JOptionPane.showMessageDialog(null, "学号不能为空!");
		          }
			 else if(jTextField1.getText().trim().equals("")){
				 JOptionPane.showMessageDialog(null, "课程编号不能为空!");
				 }
				else if(db.getResult(strSQL).first())
   				{    
   					strSQL="delete from cj where 学号='"+
   					jTextField2.getText().trim()+"' and  课程编号='"+jTextField1.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 StuGradeDelete();
   			      		      this.dispose();
   			         }
   			         else{
   			    	      this.dispose();
   					      db.closeConnection();
   				}
   					}
   				else
   				{
   					JOptionPane.showMessageDialog(null,"不存在此学号或者课程编号错误！");
   			}
   		}
	 }
   	catch(SQLException sqle)
   	{
   		System.out.println(sqle.toString());
   	}
   	catch(Exception ex)
   	{
   		System.out.println(ex.toString());
   	 }
   	}
  }
}