addopencourseinfohandler.java

在本系统中

package jin.handler;

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

import jin.internalFrame.*;
import jin.dao.*;
import jin.bean.*;

//输入开课编号、课程编号、开课学年、开课学期、教师本人的教师编号 
//(表的字段:开课编号、课程编号、开课学年、开课学期、教师编号)

//开课信息中的学期、学年数据项由教师用户输入，课程编号数据项由教师用户从课程信息中选择生成，
//开课编号数据项由系统按照规律自动生成，教师编号数据项取自选择开课信息的教师用户的教师编号

//开课编号取值：七位字符串，前四位为课程编号、接着两位为学年值的前两位字符、最后一位为学期，
//如：C001082（专业选修课）或G100081（公选课）

public class AddOpenCourseInfoHandler
{
	private AddOpenCourseInfo addOpenCourseInfo; 
	private JTextField[] fields;
	private JComboBox comboBox;
	private String id;
	
	public AddOpenCourseInfoHandler(AddOpenCourseInfo addOpenCourseInf,String Id)
	{
		this.addOpenCourseInfo=addOpenCourseInf;
		fields=addOpenCourseInfo.getFields();
		comboBox=addOpenCourseInfo.getComboBox();
		this.id=Id;
		

		for(int i=0;i<fields.length;i++)
		{ 		
			fields[i].addActionListener(				
				new ActionListener()
				{				
					public void actionPerformed(ActionEvent e)
					{
						for(int j=0;j<2;j++)
						{
							if(e.getSource()==fields[j])
							{								
								if(j==0)
									fields[1].grabFocus();	
								if(j==1)							
									fields[0].grabFocus();								
							}
						}						
					}
				}
			);
		}
		
		comboBox.removeAllItems();
		
		
		TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
		TeaInfoBean teaInfoBean=null;
		
		
		String Sql1="select * from teaInfo where teaID='"+id+"'";					
		ArrayList tealist=teaInfoDAO.excuteQuery(Sql1);
		
		
		System.out.println("大小（因为1）"+tealist.size());
		
		teaInfoBean=(TeaInfoBean)tealist.get(0);
		if(teaInfoBean.getState().trim().equals("在编") && teaInfoBean.getDelRecord().trim().equals("否"))
		{
			CourseInfoDAO couInfoDAO=new CourseInfoDAO();
			CourseInfoBean courseInfoBean=null;
			
			
			String Sql2="select * from courseInfo where majorID='"+teaInfoBean.getMajorID()+"'";					
			ArrayList courlist=couInfoDAO.excuteQuery(Sql2);
			
			System.out.println("属于该教师专业的课程的大小:"+courlist.size());
			
			
			
			for(int i=0;i<courlist.size();i++)
			{
				courseInfoBean=(CourseInfoBean)courlist.get(i);
				
				if(courseInfoBean.getState().trim().equals("在编"))
				{
					System.out.println("加没有"+courseInfoBean.getCourseID());
					String text=courseInfoBean.getCourseID();
					System.out.println("text="+text);
					comboBox.addItem(text);
				}
				
			}
		
		}
		
		CourseInfoDAO couInfoDAO=new CourseInfoDAO();
		CourseInfoBean courseInfoBean=null;
		
		
		String Sql3="select * from courseInfo where majorID='100'";					
		ArrayList Gcourlist=couInfoDAO.excuteQuery(Sql3);
		
		for(int i=0;i<Gcourlist.size();i++)
		{
			courseInfoBean=(CourseInfoBean)Gcourlist.get(i);
			
			comboBox.addItem(courseInfoBean.getCourseID().trim());
		}
	
		addOpenCourseInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{	
				/*				
					StringBuffer idFromTable=new StringBuffer();
					StringBuffer idFromField=new StringBuffer();					
					
					
					
					
					for(int j=0;j<fields[0].getText().trim().length();j++)
					{
						char c=fields[0].getText().trim().charAt(j);
						
				    	if(c>='a' && c<='z')
						{	
							System.out.println("CCCCCCCCCCCCCCCC");							
							
							idFromField.append((char)(c-32));								
						}
						
						else
						{
							idFromField.append(c);
						}
					}
					
					String idF=new String(idFromField);
				*/	
					
					//String openCourseID="";
					StringBuffer buffer=new StringBuffer(comboBox.getSelectedItem().toString().trim());
					
					for(int i=0;i<2;i++)
					{
						char c=fields[0].getText().trim().charAt(i);
						buffer.append(c);
					}

					buffer.append(fields[1].getText().trim().charAt(0));
					
					String openCourseID=new String(buffer);
					
					System.out.println("openCourseID="+openCourseID);
					
					
					OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
					String sql1="select * from openCourseInfo";
					
					ArrayList list=openCourseInfoDAO.excuteQuery(sql1);
					OpenCourseInfoBean openCourseInfoBean=null;
					
					int flag=0;	
							
					for(int i=0;i<list.size();i++)
					{
						openCourseInfoBean=(OpenCourseInfoBean)list.get(i);					
					
						if(openCourseInfoBean.getOpenCourseID().trim().equals(openCourseID.trim()))
						{						
							flag=1;					
							break;
						}			
					}
					
					if(flag==1)
					{
						JOptionPane.showMessageDialog(null,"已存在该开课信息!");
						System.out.println("EEEEEEEEEEEEEEEEEEE");
					}
					
					if(flag==0)
					{
						String sql2="insert into openCourseInfo values('"+openCourseID+"','"+comboBox.getSelectedItem().toString().trim()+"','"+fields[0].getText().trim()+"','"+fields[1].getText().trim()+"','"+id+"')";
						boolean BOK=openCourseInfoDAO.insert(sql2);
					
						//JOptionPane.showMessageDialog(null,"操作数据库的SQL语句错误: " + sqlEx.getMessage() );
						if(BOK)
						{
							JOptionPane.showMessageDialog(null,"添加开课成功!");
						}
						
						else
						{
							System.out.println("flag="+flag);
							JOptionPane.showMessageDialog(null,"添加开课失败!");
							
						}						
						
					}	
					addOpenCourseInfo.setVisible(false);
					
				}
			}
		);
		
		addOpenCourseInfo.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					addOpenCourseInfo.setVisible(false);
				}
			}
		);
	}
	
	public static void main(String args[])
	{
		JFrame frame=new JFrame();
	    JDesktopPane desktopPane=new JDesktopPane();
	    AddOpenCourseInfo app=new AddOpenCourseInfo(frame,desktopPane,"t001");
	    
	    frame.setSize(500,500);
	    frame.setVisible(true);	    
	}

}