check.java

用java编写的人事管理系统,很好的 学习下吧

package mypro;

import java.sql.*;
import java.util.*;

public class Check
{
	private Connection con=DatabaseConnection.getConnection();
	/*验证登陆*/
	public boolean checkCodeAndPwd(UsersData ud)
	{
		try
		{
			String strLand="select count(*) from [users] where  工号=? and 用户密码=?";
			PreparedStatement ps=con.prepareStatement(strLand);
			ps.setString(1,ud.getUserCode());
			ps.setString(2,ud.getPwd());
			ResultSet rs=ps.executeQuery();
			rs.next();
			int count=rs.getInt(1);
			rs.close();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	/*验证手机信息表和进货信息表中的手机串号和供货商代码是否一致*/
	public boolean checkImeiAndlabSupplierBrief(String strimei,String strsub)
	{
		try
		{
			String strpro="select count(*) from [stockTel] where 手机串号=? and 供货商代码=?";
			PreparedStatement ps=con.prepareStatement(strpro);
			ps.setString(1,strimei);
			ps.setString(2,strsub);
			ResultSet rs=ps.executeQuery();
			rs.next();
			int count=rs.getInt(1);
			rs.close();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}	
	}
	/*验证外键关系和主键唯一约束*/
	public boolean checkPrimary(String tabname,String comname,String py)
	{
		try
		{
			String strCheck="select count(*) from ["+tabname+"] where "+comname+"=?";
			PreparedStatement ps=con.prepareStatement(strCheck);
			ps.setString(1,py);
			ResultSet rs=ps.executeQuery();
			rs.next();
			int count=rs.getInt(1);
			rs.close();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	/*验证外键关系和主键唯一约束,方法重载*/
	public boolean checkPrimary(String tabname,String comname,int py)
	{
		try
		{
			String strCheck="select count(*) from ["+tabname+"] where "+comname+"=?";
			PreparedStatement ps=con.prepareStatement(strCheck);
			ps.setInt(1,py);
			ResultSet rs=ps.executeQuery();
			rs.next();
			int count=rs.getInt(1);
			rs.close();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	/*检查此手机是否可售出货更换*/
	public boolean checkTelWhetherExist(String strstate,String strimei)
	{
		try
		{
			String strCheck="select count(*) from productsTel where 状态=? and 手机串号=?";
			PreparedStatement ps=con.prepareStatement(strCheck);
			ps.setString(1,strstate);
			ps.setString(2,strimei);
			ResultSet rs=ps.executeQuery();
			rs.next();
			int count=rs.getInt(1);
			rs.close();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	/*验证日期是否准确合理*/
	public boolean checkDate(String date)
	{
		if(date.length()!=10)
		{
			return false;
		}
		else if(date.charAt(4)=='-'||date.charAt(7)=='-')
		{
			int year=0,month=0,day=0;
			boolean bl=true;
			try
			{
				year=Integer.parseInt(date.substring(0,4));
				month=Integer.parseInt(date.substring(5,7));
				day=Integer.parseInt(date.substring(8,date.length()));
			}
			catch(NumberFormatException ne)
			{
				bl=false;
			}
			Calendar cal=Calendar.getInstance();
			Calendar can=Calendar.getInstance();
			can.set(year,month-1,day);
			if(year>9999||month>12||year<0||month<0)
			{
				bl=false;
			}
			else if(!checkMonthAndDay(year,month,day))
			{
				bl=false;
			}
			else if(!cal.after(can))
			{
				bl=false;
			}
			else
			{
				bl=true;
			}
			return bl;
		}
		else
		{
			return true;
		}
		
	}
	public boolean checkYearLeap(int year)
	{
		if(year%400==0||year%4==0&&year%100!=0)
		{
			return true;
		}
		else
		{
			return false;
		}
	}
	public boolean checkMonthAndDay(int year,int month,int day)
	{
		int[] dayArray1={0,31,28,31,30,31,30,31,31,30,31,30,31};
		int[] dayArray2={0,31,29,31,30,31,30,31,31,30,31,30,31};
		if(checkYearLeap(year))
		{
			if(day<=dayArray2[month]&&day>=1)
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		else
		{
			if(day<=dayArray1[month]&&day>=1)
			{
				return true;
			}
			else
			{
				return false;
			}
		} 
	}
	/*验证邮箱地址是否准确合理*/
	public boolean checkEmail(String email)
	{
		int n1=email.indexOf('@');
		int n2=email.indexOf('.');
		int n3=email.lastIndexOf('@');
		if(email.length()>20)
		{
			return false;
		}
		else if(n1<0||n2<0)
		{
			return false;
		}
		else if(n1==0||n2<n1||n2==n1+1||n1!=n3)
		{
			return false;
		}
		else
		{
			return true;
		}
	}
	/*验证电话号码是否准确合理*/
	public boolean checkTel(String tel)
	{
		boolean flag=false;
		int n1=tel.indexOf('-');
		if(n1==3||n1==4)
		{
			if(tel.length()<11||tel.length()>13)
			{
				flag=false;
			}
			else if(tel.indexOf("0")==0)
			{
				String before=tel.substring(0,n1);
				String after=tel.substring(n1+1,tel.length());
				for(int i=0;i<before.length();i++)
				{
					if(before.charAt(i)>='0'&&before.charAt(i)<='9')
					{
						flag=true;
						continue;
					}
					else
					{
						flag=false;
						break;
					}
				}
				if(flag==true && after.length()>6)
				{
					for(int i=0;i<after.length();i++)
					{
						if(after.charAt(i)>='0'&&after.charAt(i)<='9')
						{
							flag=true;
							continue;
						}
						else
						{
							flag=false;
							break;
						}
					}
				}
				else
				{
					flag=false;
				}
			}
			else
			{
				flag=false;
			}
		}
		else if(n1<0)
		{
			String strnum=tel.substring(0,2);
			if(tel.length()==11)
			{
				if(strnum.equals("13")||strnum.equals("15"))
				{
					for(int i=0;i<tel.length();i++)
					{
						if(tel.charAt(i)>='0'&&tel.charAt(i)<='9')
						{
							flag=true;
							continue;
						}
						else
						{
							flag=false;
							break;
						}
					}
				}
			}
			else
			{
				flag=false;
			}
		}
		return flag;
	}
	/*验证修改主键列数据时该主键列是否数据唯一*/
	public boolean checkUpdataAfterUnique(String tabname,String strcomname,String strtext,String strtable)
	{
		try
		{
			String strup="select count(*) from ["+tabname+"] where ? in(select "+strcomname+" from ["+tabname+"] where "+strcomname+"<>?)";
			PreparedStatement ps=con.prepareStatement(strup);
			ps.setString(1,strtext);
			ps.setString(2,strtable);
			ResultSet rs=ps.executeQuery();
			rs.next();
			int count=rs.getInt(1);
			rs.close();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return true;
		}
	}
	/*验证修改主键列数据时该主键列是否数据唯一，方法重载*/
	public boolean checkUpdataAfterUnique(String tabname,String strcomname,int strtext,int strtable)
	{
		try
		{
			String strup="select count(*) from ["+tabname+"] where ? in(select "+strcomname+" from ["+tabname+"] where "+strcomname+"<>?)";
			PreparedStatement ps=con.prepareStatement(strup);
			ps.setInt(1,strtext);
			ps.setInt(2,strtable);
			ResultSet rs=ps.executeQuery();
			rs.next();
			int count=rs.getInt(1);
			rs.close();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return true;
		}
	}
}