qtdesigner-请假（仅仅是尝试使用软件）

下面是我给他们起的名字。

现在修改完名字之后，导出成MainWindow.ui文件

打开anaconda的shell

现在就产生了MainWindow.py,打开它
打开pycharm，创建一个新的名为askForLeave的project，把MainWindow.py移进来。
创建Leave.py作为主程序（起名废）

现在给MainWindow.py配置环境

写的代码如下

    def ask4leave(self):
        logmsg=''
        strSN=self.lineEdit_studentNumber.text()
        strCN=self.lineEdit_classNumber.text()
        strW=self.lineEdit_week.text()
        intW=int(strW)
        strO=self.lineEdit_order.text()
        intO=int(strO)
        strR=self.lineEdit_reason.text()
        print('Connecting to MSSQL...')
        cnxn = pyodbc.connect(
            'DRIVER={SQL Server};SERVER=localhost;DATABASE=register;UID=sa;PWD=gslsgsls')
        print('Connected...')
        cursor = cnxn.cursor()
        sql = "insert into 请假(学号，课程号，周次，编号，请假理由，处理状态) values（"+strSN+","+strCN+","+intW+","+\
            intO+","+strR+",'未处理'）"
        logmsg=sql
        try:
            cursor.execute(sql)
            cnxn.commit()
            cnxn.close()
            print("提交成功！")
            logmsg += "\n已提交！"
            self.lineEdit_studentNumber.clear()
            self.lineEdit_classNumber.clear()
            self.lineEdit_week.clear()
            self.lineEdit_order.clear()
            self.lineEdit_reason.clear()
            flag=1
        except:
            if flag==0:
                print("提交失败")
                logmsg += '提交失败'

现在尝试运行一下：


建立了一些脚手架

print('Connected...')
        cursor = cnxn.cursor()
        print("成功创建游标")
        print(strSN,strCN,intW,intO,strR)
        sql = "insert into registration values('" + strSN + "', '" + strCN + "', '" + intW + "', '" + intO + "', '" +strR+ "')"
        print('成功定义sql语句')
        logmsg=sql
        flag=0
        try:
            print("开始尝试")

所以问题出在赋值语句sql = "insert into registration values('" + strSN + "', '" + strCN + "', '" + intW + "', '" + intO + "', '" +strR+ "')"
原来问题出在python语句中int类型变量不能和字符串直接相加。
改成

sql = "insert into 请假(学号，课程号，周次，编号，请假理由，处理状态) values("+strSN+","+strCN+","+strW+","+strO+\
            ","+strR+",'未处理')"

现在的结果是这样的：

最后发现报错的原因还是这句sql的赋值语句，单引号忘记了，还有有些逗号是中文格式的。又修改了一下：

        sql = "insert into 请假(学号,课程号,周次,编号,请假理由,处理状态)values("+"'"+strSN+"'"+","+"'"+strCN+"'"+","\
              +strW+","+strO+","+"'"+strR+"'"+",'未处理')"

就成功了！！
所以以下是代码：

    def ask4leave(self):
        logmsg=''
        strSN=self.lineEdit_studentNumber.text()
        strCN=self.lineEdit_classNumber.text()
        strW=self.lineEdit_week.text()
        intW=int(strW)
        strO=self.lineEdit_order.text()
        intO=int(strO)
        strR=self.lineEdit_reason.text()


        print('Connecting to MSSQL...')
        cnxn = pyodbc.connect(
            'DRIVER={SQL Server};SERVER=localhost;DATABASE=register;UID=sa;PWD=gslsgsls')
        print('Connected...')
        cursor = cnxn.cursor()
        sql = "insert into 请假(学号,课程号,周次,编号,请假理由,处理状态)values("+"'"+strSN+"'"+","+"'"+strCN+"'"+","\
              +strW+","+strO+","+"'"+strR+"'"+",'未处理')"
        print(sql)
        logmsg=sql
        flag=0
        try:
            cursor.execute(sql)
            cnxn.commit()
            cnxn.close()
            print("提交成功！")
            logmsg += "\n已提交！"
            flag=1
            self.lineEdit_studentNumber.clear()
            self.lineEdit_classNumber.clear()
            self.lineEdit_week.clear()
            self.lineEdit_order.clear()
            self.lineEdit_reason.clear()
        except:
            if flag==0:
                print("提交失败")
                logmsg += '提交失败'

别忘了在setupUi里加一句：

self.pushButton.clicked.connect(self.ask4leave)