701b303cb8f3001c1ba5970dd0539ecd

用于学生资料的管理、成绩的记录、成绩的统计等功能的实现

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

import javax.swing.*;
public class XueQiTJFrame extends JFrame implements ActionListener{
		JLabel label1 = new JLabel("学号");
		JLabel label2 = new JLabel("学期");
		JLabel label3=new JLabel("查询结果");
		JLabel label4=new JLabel("");
        JTextField textField1 = new JTextField();
		JTextField textField２ =new JTextField();
		JTextField textField３ =new JTextField();
		JButton button1 = new JButton("课程数");
		JButton button2 = new JButton("学分数");
		JButton button3 = new JButton("GPA值");
		JButton button4 = new JButton("获优课程数");
		Connection conn;
		Statement stmt;
		ResultSet rs;  
		String strurl;
	public XueQiTJFrame() throws Exception
	{
		 	super("学期总结窗口");
			setSize(480,400);
			setLayout(null); 
			this.setLocation(200,200);
			button1.addActionListener(this);
			button2.addActionListener(this);
			button3.addActionListener(this);
			button4.addActionListener(this);
			button1.setBounds(20, 226, 83, 23);
			button2.setBounds(115, 226, 83, 23);
			button3.setBounds(205, 226, 83, 23);
			button4.setBounds(295, 226, 100, 23);
			textField1.setBounds(86, 86, 76, 20);
			textField２.setBounds(225, 86, 76, 20);
			textField３.setBounds(86, 145, 76, 20);
			label1.setBounds(20, 86, 30, 19);
			label2.setBounds(175, 86, 30, 19);
			label3.setBounds(20, 145,60, 19);
			label4.setBounds(175, 145, 100, 19);
			//label5.setBounds(20, 126, 30, 19);
			//label6.setBounds(45, 170,100, 19);
			add(button1);
			add(button2);
			add(button3);
			add(button4);		   
	    	add(label1);
	    	add(label2);
	    	add(label3);
	    	add(label4);
	    	add(textField1);
	    	add(textField２);
	    	add(textField３);

	    	//add(label4);
	    	//	add(label5);
	    	//add(label6);
	    	strurl ="jdbc:odbc:student";

	    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    	conn = DriverManager.getConnection(strurl);
	    	stmt = conn.createStatement();
	    	setVisible(true);
	    	addWindowListener(new WindowAdapter(){
	    		public void windowClosing(WindowEvent e){
	    			dispose();
	    			setVisible(false);
	    		}
	    	}); 
	}
	
	public void actionPerformed(ActionEvent e)
	{
		String str=e.getActionCommand();
		if (str.equals("课程数"))
		{
			if(textField1.getText().equals(""))
			{
				label4.setText("学号不能为空");
			}
			else if(textField２.getText().equals(""))
			{
				label4.setText("学期不能为空");
			}
			
			else{
				try
				{
			
					rs = stmt.executeQuery("SELECT * FROM TJ where 学号='"+textField1.getText()+"' and 学期='"+textField２.getText()+"'");		
					if(rs.next())
					{
						
						
						textField３.setText(rs.getString("课程数"));
						
						
					}
					else{
						JOptionPane.showMessageDialog(null, "记录不存在", "警告",
								JOptionPane.WARNING_MESSAGE);
					}
					

				}
				catch (Exception eg) {
					
					eg.printStackTrace();
				}
			}
		}
		if (str.equals("学分数"))
		{
			if(textField1.getText().equals(""))
			{
				label4.setText("学号不能为空");
			}
			else if(textField２.getText().equals(""))
			{
				label4.setText("学期不能为空");
			}
			
			else{
				try
				{
					
					rs = stmt.executeQuery("SELECT * FROM TJ where 学号='"+textField1.getText()+"' and 学期='"+textField２.getText()+"'");		
					if(rs.next())
					{
						
						
						textField３.setText(rs.getString("学分数"));
						
						
					}
					else{
						JOptionPane.showMessageDialog(null, "记录不存在", "警告",
                            	JOptionPane.WARNING_MESSAGE);
					}
					
					
				}
				catch (Exception eg) {
					
					eg.printStackTrace();
				}
			}
		}
		if (str.equals("GPA值"))
		{
			if(textField1.getText().equals(""))
			{
				label4.setText("学号不能为空");
			}
			else if(textField２.getText().equals(""))
			{
				label4.setText("学期不能为空");
			}
			
			else{
				try
				{
					
					rs = stmt.executeQuery("SELECT * FROM TJ where 学号='"+textField1.getText()+"' and 学期='"+textField２.getText()+"'");		
					if(rs.next())
					{
						
						
						textField３.setText(rs.getString("GPA值"));
						
						
					}
					else{
						JOptionPane.showMessageDialog(null, "记录不存在", "警告",
								JOptionPane.WARNING_MESSAGE);
					}					
				}
				catch (Exception eg) {
					
					eg.printStackTrace();
				}
			}
		}
		if (str.equals("获优课程数"))
		{
			if(textField1.getText().equals(""))
			{
				label4.setText("学号不能为空");
			}
			else if(textField２.getText().equals(""))
			{
				label4.setText("学期不能为空");
			}
			
			else{
				try
				{					
					rs = stmt.executeQuery("SELECT * FROM TJ where 学号='"+textField1.getText()+"' and 学期='"+textField２.getText()+"'");		
					if(rs.next())
					{						
						textField３.setText(rs.getString("获优课程数"));						
					}
					else{
						JOptionPane.showMessageDialog(null, "记录不存在", "警告",
								JOptionPane.WARNING_MESSAGE);
					}						
				}
				catch (Exception eg) {
					
					eg.printStackTrace();
				}
			}
		}			
	}
           		
}