addstuinfohandler.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 AddStuInfoHandler
{
	private AddStuInfo addstuInfo; 
	private JTextField[] fields;
	private JComboBox[] comboBoxs;
	
	public AddStuInfoHandler(AddStuInfo addstuInf)
	{
		this.addstuInfo=addstuInf;
		fields=addstuInfo.getFields();
		comboBoxs=addstuInfo.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();								
							}
						}						
					}
				}
			);
		}
		
		StuInfoDAO stuInfoDAO=new StuInfoDAO();
		String Sql="select * from stuInfo";
					
		ArrayList stuList=stuInfoDAO.excuteQuery(Sql);
		
		fields[0].setText(String.valueOf((stuList.size()+101001)));
			
		
		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());
					}
					
				}
			}
		);
		
		comboBoxs[1].addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					comboBoxs[1].addItem("请选择");			
					comboBoxs[2].removeAllItems();
					
					comboBoxs[2].addItem("请选择");		
					
					MajorInfoBean majorInfoBean=null;
					MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
					String sq2="select * from majorInfo where majorName='"+comboBoxs[1].getSelectedItem().toString().trim()+"'";
					ArrayList list=majorInfoDAO.excuteQuery(sq2);
					
					for(int i=0;i<list.size();i++)
					{
						majorInfoBean=(MajorInfoBean)list.get(i);
						
						ClassInfoBean classInfoBean=null;
						ClassInfoDAO classInfoDAO=new ClassInfoDAO();
						String sql3="select * from classInfo where majorID='"+majorInfoBean.getMajorID().trim()+"'";
						ArrayList classlist=classInfoDAO.excuteQuery(sql3);
						
						for(int j=0;j<classlist.size();j++)
						{
							classInfoBean=(ClassInfoBean)classlist.get(j);
							comboBoxs[2].addItem(classInfoBean.getClassName());
						}						
					}
					
				}
			}
		);
		
		
	/*	
		MajorInfoBean majorInfoBean=null;
		MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
		String sql="select * from majorInfo";
		ArrayList list=majorInfoDAO.excuteQuery(sql);
		
		int flag1=0;
		int flag2=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<comboBoxs[0].getItemCount();j++)
			{				
				if(majorInfoBean.getBelongTo().trim().equals(comboBoxs[0].getItemAt(j).toString().trim()))
				{
					flag1=1;
					break;
				}				
			}
			
			if(flag1==0)
			{
				comboBoxs[0].addItem(majorInfoBean.getBelongTo().trim());				
			}
			
			
			if(flag1==1)
			{
				flag1=0;
			}
			
			
			for(int k=0;k<comboBoxs[1].getItemCount();k++)
			{
				if(majorInfoBean.getMajorName().trim().equals(comboBoxs[1].getItemAt(k).toString().trim()))
				{
					flag2=1;
					break;
				}
			}
			
			if(flag2==0)
			{
				comboBoxs[1].addItem(majorInfoBean.getMajorName().trim());				
			}
			
			
			if(flag2==1)
			{
				flag2=0;
			}
		}
		
		
		ClassInfoBean classInfoBean=null;
		ClassInfoDAO classInfoDAO=new ClassInfoDAO();
		String sql1="select * from classInfo";
		ArrayList classList=classInfoDAO.excuteQuery(sql1);
		
		int flag3=0;
		
		for(int i=0;i<classList.size();i++)
		{
			classInfoBean=(ClassInfoBean)classList.get(i);
			
			System.out.println(classInfoBean.getClassName().trim());   
			for(int j=0;j<comboBoxs[2].getItemCount();j++)
			{				
				if(classInfoBean.getClassName().trim().equals(comboBoxs[2].getItemAt(j).toString().trim()))
				{
					flag3=1;
					break;
				}				
			
			}
			
			if(flag3==0)
			{
				comboBoxs[2].addItem(classInfoBean.getClassName().trim());				
			}
			
			
			if(flag3==1)
			{
				flag3=0;
			}
			
		}
		
		*/
	
		addstuInfo.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);
					
					
					StuInfoDAO stuInfoDAO=new StuInfoDAO();
					String sql1="select * from stuInfo";
					
					ArrayList list=stuInfoDAO.excuteQuery(sql1);
					StuInfoBean stuInfoBean=null;
					
					int flag=0;	
							
					for(int i=0;i<list.size();i++)
					{
						stuInfoBean=(StuInfoBean)list.get(i);					
					
						if(stuInfoBean.getStuID().trim().equals(idF))
						{
						
							flag=1;					
							break;
						}
						
						else
						{
							idFromTable=new StringBuffer();
						}				
					}
					
					if(flag==1)
					{
						JOptionPane.showMessageDialog(null,"已存在该学生信息!");
						System.out.println("EEEEEEEEEEEEEEEEEEE");
					}
					
					if(flag==0)
					{
						//(label的顺序:"学生学号","学生姓名","状态       ","院系名称","专业名称","班级名称"	)
	
						//(表的字段:学号、姓名、班级编号、状态、是否删除标记)
						ClassInfoDAO classInfoDAO=new ClassInfoDAO();
						String sql="select * from classInfo";
					
						ArrayList classInfoList=classInfoDAO.excuteQuery(sql);
						ClassInfoBean classInfoBean=null;
						
						for(int i=0;i<classInfoList.size();i++)
						{
							classInfoBean=(ClassInfoBean)classInfoList.get(i);
							if(classInfoBean.getClassName().trim().equals(comboBoxs[2].getSelectedItem().toString().trim()))
							break;
						}
						
						String sql2="insert into stuInfo values('"+idFromField+"','"+fields[1].getText().trim()+"','"+classInfoBean.getClassID().trim()+"','"+fields[2].getText().trim()+"','否')";
						boolean BOK=stuInfoDAO.insert(sql2);
					
						//JOptionPane.showMessageDialog(null,"操作数据库的SQL语句错误: " + sqlEx.getMessage() );
						if(BOK)
						{
							sql="insert into usersLogin values('"+idFromField+"','111111','2','否')";
							UsersDAO usersDAO=new UsersDAO();
							BOK=usersDAO.insert(sql);
							if(BOK)
							{
								JOptionPane.showMessageDialog(null,"添加成功!");
							}
							else
							{								
								JOptionPane.showMessageDialog(null,"添加失败!");							
							}
							
						}
						
						else
						{							
							JOptionPane.showMessageDialog(null,"添加失败!");							
						}						
						
					}	
					addstuInfo.setVisible(false);
				}
			}
		);
		
		
		addstuInfo.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{	
					addstuInfo.setVisible(false);
				}
			}
		);
	}

}