70bb2740b8f3001c1ba5970dd0539ecd

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

//ok没法写入数据库
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class JiFenFrame extends JFrame implements ActionListener{
	JLabel label1 = new JLabel("课程名");
	JLabel label2 = new JLabel("成绩");
	JLabel label3 = new JLabel("学分");
	JLabel label5 =new JLabel("学期");
	JLabel label6 =new JLabel();
	JLabel label4 = new JLabel("学号");
	TextField textField1 = new TextField();
	TextField textField2 = new TextField();
	TextField textField3 = new TextField();
	TextField textField4 = new TextField();
	TextField textField5 = new TextField();
	JButton button1 = new JButton("添加");
	JButton button2 = new JButton("退出");
	Connection conn;
	Statement stmt;
	ResultSet rs;  
	String strurl;

    public JiFenFrame() throws Exception
    {	
    	super("登记");
    	setSize(480,400);
    	setLayout(null);
    	this.setLocation(200,200);
    	button2.setBounds(219, 228, 89, 25);/////////////////////
    	button1.addActionListener(this);
    	button1.setBounds(68, 226, 83, 23);///////////////////
    	button2.addActionListener(this);
    	textField1.setBounds(105, 86, 76, 20);//////////////////
    	textField2.setBounds(271, 86, 76, 20);//////////////////////
    	textField3.setBounds(105, 170, 76, 20);////////////////
    	textField4.setBounds(105,126,76,20);
    	textField5.setBounds(271,126,76,20);
    	label1.setBounds(45, 86, 57, 19);//////////////
    	label2.setBounds(45, 126, 57, 19);///////////////
    	label3.setBounds(45, 170, 57, 19);/////////////////////
    	label4.setBounds(210, 86, 53, 19);////////////////////
    	label5.setBounds(210, 126, 53, 20);/////////////////
    	label6.setBounds(210, 170, 100, 20);
    	add(button1);
    	add(button2);
    	add(label1);
    	add(label2);
    	add(label3);
    	add(label4);
    	add(label5);
    	add(label6);
    	add(textField5);
    	add(textField4);
    	add(textField3);
		add(textField2);
		add(textField1);
		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(""))
    		{
    			label6.setText("输入不能为空");
    		}	
    		else{
    			try
    			{
    				rs = stmt.executeQuery("select * from COURSE where 学号='"+textField4.getText()+"' and 课程名='"+textField1.getText()+"'" );
    				if(rs.next()){
    					JOptionPane.showMessageDialog(null, "字段存在重新输入",  "提示",
                                  	JOptionPane.WARNING_MESSAGE);
    					textField1.setText("");
    					textField2.setText("");
    					textField3.setText("");
    				}
    				else{
    					stmt.execute(
    							"insert into COURSE(学号,课程名,成绩,学期,学分) values ('" +
    							textField2.getText() + "','" + textField1.getText() + "','" +
    							textField4.getText() + "','" + textField5.getText() + "','"+textField3.getText()+"')" );
    					textField1.setText("");
    					textField2.setText("");
    					textField3.setText("");
    					textField4.setText("");
    					textField5.setText("");
    					label6.setText("输入成功");
    				}
    			}
    			catch (Exception eg) {
    				label6.setText("输入错误");
    				eg.printStackTrace();
    			}
    		}
    	}
    	if(str.equals("退出"))
    	{
    		setVisible(false);
    	}
    }
}