checkusername.java

来自「功能是公安和学校的管理系统,用struts+hibernate+spring等匡」· Java 代码 · 共 69 行

package com.comingnet.bean;
import java.sql.*;
import com.db.*;
public  class CheckUserName {
	static Connection conn=null;
	static PreparedStatement stmt=null;
	static ResultSet rs=null;
	public CheckUserName()
	{
		
	}
	public static boolean isExistUsername(String username,String userclass)
	{
		boolean flag=false;
		try
		{
			String sqlStr="";
			if(userclass.equals("1"))
				sqlStr="select * from m_student where xszh=?";
			else if(userclass.equals("2"))
				sqlStr="select * from m_teacher where jszh=?";
			conn=DBUtils.getConnection();
			stmt=conn.prepareStatement(sqlStr);
            stmt.setString(1,username);
			rs=stmt.executeQuery();
			if(rs.next())
				flag=true;
			else 
				flag=false;
		}catch(Exception e)
		{
			System.out.println(e);
		}finally
		{
			DBUtils.closeResultSet(rs);
			DBUtils.closeStatement(stmt);
			DBUtils.closeConnection(conn);
		}
	  return flag;	
	}
	public static boolean isExistUsernumber(String sxh)
	{
		boolean flag=false;
		try
		{
			String sqlStr="";
			sqlStr="select * from m_student where xsxh=?";
			conn=DBUtils.getConnection();
			stmt=conn.prepareStatement(sqlStr);
            stmt.setString(1,sxh);
			rs=stmt.executeQuery();
			if(rs.next())
				flag=true;
			else 
				flag=false;
		}catch(Exception e)
		{
			System.out.println(e);
		}finally
		{
			DBUtils.closeResultSet(rs);
			DBUtils.closeStatement(stmt);
			DBUtils.closeConnection(conn);
		}
	  return flag;
	}

}