擅长:python、mysql、java
<p>会话成本=浮动(票价)/100.0</p>
<pre><code>iso_date = "%s-%s-%s" % (tmp[0], tmp[1], tmp[2])
entryDatetime = "%s %s " % (iso_date, start_time)
expiryDatetime = "%s %s " % (iso_date, end_time)
sql_local = """INSERT INTO customer_1.pay_and_display
(plate, machine_id, ticket_datetime, expiry_datetime, ticket_name, ticket_price)
VALUES ("%s", "%s", "%s", "%s", "%s", "%s") """ % (vrm, location_id, entryDatetime, expiryDatetime, "RINGOtest",SessionCost)
print sql_local
cursor.execute(sql_local)
</code></pre>