请看下面例子.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();
} }}
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();
} }}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货