#-*-coding: utf-8 -*-
from PyQt4 import QtCore, QtGui, QtSql
import sys
import kinterbasdb
class LoginWindow(QtGui.QWidget):
    def __init__(self, parent=None):
        QtGui.QWidget.__init__(self, parent)
        
        self.lineEditName = QtGui.QLineEdit()
        self.lineEditDbase = QtGui.QLineEdit()
        self.lineEditPass = QtGui.QLineEdit()
        self.lineEditIp = QtGui.QLineEdit()
        self.lineEditPass.setEchoMode(2)  
        self.buttonOk = QtGui.QPushButton("Ok")              
        self.hbox = QtGui.QHBoxLayout()
        self.hbox.addWidget(self.buttonOk)
        self.form =QtGui.QFormLayout()
        self.form.addRow("Login:", self.lineEditName)
        self.form.addRow("Pass:", self.lineEditPass)
        self.form.addRow("BD:", self.lineEditDbase)
        self.form.addRow("Ip:", self.lineEditIp)
        self.form.addRow(self.hbox)
        self.setLayout(self.form)
        self.lineEditPass.setFocus()
        
        self.buttonOk.clicked.connect(self.on_Ok)
    def on_Ok(self):
       
        
        host = "192.168.1.88:E:\BD\BD1.FDB"
        BDUSER = "XXXX"
        BDPASSWORD = "XXX" 
        #raw_input ("password   ")
        con = kinterbasdb.connect(dsn=host,user=BDUSER,password=BDPASSWORD)
        cur = con.cursor()
        cur.execute('SELECT* FROM TABLE1')
        for row in cur:
            print 'ID', row[0]
            print 'NAME', row[1]
        
        
#Окно для подтверждения закрытия       
    def closeEvent(self, event):
        reply = QtGui.QMessageBox.question(self, 'Message',
            "Are you sure to quit?", QtGui.QMessageBox.Yes, QtGui.QMessageBox.No)
        if reply == QtGui.QMessageBox.Yes:
            event.accept()
        else:
            event.ignore()
app = QtGui.QApplication(sys.argv)
win = LoginWindow()
win.show()              
sys.exit(app.exec_())