Connection con = DriverManager.getConnection(dbURL,"sa","sa");
System.out.println("建立连接成功!");
Statement stat=con.createStatement();
result=stat.executeQuery("select TOP 10 * from master.dbo.spt_values"); System.out.println("----------------------------------------------------------");
int i=0; while(result.next()) { i++; System.out.println(String.valueOf(i)+" "+result.getString(1)+" "+result.getString(2)+" "+result.getString(3));
import java.sql.*; class SQL2005Test {
public static void main(String[] args) { ResultSet result;
String dbURL;
dbURL= "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=master";
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection(dbURL,"sa","sa");
System.out.println("建立连接成功!");
Statement stat=con.createStatement();
result=stat.executeQuery("select TOP 10 * from master.dbo.spt_values"); System.out.println("----------------------------------------------------------");
int i=0;
while(result.next())
{
i++;
System.out.println(String.valueOf(i)+" "+result.getString(1)+" "+result.getString(2)+" "+result.getString(3));
}
System.out.println("----------------------------------------------------------");
}
catch (Exception e){
e.printStackTrace();
}
}
}