import java.sql.DriverManager;

import java.sql.Statement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Connection;

public class DBTest {

  Connection m_Connection = null;

  Statement m_Statement = null;

  ResultSet m_ResultSet = null;

  String m_Driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

  String m_Url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDatabase";

  public DBTest() {

    //Load driver

    try {

      Class.forName(m_Driver);

    }

    catch (ClassNotFoundException ex) {

      ex.printStackTrace();

    }

  }

  public void doWork() {

    String query = "";

    try {

      //Create connection object

      m_Connection = DriverManager.getConnection(m_Url, "userid", "password");

      

      //Create Statement object

      m_Statement = m_Connection.createStatement();

      query = "SELECT * FROM MyTable";

      //Execute the query

      m_ResultSet = m_Statement.executeQuery(query);

      //Loop through the results

      while (m_ResultSet.next()) {

          System.out.print(m_ResultSet.getString(1));

          System.out.print(", ");

          System.out.print(m_ResultSet.getString(2));

          System.out.print(", ");

          System.out.print(m_ResultSet.getString(3));

          System.out.print("\n"); //new line

          

      }

   }

    catch (SQLException ex) {

      ex.printStackTrace();

      System.out.println(query);

    }

    finally {

      try {

        if (m_ResultSet != null)

          m_ResultSet.close();

        if (m_Statement != null)

          m_Statement.close();

        if (m_Connection != null)

          m_Connection.close();

      }

      catch (SQLException ex) {

        ex.printStackTrace();

      }

    }

  }

  public static void main(String[] args) {

    DBTest dbTest = new DBTest();

    dbTest.doWork();

  }

}