90 likes | 144 Views
Learn to design tasks, connect to a database, execute SQL queries, display results in a table, Threads & GUI Programming. Boost your skills now!
E N D
GUI Programming IS 313 2.18.2003
Homework #2 Either Threads Programming example Outline
Homework #2 solution • Three Commands • ShowAll • FindByName • Delete
ShowAll • No input necessary • Join to get room description • Custom display loop
FindByName • First / Last input • Prepared statement • Built-in display
Delete • Most complex command • Transaction required • Must iterate through Capacity table
Question • More GUI Programming • On to Threads?
Design task • Database URL • Connect button • If successful, • SQL query • Query type • Buttons to execute query • Table to display results