"com.microsoft.jdbc.sqlserver.SQLServerDriver";

import java.sql.Connection;import java.sql.DriverManager;public class TestCenter {public static void main(String[] args) {String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";String dbURL = "jdbc:microsoft:sqlserver://192.168.1.109:5090; DatabaseName=anorder";String userName = "sa";String userPwd = "123";try {Class.forName(driverName);Connection conn = DriverManager.getConnection(dbURL, userName, userPwd);System.out.println("Connection Successful!");java.sql.Statement stmt = conn.createStatement();java.sql.ResultSet rs = stmt.executeQuery("select getdate() as date ");//if (rs.next()) System.err.println("@@@ >> "+rs.getString(1));java.sql.ResultSetMetaData rmd = rs.getMetaData();int cnt = rmd.getColumnCount()+1;while (rs.next()){for (int i=1; i<cnt; i++) System.err.print("\t  "+rmd.getColumnName(i)+"["+i+"]="+rs.getString(i));System.err.println( );}rs.close();stmt.close();conn.close();conn = null;System.out.println("Connection down ~ !");} catch (Exception e) {e.printStackTrace();}} }