언제나 휴일

DB 설계 CREATE TABLE [dbo].News ( [nid] INT NOT NULL PRIMARY KEY IDENTITY, [title] VARCHAR(200) NOT NULL, [link] VARCHAR(200) NOT NULL, [description] VARCHAR(MAX) NOT NULL, [pubdate] DATETIME NOT NULL, [mcnt] int NOT NULL CONSTRAINT TU UNIQUE(link) ) =================================================== CREATE TABLE [dbo].Morpheme ( [mid] INT NOT NULL PRIMARY KEY IDENTITY, [word] VARCHAR(50) NOT NUL..

뉴스 테이블 CREATE TABLE [dbo].News ( [nid] INT NOT NULL PRIMARY KEY IDENTITY, [title] VARCHAR(200) NOT NULL, [link] VARCHAR(200) NOT NULL, [description] VARCHAR(MAX) NOT NULL, [pubdate] DATETIME NOT NULL, [mcnt] int NOT NULL CONSTRAINT TU UNIQUE(link) ) 형태소 테이블 CREATE TABLE [dbo].Morpheme ( [mid] INT NOT NULL PRIMARY KEY IDENTITY, [word] VARCHAR(50) NOT NULL, CONSTRAINT WU UNIQUE(word) ) 역참조 테이블(역파일..

News.py #News.py class News: def __init__(self,title,link,description,pubdate): self.title = title self.link = link self.description = description self.pubdate = pubdate @staticmethod def MakeNews(jnews): title = jnews['title'] link = jnews['link'] description = jnews['description'] pubdate = jnews['pubDate'] return News(title,link,description,pubdate) Morpheme.py #Morpheme.py - 형태소 클래스 class Mo..

Main.py import urllib.request import json class Morpheme: def __init__(self,word): self.word = word self.ref = 1 def Merge(self,other): if self.IsEqual(other): self.ref = self.ref + other.ref def IsEqual(self,other): return self.word == other.word class MorphemeParser: @staticmethod def Parse(src): morphes = list() #반환할 형태소 컬렉션 src = MorphemeParser.RemoveNonAlpha(src) msrc = src.split(' ') for e..

Book.py #Book.py class Book: def __init__(self,title,author,price,content="",publisher="",link="",imglink=""): self.title = title self.author = author self.price = price self.content = content self.publisher = publisher self.link = link self.imglink=imglink NaverBookSearcher.py #NaverBookSearcher.py import urllib.request import json from Book import Book class NaverBookSearcher: @staticmethod de..

Book.py #Book.py class Book: def __init__(self,title,author,price,content="",publisher="",link="",imglink=""): self.title = title self.author = author self.price = price self.content = content self.publisher = publisher self.link = link self.imglink=imglink NaverBookSearcher.py #NaverBookSearcher.py import urllib.request import json from Book import Book class NaverBookSearcher: @staticmethod de..

CustomSql.py #CustomSql.py import pymssql class CustomSql: def AddCustom(self, cid, cname): conn = pymssql.connect("127.0.0.1:1433","sa","1234","BigPro") cursor = conn.cursor() query =str.format("insert into Custom (CID, CNAME) values('{0}','{1}')", cid,cname) cursor.execute(query) conn.commit() conn.close() def RemoveCustom(self, ckey): conn = pymssql.connect("127.0.0.1:1433","sa","1234","BigPr..

CustomSql.py #CustomSql.py import pymssql class CustomSql: def AddCustom(self, cid, cname): conn = pymssql.connect("127.0.0.1:1433","sa","1234","BigPro") cursor = conn.cursor() query =str.format("insert into Custom (CID, CNAME) values('{0}','{1}')", cid,cname) cursor.execute(query) conn.commit() conn.close() def RemoveCustom(self, ckey): conn = pymssql.connect("127.0.0.1:1433","sa","1234","BigPr..

ProductSql.py #ProductSql.py import pymssql class ProductSql: def AddProduct(self, pid,pname,price): conn = pymssql.connect("localhost","sa","1234","BigPro") cursor = conn.cursor() query =str.format("insert into Product (PID, PNAME, Price) values('{0}','{1}',{2})", pid,pname,price) cursor.execute(query) conn.commit() conn.close() def RemoveProduct(self,pkey): conn = pymssql.connect("localhost","..

항목 추가 : addItem(항목) 항목 삭제: takeItem(항목 인덱스) 모든 항목 삭제: clear() 선택 항목 변경 이벤트: currentItemChanged 공식 QT 문서에서 자세히 살펴보기 MyWidget.py #MyWidget.py from PyQt5.QtWidgets import * from PyQt5.QtGui import * class MyWidget(QWidget): def __init__(self): super().__init__() self.setWindowTitle("리스트 박스 사용 데모") self.resize(1000,800) self.lbox = QListWidget(self) self.lbox.resize(400,600) self.te=QTextEdit(self) ..