manage_score.java

可以用的成绩管理系统

import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
import java.sql.PreparedStatement;
import javax.swing.*;
public class Manage_score extends JFrame implements ActionListener
{
	Connection connection;     
	Statement statement;     
	ResultSet resultSet;     
	//ResultSetMetaData rsMetaData; 
	
	GridBagLayout gbl=new GridBagLayout();
    GridBagConstraints gbc=new GridBagConstraints();
	JLabel banhao,xuehao,kehao,fenshu,la1,la2,la3,la4,la5,la6,la7,la8,la9,la0;
	JTextField tf_fenshu;
	Choice choice1,choice2,choice3;
	JButton tianjia,xiugai,shanchu,fanhui;
	public Manage_score()
	{
		super.setTitle("成绩管理！");
		super.setLocation(90,100);
		super.setSize(800,400);
		banhao=new JLabel("班号");
		xuehao=new JLabel("学号");
		kehao=new JLabel("课号");
		fenshu=new JLabel("分数");
		tf_fenshu=new JTextField(5);
		la1=new JLabel("  ");
		la2=new JLabel("  ");
		la3=new JLabel("  ");
		la4=new JLabel("  ");
		la5=new JLabel("  ");
		la6=new JLabel("  ");
		la7=new JLabel("  ");
		la8=new JLabel("  ");
		la9=new JLabel("  ");
		la0=new JLabel("  ");
		choice1=new Choice();
		choice2=new Choice();
		choice3=new Choice();
		tianjia=new JButton("添加");
		tianjia.addActionListener(this);
		xiugai=new JButton("修改");
		xiugai.addActionListener(this);
		shanchu=new JButton("删除");
		shanchu.addActionListener(this);
		fanhui=new JButton("返回");
		fanhui.addActionListener(this);
		
		set(0,0,1,1,banhao);
		set(1,0,1,1,choice1);
		set(2,0,1,1,xuehao);
		set(3,0,1,1,choice2);
		set(4,0,1,1,kehao);
		set(5,0,1,1,choice3);
		set(6,0,1,1,fenshu);
		set(7,0,1,1,tf_fenshu);
		set(0,1,1,1,la0);
		set(1,1,1,1,la1);
		set(2,1,1,1,la3);
		set(3,1,1,1,la4);
		set(4,1,1,1,la5);
		set(5,1,1,1,la6);
		set(6,1,1,1,la7);
		set(7,1,1,1,la8);
		set(3,2,1,1,tianjia);
		set(4,2,1,1,xiugai);
		set(5,2,1,1,shanchu);
		set(6,2,1,1,fanhui);
		setLayout(gbl);
		
		String url="jdbc:odbc:StudentScore";     
	    String username="sa";     
	    String password=""; 
		try 
	    {         
	    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");     
	        connection=DriverManager.getConnection(url,username,password);     
	    }     
	    catch(ClassNotFoundException cnfex)  
	    {  
	    	System.err.println( "装载JDBC/ODBC驱动程序失败。");     
	        //cnfex.printStackTrace();     
	        System.exit(1);    
	    }     
	    catch(SQLException sqlex)  
	    {
	    	System.err.println("无法连接数据库");     
	        //sqlex.printStackTrace();     
	        System.exit(1);
	    } 
	    String query1="select distinct student_class from student";
	    try
		{
			statement =connection.createStatement();     
		    resultSet=statement.executeQuery(query1);
		    while(resultSet.next())
		    {
		    	choice1.add(resultSet.getString(1));
		    }
		}
		catch(SQLException sql)
		{
			//System.out.println(sql.getMessage());
		}
		String classNo=choice1.getSelectedItem();
		String query2="select distinct student_no from student where student_class="+"'"+classNo+"'";
		try
		{
			statement =connection.createStatement(); 
		    resultSet=statement.executeQuery(query2);
		    while(resultSet.next())
		    {
		    	choice2.add(resultSet.getString(1));
		    }
		}  
		catch(SQLException sql)
		{
			//System.out.println(sql.getMessage());
		}
		String query3="select distinct course_no from course";
		try
		{
			statement =connection.createStatement(); 
		    resultSet=statement.executeQuery(query3);
		    while(resultSet.next())
		    {
		    	choice3.add(resultSet.getString(1));
		    }
		}
		catch(SQLException sql)
		{
			//System.out.println(sql.getMessage());
		}
	}
	public void set(int x,int y,int w,int h,Component com)
    {
   	 gbc.anchor=GridBagConstraints.CENTER;
   	 gbc.gridx=x;
   	 gbc.gridy=y;
   	 gbc.gridwidth=w;
   	 gbc.gridheight=h;
   	 gbl.setConstraints(com, gbc);
   	 add(com);
    }
	public void actionPerformed(ActionEvent e)
	{
		Object obj=e.getSource();
		if(obj==tianjia)
		{
			String selectClass=choice1.getSelectedItem().trim();
			String selectStu=choice2.getSelectedItem().trim();
			String selectCr=choice3.getSelectedItem().trim();
			int score=Integer.parseInt(tf_fenshu.getText().trim());
			String query="insert into score(student_no,course_no,score,legal) values("+"'"+selectStu+"'"+","+"'"+selectCr+"'"+","+score+","+"'y'"+")";                          
			try
			{
				JOptionPane.showMessageDialog((Component)null,"添加成功!","提示信息",JOptionPane.QUESTION_MESSAGE);
				statement =connection.createStatement();     
			    statement.executeQuery(query);
			}
			catch(SQLException sql)
			{
				//System.out.println(sql.getMessage());
			}
		}
		if(obj==shanchu)
		{
			//String selectClass=choice1.getSelectedItem().trim();
			String selectStu=choice2.getSelectedItem().trim();
			String selectCr=choice3.getSelectedItem().trim();
			//int score=Integer.parseInt(tf_fenshu.getText().trim());
			String query="delete from score where student_no="+"'"+selectStu+"'"+"and course_no="+"'"+selectCr+"'";                        
			try
			{
				JOptionPane.showMessageDialog((Component)null,"删除成功!","提示信息",JOptionPane.QUESTION_MESSAGE);
				statement =connection.createStatement();     
			    statement.executeQuery(query);
			}
			catch(SQLException sql)
			{
				//System.out.println(sql.getMessage());
			}
		}
		if(obj==xiugai)
		{
			String selectStu=choice2.getSelectedItem().trim();
			String selectCr=choice3.getSelectedItem().trim();
			int score=Integer.parseInt(tf_fenshu.getText().trim());
			String query="update score set score="+score+"where student_no="+"'"+selectStu+"'"+"and course_no="+"'"+selectCr+"'";                       
			try
			{
				JOptionPane.showMessageDialog((Component)null,"修改成功!","提示信息",JOptionPane.QUESTION_MESSAGE);
				statement =connection.createStatement();     
			    statement.executeQuery(query);
			}
			catch(SQLException sql)
			{
				//System.out.println(sql.getMessage());
			}
		}
		if(obj==fanhui)
		{
			this.dispose();
			Admin_manage ma=new Admin_manage();
			ma.setVisible(true);
		}
	}
	public static void main(String[] args)
	{
		Manage_score teach=new Manage_score();
		teach.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		teach.setVisible(true);
	}
}