package com.jekon.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JdbcTest
{

    /**
     * @param args
     * @throws SQLException
     */
    public static void main(String[] args) throws SQLException
    {
        // TODO Auto-generated method stub

        String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
        String url = "jdbc:sqlserver://localhost:1433;databaseName=Northwind;";
        String username = "sa";
        String password = "";
        String sql = "SELECT * FROM dbo.Customers";

        Connection conn = null;
        Statement stmt = null;
        ResultSet data = null;

        try
        {
            Class.forName(driver);
            System.out.println("Loaded Driver");

            conn = DriverManager.getConnection(url, username, password);
            System.out.println("Connected");

            stmt = conn.createStatement();

            data = stmt.executeQuery(sql);
            System.out.println("sql excute");

            while (data.next())
            {
                System.out.println(data.getObject(1) + " " + data.getObject(2)
                        + " " + data.getObject(3) + " " + data.getObject(4)
                        + " " + data.getObject(5) + " " + data.getObject(6)
                        + " " + data.getObject(7) + " " + data.getObject(8)
                        + " " + data.getObject(9) + " " + data.getObject(10)
                        + " " + data.getObject(11));
            }
        }
        catch (Exception e)
        {
            // TODO: handle exception
            e.printStackTrace();
        }
        finally
        {
            try
            {
                if (null != data)
                    data.close();
            }
            catch (Exception e2)
            {
            }
            finally
            {
                try
                {
                    if (null != stmt)
                        stmt.close();
                }
                catch (Exception e3)
                {
                    // TODO: handle exception
                }
                finally
                {
                    try
                    {
                        if (null != null)
                            conn.close();
                    }
                    catch (Exception e4)
                    {
                        // TODO: handle exception
                    }
                }
            }
            System.out.println("Source Unloaded");
        }
    }
}