addclassinfohandler.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 AddClassInfoHandler
{
	private AddClassInfo addClassInfo; 
	private JTextField[] fields;
	private JComboBox comboBox;
	
	public AddClassInfoHandler(AddClassInfo addClassInf)
	{
		this.addClassInfo=addClassInf;
		fields=addClassInfo.getFields();
		comboBox=addClassInfo.getComboBox();
	
		for(int i=0;i<fields.length;i++)
		{ 		
			fields[i].addActionListener(				
				new ActionListener()
				{				
					public void actionPerformed(ActionEvent e)
					{
						for(int j=0;j<3;j++)
						{
							if(e.getSource()==fields[j])
							{
								if(j==2)							
									fields[0].grabFocus();				
								
								if(j>=0 && j<2)
									fields[j+1].grabFocus();								
							}
						}						
					}
				}
			);
		}		
		
		ClassInfoDAO claInfoDAO=new ClassInfoDAO();
		String Sql="select * from classInfo";
					
		ArrayList claList=claInfoDAO.excuteQuery(Sql);
		
		fields[0].setText(String.valueOf((claList.size()+1010)));
		
		
			
		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;
			}		
		}
		
		addClassInfo.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);
					
					
					ClassInfoDAO classInfoDAO=new ClassInfoDAO();
					String sql1="select * from classInfo";
					
					ArrayList list=classInfoDAO.excuteQuery(sql1);
					ClassInfoBean classInfoBean=null;
					
					int flag=0;	
							
					for(int i=0;i<list.size();i++)
					{
						classInfoBean=(ClassInfoBean)list.get(i);					
					
						if(classInfoBean.getClassID().trim().equals(idF))
						{
						
							flag=1;					
							break;
						}
						
						else
						{
							idFromTable=new StringBuffer();
						}		
					}
					
					if(flag==1)
					{
						JOptionPane.showMessageDialog(null,"已存在该专业信息!");
						System.out.println("EEEEEEEEEEEEEEEEEEE");
					}
					
					if(flag==0)
					{
						String sql2="insert into classInfo values('"+idFromField+"','"+fields[1].getText().trim()+"','"+comboBox.getSelectedItem().toString().trim()+"','"+fields[2].getText().trim()+"')";
						boolean BOK=classInfoDAO.insert(sql2);
					
						//JOptionPane.showMessageDialog(null,"操作数据库的SQL语句错误: " + sqlEx.getMessage() );
						if(BOK)
						{
							JOptionPane.showMessageDialog(null,"添加成功!");
						}
						
						else
						{
							System.out.println("flag="+flag);
							JOptionPane.showMessageDialog(null,"添加失败!");
							
						}						
						
					}	
					addClassInfo.setVisible(false);
				}
			}
		);
		
		
		addClassInfo.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					addClassInfo.setVisible(false);
				}
			}
		);
	}

}