rous.java

企业办公自动化管理系统

package swing;

import com.zh.conpool.Condata;
import java.sql.ResultSet;

public class Rous{

  private int[] rous=new int[26];
  Condata con=new Condata();
  private String name="";
  private String page="";
  private boolean retun=false;
  private ResultSet rs=null;

  public Rous(){
    try{
        con.getConnection();
      }catch(Exception e){
        System.out.println(e.getStackTrace()+"2222222222");
      }
    }
    /**
     * in the method: name is person'name,page is that HTMLpage what it is numbers!
     */
  public boolean toInt(String name,String page){
    this.name=name;
    this.page=page;
    String sql="select * from tb_roes where PerNam='"+this.name+"' and "+this.page+"='1'";
    try{
      rs=con.executeQuery(sql);
      if(rs.next()){
       return retun=true;
      }else{
      	return retun=false;
      }
    }catch(Exception e){
      System.out.println(e.getMessage()+"11111111");
    }
    return retun;
  }

  public void close(){
    try {
      rs.close();
      con.close();
    }
    catch (Exception ee) {
      System.out.println(ee.getMessage());
    }
    finally {
      con.close();
    }
  }
  
  /*public static void main(String[] args){
  		Rous ou=new Rous();
  		boolean bo=ou.toInt("111","row126");
  		System.out.println(bo);
  	}*/
  }