Everytime i have to import my collection api for insertin and diplaying

Question

i am making web app using meteor with react and in my LedgerMaster.jsx is

   import React, { Component } from 'react';
   import { createContainer } from 'meteor/react-meteor-data';
   import { LedgerMasterApi } from '../../../api/ledgerMaster';
   import  LedgerMasterForm  from './LedgerMasterForm';
   import  LedgerMasterDiplay  from './LedgerMasterDiplay';
    class LedgerMaster extends Component {
    render(){
    return(
        <div>
          <LedgerMasterForm />
          <LedgerMasterDiplay ledgeres={this.props.ledgeres}  />
        </div>
       );
      }
    }
 export default createContainer(() => {
  return {
     ledgeres: LedgerMasterApi.find({}).fetch(),
    };
 }, LedgerMaster);

so the problem is i have to define my import { LedgerMasterApi } from '../../../api/ledgerMaster'; in both LedgerMasterForm for insertion and LedgerMasterDiplay for fetch data

Answer 1

Im not sure. try this work what u want.

use this query.

SELECT category.catnap,sub_category.subcatname  FROM category
INNER JOIN sub_category ON TRIM(category.canid) = TRIM(sub_category.canid)  ORDER BY category.catnap ASC

use this code

while(rs.next()){
       out.println(rs.getString("catnap")+"."+rs.getString("subcatname"));
}

Answer 2

    rs=stat.executeQuery("select count(catname) as numRows, catname from category group by catname");
    while(rs.next()){
        String cat="";int count=0;
       int catrow=rs.getInt("numRows");
       for (int j=1;j<=catrow.length;j++){
           count=0;
           cat=rs.getString("catname");
           system.out.println(cat);
           rs1=stat.executeQuery("SELECT sub.subcatname from sub_category sub where sub.catid="+'cat'+);

           while(rs1.next()){
               system.out.println(rs1.getString("subcategory"));
               count++;
           }
       }

}