authcertificate.java

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

package com.comingnet.bean;
import com.db.DBUtils;
import java.sql.*;

public class AuthCertificate {
	public AuthCertificate()  
	{
	 
	}
	public boolean getUserAuth(int userid,String userclass,String auid)
	{
        Connection conn=null;
        PreparedStatement stmt=null;
        ResultSet rs=null;
        boolean flag=false;
		try
		{
			conn=DBUtils.getConnection();
			stmt=conn.prepareStatement("select * from auth_list where qxid=? and ryid=? and ryclass=?");
			stmt.setString(1,auid);
			stmt.setInt(2,userid);
			stmt.setString(3,userclass);
			rs=stmt.executeQuery();
			if(rs.next())
			{
			    flag=true;
			}else
			{
				flag=false;
			}
		}catch(Exception e)
		{
			flag=false;
		}finally
		{
			DBUtils.closeResultSet(rs);
			DBUtils.closeStatement(stmt);
			DBUtils.closeConnection(conn);
		}
		return flag;
	}

}