Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void loginActionPerformed(java.awt.event.ActionEvent evt) {
- protected static javax.swing.JTexfield userTF;
- try{
- String pass = passTF.getText().trim();
- String user = userTF.getText().trim();
- String sql = "select uname,pass"
- + " from login "
- + "where uname = '"+user+"' "
- + "AND pass = '"+pass+"'";
- pst = (OraclePreparedStatement) conn.prepareStatement(sql);
- rs = (OracleResultSet) pst.executeQuery(sql);
- // remaining code
- }
- //catch block
- }
- private void ConOrd2ActionPerformed(java.awt.event.ActionEvent evt) {
- try{
- signin l = new signin();
- l.getComponent(0).getName();
- int rows = jTable23.getRowCount();
- String user4 = l.userTF.getText().trim();
- String sqli = "insert into orders"
- + "(o_id,item_id, order_name, uname)"
- + " values (ord_seq.nextval,?,?,'"+user4+"')";
- //o_id,item_id,order_name is inserted and uname value is added as
- //Null instead of the username value in the JTextfield in the Signin page.
- pst = (OraclePreparedStatement) conn.prepareStatement(sqli);
- for(int row =0; row < rows; row++)
- {
- String item2= (String)jTable23.getValueAt(row, 0);
- String fooname2= (String)jTable23.getValueAt(row, 1);
- pst.setString(1, item2);
- pst.setString(2, fooname2);
- pst.execute();
- }
- pst.executeUpdate();
- conn.commit();
- }
- catch(Exception e)
- {
- System.out.println(e);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement