a0203701c1f3001c16d68d4fa542eec9

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

package xscj;
/////////ok
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;


public class KeChengFrame extends JFrame implements ActionListener{
	JLabel label1 = new JLabel("学号");
	JLabel label2 = new JLabel("学期");
	JLabel label3=new JLabel("所选课程如下 :");
	JLabel label4=new JLabel();
    JTextField textField2 = new JTextField();
	JTextField textField3 = new JTextField();
	JTextField textField4 = new JTextField();
	JTextField textField1 = new JTextField();
	JTextField textField5 =new JTextField();
	//TextField textField6 =new TextField();
	JButton button1 = new JButton("确定");
	JButton button2 = new JButton("退出");
          Connection conn;
          Statement stmt;
          ResultSet rs;  
          String strurl;

    public KeChengFrame() throws Exception
    {	
    	super("查询所选课程窗口");
    	setSize(300,350);
    	setLayout(null);
    	this.setLocation(200,200);
    	button1.addActionListener(this);
    	button2.addActionListener(this);
    	button1.setBounds(45, 226, 83, 23);
    	button2.setBounds(145, 226, 83, 23);
    	textField2.setBounds(60, 126, 76, 20);
    	textField4.setBounds(160, 126, 76, 20);
    	textField1.setBounds(60, 86, 76, 20);
    	textField3.setBounds(160, 86, 76, 20);
    	textField5.setBounds(160, 170, 76, 20);
    	label1.setBounds(15, 86, 45, 19);
    	label2.setBounds(15, 126, 45, 19);
    	label3.setBounds(145, 45,100, 19);
    	label4.setBounds(15, 170,100, 19);
		add(button1);
		add(button2);
	   	add(label1);
	   	add(label2);
	   	add(label3);
	   	add(label4);
	   	add(textField3);
		add(textField2);
		add(textField1);   		
		add(textField5);
		add(textField4);
		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(textField2.getText().equals(""))
    		{
    			label4.setText("学期不能为空");
    		}
    		else{
    			try
    			{    				
    				rs = stmt.executeQuery("SELECT * FROM SC where 学号='"+textField1.getText()+"' and 学期='"+textField2.getText()+"'");		
    				if(rs.next())
    				{
    					textField3.setText(rs.getString("课程1"));
    					textField4.setText(rs.getString("课程2"));
    					textField5.setText(rs.getString("课程3"));    					
    				}
    				else{
    					JOptionPane.showMessageDialog(null, "记录不存在", "警告",
                            JOptionPane.WARNING_MESSAGE);
    				}	
    			}
    			catch (Exception eg) {
    				eg.printStackTrace();
    			}
    		}
    	}
    	if(str.equals("退出"))
    	{
    		System.exit(0);	
    	}
	}    
}