1 / 7

DT249-Information Systems Research Practice-2013-14

DT249-Information Systems Research Practice-2013-14. Programming Revision Lecture 3 Lecturer: Patrick Browne. Two Eclipse Database Projects. Assume Eclipse Standard version (Kepler) https://www.eclipse.org/downloads/index-developer.php. Run SQLite. Make folder called C:ISPR

vienna
Download Presentation

DT249-Information Systems Research Practice-2013-14

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. DT249-Information Systems Research Practice-2013-14 Programming Revision Lecture 3 Lecturer: Patrick Browne

  2. Two Eclipse Database Projects • Assume Eclipse Standard version (Kepler) https://www.eclipse.org/downloads/index-developer.php

  3. Run SQLite • Make folder called C:\ISPR • Download the Eclipse Project from ISRP page: http://www.comp.dit.ie/pbrowne/Information%20Systems%20Research%20Practice/SQLite.7z • Unzip to C:\ISPR • Change directory or folder to C:\ISPR\SQLite • Run sqlite3.exe from command prompt or click from Windows Explorer. • Type the following at SQLite prompt .open movies.db select * from actors;

  4. Eclipse SQLite • Import the Project. Use your default workspace. A workspace is a collection of projects held in a directory.

  5. Eclipse SQLite • Set the classpath to point to the JDBC driver. • Use Properties External jars: C:\ISPR\SQLite • In Eclipse Project Pane navigate to Simple.java • Run as Java Application

  6. Eclipse SQLite • In Eclipse Package Manager navigate to Simple1.java • Run as Java Application

  7. SQLite sources • Get SQLite http://www.sqlite.org/download.html • For Windows use Precompiled Binaries for Windows • Get JDBC drivers at https://bitbucket.org/xerial/sqlite-jdbc/downloads • I used sqlite-jdbc4-3.8.2-SNAPSHOT.jar • For this project SQLite and JDBC were stored in sqlite-jdbc4-3.8.2-SNAPSHOT.jar inC:\ISPR\SQLite

More Related