package dbBean;

import java.sql.ResultSet;

public class order 
{
	dbConnection dbConn;
	   public order()
	   {
		   dbConn=new dbConnection();
      	   dbConn.getConnect("bookshop", "manager", "123");
	   }
       public ResultSet SearchPayed(int type)
       {
    	   ResultSet rs = null;
    	   if(type==1)
    	   {
      	  String sql="select count(*) as t from orderS where  Total_price=Payables";
      	  rs=dbConn.selectSql(sql);
    	   }
    	   if(type==2)
    	   {
    		   String sql="select count(*) as t from orderS where  Total_price<>Payables";
    	       rs=dbConn.selectSql(sql);
    	   }
    	  return rs; 
       }
       public ResultSet searchSql(String sql)
       {
    	  ResultSet rs=dbConn.selectSql(sql);
       	  return rs;
       }
       
}