public List Select_Product(String product, String type, String startrow, String endrow) throws Exception {
        

        product = StringInsdb.getStringForInsert(product);
        type= StringInsdb.getStringForInsert(type);

              
        MyConnection Mycon = new MyConnection();
        Connection conn = Mycon.getConNotPoll();

product = Function.PreparCond_Product(product,type,"prodnameth_idx");
        
        String strSql = " select y.*"
                      + " from "
                      + "(select rownum mynum,x.* "
                      + " from "
                      + "(select xxx, ddd, yyy, zzz "
                      + " from prod ";
        
        
        if(!product.equals(""))
        {
            strSql = strSql + " where '"+ product +"'";
        }
        
        strSql = strSql + " order by prodname_th ) x ";
        strSql = strSql + " where rownum <= "+ endrow +") y";
        strSql = strSql + " where mynum >= "+ startrow;
        
        System.out.println(strSql);
        Statement stmt = conn.createStatement();
        ResultSet rst = stmt.executeQuery(strSql);      
        
        List listResult = new ArrayList();
        String[] list = new String[4];
        
        while(rst.next()){

            list[0] = StringUtil.StringConvert(rst.getString("xxx"));
            list[1] = StringUtil.StringConvert(rst.getString("ddd"));
            list[2] = StringUtil.StringConvert(rst.getString("yyy"));
            list[3] = StringUtil.StringConvert(rst.getString("zzz"));
            
            listResult.add(list);      

         }
         System.out.println("Size = " + listResult.size());
         System.out.println("OK");
         rst.close();
         conn.close();
         return listResult;
    }

@WebMethod
    public List Select_Product(@WebParam(name = "product") String product, @WebParam(name = "type") String type, @WebParam(name = "startrow") String startrow, @WebParam(name = "endrow") String endrow)throws Exception {
        // TODO implement operation
        List lstResult = new ArrayList();
        WSTisiQuery qry = new WSTisiQuery();
        
        lstResult = qry.Select_Product(product,type,startrow,endrow);
        System.out.println("size = "+lstResult.size());
        return lstResult;
    }