이클립스에서 파이썬으로 MariaDB 연결 3)_파이썬 연동

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
32
33
34
35
36
37
38
39
40
41
42
43
·¬
import·mysql.connector·#·DB연동에·필요한·모듈·추가¬
from·mysql.connector·import·errorcode·#·DB·연동·시·Error·체크·¬
¬
#·mysql/mariaDB·환경변수¬
config·=·{¬
····'user':'scott',¬
····'password':'****',·#임의의·*로·가린겁니다¬
····'host':'127.0.0.1',¬
····'database':'work',¬
····'port':'3306'¬
}¬
¬
try:¬
····#·db·연결·객체·생성¬
····conn·=·mysql.connector.connect(**config)¬
····#·SQL·실행·객체·생성¬
····cursor·=·conn.cursor()¬
¬
····sql·=·"select·*·from·goods"¬
····cursor.execute(sql)·#sql문·실행¬
····¬
····#insert,·update,·delete는·execute()이후·커밋을·해야·적용됨¬
····#conn.commit()¬
¬
····res·=·cursor.fetchall()¬
····for·row·in·res:¬
········print(row)¬
¬
#·DB·연결·예외·처리··········¬
except·mysql.connector.Error·as·err:¬
····if·err.errno·==·errorcode.ER_ACCESS_DENIED_ERROR:¬
········print('id·or·password·오류')¬
····elif·err.errno·==·errorcode.ER_BAD_DB_ERROR:¬
········print('db·연동·오류')¬
····else:¬
········print('기타·에러:',·err)¬
····conn.rollback()·#·롤백·처리¬
finally:¬
····cursor.close();·conn.close()·#·연결·객체·닫기·¬
¬
}¬
¶
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

config 부분에 DB정보를 작성하고 connector 객체로 DB에 연결, cursor 객체로 sql문을 실행함.

환경변수, try, except 틀만 준수하고 conn, cursor 부분으로 조종

jdbc와 마찬가지로 입력, 수정, 삭제같은 경우는 execute후에 commit을 해줘야함.

<select 수행 결과>

http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python

(커넥터)