gengxinchengji.java

学生成绩管理系统可以查询修改成绩 修改密码 删除填加成绩

package don;

import java.awt.CheckboxGroup;
import java.awt.HeadlessException;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.ButtonGroup;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JRadioButton;
import javax.swing.JTextField;


public class gengxinchengji extends JFrame
{
	static ImageIcon icon=new ImageIcon("FOX.jpg");
	JLabel tupian;
	JLabel xuanze;
	JLabel xiugai;
	JLabel shanchu;
	JLabel tianjia;
	JRadioButton tianjia0;
	JRadioButton xiugai0;
	JRadioButton shanchu0;
	ButtonGroup xuanze0;
	JButton tuichu;
	JLabel xuehao;
	JTextField xuehao0;
	JLabel yuwen;
	JLabel shuxue;
	JLabel yingyu;
	JTextField yuwen0;
	JTextField shuxue0;
	JTextField yingyu0;
	JButton tijiao;
	JButton guanbi;
	JLabel kemu;
	JComboBox kemu1;
	JLabel xueqi;
	JComboBox xueqi1;
	
	
	
	
	gengxinchengji()
	{
	super("更新成绩");
	xuanze=new JLabel("选择您要执行的操作:");
	tupian=new JLabel();
	ImageIcon ligong=new ImageIcon("ligong.jpg");
	tupian=new JLabel(ligong);
	tianjia=new JLabel("添加成绩");
	xiugai=new JLabel("修改成绩");
	shanchu=new JLabel("删除成绩");
	tianjia0=new JRadioButton();//添加的按钮
	xiugai0=new JRadioButton();//修改的按按钮
	shanchu0=new JRadioButton();
	xuanze0=new ButtonGroup();
	xuehao=new JLabel("输入学号:");
	xuehao0=new JTextField(10);
	yuwen=new JLabel("语文成绩:");
	shuxue=new JLabel("数学成绩:");
	yingyu=new JLabel("英语成绩:");
	yuwen0=new JTextField(10);
	shuxue0=new JTextField(10);
	yingyu0=new JTextField(10);
	tijiao=new JButton("提交");
	guanbi=new JButton("退出");
    kemu=new JLabel("科目:");
    kemu1=new JComboBox();
    kemu1.addItem("语文");
    kemu1.addItem("数学");
    kemu1.addItem("英语");
    xueqi=new JLabel("学期");
    xueqi1=new JComboBox();
    xueqi1.addItem("第一学期");
    xueqi1.addItem("第二学期");
    
    setBounds(200,120,650,480);//设置窗口显示的坐标及位置
	setIconImage(icon.getImage());//设置图标
	add(tupian);
	add(xuanze);
	xuanze0.add(tianjia0);
	xuanze0.add(xiugai0);
	xuanze0.add(shanchu0);
	add(tianjia0);
	add(xiugai0);
	add(shanchu0);
	
	add(tianjia);
	add(xiugai);
	add(shanchu);
	add(xuehao);
	add(xuehao0);
	add(yuwen);
	
	add(yuwen0);
	add(shuxue);
	add(shuxue0);
	add(yingyu);
	add(yingyu0);
	add(tijiao);
	add(guanbi);
	add(kemu);
	add(kemu1);
    add(xueqi);
	add(xueqi1);
	tianjia0.setSelected(false);
	tupian.setBounds(0,0,650,130);
    xuanze.setBounds(90,145,160,20);
	tianjia.setBounds(240, 145, 80, 20);
	xiugai.setBounds(340, 145, 80, 20);
	shanchu.setBounds(440, 145, 80, 20);
	tianjia0.setBounds(220,147,16,16);
	xiugai0.setBounds(320,147,16,16);
	shanchu0.setBounds(420,147,16,16);
	xuehao.setBounds(155,190,80,20);
	xuehao0.setBounds(225,190,80,25);
	yuwen.setBounds(155,240,80,20);
	yuwen0.setBounds(225,240,80,25);
	shuxue.setBounds(155,290,80,20);
	shuxue0.setBounds(225,290,80,25);
	yingyu.setBounds(155,340,80,20);
	yingyu0.setBounds(225,340,80,25);
	tijiao.setBounds(350,335,65,30);
	kemu.setBounds(335,190,80,20);
	kemu1.setBounds(375,190,80,20);
	xueqi.setBounds(335, 240, 80, 20);
	xueqi1.setBounds(375, 240, 80, 20);
	
	guanbi.setBounds(430,335,65,30);
	
	tianjia0.addActionListener(new MyListener());
	xiugai0.addActionListener(new MyListener());
	shanchu0.addActionListener(new MyListener());
	tijiao.addActionListener(new ActionListener()
	{
		public void actionPerformed(ActionEvent e)
		{
				String tt;
				DBSource db=new DBSource();
    			if(tianjia0.isSelected())
    			{
    				
    				 if(xueqi1.getSelectedItem().equals("第一学期"))
    				{
    					tt="term1";
    				}
    				else 
    				{
    					tt="term2";
    				}
    				String s1="select * from geren where sno='" + xuehao0.getText() + "'";
    				ResultSet rs1=db.executeQuery(s1);//有关此学号的纪录已经存在！
    				//System.out.println("ljlj");
    					try
    					{
    						if(rs1.next())
	    					{
    							if(tt=="term1")
    							{
    							//System.out.println("ljlj");
    							//DBsource db1=new DBsource();
    							String ss2="update  term1  set schinese='"+yuwen0.getText().trim() + "',senglish='"+yingyu0.getText().trim()+"',smath='"+shuxue0.getText().trim()+"'where sno='" + xuehao0.getText().trim() + "'" ;
	    						System.out.println(ss2);
	    						boolean ba=db.execute(ss2);
	    						if(ba)
	    						{
	    							JOptionPane.showMessageDialog(null,"添加成绩成功！！！");
	    						}
    	    					}
    							else
    							{
    								DBSource db2=new DBSource();
    							String ss2="update  term2   set schinese='"+yuwen0.getText().trim() + "',senglish='"+yingyu0.getText().trim()+"',smath='"+shuxue0.getText().trim()+"'where sno='" + xuehao0.getText().trim() + "'" ;
	    						System.out.println(ss2);
	    						boolean ba=db2.execute(ss2);
	    						if(ba)
	    						{
	    							JOptionPane.showMessageDialog(null,"添加成绩成功！！！");
	    						}
    							}
	    					}
    						else
    						{
    							JOptionPane.showMessageDialog(null,"此学号不存在！！！");
    						}
    					}
    							catch (HeadlessException e1)
    							{
    									e1.printStackTrace();
    							} 
    							catch (SQLException e1) 
    							{
    								e1.printStackTrace();
    							}
    				}
    			if(xiugai0.isSelected())
    			{
    				
    				 if(xueqi1.getSelectedItem().equals("第一学期"))
    				{
    					tt="term1";
    				}
    				else 
    				{
    					tt="term2";
    				}
    				String ss3="select * from geren where sno='" + xuehao0.getText() + "'";
    				ResultSet rs2=db.executeQuery(ss3);//有关此学号的纪录已经存在！
    				//System.out.println("ljlj");
    					try
    					{
    						if(rs2.next())
	    					{
    							if(tt=="term1")
    							{
    								if(kemu1.getSelectedItem().equals("语文"))
    								{
    								
    	    							String ss5="update  term1   set schinese='"+yuwen0.getText().trim() + "' where sno='" + xuehao0.getText().trim() + "'" ;
    		    						System.out.println(ss5);
    		    						boolean ba=db.execute(ss5);
    		    						if(ba)
    		    						{
    		    							JOptionPane.showMessageDialog(null,"修改语文成绩成功！！！");
    		    						}
    								}
    								else if(kemu1.getSelectedItem().equals("数学"))
    								{
    									
    	    							String ss6="update  term1   set smath='"+shuxue0.getText().trim() + "' where sno='" + xuehao0.getText().trim() + "'" ;
    		    						System.out.println(ss6);
    		    						boolean ba=db.execute(ss6);
    		    						if(ba)
    		    						{
    		    							JOptionPane.showMessageDialog(null,"修改数学成绩成功！！！");
    		    						}
    								}
    								else if(kemu1.getSelectedItem().equals("英语"))
    								{
    									
    	    							String ss7="update  term1   set senglish='"+yingyu0.getText().trim() + "' where sno='" + xuehao0.getText().trim() + "'" ;
    		    						System.out.println(ss7);
    		    						boolean ba=db.execute(ss7);
    		    						if(ba)
    		    						{
    		    							JOptionPane.showMessageDialog(null,"修改英语成绩成功！！！");
    		    						}
    								}
    							}
    							if(tt=="term2")
    							{
    								if(kemu1.getSelectedItem().equals("语文"))
    								{
    									String ss8="update  term2   set schinese='"+yuwen0.getText().trim() + "' where sno='" + xuehao0.getText().trim() + "'" ;
    		    						System.out.println(ss8);
    		    						boolean ba=db.execute(ss8);
    		    						if(ba)
    		    						{
    		    							JOptionPane.showMessageDialog(null,"修改语文成绩成功！！！");
    		    						}
    								}
    								else if(kemu1.getSelectedItem().equals("数学"))
    								{
    									DBSource db7=new DBSource();
    	    							String ty="update  term2   set smath='"+shuxue0.getText().trim() + "' where sno='" + xuehao0.getText().trim() + "'" ;
    		    						System.out.println(ty);
    		    						boolean ba=db7.execute(ty);
    		    						if(ba)
    		    						{
    		    							JOptionPane.showMessageDialog(null,"修改数学成绩成功！！！");
    		    						}
    								}
    								else if(kemu1.getSelectedItem().equals("英语"))
    								{
    									
    	    							String ss9="update  term2   set senglish='"+yingyu0.getText().trim() + "' where sno='" + xuehao0.getText().trim() + "'" ;
    		    						System.out.println(ss9);
    		    						boolean ba=db.execute(ss9);
    		    						if(ba)
    		    						{
    		    							JOptionPane.showMessageDialog(null,"修改英语成绩成功！！！");
    		    						}
    								}
    							}
	    					}
    						else
    						{
    							JOptionPane.showMessageDialog(null,"此学号不存在！！！");
    						}
    					}
    					
    					
    							catch (HeadlessException e1)
    							{
    									e1.printStackTrace();
    							} 
    							catch (SQLException e1) 
    							{
    								e1.printStackTrace();
    							}
    				}
    			
    			if(shanchu0.isSelected())
    			{
    			
    				 if(xueqi1.getSelectedItem().equals("第一学期"))
    				{
    					tt="term1";
    				}
    				else 
    				{
    					tt="term2";
    				}
    				String ss10="select * from geren where sno='" + xuehao0.getText() + "'";
    				ResultSet rs3=db.executeQuery(ss10);//有关此学号的纪录已经存在！
    				//System.out.println("ljlj");
    					try
    					{
    						if(rs3.next())
	    					{
    							if(tt=="term1")
    							{
    								if(kemu1.getSelectedItem().equals("语文"))
    								{
    									
    	    							String ss11="update  term1   set schinese='"+null+"' where sno='" + xuehao0.getText().trim() + "'" ;
    		    						System.out.println(ss11);
    		    						boolean ba=db.execute(ss11);
    		    						if(ba)
    		    						{
    		    							JOptionPane.showMessageDialog(null,"删除语文成绩成功！！！");
    		    						}
    								}
    								
    								else if(kemu1.getSelectedItem().equals("数学"))
    								{
    								
    	    							String ss12="update  term1   set smath='"+null+"' where sno='" + xuehao0.getText().trim() + "'" ;
    		    						System.out.println(ss12);
    		    						boolean ba=db.execute(ss12);
    		    						if(ba)
    		    						{
    		    							JOptionPane.showMessageDialog(null,"删除数学成绩成功！！！");
    		    						}
    								}
    								else if(kemu1.getSelectedItem().equals("英语"))
    								{
    									
    	    							String ss13="update  term1   set senglish='"+null+ "' where sno='" + xuehao0.getText().trim() + "'" ;
    		    						System.out.println(ss13);
    		    						boolean ba=db.execute(ss13);
    		    						if(ba)
    		    						{
    		    							JOptionPane.showMessageDialog(null,"删除英语成绩成功！！！");
    		    						}
    								}
    							}
    							else
    							{
    								if(kemu1.getSelectedItem().equals("语文"))
    								{
    									
    	    							String ss14="update  term2   set schinese='"+null+ "' where sno='" + xuehao0.getText().trim() + "'" ;
    		    						System.out.println(ss14);
    		    						boolean ba=db.execute(ss14);
    		    						if(ba)
    		    						{
    		    							JOptionPane.showMessageDialog(null,"删除语文成绩成功！！！");
    		    						}
    								}
    								else if(kemu1.getSelectedItem().equals("数学"))
    								{
    									
    	    							String ss15="update  term2   set smath='"+null+ "' where sno='" + xuehao0.getText().trim() + "'" ;
    		    						System.out.println(ss15);
    		    						boolean ba=db.execute(ss15);
    		    						if(ba)
    		    						{
    		    							JOptionPane.showMessageDialog(null,"删除数学成绩成功！！！");
    		    						}
    								}
    								else if(kemu1.getSelectedItem().equals("英语"))
    								{
    									
    	    							String ss16="update  term2   set senglish='"+null+ "' where sno='" + xuehao0.getText().trim() + "'" ;
    		    						System.out.println(ss16);
    		    						boolean ba=db.execute(ss16);
    		    						if(ba)
    		    						{
    		    							JOptionPane.showMessageDialog(null,"删除英语成绩成功！！！");
    		    						}
    								}
    							}
	    					}
    						else
    						{
    							JOptionPane.showMessageDialog(null,"此学号不存在！！！");
    						}
    					}
    					
    					
    							catch (HeadlessException e1)
    							{
    									e1.printStackTrace();
    							} 
    							catch (SQLException e1) 
    							{
    								e1.printStackTrace();
    							}
    				}
    			
		}						
	});
	guanbi.addActionListener//关闭按钮的监听
	(
			new ActionListener()
		    {
		    		public void actionPerformed(ActionEvent evt)
		    		{
		    			System.exit(0);
		    		}
		    }
	);
	setResizable(false);//设置窗口的尺寸不可改变
	setLayout(null);
    setState(JFrame.NORMAL);//设置窗口为标准状态，也可fra.setState(Frame.NORMAL);
	setVisible(true);//继承Window类的方法，在屏幕上显示窗口也可用fra.setVisible(true);
	addWindowListener(new WindowAdapter()
	{
		public void windowClosing(WindowEvent e)
		{
    		System.exit(0);
		}

	});
	}
	class MyListener  implements ActionListener//设置事件处理；
	{

			public void actionPerformed(ActionEvent e)
			{
	
				    
				if(e.getSource()==tianjia0)
				{
					xuehao0.setEditable(true);
			    	yuwen0.setEditable(true);
			    	shuxue0.setEditable(true);
			    	yingyu0.setEditable(true);
			    	kemu1.setEnabled(false);
			    }
				else if(e.getSource()==xiugai0)
				{ 
					xuehao0.setEditable(true);
			    	yuwen0.setEditable(true);
			    	shuxue0.setEditable(true);
			    	yingyu0.setEditable(true);
			    	kemu1.setEnabled(true);
				}
				else if(e.getSource()==shanchu0)
				{
				    	xuehao0.setEditable(true);
				    	yuwen0.setEditable(false);
				    	shuxue0.setEditable(false);
				    	yingyu0.setEditable(false);
				    	kemu1.setEnabled(true);
				}

	}		
}
		
	public static void main(String[] args) 

	{ 
		new gengxinchengji();
	}
}