public String insertCustomerDetails(String memNo) { CustomerDBConnection c = new CustomerDBConnection(); String res = " "; ResultSet rs = null; String status = "pending"; int quantity = 1; String type = "DVD"; String fine = "0"; try { String issuedate = c.calculateIssueDate(); String duedate = c.calculateDueDate(); String query1 = "Select movieID from cart where memNo=?"; ps = con.prepareStatement(query1); ps.setString(1, memNo); rs = ps.executeQuery(); while (rs.next()) { String movieid = rs.getString(1); System.out.println("inside db"); String query = "Insert into customerdetails(membershipno,movieid,quantity,type,issueddate,duedate,status,fine) values(?,?,?,?,?,?,?,?)"; ps = con.prepareStatement(query); ps.setString(1, memNo); ps.setString(2, movieid); ps.setInt(3, quantity); ps.setString(4, type); ps.setString(5, issuedate); ps.setString(6, duedate); ps.setString(7, status); ps.setString(8, fine); ps.executeUpdate(); } String query3 = "Delete from cart where memNo=?"; ps = con.prepareStatement(query3); ps.setString(1, memNo); ps.executeUpdate(); res = "true"; } catch (Exception e) { e.printStackTrace(); } finally { try { ps.close(); } catch (SQLException e) { e.printStackTrace(); } } return res; }