From Start to Output

Listing 1. SQLServerJDBC.java can be run as a command-line application or in an IDE.

import java.io.*;

import java.sql.*;

public class SQLServerJDBC {
  public void getConnection() {
    try {
      //Create Connection
      Class.forName(
        "com.microsoft.sqlserver.jdbc.SQLServerDriver"
        );

      String url = "jdbc:sqlserver://localhost:1879";
      Connection conn = DriverManager.getConnection(
        url, "sa", "sqlserver");

      //Create a Table
      Statement stmt = conn.createStatement();
      String sql = 
        "CREATE TABLE Catalog(
        CatalogId VARCHAR(25) PRIMARY KEY," +
        "Journal VARCHAR(25), Publisher VARCHAR(25),
        Edition VARCHAR(25), Title Varchar(75), 
        Author Varchar(25))";
      stmt.execute(sql);

      //Add a Table Row
      stmt = conn.createStatement();
      sql = "INSERT INTO Catalog VALUES(
        'catalog1', 'MSDN Magazine',  'MSDN', 
        'January 2006'," +
        "'Create Reusable Project And Item Templates 
        For Your Development Team', 'Matt Milner')";
      stmt.execute(sql);

      //Obtain result set
      stmt = conn.createStatement();

      String query = "SELECT * from Catalog";
      ResultSet rs = stmt.executeQuery(query);

      while (rs.next()) {
        System.out.println("Catalog Id: " + 
          rs.getString("CatalogId"));
        System.out.println("Journal: " + 
          rs.getString("Journal"));
        System.out.println("Publisher: " + 
          rs.getString("Publisher"));
        System.out.println("Edition: " + 
          rs.getString("Edition"));
        System.out.println("Title: " + 
          rs.getString("Title"));
        System.out.println("Author: " + 
          rs.getString("Author"));
      }

      rs.close();
      stmt.close();
      conn.close();
    } catch (SQLException e) {
      System.out.println("SQLException" + 
        e.getMessage());
    } catch (ClassNotFoundException e) {
      System.out.println("ClassNotFoundException" + 
        e.getMessage());
    }
  }

  public static void main(String[] argv) {
    SQLServerJDBC jdbc = new SQLServerJDBC();
    jdbc.getConnection();
  }
}