professorui.java

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

package Professor;
import java.awt.*;

import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;


public class ProfessorUI extends JFrame{

	String PID=null;
	String key=null;
	JButton jb1=new JButton();
	JButton jb2=new JButton();
	JButton jb3=new JButton();
	JButton jb4=new JButton();
	JButton jb5=new JButton();
	JButton jb6=new JButton();
	JScrollPane jsp=new JScrollPane();
	JTable jtb;
	JPanel jp1=new JPanel();
	Container cp=getContentPane();
	Vector v1=new Vector();
	Vector v2=new Vector();
	ResultSet rs;
	public ProfessorUI(String PIDd,String keyd)
	{
		PID=PIDd;
		key=keyd;
		try{
			jbinit();
		}catch(Exception e){e.printStackTrace();}
		
	}
	public void jbinit()
	{
		jb1.setFont(new Font("SansSerif", Font.PLAIN, 12));
		jb1.setText("查看可选课程");
		jb1.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				try{
					v1.removeAllElements();
					v2.removeAllElements();
					v2.add("课程号");
					v2.add("课程名");
					v2.add("学分");
					v2.add("上课教室");
					MyJDBC k=new MyJDBC();
					rs=k.exceteQuery("select * from wengxinzhi.professorcourseview");
					while(rs.next())
					{
						Vector v3=new Vector();
						v3.add(rs.getString(1));
						v3.add(rs.getString(2));
						v3.add(Integer.toString(rs.getInt(3)));
						v3.add(rs.getString(4));
						v1.add(v3);
					}
					jtb=new JTable(v1,v2);
					jsp.getViewport().add(jtb,null);
				
				}catch(Exception o){o.printStackTrace();}
			}
		});
		jb1.setForeground(Color.BLUE);
		jb2.setFont(new Font("SansSerif", Font.PLAIN, 12));
		jb2.setText("选择授课");
		jb2.setForeground(Color.BLUE);
		jb2.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				SelectTeach p=new SelectTeach(PID);
			}
		}
		);
		
		class PersonalDetail implements ActionListener
		{
			String ID;
			public PersonalDetail(String IDt)
			{
				ID=IDt;
			}
			
			public void actionPerformed(ActionEvent e)
			{
				try{
					v1.removeAllElements();
					v2.removeAllElements();

					MyJDBC k=new MyJDBC();
					MyJDBC t=new MyJDBC();
					String sql="select wengxinzhi.professor.pid,name,level,cname,wengxinzhi.course.cid from wengxinzhi.professor,wengxinzhi.psc,wengxinzhi.course where wengxinzhi.professor.pid='"+ID +" ' and wengxinzhi.professor.pid=wengxinzhi.psc.pid and wengxinzhi.course.cid=wengxinzhi.psc.cid";
					rs=k.exceteQuery(sql);
					ResultSetMetaData s=rs.getMetaData();
					if(rs.next())
					{
						rs=k.exceteQuery(sql);
					while(rs.next())
					{
						Vector v3=new Vector();
						v3.add(rs.getString(1));
						v3.add(rs.getString(2));
						v3.add(rs.getString(3));
						v3.add(rs.getString(4));
						v3.add(rs.getString(5));
						v1.add(v3);
					}
					v2.add("教工号");
					v2.add("教师姓名");
					v2.add("教师职称");
					v2.add("已选受课程");
					v2.add("课程代号");
					jtb=new JTable(v1,v2);
					jsp.getViewport().add(jtb,null);
					}
					else{
						sql="select pid,name,level from wengxinzhi.professor where pid='"+ID+"'";
						rs=k.exceteQuery(sql);
						while(rs.next())
						{
						Vector v3=new Vector();
						v3.add(rs.getString(1));
						v3.add(rs.getString(2));
						v3.add(rs.getString(3));
						v1.add(v3);
					}
					v2.add("教工号");
					v2.add("教师姓名");
					v2.add("教师职称");
					jtb=new JTable(v1,v2);
					jsp.getViewport().add(jtb,null);
						
					}
			}catch(Exception o){o.printStackTrace();}
			}
			
		}
		jb3.setFont(new Font("SansSerif", Font.PLAIN, 12));
		jb3.setText("个人信息");
		jb3.setForeground(Color.BLUE);
		jb3.addActionListener(new PersonalDetail(PID));
		
		
		
		
		jb4.setFont(new Font("SansSerif", Font.PLAIN, 12));
		jb4.setText("修改个人信息");
		jb4.setForeground(Color.BLUE);
		jb4.addActionListener(new ActionListener()
				{
					public void actionPerformed(ActionEvent e)
					{
						ModifyDetail x=new ModifyDetail(PID);
					}
				}
				);
		
		
		
		
		jb5.setFont(new Font("SansSerif", Font.PLAIN, 12));
		jb5.setText("退出系统");
		jb5.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				System.exit(0);
			}
			}
			);
		jb5.setForeground(Color.BLUE);
		jb6.setFont(new Font("SansSerif", Font.PLAIN, 12));
		jb6.setText("上传成绩");
		jb6.setForeground(Color.BLUE);
		jb6.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				CommitResult t=new CommitResult();
			}
		});
		cp.setLayout(new BorderLayout());
		jp1.add(jb1);
		jp1.add(jb2);		
		jp1.add(jb3);
		jp1.add(jb4);
		jp1.add(jb6);
		jp1.add(jb5);
		cp.add(jp1,BorderLayout.NORTH);
		cp.add(jsp,BorderLayout.CENTER);
		this.setLocation(250,200);
		this.setSize(580,400);
		this.setTitle("CRS-Professor");
		this.setVisible(true);
	}
}