chengjicaxun.java

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

package don;

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;

import javax.swing.ButtonGroup;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JTable;

import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;


//数据库引入
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Chengjicaxun  extends JFrame  implements ActionListener
{
	
	JLabel l0,l1,l2,l4;
	JButton b1,b2;
	ButtonGroup bg;
	JRadioButton jrb1,jrb2,jrb4;//jrb3;//;
	JPanel jp1;			//创建面板
	JLabel l5,l6,l7,l8,l10; //输入和选择框提示
	JTextField t1,t2;
	JComboBox jcb,jcb1;
	JLabel l9; //显示图片
	JTable jt;
	Font f1;
	DefaultTableModel md;
	

	Chengjicaxun()
	{
		super("学生信息管理系统");	
		f1=new Font("SansSerif",Font.PLAIN,20);//设置字体大小式样
		l0=new JLabel("－－－－－－－－－－－－学生成绩查询－－－－－－－－－－－－－");
		l0.setFont(f1);
		l0.setForeground(Color.CYAN);
		
		b1=new JButton("确定");
		b2=new JButton("退出");
		bg=new ButtonGroup();
		jrb1=new JRadioButton();
		jrb2=new JRadioButton();
		//jrb3=new JRadioButton();
		jrb4=new JRadioButton();
		l1=new JLabel("按学号查询");
		l2=new JLabel("按姓名查询");
		//l3=new JLabel("按专业查询");
		l4=new JLabel("按课程查询");
		l5=new JLabel("请输入学号");
		l6=new JLabel("请输入姓名");
		l7=new JLabel("请选择学期");
		l8=new JLabel("查询成绩显示");
		l10=new JLabel("请选择课程");
		t1=new JTextField("",10);
		t2=new JTextField("",10);
		
		md = new DefaultTableModel();
		String[] columnName={"学号","姓名","数学","英语","语文"};
		
		jp1=new JPanel();
		//jp1.setBackground(Color.blue);//测试时加的颜色
		jt=new JTable(md);//显示窗体
		//jt.setBackground(Color.white);//测试时加的颜色
		JScrollPane jsp=new JScrollPane(jt,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
		
		
		
		
 		Dimension dim=new Dimension(300,350);
		jt.setPreferredScrollableViewportSize(dim);
		for(int i=0;i<columnName.length;i++)
		{
			md.addColumn(columnName[i]);
		}
		jp1.add(jsp);	
		
//		JScrollPane jsp=new JScrollPane(jt,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
		

		
		
		ImageIcon ii=new ImageIcon("ligong.jpg");
		l9=new JLabel(ii);
		
		jcb=new JComboBox();
		jcb.addItem("第一学期");
		jcb.addItem("第二学期");
		jcb.setBackground(Color.white);
		jcb.setSelectedIndex(0);
 		
		
		jcb1=new JComboBox();
		jcb1.addItem("数学");
		jcb1.addItem("英语");
		jcb1.addItem("语文");
		jcb1.setBackground(Color.white);
		jcb1.setSelectedIndex(0);
		
		
		setBounds(100,100,650,600);
		setLayout(null);
		setResizable(false);//设置窗体大小是否可变
		
		
		jrb1.setSelected(false);//单选按钮初始化为未被选中
		
		
		
		add(l0);
		bg.add(jrb1);
		bg.add(jrb2);
		bg.add(jrb4);
		add(jrb1);
		add(jrb2);
		add(jrb4);
		add(jcb);
		add(jcb1);
		add(b1);
		add(b2);
		add(l1);
		add(l2);
		add(l4);
		add(l5);
		add(l6);
		add(l7);
		add(t1);
		add(t2);
		add(l8);
		add(l9);
		add(l10);
		add(jp1);
		
		
		
	
		l0.setBounds(0,60,700,25);		
		jrb1.setBounds(40,170,16,16);
		l1.setBounds(58,170,80,20);
		jrb2.setBounds(40,240,16,16);
		l2.setBounds(58,240,80,20);
		jrb4.setBounds(40,310,16,16);
		l4.setBounds(58,310,80,20);
		b1.setBounds(40,420,60,30);
		b2.setBounds(110,420,60,30);
		l5.setBounds(40,200,70, 25);
		t1.setBounds(112,200,70, 25);
		l6.setBounds(40,270,70, 25);
		t2.setBounds(112,270,70, 25);
		l7.setBounds(58,100,80,20);
		jcb.setBounds(58,130,80,25);
		l10.setBounds(40,340,70,25);
		jcb1.setBounds(112,340,80,25);
		l8.setBounds(240,100,120,25);
		l9.setBounds(0,0,650,60);
		jp1.setBounds(240,135,320,380);
		
	
		jrb1.addActionListener(this);
		jrb2.addActionListener(this);
		jrb4.addActionListener(this);
		
		b1.addActionListener(new button1());		
		b2.addActionListener
		(
				new ActionListener()
				{
					public void actionPerformed(ActionEvent e)
					{
						setVisible(false);
					}
				}
		);
		
//退出并且释放内存		
//		addWindowListener(new WindowAdapter()
//		{
//			public void windowClosing(WindowEvent e)
//			{
//				System.exit(0);
//			}
//	
//		});
//		

	}
	public void actionPerformed(final ActionEvent e)
	{
	
		if(e.getSource()==jrb1)
		{
			t1.setEditable(true);
			t2.setEditable(false);		
			jcb1.setEnabled(false);
		}
		else if(e.getSource()==jrb2)
		{
			t1.setEditable(false);
			t2.setEditable(true);
			jcb1.setEnabled(false);
		}
		
		else if(e.getSource()==jrb4)
		{
			t1.setEditable(false);
			t2.setEditable(false);
			jcb1.setEnabled(true);
		}
	
	}
		
	
	public class button1 implements ActionListener
	{
		String[][] row=null;

		public void actionPerformed(ActionEvent ee)
		{
			final String a;
			final String b;
			final String d;
			a=t1.getText();
			b=t2.getText();
			d=(String)jcb1.getSelectedItem();

			DBSource db=new DBSource();
			String sno=null;
			String sname=null;
			String smath=null;
			String senglish=null;
			String schinese=null;
			int count=md.getRowCount();////////////////////
			   for(int i=0;i<count;i++)
			   {
					md.removeRow(0);
			   }                           ////
			
			if(ee.getSource()==b1)
			{
				if(jrb1.isSelected()||jrb2.isSelected()||jrb4.isSelected())
				{
					if(jrb1.isSelected())
					{
						if((t1==null||t1.getText().equals("")))
						{
							JOptionPane.showMessageDialog(null,"对不起，您没有没有输入学号，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);
								
						}
						else
						{
							if(jcb.getSelectedItem().equals("第一学期"))
							{
								String sql1="select * from term1 where sno='" + a + "'";
								ResultSet rs1=db.executeQuery(sql1);
								try {
										while(rs1.next())
										{
										
											sno=rs1.getString(1);
											sname=rs1.getString(2);
											smath=rs1.getString(3);
											senglish=rs1.getString(4);
											schinese=rs1.getString(5);
											String[] row={sno,sname,smath,senglish,schinese};
											md.addRow(row);
											return;

										}
										if(!rs1.next())
										{
											JOptionPane.showMessageDialog(null,"对不起，您输入的学号没有记录，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);
										}
									} 
									catch (SQLException e) 
									{
										// TODO Auto-generated catch block
										e.printStackTrace();
									}
									
							}
							else if(jcb.getSelectedItem().equals("第二学期"))
							{
								String sql1="select * from term2 where sno='" + a + "'";
								ResultSet rs1=db.executeQuery(sql1);
								try {
										while(rs1.next())
										{
										
											sno=rs1.getString(1);
											sname=rs1.getString(2);
											smath=rs1.getString(3);
											senglish=rs1.getString(4);
											schinese=rs1.getString(5);
											String[] row={sno,sname,smath,senglish,schinese};
											md.addRow(row);
											return;
										}
										if(!rs1.next())
										{
											JOptionPane.showMessageDialog(null,"对不起，您输入的学号没有记录，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);