티스토리 뷰

Dev/Phython

[PYTHON] DB 연결

Happy Anko♡ 2017. 2. 3. 18:31


spring에서는 


application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/sample?uniCode=true&characterEncoding=utf8


python에서는 


import pymysql

conn = pymysql.connect(host='localhost', port=3306, user='root', passwd='password', db='sample')

cur = conn.cursor()

cur.execute("select current_timestamp() from dual")

print(cur.fetchone())

cur.close()

conn.close()

댓글
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
링크
«   2024/05   »
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
글 보관함