String driverClassName =
"com.microsoft.jdbc.sqlserver.SQLServerDriver";
String databaseName = "test";
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433";
String user = "sa";
String password = "sa"
try {
Class.forName(driverClassName);
Connection conn = DriverManager.getConnection(url,user,password);
conn.setCatalog(databaseName);
java.sql.DatabaseMetaData databaseMeta = conn.getMetaData();
ResultSet rs = databaseMeta.getTables(databaseName,"dbo",null,null);
java.sql.ResultSetMetaData meta = rs.getMetaData();
int colNumber = meta.getColumnCount();
while(rs.next()){
for(int k = 1; k <= colNumber ; k++){
System.out.print(rs.getString(k) + " ");
}
System.out.println("");
// System.out.println(rs.getString(1));
}
}
catch (Exception ex) {
}
//////////////////////////////////
我得版本是sql server 2000
"com.microsoft.jdbc.sqlserver.SQLServerDriver";
String databaseName = "test";
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433";
String user = "sa";
String password = "sa"
try {
Class.forName(driverClassName);
Connection conn = DriverManager.getConnection(url,user,password);
conn.setCatalog(databaseName);
java.sql.DatabaseMetaData databaseMeta = conn.getMetaData();
ResultSet rs = databaseMeta.getTables(databaseName,"dbo",null,null);
java.sql.ResultSetMetaData meta = rs.getMetaData();
int colNumber = meta.getColumnCount();
while(rs.next()){
for(int k = 1; k <= colNumber ; k++){
System.out.print(rs.getString(k) + " ");
}
System.out.println("");
// System.out.println(rs.getString(1));
}
}
catch (Exception ex) {
}
//////////////////////////////////
我得版本是sql server 2000
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货