rous.java

改代码是采用JSP实现的在线办公自动化管理系统

package swing;

import com.zh.conpool.Condata;
import com.mysql.jdbc.Driver;
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;
    try{
      rs=con.executeQuery("select * from tb_rose where PerNam='"+this.name+"' and "+this.page+"=1");
      if(rs.next()){
         retun=true;
      }
    }catch(Exception e){
      System.out.println(e.getMessage());
    }
    return retun;
  }

  public void close(){
    try {
      rs.close();
      con.close();
    }
    catch (Exception ee) {
      System.out.println(ee.getMessage());
    }
    finally {
      con.close();
    }
  }
  }