\n PyQt\ub294 Python\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub9e4\uc6b0 \uac15\ub825\ud558\uace0 \uc0ac\uc6a9\uc790 \uce5c\ud654\uc801\uc778 GUI \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uac1c\ubc1c\ud560 \uc218 \uc788\ub294 \ud504\ub808\uc784\uc6cc\ud06c\uc785\ub2c8\ub2e4.
\n \ubcf8 \uac15\uc88c\uc5d0\uc11c\ub294 PyQt\ub97c \uc0ac\uc6a9\ud558\uc5ec SQLite \ubc0f MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud558\uace0, \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uace0, \ucd94\uac00, \uc218\uc815 \ubc0f \uc0ad\uc81c\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.\n<\/p>\n
\n PyQt\ub294 Qt \ub77c\uc774\ube0c\ub7ec\ub9ac\uc758 Python \ubc14\uc778\ub529\uc73c\ub85c, \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8 \ubc0f \ud234\uc744 \uc27d\uace0 \ube60\ub974\uac8c \uad6c\ucd95\ud560 \uc218 \uc788\ub294 \ub3c4\uad6c\uc785\ub2c8\ub2e4.
\n PyQt\ub294 \ub2e4\uc591\ud55c GUI \uad6c\uc131 \uc694\uc18c(\uc704\uc82f)\ub97c \uc81c\uacf5\ud558\uc5ec \uc9c1\uad00\uc801\uc778 \uc0ac\uc6a9\uc790 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc81c\uacf5\ud558\uba70,
\n \ub2e4\uc591\ud55c \ud50c\ub7ab\ud3fc\uc5d0\uc11c \ub3d9\uc791\ud569\ub2c8\ub2e4. PyQt\ub97c \uc0ac\uc6a9\ud558\uba74 \ubcf5\uc7a1\ud55c GUI\ub97c \uc27d\uac8c \uc124\uacc4\ud558\uace0,
\n \uc0ac\uc6a9\uc790\uc640 \uc0c1\ud638\uc791\uc6a9\ud560 \uc218 \uc788\ub294 \ud48d\ubd80\ud55c \uacbd\ud5d8\uc744 \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n<\/p>\n
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ub370\uc774\ud130\ub97c \uad6c\uc870\uc801\uc73c\ub85c \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud560 \uc218 \uc788\ub294 \uc2dc\uc2a4\ud15c\uc785\ub2c8\ub2e4.
\n \uc5ec\uae30\uc11c\ub294 \ub450 \uac00\uc9c0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc778 SQLite\uc640 MySQL\uc744 \uc0ac\uc6a9\ud560 \uac83\uc785\ub2c8\ub2e4.
\n \uc774 \ub458\uc740 \uac01\uac01\uc758 \ud2b9\uc9d5\uacfc \uc7a5\uc810\uc774 \uc788\uc73c\uba70, \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub530\ub77c \uc120\ud0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n<\/p>\n
\n SQLite\ub294 \ud30c\uc77c \uae30\ubc18\uc758 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc785\ub2c8\ub2e4.
\n \ucf54\ub529 \ubc0f \uad6c\ud604\uc774 \ub9e4\uc6b0 \uac04\ub2e8\ud558\uc5ec, \uc18c\uaddc\ubaa8 \ud504\ub85c\uc81d\ud2b8\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4.
\n SQLite\ub294 \uc11c\ubc84\uac00 \ud544\uc694 \uc5c6\uc73c\uba70, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ud558\ub098\uc758 \ud30c\uc77c\ub85c \uc800\uc7a5\ub418\uc5b4 \uc788\uc5b4 \uc774\ub3d9\uc774 \uc6a9\uc774\ud569\ub2c8\ub2e4.\n<\/p>\n
\n MySQL\uc740 \ubcf4\ub2e4 \ubcf5\uc7a1\ud55c \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 \uc801\ud569\ud55c \uc11c\ubc84 \uae30\ubc18\uc758 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc785\ub2c8\ub2e4.
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub97c \uc81c\uacf5\ud558\uc5ec \ub124\ud2b8\uc6cc\ud06c\ub97c \ud1b5\ud574 \uc5ec\ub7ec \ud074\ub77c\uc774\uc5b8\ud2b8\uac00 \ub370\uc774\ud130\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4.
\n \ub300\uaddc\ubaa8 \ub370\uc774\ud130 \ucc98\ub9ac\uac00 \ud544\uc694\ud560 \ub54c \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n<\/p>\n
\n SQLite\uc640 PyQt\ub97c \ud1b5\ud569\ud558\uc5ec \uac04\ub2e8\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ub9cc\ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
\n \uc5ec\uae30\uc11c\ub294 \ub370\uc774\ud130\ub97c \ucd94\uac00\ud558\uace0 \uc870\ud68c\ud558\ub294 \uae30\ubcf8\uc801\uc778 \uc608\uc81c \ucf54\ub4dc\ub97c \uc791\uc131\ud569\ub2c8\ub2e4.\n<\/p>\n
\nimport sys\nfrom PyQt5.QtWidgets import QApplication, QWidget, QVBoxLayout, QLineEdit, QPushButton, QListWidget, QLabel\nimport sqlite3\n\nclass App(QWidget):\n def __init__(self):\n super().__init__()\n self.initUI()\n self.create_connection()\n\n def initUI(self):\n self.setWindowTitle('SQLite\uc640 PyQt \uc5f0\ub3d9')\n self.setGeometry(100, 100, 400, 400)\n \n self.layout = QVBoxLayout()\n \n self.label = QLabel('\uc774\ub984 \uc785\ub825:')\n self.layout.addWidget(self.label)\n \n self.input_name = QLineEdit(self)\n self.layout.addWidget(self.input_name)\n \n self.add_button = QPushButton('\ucd94\uac00', self)\n self.add_button.clicked.connect(self.add_data)\n self.layout.addWidget(self.add_button)\n \n self.list_widget = QListWidget(self)\n self.layout.addWidget(self.list_widget)\n \n self.setLayout(self.layout)\n \n def create_connection(self):\n self.connection = sqlite3.connect('test.db')\n self.cursor = self.connection.cursor()\n self.cursor.execute('CREATE TABLE IF NOT EXISTS users (name TEXT)')\n \n def add_data(self):\n name = self.input_name.text()\n if name:\n self.cursor.execute('INSERT INTO users (name) VALUES (?)', (name,))\n self.connection.commit()\n self.input_name.clear()\n self.load_data()\n\n def load_data(self):\n self.list_widget.clear()\n self.cursor.execute('SELECT name FROM users')\n rows = self.cursor.fetchall()\n for row in rows:\n self.list_widget.addItem(row[0])\n \n def closeEvent(self, event):\n self.connection.close()\n\nif __name__ == '__main__':\n app = QApplication(sys.argv)\n ex = App()\n ex.show()\n sys.exit(app.exec_())\n<\/pre>\n3.2 \ucf54\ub4dc \uc124\uba85<\/h3>\n
\n \uc704\uc758 \ucf54\ub4dc\ub294 PyQt\ub97c \uc0ac\uc6a9\ud558\uc5ec SQLite \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0c1\ud638\uc791\uc6a9\ud558\ub294 \uac04\ub2e8\ud55c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc785\ub2c8\ub2e4.
\n \uc0ac\uc6a9\uc790\ub294 \uc785\ub825 \ud544\ub4dc\uc5d0 \uc774\ub984\uc744 \uc785\ub825\ud558\uace0 “\ucd94\uac00” \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec \ub370\uc774\ud130\ub97c
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ucd94\uac00\ud560 \uc218 \uc788\uace0, \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \ub9ac\uc2a4\ud2b8\ub85c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.
\n \uc8fc\uc694 \uae30\ub2a5\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.\n<\/p>\n
\n \uc774\ubc88 \uc139\uc158\uc5d0\uc11c\ub294 MySQL\uacfc PyQt\ub97c \uc5f0\ub3d9\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \n \uc704 \ucf54\ub4dc\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0c1\ud638\uc791\uc6a9\ud558\uae30 \uc704\ud55c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc785\ub2c8\ub2e4. \n \ubcf8 \uac15\uc88c\uc5d0\uc11c\ub294 PyQt\ub97c \uc0ac\uc6a9\ud558\uc5ec SQLite \ubc0f MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc5f0\uacb0\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uc600\uc2b5\ub2c8\ub2e4.
\n MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud558\uae30 \uc704\ud574 mysql-connector-python<\/strong> \ud328\ud0a4\uc9c0\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.
\n \uc544\ub798\uc758 \ucf54\ub4dc\ub97c \ucc38\uace0\ud558\uc5ec MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud558\uace0 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\ub294 \uc608\uc81c\ub97c \ub9cc\ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.\n<\/p>\n4.1 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uc815<\/h3>\n
\nimport sys\nfrom PyQt5.QtWidgets import QApplication, QWidget, QVBoxLayout, QLineEdit, QPushButton, QListWidget, QLabel\nimport mysql.connector\n\nclass App(QWidget):\n def __init__(self):\n super().__init__()\n self.initUI()\n self.create_connection()\n\n def initUI(self):\n self.setWindowTitle('MySQL\uacfc PyQt \uc5f0\ub3d9')\n self.setGeometry(100, 100, 400, 400)\n \n self.layout = QVBoxLayout()\n \n self.label = QLabel('\uc774\ub984 \uc785\ub825:')\n self.layout.addWidget(self.label)\n \n self.input_name = QLineEdit(self)\n self.layout.addWidget(self.input_name)\n \n self.add_button = QPushButton('\ucd94\uac00', self)\n self.add_button.clicked.connect(self.add_data)\n self.layout.addWidget(self.add_button)\n \n self.list_widget = QListWidget(self)\n self.layout.addWidget(self.list_widget)\n \n self.setLayout(self.layout)\n \n def create_connection(self):\n self.connection = mysql.connector.connect(\n host='localhost',\n user='your_username',\n password='your_password',\n database='your_database'\n )\n self.cursor = self.connection.cursor()\n self.cursor.execute('CREATE TABLE IF NOT EXISTS users (name VARCHAR(255))')\n\n def add_data(self):\n name = self.input_name.text()\n if name:\n self.cursor.execute('INSERT INTO users (name) VALUES (%s)', (name,))\n self.connection.commit()\n self.input_name.clear()\n self.load_data()\n\n def load_data(self):\n self.list_widget.clear()\n self.cursor.execute('SELECT name FROM users')\n rows = self.cursor.fetchall()\n for row in rows:\n self.list_widget.addItem(row[0])\n \n def closeEvent(self, event):\n self.connection.close()\n\nif __name__ == '__main__':\n app = QApplication(sys.argv)\n ex = App()\n ex.show()\n sys.exit(app.exec_())\n<\/pre>\n4.2 \ucf54\ub4dc \uc124\uba85<\/h3>\n
\n SQLite \uc608\uc81c\uc640 \uc720\uc0ac\ud558\uc9c0\ub9cc MySQL\uc5d0 \ub9de\uac8c \uc218\uc815\ub418\uc5c8\uc2b5\ub2c8\ub2e4.
\n \ucf54\ub4dc\uc758 \uc911\uc694\ud55c \ubd80\ubd84\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.\n<\/p>\n\n
5. \uacb0\ub860<\/h2>\n
\n PyQt\uc758 \uac15\ub825\ud55c GUI \uad6c\uc131 \uc694\uc18c\uc640 \ud568\uaed8 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\ub3d9\uc744 \ud1b5\ud574 \ud6a8\uc728\uc801\uc778 \ub370\uc774\ud130 \uad00\ub9ac\ub97c \uad6c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n \ub2e4\uc591\ud55c \ub370\uc774\ud130 \ucc98\ub9ac \ub85c\uc9c1\uc744 \ucd94\uac00\ud558\uc5ec \ub354\uc6b1 \ubc1c\uc804\ub41c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ub9cc\ub4e4\uc5b4 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n \ud559\uc2b5\ud55c \ub0b4\uc6a9\uc744 \ubc14\ud0d5\uc73c\ub85c \uc790\uc2e0\ub9cc\uc758 \ud504\ub85c\uc81d\ud2b8\ub97c \uc2dc\uc791\ud574 \ubcf4\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.\n<\/p>\n