쥬 잡동사니

#!/usr/bin/env python
#-*- coding: utf-8 -*-

import os, sys
import sqlite3

def makeSqliteTable(rows):
    conn= sqlite3.connect("dbName")
    conn.text_factory= str
    c= conn.cursor()
    c.execute("DROP TABLE IF EXISTS student_info")
    c.execute("CREATE TABLE student_info (kor_name text, address text, job text, age text)")
    c.executemany("INSERT INTO student_info VALUES(?,?,?,?)",rows) 
    conn.commit()
    conn.close()

def main():
    rows= []
    rows.append("홍길동", "경기도","대학생","24살")
    rows.append("이상화", "경기도","빙상여제","26살")
    makeSqliteTable(rows)

if __name__== "__main__":
    main()