Reply to thread

Message

<blockquote data-quote="Voltage" data-source="post: 17890772" data-attributes="member: 391265">වැඩේ ගොඩ දාගත්ත මචන්. යන්තන් query එක ලියාගත්තා. දුකේ බෑ බන් වැඩ කරනවා ලෙසටම.MihiCherub thanks මචන් අතන මම table එකට වැඩිපුර field එකක් දාල මචන්. මට ඔයා කිවුවම තමයි මීටර් උනේ. ඒ table එකේ තියන අන්තිම field එකක මම FK කරල දාලා තිබුනෙ. දැන් වැඩේ හරිQuery එක මීට වඩා අඩුවෙන් ලියන්න පුලුවන් ක්‍රමයක් තියෙනවද. මේ query එකෙන් නම් ඕන කරන result එක එනවා[CODE]&nbsp; int row = JtableCat.getSelectedRow();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String selectedCat = JtableCat.getModel().getValueAt(row,0).toString();&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //CatName to CatID Query&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ResultSet rsCatNameToId = db.getData((&quot;SELECT cat_id FROM itemcategory WHERE cat_name='&quot;+selectedCat+&quot;'&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (rsCatNameToId.next()) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int theCatId = rsCatNameToId.getInt(&quot;cat_id&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //Main Search Query&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ResultSet rsCat = db.getData(&quot;SELECT * FROM items WHERE itemCategory_cat_id='&quot;+theCatId+&quot;'&quot;);&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DefaultTableModel dtmItems = (DefaultTableModel) JtitemTable.getModel();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dtmItems.setRowCount(0);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (rsCat.next()){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Vector vItem = new Vector();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; vItem.add(rsCat.getString(&quot;item_name&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; vItem.add(rsCat.getString(&quot;item_qty&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dtmItems.addRow(vItem);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }[/CODE]</blockquote>

[QUOTE="Voltage, post: 17890772, member: 391265"] [COLOR="Black"] [/COLOR] [SIZE="4"][COLOR="Red"] [B]වැඩේ ගොඩ දාගත්ත මචන්. යන්තන් query එක ලියාගත්තා. දුකේ බෑ බන් වැඩ කරනවා ලෙසටම. [B][COLOR="Green"]MihiCherub thanks මචන් අතන මම table එකට වැඩිපුර field එකක් දාල මචන්. මට ඔයා කිවුවම තමයි මීටර් උනේ. ඒ table එකේ තියන අන්තිම field එකක මම FK කරල දාලා තිබුනෙ. දැන් වැඩේ හරි[/COLOR][/B] Query එක මීට වඩා අඩුවෙන් ලියන්න පුලුවන් ක්‍රමයක් තියෙනවද. මේ query එකෙන් නම් ඕන කරන result එක එනවා [SIZE="1"][CODE] int row = JtableCat.getSelectedRow(); String selectedCat = JtableCat.getModel().getValueAt(row,0).toString(); //CatName to CatID Query ResultSet rsCatNameToId = db.getData(("SELECT cat_id FROM itemcategory WHERE cat_name='"+selectedCat+"'")); while (rsCatNameToId.next()) { int theCatId = rsCatNameToId.getInt("cat_id"); //Main Search Query ResultSet rsCat = db.getData("SELECT * FROM items WHERE itemCategory_cat_id='"+theCatId+"'"); DefaultTableModel dtmItems = (DefaultTableModel) JtitemTable.getModel(); dtmItems.setRowCount(0); while (rsCat.next()){ Vector vItem = new Vector(); vItem.add(rsCat.getString("item_name")); vItem.add(rsCat.getString("item_qty")); dtmItems.addRow(vItem); } }[/CODE][/SIZE] [/B][/COLOR][/SIZE] [/QUOTE]

Verification

Haya warak paha keeyada? (haya wadi kireema paha)

Latest ads

Reply to thread