1 / 5

MySQL Database Server

MySQL Database Server. Popular open source database server JDBC Connector Allows connectivity to a number of databases through java programs JDBC API used to connect to MySQL server Example classes: DriverManager Connection Statement. Mission Map Editor -Architecture. XML.

yamal
Download Presentation

MySQL Database Server

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MySQL Database Server • Popular open source database server • JDBC Connector • Allows connectivity to a number of databases through java programs • JDBC API used to connect to MySQL server • Example classes: • DriverManager • Connection • Statement

  2. Mission Map Editor-Architecture XML Mission Map Model VT Model DB

  3. DB Connectivity In MMEditor Provide high level functions Provide query level functions Encapsulate JDBC constructs: Driver, Connection, Statement

  4. Database Interaction in MissionMapEditor • Three classes involved: • MissionDbManager • Methods • saveMaptoDB() – save a copy of the missionmapto database • loadMapFromDb() – load a missionmap from database • MissionMapDbUtility • Methods • getStatement() – creates a statement object from JDBC connection • MissionDAO • Methods • insertMission- overloaded, inserts mission data into database • getMissions() – returns a list object containing the missions currently stored in database

  5. Current Tasks • Refine database interaction functionality of Mission Map Editor • Add high level updateMapToDb() method to MissionDbManagerclass • Add query level methods to MissionDAOclass • updateMission() – query level method to execute update commands on database • deleteMission() – query level method to delete a mission from the current database • Initial design of the Vulnerability Tracker tool

More Related