info_manage.java

学生信息管理系统

  	{
  		ResultSet rs=null;
  		Database_operate DB=new Database_operate();
  		String sql=new String();
  	
  		if(action.equals("Add")) 
  		{
  			sql="select Num from studentInfo where Num='"+jTextField_Num.getText()+"'";
  			rs=DB.getResult(sql);
  			try
  			{
  				if(rs.next())
				{
					JOptionPane.showMessageDialog(null,"次学号已经存在");
				}
				else
				{
					sql="insert into studentInfo(Num,Name,Sex,Home,Race,Phone,Email,Profession,Address) ";
					sql=sql+" values('"+jTextField_Num.getText()+"',";
					sql=sql+        "'"+jTextField_Name.getText()+"',";
					sql=sql+        "'"+jTextField_Sex.getText()+"',";
					sql=sql+        "'"+jTextField_Home.getText()+"',";
					sql=sql+        "'"+jTextField_Race.getText()+"',";
					sql=sql+        "'"+jTextField_Phone.getText()+"',";
					sql=sql+        "'"+jTextField_Email.getText()+"',";
					sql=sql+        "'"+jTextField_Profession.getText()+"',";
					sql=sql+        "'"+jTextField_Address.getText()+"')";
				
					if(DB.executeSql(sql))
					{
						JOptionPane.showMessageDialog(null,"添加信息成功");
					}
					else
					{
						JOptionPane.showMessageDialog(null,"添加信息失败_DB.executeSql(sql)");
					}
				}  			
  			
  			}catch(SQLException e)
  			{
  				JOptionPane.showMessageDialog(null,"添加信息失败_SQLException");
  			}
  		}
  		//*******************************
  		else if(action.equals("Edit"))
  		{
  			sql="update studentInfo set";
  			sql=sql+" Num='"+jTextField_Num.getText()+"',";
  			sql=sql+"Name='"+jTextField_Name.getText()+"',";
  			sql=sql+"Sex='"+jTextField_Sex.getText()+"',";
  			sql=sql+"Home='"+jTextField_Home.getText()+"',";
  			sql=sql+"Race='"+jTextField_Race.getText()+"',";
  			sql=sql+"Phone='"+jTextField_Phone.getText()+"',";
  			sql=sql+"Email='"+jTextField_Email.getText()+"',";
  			sql=sql+"Profession='"+jTextField_Profession.getText()+"',";
  			sql=sql+"Address='"+jTextField_Address.getText()+"'"+" where Num='"+jTextField_Num.getText()+"'"; 	
  		
  			if(DB.executeSql(sql))
			{
				JOptionPane.showMessageDialog(null,"更新信息成功");
			}
			else
			{
				JOptionPane.showMessageDialog(null,"更新信息失败_DB.executeSql(sql)");
			}
  		}
  		//***********************************
  		else if(action.equals("Cancel"))
		{
			jTextField_Num.setText(null);
			jTextField_Name.setText(null);
			jTextField_Sex.setText(null);
			jTextField_Home.setText(null);
			jTextField_Race.setText(null);
			jTextField_Phone.setText(null);
			jTextField_Email.setText(null);
			jTextField_Profession.setText(null);
			jTextField_Address.setText(null);	
		}
		//********************************
		else if(action.equals("Close"))
		{
			this.dispose();
		}
		//***********************************
		else if(action.equals("Search"))
		{
			if(jTextField_Num.equals(null))
			{
				JOptionPane.showMessageDialog(null,"学号不能为空");
			}
			else
			{
				sql="select * from studentInfo where Num='"+jTextField_Num.getText()+"'";
				rs=DB.getResult(sql);
				try
				{
					if(rs.next())
					{
						jTextField_Num.setText(rs.getString("Num"));
						jTextField_Name.setText(rs.getString("Name"));
						jTextField_Sex.setText(rs.getString("Sex"));
						jTextField_Home.setText(rs.getString("Home"));
						jTextField_Race.setText(rs.getString("Race"));
						jTextField_Phone.setText(rs.getString("Phone"));
						jTextField_Email.setText(rs.getString("Email"));
						jTextField_Profession.setText(rs.getString("Profession"));
						jTextField_Address.setText(rs.getString("Address"));	
					}
					else
					{
						JOptionPane.showMessageDialog(null,"学号不存在");
					}
				}catch(SQLException e)
				{
					JOptionPane.showMessageDialog(null,"查询操作失败_SQLException");
				}
			}
		}
		//**************************************
		else if(action.equals("Del"))
		{
			sql="delete from studentInfo where Num='"+jTextField_Num.getText()+"'";
			if(DB.executeSql(sql))
			{
				JOptionPane.showMessageDialog(null,"删除操作成功");	
			}
			else
			{
				JOptionPane.showMessageDialog(null,"删除操作失败");
			}
		}
	}
  
}


//************************* 事件监听的接口实现 **********************

class Info_manage_Dialog_jButton_Close_actionAdapter
	implements ActionListener 
{
  	private Info_manage_Dialog adaptee;
  	Info_manage_Dialog_jButton_Close_actionAdapter(Info_manage_Dialog adaptee) 
  	{
    	this.adaptee = adaptee;
  	}

  	public void actionPerformed(ActionEvent e) 
  	{
    	adaptee.jButton_Close_actionPerformed(e);
  	}
}

class Info_manage_Dialog_jButton_Cancel_actionAdapter
    implements ActionListener 
{
  	private Info_manage_Dialog adaptee;
  	Info_manage_Dialog_jButton_Cancel_actionAdapter(Info_manage_Dialog adaptee) 
  	{
    	this.adaptee = adaptee;
  	}

  	public void actionPerformed(ActionEvent e) 
  	{
    	adaptee.jButton_Cancel_actionPerformed(e);
  	}
}

class Info_manage_Dialog_jButton_Add_actionAdapter
    implements ActionListener 
{
  	private Info_manage_Dialog adaptee;
  	Info_manage_Dialog_jButton_Add_actionAdapter(Info_manage_Dialog adaptee) 
  	{
    	this.adaptee = adaptee;
  	}

  	public void actionPerformed(ActionEvent e) 
  	{
    	adaptee.jButton_Add_actionPerformed(e);
  	}
}


class Info_manage_Dialog_jButton_Search_actionAdapter
    implements ActionListener 
{
  	private Info_manage_Dialog adaptee;
  	Info_manage_Dialog_jButton_Search_actionAdapter(Info_manage_Dialog adaptee) 
  	{
    	this.adaptee = adaptee;
  	}

  	public void actionPerformed(ActionEvent e) 
  	{
    	adaptee.jButton_Search_actionPerformed(e);
  	}	
}

class Info_manage_Dialog_jButton_Del_actionAdapter
    implements ActionListener 
{
  	private Info_manage_Dialog adaptee;
  	Info_manage_Dialog_jButton_Del_actionAdapter(Info_manage_Dialog adaptee) 
  	{
    	this.adaptee = adaptee;
  	}

  	public void actionPerformed(ActionEvent e) 
  	{
    	adaptee.jButton_Del_actionPerformed(e);
  	}
}

class Info_manage_Dialog_jButton_Edit_actionAdapter
    implements ActionListener 
{
  	private Info_manage_Dialog adaptee;
  	Info_manage_Dialog_jButton_Edit_actionAdapter(Info_manage_Dialog adaptee) 
  	{
    	this.adaptee = adaptee;
  	}

  	public void actionPerformed(ActionEvent e) 
  	{
    	adaptee.jButton_Edit_actionPerformed(e);
  	}
}