def showalldata():
        print "-------------------處理后后的數(shù)據(jù)-------------------"
        hel = opendata()
        cur = hel[1].cursor()
        cur.execute("select * from tianjia")
        res = cur.fetchall()
        for line in res:
                for h in line:
                        print h,
                print
        cur.close()
#輸入信息

def into():
        username1 = str(raw_input("請輸入您的用戶名："))
        passworld1 = str(raw_input("請輸入您的密碼："))
        address1 = str(raw_input("請輸入您的地址："))
        telnum1 = str(raw_input("請輸入您的聯(lián)系電話："))
        return username1, passworld1, address1, telnum1
#  (添加)  往數(shù)據(jù)庫中添加內(nèi)容

def adddata():
        welcome = """-------------------歡迎使用添加數(shù)據(jù)功能---------------------"""
        print welcome
        person = into()
        hel = opendata()
        hel[1].execute("insert into tianjia(username, passworld, address, telnum)values (?,?,?,?)",
                                        (person[0], person[1], person[2], person[3]))
        hel[1].commit()
        print "-----------------恭喜你數(shù)據(jù)，添加成功----------------"
        showalldata()
        hel[1].close()
#  （刪除）刪除數(shù)據(jù)庫中的內(nèi)容

def deldata():
        welcome = "------------------歡迎您使用刪除數(shù)據(jù)庫功能------------------"
        print welcome
        delchoice = raw_input("請輸入您想要刪除用戶的編號：")
        hel = opendata()              # 返回游標(biāo)conn
        hel[1].execute("delete from tianjia where id ="+delchoice)
        hel[1].commit()
        print "-----------------恭喜你數(shù)據(jù)，刪除成功----------------"
        showalldata()
        hel[1].close()
# （修改）修改數(shù)據(jù)的內(nèi)容

def alter():
        welcome = "--------------------歡迎你使用修改數(shù)據(jù)庫功能-----------------"
        print welcome
        changechoice = raw_input("請輸入你想要修改的用戶的編號:")
        hel =opendata()
        person = into()
        hel[1].execute("update tianjia set username=?, passworld= ?,address=?,telnum=? where id="+changechoice,
                                (person[0], person[1], person[2], person[3]))
        hel[1].commit()
        showalldata()
        hel[1].close()
# 查詢數(shù)據(jù)

def searchdata():
        welcome = "--------------------歡迎你使用查詢數(shù)據(jù)庫功能-----------------"
        print welcome
        choice = str(raw_input("請輸入你要查詢的用戶的編號："))
        hel = opendata()
        cur = hel[1].cursor()
        cur.execute("select * from tianjia where id="+choice)
        hel[1].commit()
        row = cur.fetchone()
        id1 = str(row[0])
        username = str(row[1])
        passworld = str(row[2])
        address = str(row[3])
        telnum = str(row[4])
        print "-------------------恭喜你，你要查找的數(shù)據(jù)如下---------------------"
        print ("您查詢的數(shù)據(jù)編號是%s" % id1)
        print ("您查詢的數(shù)據(jù)名稱是%s" % username)
        print ("您查詢的數(shù)據(jù)密碼是%s" % passworld)
        print ("您查詢的數(shù)據(jù)地址是%s" % address)
        print ("您查詢的數(shù)據(jù)電話是%s" % telnum)
        cur.close()
        hel[1].close()
# 是否繼續(xù)

def contnue1(a):
        choice = raw_input("是否繼續(xù)？（y or n):")
        if choice == 'y':
                a = 1
        else:
                a = 0
        return a

if __name__ == "__main__":
        flag = 1
        while flag:
                welcome = "---------歡迎使用仙寶數(shù)據(jù)庫通訊錄---------"
                print welcome
                choiceshow = """
請選擇您的進一步選擇：
(添加)往數(shù)據(jù)庫里面添加內(nèi)容
(刪除)刪除數(shù)據(jù)庫中內(nèi)容
(修改)修改書庫的內(nèi)容
（查詢）查詢數(shù)據(jù)的內(nèi)容
選擇您想要的進行的操作：
"""
                choice = raw_input(choiceshow)
                if choice == "添加":
                        adddata()
                        contnue1(flag)
                elif choice == "刪除":
                        deldata()
                        contnue1(flag)
                elif choice == "修改":
                        alter()
                        contnue1(flag)
                elif choice == "查詢":
                        searchdata()
                        contnue1(flag)
                else:
                        print "你輸入錯誤，請重新輸入"