Reply to thread

Message

<blockquote data-quote="pradeep0079" data-source="post: 10900690" data-attributes="member: 302518">[CODE]machan mewage table ekak create karapan ube db eke data type wenaswenna puluwan db eka wenasnum mama use karanne enterprisedb 8.3r2-------------------------------------------------------------------------------------------------------------------------------------------CREATE TABLE yourname_serials(&nbsp; serial_name character varying NOT NULL,&nbsp; serial_code integer NOT NULL,&nbsp; CONSTRAINT yourname_serials_pkey PRIMARY KEY (serial_name))oya tbale eka dan insert karapan values INSERT INTO eti_serials(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; serial_name, serial_code)&nbsp; &nbsp; VALUES ('your_serial',0);// me method eken thama serial eka generate karanne public String generatePurchaseOrderSerial() {&nbsp; &nbsp; &nbsp; &nbsp; Connection c = null;&nbsp; &nbsp; &nbsp; &nbsp; Statement s = null;&nbsp; &nbsp; &nbsp; &nbsp; ResultSet rs = null;&nbsp; &nbsp; &nbsp; &nbsp; DefaultComboBoxModel comboBoxModel = new DefaultComboBoxModel();&nbsp; &nbsp; &nbsp; &nbsp; String serial = &quot;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; String sql = &quot;SELECT lpad(to_number(serial_code)+1,6,'0') as&nbsp; serial,to_number(serial_code)+1 sid&nbsp; FROM your_serials where&nbsp; serial_name='po_serial';&quot;;&nbsp; &nbsp; &nbsp; &nbsp; String serialx = &quot;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; int tserial = 0;&nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DBConnection bConnection = new DBConnection();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c = bConnection.getDBConnection_luser();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // c.setTransactionIsolation(c.TRANSACTION_READ_COMMITTED);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c.setAutoCommit(false);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s = c.createStatement();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rs = s.executeQuery(sql);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (rs != null) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (rs.next()) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; serialx = rs.getString(&quot;serial&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; tserial = rs.getInt(&quot;sid&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String updatesql = &quot;update eti_serials set serial_code=&quot; + tserial + &quot;&nbsp; where serial_name='po_serial' &quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s.executeUpdate(updatesql);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c.commit();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rs.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return serialx;&nbsp; &nbsp; &nbsp; &nbsp; } catch (Exception e) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c.rollback();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } catch (Exception ex) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ex.printStackTrace();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return null;&nbsp; &nbsp; &nbsp; &nbsp; } finally {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (rs != null) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rs.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (s != null) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (c != null) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } catch (Exception e) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e.printStackTrace();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }private void btnNewOrderActionPerformed(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; &nbsp; // TODO add your handling code here:&nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String serial = bHelper.generatePurchaseOrderSerial_general();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtPoNo.setText(serial);&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; // oya generate order serial kiyana method eke&nbsp; mehema seen ekak thiyenawa.ekiiyanne eka serial eka gattha gaman serial_value eka update karanawa.eke problem eke wenne uba aluth order eka cancel karoth serial order eka 1 kin paninawaekiyanne api kiyamu dan thiyenne 00001 kiyala ita passe uba igawa order eka cancel karanawa 00002but database eke thiyeene update wechcha eka ekiyanne uba cancel kalata serial eka reverse wenne nehe eka nisa ubta ilaga order number eka enne 00003habai eka machine ekaka witharak num run wenne mama method ekak dannum ethakota order eka save wenakota thma serial eka update wenne ethakota oya problem eka nehe.habai meka use karanne puluwan only for one user nathnum concureency problem ennawauba me method eka use karanawanum generatePurchaseOrderSerial&nbsp; me method eke thiye serial_update query eka comment karapan.ita passe save button event ekedi me method eka call karapan&nbsp; if save is successmekata serial walue eka pass karapan ,ara issella method eken gattha serial value eka ekiiwe oya code eken gattha serial eka &nbsp; //&nbsp; &nbsp; &nbsp; &nbsp; String serial = bHelper.generatePurchaseOrderSerial_general();//&nbsp; &nbsp; txtPoNo.setText(serial);menna me widiyata convert karala ganin &nbsp;int serial = Integer.parseInt(txtPoNo.getText());in your save button if (success){&nbsp;bHelper.updatePurchaseOrderSerial_general(serial);}///public String updatePurchaseOrderSerial_general(int serial) {&nbsp; &nbsp; &nbsp; &nbsp; Connection c = null;&nbsp; &nbsp; &nbsp; &nbsp; Statement s = null;&nbsp; &nbsp; &nbsp; &nbsp; ResultSet rs = null;&nbsp; &nbsp; &nbsp; &nbsp; DefaultComboBoxModel comboBoxModel = new DefaultComboBoxModel();&nbsp; &nbsp; &nbsp; &nbsp; String serialx = &quot;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; int tserial = 0;&nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; DBConnection bConnection = new DBConnection();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c = bConnection.getDBConnection_luser();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // c.setTransactionIsolation(c.TRANSACTION_READ_COMMITTED);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c.setAutoCommit(false);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s = c.createStatement();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String updatesql = &quot;update your_serials set serial_code=&quot; + serial + &quot;&nbsp; where serial_name='po_gen' &quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s.executeUpdate(updatesql);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c.commit();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rs.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return serialx;&nbsp; &nbsp; &nbsp; &nbsp; } catch (Exception e) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c.rollback();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } catch (Exception ex) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ex.printStackTrace();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return null;&nbsp; &nbsp; &nbsp; &nbsp; } finally {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (rs != null) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rs.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (s != null) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (c != null) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } catch (Exception e) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e.printStackTrace();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }[/CODE]</blockquote>

[QUOTE="pradeep0079, post: 10900690, member: 302518"] [CODE] machan mewage table ekak create karapan ube db eke data type wenaswenna puluwan db eka wenasnum mama use karanne enterprisedb 8.3r2 ------------------------------------------------------------------------------------------------------------------------------------------- CREATE TABLE yourname_serials ( serial_name character varying NOT NULL, serial_code integer NOT NULL, CONSTRAINT yourname_serials_pkey PRIMARY KEY (serial_name) ) oya tbale eka dan insert karapan values INSERT INTO eti_serials( serial_name, serial_code) VALUES ('your_serial',0); // me method eken thama serial eka generate karanne public String generatePurchaseOrderSerial() { Connection c = null; Statement s = null; ResultSet rs = null; DefaultComboBoxModel comboBoxModel = new DefaultComboBoxModel(); String serial = ""; String sql = "SELECT lpad(to_number(serial_code)+1,6,'0') as serial,to_number(serial_code)+1 sid FROM your_serials where serial_name='po_serial';"; String serialx = ""; int tserial = 0; try { DBConnection bConnection = new DBConnection(); c = bConnection.getDBConnection_luser(); // c.setTransactionIsolation(c.TRANSACTION_READ_COMMITTED); c.setAutoCommit(false); s = c.createStatement(); rs = s.executeQuery(sql); if (rs != null) { while (rs.next()) { serialx = rs.getString("serial"); tserial = rs.getInt("sid"); } } String updatesql = "update eti_serials set serial_code=" + tserial + " where serial_name='po_serial' "; s.executeUpdate(updatesql); c.commit(); rs.close(); s.close(); c.close(); return serialx; } catch (Exception e) { try { c.rollback(); } catch (Exception ex) { ex.printStackTrace(); } return null; } finally { try { if (rs != null) { rs.close(); } if (s != null) { s.close(); } if (c != null) { c.close(); } } catch (Exception e) { e.printStackTrace(); } } } private void btnNewOrderActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try { String serial = bHelper.generatePurchaseOrderSerial_general(); txtPoNo.setText(serial); } catch (Exception e) { e.printStackTrace(); } } // oya generate order serial kiyana method eke mehema seen ekak thiyenawa. ekiiyanne eka serial eka gattha gaman serial_value eka update karanawa. eke problem eke wenne uba aluth order eka cancel karoth serial order eka 1 kin paninawa ekiyanne api kiyamu dan thiyenne 00001 kiyala ita passe uba igawa order eka cancel karanawa 00002 but database eke thiyeene update wechcha eka ekiyanne uba cancel kalata serial eka reverse wenne nehe eka nisa ubta ilaga order number eka enne 00003 habai eka machine ekaka witharak num run wenne mama method ekak dannum ethakota order eka save wenakota thma serial eka update wenne ethakota oya problem eka nehe. habai meka use karanne puluwan only for one user nathnum concureency problem ennawa uba me method eka use karanawanum generatePurchaseOrderSerial me method eke thiye serial_update query eka comment karapan. ita passe save button event ekedi me method eka call karapan if save is success mekata serial walue eka pass karapan ,ara issella method eken gattha serial value eka ekiiwe oya code eken gattha serial eka // String serial = bHelper.generatePurchaseOrderSerial_general(); // txtPoNo.setText(serial); menna me widiyata convert karala ganin int serial = Integer.parseInt(txtPoNo.getText()); in your save button if (success){ bHelper.updatePurchaseOrderSerial_general(serial); } /// public String updatePurchaseOrderSerial_general(int serial) { Connection c = null; Statement s = null; ResultSet rs = null; DefaultComboBoxModel comboBoxModel = new DefaultComboBoxModel(); String serialx = ""; int tserial = 0; try { DBConnection bConnection = new DBConnection(); c = bConnection.getDBConnection_luser(); // c.setTransactionIsolation(c.TRANSACTION_READ_COMMITTED); c.setAutoCommit(false); s = c.createStatement(); String updatesql = "update your_serials set serial_code=" + serial + " where serial_name='po_gen' "; s.executeUpdate(updatesql); c.commit(); rs.close(); s.close(); c.close(); return serialx; } catch (Exception e) { try { c.rollback(); } catch (Exception ex) { ex.printStackTrace(); } return null; } finally { try { if (rs != null) { rs.close(); } if (s != null) { s.close(); } if (c != null) { c.close(); } } catch (Exception e) { e.printStackTrace(); } } } [/CODE] [/QUOTE]

Verification

Nawa warak dahaya keeyada? (Namaya wadi kireema dahaya)

Search

Latest ads

Reply to thread