commitresult.java

一个简单的选课系统的源代码,本人的数据库课程的作品.数据库用的是db2

package Professor;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;

public class CommitResult extends JFrame{

	JLabel jl1=new JLabel("课程号  ");
	JLabel jl2=new JLabel("学号    ");
	JLabel jl3=new JLabel("学生成绩");
	JLabel jl=new JLabel("请填入一下信息");
	JTextField jtf1=new JTextField(15);
	JTextField jtf2=new JTextField(15);
	JTextField jtf3=new JTextField(15);
	JPanel jp1=new JPanel();
	JPanel jp2=new JPanel();
	JPanel jp3=new JPanel();
	JPanel jp4=new JPanel();
	JPanel jp5=new JPanel();
	JPanel jp6=new JPanel();
	JButton jb1=new JButton();
	JButton jb2=new JButton();
	Container cp=this.getContentPane();
	
	
	public CommitResult()
	{
		try{
			jbinit();
		}catch(Exception e){e.printStackTrace();}
	}
	private void jbinit()
	{
		jp1.add(jl1);
		jp1.add(jtf1);
		jp2.add(jl2);
		jp2.add(jtf2);
		jp3.add(jl3);
		jp3.add(jtf3);
		jp4.add(jl);
		jl.setFont(	new Font("SansSerif", Font.PLAIN, 24));
		jl.setForeground(Color.RED);
		jp5.setLayout(new GridLayout(3,1));
		jp5.add(jp1);
		jp5.add(jp2);
		jp5.add(jp3);
		jb1.setText("提交");
		jb1.setForeground(Color.BLUE);
		jb1.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				int then;
				String cid,sid,grade,sql;
				cid=jtf1.getText();
				sid=jtf2.getText();
				grade=jtf3.getText();
				sql="update wengxinzhi.result set grade="+grade+" where cid='"+cid+"' and sid='"+sid+"'";
				try{
				MyJDBC k=new MyJDBC();
				then=k.insert(sql);
				if(then>0)
				{
					JOptionPane.showMessageDialog(null,"更新完成");
					
				}else{JOptionPane.showMessageDialog(null,"发生错误,请确认所填写的数据正确");}
				}catch(Exception o){o.printStackTrace();}
			}
			}
		);
		
		jb2.setText("退出");
		jb2.setForeground(Color.BLUE);
		jb2.addActionListener(new ActionListener()
				{
			public void actionPerformed(ActionEvent e)
			{
				dispose();
				}
			}
		);
		jp6.add(jb1);

		jp6.add(jb2);

		cp.setLayout(new BorderLayout());
		cp.add(jp4,BorderLayout.NORTH);
		cp.add(jp5,BorderLayout.CENTER);
		cp.add(jp6,BorderLayout.SOUTH);
		this.setLocation(250,200);
		this.setSize(300,250);
		this.setTitle("提交成绩");
		this.setVisible(true);
	}
}