Reply to thread

Message

<blockquote data-quote="sboy" data-source="post: 16616723" data-attributes="member: 36379">හිතවත් අයියලා

මේ මම හදන්නේ table එකේ තියන data ටික JTable එකකට ගන්න. 
ඒත්&nbsp; ඒක එන්නේ එක column එකක් විතරයිනේ. මගේ code එකේ වැරැද්ද හොයලා දෙන්න පුලුවන්දෝ
stuid , stuname කියල column දෙකක් තියෙනවා. stuid එක විතරයි එන්නේ

මේක මම කලේ youtube එකේ තිබුන එකක් බලාගෙන. ඒකෙ නම් තිබුනේ MSSQL වලින්. මම කරන්නේ MYSQL වලින්

තව තැන්වල තිබුනා rs2xml කියල library එකක් දාලා කරන ක්‍රමයක්. මේක Library එකක් නැතිව කරන්න බැරිද 

Java , NetBeans<img src="/styles/default/xenforo/smilies/default/happy.gif"&nbsp; class="smilie" loading="lazy" alt=":)" title="Happy&nbsp; &nbsp; :)" data-shortname=":)" /><img src="/styles/default/xenforo/smilies/default/happy.gif"&nbsp; class="smilie" loading="lazy" alt=":)" title="Happy&nbsp; &nbsp; :)" data-shortname=":)" /><img src="/styles/default/xenforo/smilies/default/happy.gif"&nbsp; class="smilie" loading="lazy" alt=":)" title="Happy&nbsp; &nbsp; :)" data-shortname=":)" />
[CODE] public RegGui() {&nbsp; &nbsp; &nbsp; &nbsp; initComponents();&nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Connection c= (Connection) dbConn.getConnection();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Statement s=c.createStatement();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ResultSet rs1= s.executeQuery(&quot;Select * From details&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ResultSetMetaData rsmetadata =(ResultSetMetaData) rs1.getMetaData();&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int columns=rsmetadata.getColumnCount();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DefaultTableModel dftm =new DefaultTableModel();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Vector column_name=new Vector();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Vector data_rows=new Vector();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (int i = 1; i &lt;columns; i++) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; column_name.addElement(rsmetadata.getColumnName(i));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; dftm.setColumnIdentifiers(column_name);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while(rs1.next()){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; data_rows=new Vector();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (int j = 1; j &lt;columns; j++) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; data_rows.addElement(rs1.getString(j));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dftm.addRow(data_rows);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; tbl1.setModel(dftm);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } catch (Exception ex) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JOptionPane.showMessageDialog(this, ex);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; }[/CODE]<img src="http://i58.tinypic.com/264hsts.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></blockquote>

[QUOTE="sboy, post: 16616723, member: 36379"] [LEFT][SIZE="3"][B][SIZE="4"]හිතවත් අයියලා මේ මම හදන්නේ table එකේ තියන data ටික JTable එකකට ගන්න. ඒත් ඒක එන්නේ එක column එකක් විතරයිනේ. මගේ code එකේ වැරැද්ද හොයලා දෙන්න පුලුවන්දෝ stuid , stuname කියල column දෙකක් තියෙනවා. stuid එක විතරයි එන්නේ මේක මම කලේ youtube එකේ තිබුන එකක් බලාගෙන. ඒකෙ නම් තිබුනේ MSSQL වලින්. මම කරන්නේ MYSQL වලින් තව තැන්වල තිබුනා rs2xml කියල library එකක් දාලා කරන ක්‍රමයක්. මේක Library එකක් නැතිව කරන්න බැරිද Java , NetBeans:):):)[/SIZE][/B] [/SIZE][/LEFT] [CODE] public RegGui() { initComponents(); try { Connection c= (Connection) dbConn.getConnection(); Statement s=c.createStatement(); ResultSet rs1= s.executeQuery("Select * From details"); ResultSetMetaData rsmetadata =(ResultSetMetaData) rs1.getMetaData(); int columns=rsmetadata.getColumnCount(); DefaultTableModel dftm =new DefaultTableModel(); Vector column_name=new Vector(); Vector data_rows=new Vector(); for (int i = 1; i <columns; i++) { column_name.addElement(rsmetadata.getColumnName(i)); } dftm.setColumnIdentifiers(column_name); while(rs1.next()){ data_rows=new Vector(); for (int j = 1; j <columns; j++) { data_rows.addElement(rs1.getString(j)); } dftm.addRow(data_rows); } tbl1.setModel(dftm); } catch (Exception ex) { JOptionPane.showMessageDialog(this, ex); } } [/CODE][IMG]http://i58.tinypic.com/264hsts.png[/IMG] [/QUOTE]

Verification

Nawa warak dahaya keeyada? (Namaya wadi kireema dahaya)

Search

Latest ads

Reply to thread