perm.java

一个关于商业的网站

package com.everstar.usermanage;

import java.sql.*;
import java.io.*;
import com.everstar.database.*;

public class Perm
{
	private Database dbConn;
	public Perm(Database dbConn)
	{
		this.dbConn = dbConn;
	}
 // set user perm
	public void setPerm(int userid,String operateName)
	{
        	try
        	{
        		String DELETE_PERM = "delete from perms where userid="+userid+" and operate='"+operateName+"'";
        		dbConn.delete(DELETE_PERM);
        		String GIVE_PERM = "insert into perms values("+userid+",'"+operateName+"')";
				dbConn.insert(GIVE_PERM);
			}
        	catch( Exception e )
        	{
            	e.printStackTrace();
        	}

	}
 	//check if the user have the perm
	public  boolean getPerm(int userid,String operateName)
	{
		int i=0;
       	try
       	{
			String CHECK_PERM = "select count(*) from perms where userid="+userid+" and operate='"+operateName+"'";
			i = dbConn.count(CHECK_PERM);
        	ResultSet rs =dbConn.select(CHECK_PERM);
        	if (rs.next())
        	i = rs.getInt(1);
        	rs.close();
        	dbConn.close();

		}
       	catch( Exception e )
       	{
           	e.printStackTrace();
       	}


   		if (i==1)
   			return true;
   		else
   			return false;

	}
}