class st_test(): #st_test로 클래스 정의
def __init__(self, std_name, std_number, subject, score): #변수 4개
self.std_name = std_name
self.std_number = std_number
self.subject = subject
self.score = score
def db_create(): #db생성
sql = '''CREATE table test(
std_name varchar(16),
std_id varchar(16),
subject varchar(16)
score int,
primary key(std_name,std_id,subject, score));'''
conn = sq3.connect("lasttest.db")
cur = conn.cursor()
cur.execute(sql) #테이블 삽입
conn.commit()
cur.close()
def insert_db(): #db 연결
conn = sq3.connect('lasttest.db')
cur = conn.cursor()
cur.execute('SELECT * FROM test') #test테이블에서 전체 가져오기
records = cur.fetchall()
for (std_name, std_number,subject, score) in records:
print(std_name,std_number,subject,str(score))
conn.commit()
conn.close()
insert_db(std_name,std_number,subject, score)
댓글 입력