1 / 6

Database Programming Assignment Clarifications and Changes

Ensure successful completion of database programming assignment by following specified instructions and guidelines. Submit via email and hard copy by the due date. Utilize provided samples and resources for assistance.

brodrigez
Download Presentation

Database Programming Assignment Clarifications and Changes

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. Assignment changes and clarifications (to be on the web soon) • You can delete hw3 tables , but be careful • Create ODBC same as for Interdev; do not use NT Authentication • Program in the \\iinetsrv project space for project, wherever for hw5 • hw5 should still run when log files are unavailable • Each view should be per user • For CS logs, files are added once a day • 1 table for user, or all users in same table; your choice • Please refer to your tables with username info (e.g., [csepclab\rap].raplogs)

  2. What (and how) to turn in • E-mail Rachel (rap@cs.washington.edu) code • Hand in hard copy of: • screen shots • a README telling what extra cool features are in your assignment, and assignment rating • for each user, number of accesses by date • Due next Friday

  3. Visual J++ • New Project • Visual J++ Project • Console Application

  4. JDBC calls • Sample created for you. • Get help! Links to be added • On reserve in Engineering library: • Client/Server Programming with Java and CORBA by Robert Orfal • Database Programming with JDBC and Java by George Reese

  5. JDBC Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver"); java.sql.Connection c = DriverManager.getConnection("jdbc:odbc:entities",”login I mailed you",”passwd I mailed you"); java.sql.Statement s= c.createStatement(); java.sql.ResultSet rs; rs = s.executeQuery("Select * from [csepclab\\hongyu].Office"); java.sql.ResultSetMetaData md = rs.getMetaData(); while (rs.next()){ area.append("\nTUPLE: |"); for (int i = 1; i <= md.getColumnCount();i++){ area.append(rs.getString(i) + " | "); }

  6. Other helpful info in Java • boolean File.isDirectory() • String[] File.list()

More Related