Case 7 – MVC and JDBC

Think-Design-Write Test-Code

A model, view, and control implementation in a server

• Description

Having now found a way to pass messages with which you feel comfortable, you turn your attention to your next job assigned to you by your boss that is to figure out how to store and retrieve the messages for all users in a database. Your boss has instructed you that you are to use JDBC, Java Database Connectivity, with the MySQL database to accomplish this.  Your boss also says that all calls to the database are to use prepared statements.  The company you are working for enforces this in all applications for security reasons.

You begin your exploration with installing MySQL, it’s tools, and what is called the MySQL driver (see the downloads tab).

You quickly learn that you need to brush up on your SQL skills and so you begin your exploration.

• Deliverables
  1. A UML state diagram for your solution
  2. UML sequence diagrams for both your client and server solution
  3. A UML class diagram for your solution
  4. A working client and server
  5. A modification of your client, testing client, and server classes
  6. A presentation of your teams solution to the problem
• Resources
  1. An SQL Tutorial
  2. MySQL JDBC Example
  3. How to use Prepared Statements
  4. Why use Prepared Statements
  5. Java API: Class, DriverManager, Connection
  6. Visual Paradigm