JDBC API Demo 2

Jdbc2.java

/*
 * JDBC API Demo 2
 *
 * PreparedStatement is pre-compiled statement and activites include:
 *  - load the query
 *  - parse the query
 *  - execute the query
 *  - save the query
 *
 * Usage:
 * - Download the connector from http://dev.mysql.com/downloads/connector/j/
 * - Configure your classpath system variable to point to your connector .jar file.
 * - Run your MySQL server.
 * - Go to phpmyadmin and create training table with 4 columns: id, name, course, address
 * - Run:
 *    - javap com.mysql.jdbc.Driver
 *    - javac Jdbc2.java
 *    - java Jdbc2
 */

import java.sql.*;
import java.io.*;

class Jdbc2 {
  public static void main(String[] args) throws Exception {

    // Load the driver.
    Class.forName("com.mysql.jdbc.Driver");

    // Establish the connection to the existing database: training.
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost/training", "root", "");
    System.out.println("Connected!");

    // Create a statement.
    PreparedStatement pst = con.prepareStatement("INSERT INTO student (name, course, address) VALUES (?, ?, ?)");

    // Execute the query
    BufferedReader br = new BufferedReader(new InputStreamReader(System.in));

    System.out.println("Enter name");
    String name = br.readLine();

    System.out.println("Enter course");
    String course = br.readLine();

    System.out.println("Enter address");
    String address = br.readLine();

    // Replace ?s
    pst.setString(1, name);
    pst.setString(2, course);
    pst.setString(3, address);

    // Notes:
    //   execute() is for all commands.
    //   executeQuery() is for SELECT only.
    //   executeUpdate() is for INSERT, UPDATE & DELETE.
    int i = pst.executeUpdate();

    if (i > 0) {
        System.out.println(i + " record created.");
    } else {
        System.out.println("Query failure!");
    }

  }
  
}