package com.example.helloworld;

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

/**
 * Created by bzell on 5/2/2016.
 */
public class HelloWorld {
    public void dbConnnect(String connectionString, String userId, String password) {
        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection conn = DriverManager.getConnection(connectionString,userId,password);
            Statement statement = conn.createStatement();
            String queryString = "select top 10 CustomerID, FirstName, MiddleName, LastName from SalesLT.Customer";
            ResultSet rs = statement.executeQuery(queryString);
            while (rs.next()) {
                StringBuilder sb = new StringBuilder();
                sb.append(rs.getInt("CustomerID"));
                sb.append(" ");
                sb.append(rs.getString("FirstName"));
                sb.append(" ");
                sb.append(rs.getString("MiddleName") != null ? rs.getString("MiddleName") : "");
                sb.append(" ");
                sb.append(rs.getString("LastName"));
                System.out.println(sb.toString());
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    public static void main(String[] args) {
        HelloWorld hw = new HelloWorld();
        hw.dbConnnect("jdbc:sqlserver://localhost\\SQLEXPRESS:1433;databaseName=AdventureWorksLT2012","test1","test1");
    }
}