chengjiframe.java

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

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

public class ChengJiFrame extends JFrame implements ActionListener{
	    JLabel label1 = new JLabel("学号");
		JLabel label2 = new JLabel("学期");
		JLabel label3 = new JLabel("课程名");
		JLabel label4 = new JLabel("成绩");
        JLabel label5=new JLabel();
        JTextField textField2 = new JTextField();
		JTextField textField3 = new JTextField();
		JTextField textField4 = new JTextField();
		JTextField textField1 = new JTextField();
		JButton button1 = new JButton("确定");
          Connection conn;
          Statement stmt;
          ResultSet rs;  
          String strurl;

public ChengJiFrame() throws Exception
{
    super("查询各科成绩窗口");
	setSize(480,300);
	setLayout(null);	 
	this.setLocation(200,200);	
	button1.addActionListener(this);
	button1.setBounds(45, 226, 83, 23);
    //textField6.setBounds(271, 169, 76, 20);
	//textField5.setBounds(271, 126, 76, 20);
	textField1.setBounds(105, 86, 76, 20);
	textField4.setBounds(271, 120, 76, 20);
	textField3.setBounds(105, 120, 76, 20);
	textField2.setBounds(271, 86, 76, 20);
	label1.setBounds(55, 86, 57, 19);
	label2.setBounds(185, 86, 45, 19);
    label3.setBounds(55, 120, 57, 19);
    label4.setBounds(185, 120, 45, 19);///////////////////
    label5.setBounds(45, 170, 100, 19);
		add(button1);
	    add(label1);
	    add(label2);
        add(label3);
        add(label4);
        add(label5);
	    add(textField3);
		add(textField2);
		add(textField1);
	
		//add(textField6);
		//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();
		String sno,cou,xq;
		if (str.equals("确定"))
		{
			sno=textField1.getText().trim();
			cou=textField3.getText().trim();
			xq=textField2.getText().trim();		
			if(textField1.getText().equals(""))
			{
				label5.setText("学号不能为空");
			}
			else if(textField2.getText().equals(""))
				{
				label5.setText("学期不能为空");
				}else if(textField3.getText().equals(""))
				{
					label5.setText("请输入课程名");
				}
				else{
					try
					{
						rs = stmt.executeQuery("select * from COURSE where 学号='"+sno+"'and 课程名='"+cou+"'and 学期='"+xq+"' " );
						if(rs.next())
						{
							textField4.setText(rs.getString("成绩"));
						}
						else{
							JOptionPane.showMessageDialog(null, "记录不存在", "警告",
	                            JOptionPane.WARNING_MESSAGE);
							textField1.setText("");
							textField2.setText("");
							textField3.setText("");
						}
					}
					catch (Exception eg) {
						label5.setText("输入错误");
						eg.printStackTrace();
					}
				}
		}          	
	}
}