selectteach.java

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

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

public class SelectTeach extends JFrame{
	String ID;
	JLabel jl1=new JLabel();
	JLabel jl2=new JLabel();
	JButton jb1=new JButton();
	JButton jb2=new JButton();
	JTextField jtf=new JTextField(15);
	JPanel jp1=new JPanel();
	JPanel jp2=new JPanel();
	JPanel jp3=new JPanel();
	Container cp=this.getContentPane();
	public SelectTeach(String PID)
	{
		ID=PID;
		try{
			jbinit();
		}catch(Exception e){e.printStackTrace();}
	}
	class ConfrimToTeach implements ActionListener
	{
		String ID;
		public ConfrimToTeach(String PID)
		{
			ID=PID;
		}
		public void actionPerformed(ActionEvent e)
		{
			try
			{
				int then=0;
				String CID=jtf.getText();
				String sql="insert into wengxinzhi.psc values('"+CID+"','"+ID+"')";
				MyJDBC k=new MyJDBC();
				then=k.insert(sql);
				if(then>0)
				{
					JOptionPane.showMessageDialog(null,"数据以添加完成");
				}
				else JOptionPane.showMessageDialog(null,"更新失败");
			}catch(Exception o){o.printStackTrace();}
		}
	}
	private void jbinit()
	{
		jl1.setText("选择您要教授的课程");
		jl1.setForeground(Color.RED);
		jl1.setFont(new Font("SansSerif", Font.BOLD, 16));
		jp1.add(jl1);
		jl2.setText("课程号");
		jl2.setFont(new Font("SansSerif", Font.BOLD, 12));
		jp2.add(jl2);
		jp2.add(jtf);
		jb1.setText("确认提交");
		jb1.setForeground(Color.BLUE);
		jb1.addActionListener(new ConfrimToTeach(ID));
		
		
		
		
		jb2.setText("退出");
		jb2.setForeground(Color.BLUE);
		jb2.addActionListener(new ActionListener()
				{
			public void actionPerformed(ActionEvent e)
			{
				dispose();
			}
			});
		jp3.add(jb1);
		jp3.add(jb2);
		jp2.add(jp3);
		cp.setLayout(new BorderLayout());
		cp.add(jp1,BorderLayout.NORTH);
		cp.add(jp2,BorderLayout.CENTER);
		this.setSize(300,200);
		this.setTitle("Select Course To Teach");
		this.setLocation(200,200);
		this.setVisible(true);
	}

}