addteainfohandler.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 AddTeaInfoHandler
{
	private AddTeaInfo addTeaInfo; 
	private JTextField[] fields;
	private JComboBox[] comboBoxs;
	
	public AddTeaInfoHandler(AddTeaInfo addTeaInf)
	{
		this.addTeaInfo=addTeaInf;
		fields=addTeaInfo.getFields();
		comboBoxs=addTeaInfo.getComboBoxs();
	
		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();								
							}
						}						
					}
				}
			);
		}		
		
		TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
		String Sql="select * from teaInfo";
					
		ArrayList teaList=teaInfoDAO.excuteQuery(Sql);
		int count=teaList.size();
		String text="";
		
		if(count==0)
		{
			text=text+"t001";
		}
		if(count>=1 && count<=9)
		{
			text=text+"t00"+(count+1);
		}
		
		if(count>=10 && count<=99)
		{
			text=text+"t0"+(count+1);
		}
		
		if(count>=100 && count<=999)
		{
			text=text+"t"+(count+1);
		}
		
		fields[0].setText(text);
		
		String YuanXiName[]={"请选择","铁路运输系","财贸系","旅游系","移动通信系","计算机系","艺术系","生物系","物理系","化学系","中文系","外语系"
		};
		
		for(int i=0;i<11;i++)
		{
			comboBoxs[0].addItem(YuanXiName[i]);
		}
		
		comboBoxs[0].addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					comboBoxs[1].removeAllItems();
					
					MajorInfoBean majorInfoBean=null;
					MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
					String sql="select * from majorInfo where belongTo='"+comboBoxs[0].getSelectedItem().toString().trim()+"'";
					ArrayList list=majorInfoDAO.excuteQuery(sql);
					
					for(int i=0;i<list.size();i++)
					{
						majorInfoBean=(MajorInfoBean)list.get(i);
						comboBoxs[1].addItem(majorInfoBean.getMajorName());
					}
					
				}
			}
		);
		
		addTeaInfo.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);
					*/
					
					TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
					String sql1="select * from teaInfo";
					
					ArrayList list=teaInfoDAO.excuteQuery(sql1);
					TeaInfoBean teaInfoBean=null;
					
					int flag=0;	
							
					for(int i=0;i<list.size();i++)
					{
						teaInfoBean=(TeaInfoBean)list.get(i);					
					
						//if(teaInfoBean.getTeaID().trim().equals(idF))
						if(teaInfoBean.getTeaID().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)
					{						
						MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
						String sql="select * from majorInfo";
					
						ArrayList majorInfoList=majorInfoDAO.excuteQuery(sql);
						MajorInfoBean majorInfoBean=null;
						
						for(int i=0;i<majorInfoList.size();i++)
						{
							majorInfoBean=(MajorInfoBean)majorInfoList.get(i);
							if(majorInfoBean.getMajorName().trim().equals(comboBoxs[1].getSelectedItem().toString().trim()))
							break;
						}
						
						String sql2="insert into teaInfo values('"+fields[0].getText().trim()+"','"+fields[1].getText().trim()+"','"+majorInfoBean.getMajorID().trim()+"','"+fields[2].getText().trim()+"','否')";
						boolean BOK=teaInfoDAO.insert(sql2);
					
						
						if(BOK)
						{
						
							sql="insert into usersLogin values('"+fields[0].getText().trim()+"','111111','1','否')";
							UsersDAO usersDAO=new UsersDAO();
							BOK=usersDAO.insert(sql);
							if(BOK)
							{
								JOptionPane.showMessageDialog(null,"添加成功!");
							}
							else
							{								
								JOptionPane.showMessageDialog(null,"添加失败!");							
							}
							
						}
						
						else
						{
							JOptionPane.showMessageDialog(null,"添加失败!");							
						}						
						
					}	
					addTeaInfo.setVisible(false);
				}
			}
		);
		
		addTeaInfo.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					addTeaInfo.setVisible(false);
				}
			}
		);	
	}

}