addgcourseinfohandler.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.*;

//输入课程编号、课程名称、专业编号、状态     (表的字段:课程编号、课程名称、专业编号)
public class AddGcourseInfoHandler
{
	private AddGcourseInfo addGcourseInfo; 
	private JTextField[] fields;
	//private JComboBox comboBox;
	
	public AddGcourseInfoHandler(AddGcourseInfo addGcourseInf)
	{
		this.addGcourseInfo=addGcourseInf;
		fields=addGcourseInfo.getFields();
		//comboBox=addGcourseInfo.getComboBox();
	
		for(int i=0;i<fields.length;i++)
		{ 		
			fields[i].addActionListener(				
				new ActionListener()
				{				
					public void actionPerformed(ActionEvent e)
					{
						for(int j=0;j<4;j++)
						{
							if(e.getSource()==fields[j])
							{
								if(j==3)							
									fields[0].grabFocus();				
								
								if(j>=0 && j<3)
									fields[j+1].grabFocus();								
							}
						}						
					}
				}
			);
		}		
		
		CourseInfoDAO couInfoDAO=new CourseInfoDAO();
		String Sql="select * from courseInfo";
					
		ArrayList couList=couInfoDAO.excuteQuery(Sql);
		ArrayList GcouList=new ArrayList();
		CourseInfoBean courseInfoBean=null;
		
		for(int i=0;i<couList.size();i++)
		{
			courseInfoBean=(CourseInfoBean)couList.get(i);
			if(courseInfoBean.getCourseID().charAt(0)=='G')
			{
				GcouList.add(courseInfoBean);
			}
		}		
		int count=GcouList.size();
		
		System.out.println("count="+count);
		String text="";
		
		if(count==0)
		{
			text=text+"G001";
		}
		if(count>=1 && count<=9)
		{
			text=text+"G00"+(count+1);
		}
		
		if(count>=10 && count<=99)
		{
			text=text+"G0"+(count+1);
		}
		
		if(count>=100 && count<=999)
		{
			text=text+"G"+(count+1);
		}
		
		fields[0].setText(text);	
		fields[2].setText("100");
			
		MajorInfoBean majorInfoBean=null;
		MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
		String sql="select * from majorInfo";
		ArrayList list=majorInfoDAO.excuteQuery(sql);
		
		int flag=0;
		
		/*
		for(int i=0;i<list.size();i++)
		{
			majorInfoBean=(MajorInfoBean)list.get(i);
			
			//System.out.println(majorInfoBean.getBelongTo().trim());   
			for(int j=0;j<comboBox.getItemCount();j++)
			{				
				if(majorInfoBean.getMajorID().trim().equals(comboBox.getItemAt(j).toString().trim()))
				{
					flag=1;
					break;
				}				
			}
			
			if(flag==0)
			{
				comboBox.addItem(majorInfoBean.getMajorID().trim());				
			}
			
			
			if(flag==1)
			{
				flag=0;
			}		
		}
		*/
		
		addGcourseInfo.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);
				*/	
					
					CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
					String sql1="select * from courseInfo";
					
					ArrayList list=courseInfoDAO.excuteQuery(sql1);
					CourseInfoBean courseInfoBean=null;
					
					int flag=0;	
							
					for(int i=0;i<list.size();i++)
					{
						courseInfoBean=(CourseInfoBean)list.get(i);					
					
						if(courseInfoBean.getMajorID().trim().equals(fields[0].getText().trim()))
						{
						
							flag=1;					
							break;
						}
						
						/*
						else
						{
							idFromTable=new StringBuffer();
						}
						*/		
					}
					
					if(flag==1)
					{
						JOptionPane.showMessageDialog(null,"已存在该专业信息!");
						System.out.println("EEEEEEEEEEEEEEEEEEE");
					}
					
					if(flag==0)
					{
						String sql2="insert into courseInfo values('"+fields[0].getText().trim()+"','"+fields[1].getText().trim()+"','"+fields[2].getText().trim()+"','"+fields[3].getText().trim()+"')";
						boolean BOK=courseInfoDAO.insert(sql2);
					
						//JOptionPane.showMessageDialog(null,"操作数据库的SQL语句错误: " + sqlEx.getMessage() );
						if(BOK)
						{
							JOptionPane.showMessageDialog(null,"添加成功!");
						}
						
						else
						{
							System.out.println("flag="+flag);
							JOptionPane.showMessageDialog(null,"添加失败!");
							
						}						
						
					}	
					addGcourseInfo.setVisible(false);
				}
			}
		);
		
		addGcourseInfo.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{	
					addGcourseInfo.setVisible(false);
				}
			}
		);
	}

}