Java JDBC How to - Connect to SQL Express using JDBC and ODBC

Question

We would like to know how to connect to SQL Express using JDBC and ODBC.
Answer

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
//  w w  w.  j a  v  a  2 s.c o m
public class Main {

  public static void main(String args[]) throws Exception {
    Connection conn = null;
    Statement s = null;
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    conn = DriverManager
        .getConnection("jdbc:odbc:Driver={SQL Server};"
            + "Server=.\\SQLEXPRESS;" + "Trusted_Connection=yes;"
            + "Database=myDb");
    s = conn.createStatement();
    s.executeQuery("SELECT * FROM dbo.SalesSummary WHERE 0 = 1");
    ResultSet rs = s.getResultSet();
    ResultSetMetaData rsmd = rs.getMetaData();
    for (int i = 1; i <= rsmd.getColumnCount(); i++) {
      System.out.println(String.format("-- Column %d --", i));
      System.out
          .println(String.format("Column name: %s", rsmd.getColumnName(i)));
      System.out.println(String.format("Database-specific type name: %s",
          rsmd.getColumnTypeName(i)));
      System.out.println(String.format("Column size (DisplaySize): %d",
          rsmd.getColumnDisplaySize(i)));
      System.out.println(String.format("java.sql.Type of column: %d",
          rsmd.getColumnType(i)));
      System.out.println();
    }
    s.close();
    conn.close();
  }
}