MAC下java使用第三方jar的方法(附赠JDBC访问SQLServer的例子）

1. 假设jar放置的目录为：/Users/alex/Desktop/java/

2. 在终端执行 export CLASSPATH=${CLASSPATH}:/Users/alex/Desktop/java/*

3. javac HelloWorld.java

4. java HelloWord

附JDBC访问SqlServer的代码：

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


public class HelloWorld {


   String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";   //加载JDBC驱动  
 
   String dbURL = "jdbc:sqlserver://10.10.1.188:1433; DatabaseName=xxxx";   //连接服务器和数据库sample  
 
   String userName = "xxxxx";   //默认用户名  
 
   String userPwd = "xxxx";   //密码  


  Connection dbConnection = null;
  Statement statement = null;
  ResultSet resultSet = null;


  public HelloWorld() {


    //Load driver
    try {
      Class.forName(driverName);
    }
    catch (ClassNotFoundException ex) {
      ex.printStackTrace();
    }
  }


  public void doWork() {


    String query = "";


    try {
      //Create connection object
      dbConnection = DriverManager.getConnection(dbURL, userName, userPwd);


      //Create Statement object
      statement = dbConnection.createStatement();
      query = "SELECT * FROM TableXXX";


      //Execute the query
      resultSet = statement.executeQuery(query);


      //Loop through the results
      while (resultSet.next()) {


          System.out.print(resultSet.getString(1));
          System.out.print(", ");
          System.out.print(resultSet.getString(2));
          System.out.print(", ");
          System.out.print(resultSet.getString(3));
          System.out.print(", ");
          System.out.print(resultSet.getString(4));
         System.out.print(", ");
          System.out.print(resultSet.getString(5));
          System.out.print(", ");
          System.out.print(resultSet.getString(6));
          System.out.print("\n"); //new line


      }
   }
    catch (SQLException ex) {
      ex.printStackTrace();
      System.out.println(query);
    }
    finally {


      try {
        if (resultSet != null)
          resultSet.close();
        if (statement != null)
          statement.close();
        if (dbConnection != null)
          dbConnection.close();
      }
      catch (SQLException ex) {
        ex.printStackTrace();
      }
    }
  }


  public static void main(String[] args) {
    HelloWorld dbTest = new HelloWorld();
    dbTest.doWork();
  }
}