请看下面例子.import java.sql.*;
import java.util.*;
import com.microsoft.*;public class SQLServerTest {    private static ArrayList al= new  ArrayList();    public static void main(String[] args) {        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
            String url="jdbc:microsoft:sqlserver://SaisanSvr:1433;DatabaseName=GenKa";
            String user="sa";
            String password="111";            Connection conn= DriverManager.getConnection(url,user,password);
            Statement stmt=conn.createStatement();
            String sql="select * from test1";
            ResultSet rs=stmt.executeQuery(sql);
            ResultSetMetaData rsmd = rs.getMetaData();
//获取字段名
            String sName = rsmd.getColumnName(1);
            while(rs.next()) {
                System.out.println(rs.getString("test"));
            }
        }catch(Exception e){
            e.printStackTrace();
        }    }}