Answered: "com.ibm.db2.jdbc.app.DB2Driver";…

Systems Architecture

7th Edition

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Stephen D. Burd

Chapter3: Data Representation

Section: Chapter Questions

Problem 3RP

See similar textbooks

Related questions

Question

100%

import java.sql.*; import java.util.Properties; public class PreparedStatementExample { public static void main(java.lang.String[] args) { // Load the following from a properties object. String DRIVER = "com.ibm.db2.jdbc.app.DB2Driver"; String URL = "jdbc:db2://*local"; // Register the native JDBC driver. If the driver cannot // be registered, the test cannot continue. try { Class.forName(DRIVER); } catch (Exception e) { System.out.println("Driver failed to register."); System.out.println(e.getMessage()); System.exit(1); } Connection c = null; Statement s = null; // This program creates a table that is // used by prepared statements later. try { // Create the connection properties. Properties properties = new Properties (); properties.put ("user", "userid"); properties.put ("password", "password"); // Connect to the local database. c = DriverManager.getConnection(URL, properties); // Create a Statement object. s = c.createStatement(); // Delete the test table if it exists. Note that // this example assumes throughout that the collection // MYLIBRARY exists on the system. try { s.executeUpdate("DROP TABLE MYLIBRARY.MYTABLE"); } catch (SQLException e) { // Just continue... the table probably did not exist. } // Run an SQL statement that creates a table in the database. s.executeUpdate("CREATE TABLE MYLIBRARY.MYTABLE (NAME VARCHAR(20), ID INTEGER)"); } catch (SQLException sqle) { System.out.println("Database processing has failed."); System.out.println("Reason: " + sqle.getMessage()); } finally { // Close database resources try { if (s != null) { s.close(); } } catch (SQLException e) { System.out.println("Cleanup failed to close Statement."); } } // This program then uses a prepared statement to insert many // rows into the database. PreparedStatement ps = null; String[] nameArray = {"Rich", "Fred", "Mark", "Scott", "Jason", "John", "Jessica", "Blair", "Erica", "Barb"}; try { // Create a PreparedStatement object that is used to insert data into the // table. ps = c.prepareStatement("INSERT INTO MYLIBRARY.MYTABLE (NAME, ID) VALUES (?, ?)"); for (int i = 0; i < nameArray.length; i++) { ps.setString(1, nameArray[i]); // Set the Name from our array. ps.setInt(2, i+1); // Set the ID. ps.executeUpdate(); } } catch (SQLException sqle) { System.out.println("Database processing has failed."); System.out.println("Reason: " + sqle.getMessage()); } finally { // Close database resources try { if (ps != null) { ps.close(); } } catch (SQLException e) { System.out.println("Cleanup failed to close Statement."); } } // Use a prepared statement to query the database // table that has been created and return data from it. In // this example, the parameter used is arbitrarily set to // 5, meaning return all rows where the ID field is less than // or equal to 5. try { ps = c.prepareStatement("SELECT * FROM MYLIBRARY.MYTABLE " + "WHERE ID <= ?"); ps.setInt(1, 5); // Run an SQL query on the table. ResultSet rs = ps.executeQuery(); // Display all the data in the table. while (rs.next()) { System.out.println("Employee " + rs.getString(1) + " has ID " + rs.getInt(2)); } } catch (SQLException sqle) { System.out.println("Database processing has failed."); System.out.println("Reason: " + sqle.getMessage()); } finally { // Close database resources try { if (ps != null) { ps.close(); } } catch (SQLException e) { System.out.println("Cleanup failed to close Statement."); } try { if (c != null) { c.close(); } } catch (SQLException e) { System.out.println("Cleanup failed to close Connection."); } } } }.

Incorrect downvote alsi.

Expert Solution

Step by step

Solved in 3 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.