Reply to thread

Message

<blockquote data-quote="manarrow" data-source="post: 18934705" data-attributes="member: 524640">me thiyenne mage db class eka.. mekata anuwa thama mama insert, update, search anan manan gahala thiyenne.public class DB {&nbsp; &nbsp; public static Connection c;&nbsp; &nbsp; public static Statement st;&nbsp; &nbsp; public static ResultSet rs = null;&nbsp; &nbsp; public static Connection myConnection() throws Exception {&nbsp; &nbsp; &nbsp; &nbsp; Class.forName(&quot;com.mysql.jdbc.Driver&quot;);&nbsp; &nbsp; &nbsp; &nbsp; c = DriverManager.getConnection(&quot;jdbc:mysql://localhost:3307/inventory_control_system&quot;, &quot;root&quot;, &quot;123&quot;);&nbsp; &nbsp; &nbsp; &nbsp; return c;&nbsp; &nbsp; }&nbsp; &nbsp; public static void save(String para) throws Exception, NullPointerException {&nbsp; &nbsp; &nbsp; &nbsp; if (c == null) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myConnection();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; c.createStatement().executeUpdate(para);&nbsp; &nbsp; }&nbsp; &nbsp; public static ResultSet search(String quary) throws Exception, NullPointerException {&nbsp; &nbsp; &nbsp; &nbsp; if (c == null) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myConnection();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; rs = c.createStatement().executeQuery(quary);&nbsp; &nbsp; &nbsp; &nbsp; return rs;&nbsp; &nbsp; }}onna othana ubata oona karana insert update query dekath ekka thawath usefull dewal thiyanawa. meka me mama hadapu small inventory ekaka code ekak. therun aran karpan.&nbsp;private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {&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; DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel();&nbsp; &nbsp; &nbsp; &nbsp; int x = 0;&nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (int i = 0; i &lt; jTable1.getRowCount(); i++) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String pid = jTable1.getValueAt(i, 0).toString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String p_name = jTable1.getValueAt(i, 1).toString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String quantity = jTable1.getValueAt(i, 2).toString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String unit_price = jTable1.getValueAt(i, 3).toString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String sub_total = jTable1.getValueAt(i, 4).toString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DB.save(&quot;insert into invoice (Customer_Customer_ID, Product_Name, Unit_Price, Quntity, Discount, Net_Total, Cash, Balance, Date, Time) values &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + &quot;('&quot;+txt_CustomerID.getText()+&quot;', '&quot;+p_name+&quot;', '&quot;+unit_price+&quot;', '&quot;+quantity+&quot;', '&quot;+txt_discount.getText()+&quot;', '&quot;+txt_netTotal.getText()+&quot;', '&quot;+txt_cash.getText()+&quot;', '&quot;+txt_balance.getText()+&quot;', '&quot;+Date.getText()+&quot;', '&quot;+Time.getText()+&quot;')&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DB.search(&quot;select Invoice_ID from invoice where Invoice_ID='&quot;+jTextField3.getText()+&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(DB.rs.next()){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x =&nbsp; Integer.parseInt(DB.rs.getString(&quot;Invoice_ID&quot;).toString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DB.save(&quot;insert into invoice_registry (Invoice_Invoice_ID, Stock_Product_ID, Product_Name, Unit_Price, Quantity, Total, Cash, Balance, Date, Time) values &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + &quot;('&quot;+x+&quot;', '&quot;+pid+&quot;', '&quot;+p_name+&quot;', '&quot;+unit_price+&quot;', '&quot;+quantity+&quot;', '&quot;+sub_total+&quot;', '&quot;+txt_cash.getText()+&quot;', '&quot;+txt_balance.getText()+&quot;', '&quot;+Date.getText()+&quot;', '&quot;+Time.getText()+&quot;')&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DB.save(&quot;update stock set quantity=quantity-'&quot;+quantity+&quot;' where Product_ID ='&quot;+pid+&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } catch (Exception e) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e.printStackTrace();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; JOptionPane.showMessageDialog(rootPane, &quot;INVOICE HAS SAVED!&quot;);&nbsp; &nbsp; &nbsp; &nbsp; dtm.setRowCount(0);&nbsp; &nbsp; &nbsp; &nbsp; clearText();&nbsp; &nbsp; &nbsp; &nbsp; Customer_Name.setText(&quot;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; txt_CustomerID.setText(&quot;&quot;);&nbsp; &nbsp; }</blockquote>

[QUOTE="manarrow, post: 18934705, member: 524640"] [SIZE="5"][COLOR="Blue"]me thiyenne mage db class eka.. mekata anuwa thama mama insert, update, search anan manan gahala thiyenne.[/COLOR][/SIZE] [SIZE="3"][COLOR="Red"]public class DB { public static Connection c; public static Statement st; public static ResultSet rs = null; public static Connection myConnection() throws Exception { Class.forName("com.mysql.jdbc.Driver"); c = DriverManager.getConnection("jdbc:mysql://localhost:3307/inventory_control_system", "root", "123"); return c; } public static void save(String para) throws Exception, NullPointerException { if (c == null) { myConnection(); } c.createStatement().executeUpdate(para); } public static ResultSet search(String quary) throws Exception, NullPointerException { if (c == null) { myConnection(); } rs = c.createStatement().executeQuery(quary); return rs; } }[/COLOR][/SIZE] [SIZE="5"][COLOR="Blue"]onna othana ubata oona karana insert update query dekath ekka thawath usefull dewal thiyanawa. meka me mama hadapu small inventory ekaka code ekak. therun aran karpan. [/COLOR][/SIZE] [SIZE="3"][COLOR="Red"]private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { DefaultTableModel dtm = (DefaultTableModel)jTable1.getModel(); int x = 0; try { for (int i = 0; i < jTable1.getRowCount(); i++) { String pid = jTable1.getValueAt(i, 0).toString(); String p_name = jTable1.getValueAt(i, 1).toString(); String quantity = jTable1.getValueAt(i, 2).toString(); String unit_price = jTable1.getValueAt(i, 3).toString(); String sub_total = jTable1.getValueAt(i, 4).toString(); DB.save("insert into invoice (Customer_Customer_ID, Product_Name, Unit_Price, Quntity, Discount, Net_Total, Cash, Balance, Date, Time) values " + "('"+txt_CustomerID.getText()+"', '"+p_name+"', '"+unit_price+"', '"+quantity+"', '"+txt_discount.getText()+"', '"+txt_netTotal.getText()+"', '"+txt_cash.getText()+"', '"+txt_balance.getText()+"', '"+Date.getText()+"', '"+Time.getText()+"')"); DB.search("select Invoice_ID from invoice where Invoice_ID='"+jTextField3.getText()+"'"); if(DB.rs.next()){ x = Integer.parseInt(DB.rs.getString("Invoice_ID").toString()); } DB.save("insert into invoice_registry (Invoice_Invoice_ID, Stock_Product_ID, Product_Name, Unit_Price, Quantity, Total, Cash, Balance, Date, Time) values " + "('"+x+"', '"+pid+"', '"+p_name+"', '"+unit_price+"', '"+quantity+"', '"+sub_total+"', '"+txt_cash.getText()+"', '"+txt_balance.getText()+"', '"+Date.getText()+"', '"+Time.getText()+"')"); DB.save("update stock set quantity=quantity-'"+quantity+"' where Product_ID ='"+pid+"'"); } } catch (Exception e) { e.printStackTrace(); } JOptionPane.showMessageDialog(rootPane, "INVOICE HAS SAVED!"); dtm.setRowCount(0); clearText(); Customer_Name.setText(""); txt_CustomerID.setText(""); }[/COLOR][/SIZE] [/QUOTE]

Verification

Hath warak paha keeyada? (hatha wadikireema paha)

Search

Latest ads

Reply to thread