addmajorinfohandler.java

在本系统中

package jin.handler;

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

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

public class AddMajorInfoHandler
{
	private AddMajorInfo addMajorInfo; 
	private JTextField[] fields;
	private JComboBox comboBox;
	
	public AddMajorInfoHandler(AddMajorInfo addMajorInf)
	{
		this.addMajorInfo=addMajorInf;
		fields=addMajorInfo.getFields();
		comboBox=addMajorInfo.getComboBox();
		//ActionHandler handler=new ActionHandler();
	
		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[1].grabFocus();				
								
								if(j>=0 && j<2)
									fields[j+1].grabFocus();								
							}
						}						
					}
				}
			);
		}		
		
		
		/*
		for(int i=0;i<4;i++)
		{
			fields[i].addActionListener(handler);
		}
		
		fields.addActionListener(new ActionListener()			
			{				
				public void actionPerformed(ActionEvent e)
				{
					for(int i=0;i<4;i++)
					{
						if(e.getSource()==fields[i])
						{
							if(i==3)
								fields[0].grabFocus();
							else
								fields[i+1].grabFocus();
						}
					}
				}
			}
		);	
		
		private class ActionHandler implements ActionListener
		{
			public void actionPerformed(ActionEvent e)
			{
				for(int i=0;i<4;i++)
				{
					if(e.getSource()==fields[i])
					{
						if(i==3)
							fields[0].grabFocus();
						else
							fields[i+1].grabFocus();
					}
				}
			}
		}
			
		*/
		MajorInfoDAO majInfoDAO=new MajorInfoDAO();
		String sql="select * from majorInfo";
					
		ArrayList majorList=majInfoDAO.excuteQuery(sql);
		
		fields[0].setText(String.valueOf((majorList.size()+101)));
		//fields[1].grabFocus();
		
		
		addMajorInfo.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);
						}
					}
					//System.out.println("idFromField="+idFromField);
					String idF=new String(idFromField);
					
					MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
					String sql1="select * from majorInfo";
					
					ArrayList list=majorInfoDAO.excuteQuery(sql1);
		
				
					MajorInfoBean majorInfoBean=null;
					
					int flag=0;	
							
					for(int i=0;i<list.size();i++)
					{
						majorInfoBean=(MajorInfoBean)list.get(i);					
						
						//idFromTable.append(majorInfoBean.getMajorID().trim());
						//System.out.println("majorInfoBean.getMajorID().trim()="+majorInfoBean.getMajorID().trim());
						//System.out.println("idFromTable="+idFromTable);
						
						if(majorInfoBean.getMajorID().trim().equals(idF))
						{
						//	System.out.println("idFromTable.equals(idFromField)="+idFromTable.equals(idFromField));
							flag=1;					
							break;
						}
						
						else
						{
							idFromTable=new StringBuffer();
						}			
						
						
						/*
						for(int j=0;j<majorInfoBean.getMajorID().trim().length();j++)
						{
							char c=majorInfoBean.getMajorID().trim().charAt(j);
							
					    	if(c>='a' && c<='z')
							{
								idFromTable.append((char)(c-32));
							}
							
							else
							{
								idFromTable.append(c);
							}
						}				
						
						System.out.println("idFromTable="+idFromTable);					
						
						
						if(idFromTable.equals(idFromField))
						{
							flag=1;
							
							System.out.println("DDDDDDDDDDDDDD");
							break;
						}
						
						
						else
						{
							idFromTable=new StringBuffer();			
						}		
						*/
									
					}
					
					if(flag==1)
					{
						JOptionPane.showMessageDialog(null,"已存在该专业信息!");
						System.out.println("EEEEEEEEEEEEEEEEEEE");
					}
					
					if(flag==0)
					{
						String sql2="insert into majorInfo values('"+idFromField+"','"+fields[1].getText().trim()+"','"+comboBox.getSelectedItem().toString().trim()+"','"+fields[2].getText().trim()+"')";
						boolean BOK=majorInfoDAO.insert(sql2);
					
						//JOptionPane.showMessageDialog(null,"操作数据库的SQL语句错误: " + sqlEx.getMessage() );
						if(BOK)
						{
							JOptionPane.showMessageDialog(null,"添加成功!");
						}
						
						else
						{
							System.out.println("flag="+flag);
							JOptionPane.showMessageDialog(null,"添加失败!");
							
						}						
						
					}	
					addMajorInfo.setVisible(false);
				}
			}
		);
		
		
		addMajorInfo.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					addMajorInfo.setVisible(false);
				}
			}
		);
	}
	
	/*
	public static void main(String args[])
	{
		System.out.println("a-A="+('a'-'A'));
	}
	*/
}