Advertisement
Guest User

Untitled

a guest
Oct 16th, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. private void loginActionPerformed(java.awt.event.ActionEvent evt) {
  2.  
  3. protected static javax.swing.JTexfield userTF;
  4.  
  5. try{
  6.  
  7. String pass = passTF.getText().trim();
  8. String user = userTF.getText().trim();
  9. String sql = "select uname,pass"
  10. + " from login "
  11. + "where uname = '"+user+"' "
  12. + "AND pass = '"+pass+"'";
  13. pst = (OraclePreparedStatement) conn.prepareStatement(sql);
  14. rs = (OracleResultSet) pst.executeQuery(sql);
  15.  
  16. // remaining code
  17. }
  18.  
  19. //catch block
  20.  
  21. }
  22.  
  23. private void ConOrd2ActionPerformed(java.awt.event.ActionEvent evt) {
  24. try{
  25. signin l = new signin();
  26. l.getComponent(0).getName();
  27. int rows = jTable23.getRowCount();
  28. String user4 = l.userTF.getText().trim();
  29. String sqli = "insert into orders"
  30. + "(o_id,item_id, order_name, uname)"
  31. + " values (ord_seq.nextval,?,?,'"+user4+"')";
  32.  
  33. //o_id,item_id,order_name is inserted and uname value is added as
  34. //Null instead of the username value in the JTextfield in the Signin page.
  35.  
  36. pst = (OraclePreparedStatement) conn.prepareStatement(sqli);
  37. for(int row =0; row < rows; row++)
  38. {
  39. String item2= (String)jTable23.getValueAt(row, 0);
  40. String fooname2= (String)jTable23.getValueAt(row, 1);
  41. pst.setString(1, item2);
  42. pst.setString(2, fooname2);
  43. pst.execute();
  44. }
  45. pst.executeUpdate();
  46. conn.commit();
  47.  
  48. }
  49.  
  50. catch(Exception e)
  51. {
  52. System.out.println(e);
  53. }
  54. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement