Question

Using Classes/Objects

Part-1

• Create 3 frame/label objects
• Place 2 objects side-by-side on top of the screen
• Place the 3rd object below the top 2, spanning two columns
• Display a picture in one of the top 2 objects
• Display some text(any) in each of the other 2, or text in one and navigation buttons in the other

Part-2

• Load student data from database file in a list of Student class objects
• Add navigation features, however way you see fit
• Bottom-line: picture and text should change as you navigate
• Note: use same size (dimensions) pictures

This is what I had been asked by my teacher. we have to use python programming to complete these steps but I don't understand how to do this

Answer 1

Part 1 :

# Import only those methods

# which are mentioned below, this way of

# importing methods is efficient

import tkinter as tk
import random    
root = tk.Tk()
# width x height + x_offset + y_offset:
root.geometry("170x200+30+30")     
languages = ['Python','Perl','C++','Java','Tcl/Tk']
labels = range(5)
for i in range(5):
   ct = [random.randrange(256) for x in range(3)]
   brightness = int(round(0.299*ct[0] + 0.587*ct[1] + 0.114*ct[2]))
   ct_hex = "%02x%02x%02x" % tuple(ct)
   bg_colour = '#' + "".join(ct_hex)
   l = tk.Label(root, 
                text=languages[i], 
                fg='White' if brightness < 120 else 'Black', 
                bg=bg_colour)
   l.place(x = 20, y = 30 + i*30, width=120, height=25)
root.mainloop()

Note: One can also add another LabelFrame inside another LabelFrame, as well as one can do styling of any LabelFrame like we do the styling of other widgets.

Part 2:

SQLite is a self-contained transactional relational database engine that doesn't require a server configuration, as in the case of Oracle, MySQL, etc.

Create a New Table

A string enclosing the CREATE TABLE query is passed as parameter to the execute() method of the cursor object. The following code creates the student table in the test.db database.

Example: Create a New Table in Sqlite

import sqlite3
db=sqlite3.connect('test.db')
try:        
    cur =db.cursor()
    cur.execute('''CREATE TABLE student (
    StudentID INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT (20) NOT NULL,
    age INTEGER,
    marks REAL);''')
    print ('table created successfully')
except:
    print ('error in operation')
    db.rollback()
db.close()

Example: Insert a Record in Sqlite

import sqlite3
db=sqlite3.connect('test.db')
qry="insert into student (name, age, marks) values('Rajeev', 20, 50);"
try:
    cur=db.cursor()
    cur.execute(qry)
    db.commit()
    print ("one record added successfully")
except:
    print ("error in operation")
    db.rollback()
db.close()

Example: Fetch Records

import sqlite3
db=sqlite3.connect('test.db')
sql="SELECT * from student;"
cur=db.cursor()
cur.execute(sql)
while True:
    record=cur.fetchone()
    if record==None:
        break
    print (record)
db.close()