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();
}
}