public void addReceipt(Receipt toAdd) { connect(); try { // Create a stmt object stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); // Query the database, storing the result // in an object of type ResultSet rs = stmt.executeQuery( "SELECT * from Receipt WHERE " + "UserId='" + toAdd.getUserId() + "' AND " + "ReceiptNumber='" + toAdd.getReceiptNumber() + "' AND " + "Date='" + toAdd.getDate() + "'"); // Check if User is already in the database while (rs.next()) { System.out.println("Receipt already exists in DB."); disconnect(); return; } // end while loop stmt.executeUpdate( "INSERT INTO Receipt(UserId, ReceiptNumber, Date) VALUES ('" + toAdd.getUserId() + "', '" + toAdd.getReceiptNumber() + "', '" + toAdd.getDate() + "')"); } catch (Exception e) { e.printStackTrace(); } // end catch finally { disconnect(); } }