편집 기록

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)

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)