String url = "jdbc:microsoft:sqlserver://IP:1433;DatabaseName=Northwind";
String user ="sa
String password = "*****";
String sqlStr = "select CustomerID, CompanyName, ContactName from Customers"; try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
out.println( "类实例化成功!" );
为什么运行到这下面的就不输出了啊???
===========================================================================
Connection con = DriverManager.getConnection( url, user, password );
out.println( "创建连接对像成功!" ); Statement st = con.createStatement();
out.println( "创建Statement成功!" ); ResultSet rs = st.executeQuery( sqlStr );
out.println( "操作数据表成功!" );
out.println( "----------------!" ); while(rs.next())
{
out.print(rs.getString("CustomerID") + " ");
out.print(rs.getString("CompanyName") + " ");
out.println(rs.getString("ContactName"));
}
rs.close();
st.close();
con.close();
}
catch(Exception err){
err.printStackTrace(System.out);
}
String url = "jdbc:microsoft:sqlserver://IP:1433;DatabaseName=Northwind";
这句是对还是错??
String user ="sa
String password = "*****";
String sqlStr = "select CustomerID, CompanyName, ContactName from Customers"; try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
out.println( "类实例化成功!" );
为什么运行到这下面的就不输出了啊???
===========================================================================
Connection con = DriverManager.getConnection( url, user, password );
out.println( "创建连接对像成功!" ); Statement st = con.createStatement();
out.println( "创建Statement成功!" ); ResultSet rs = st.executeQuery( sqlStr );
out.println( "操作数据表成功!" );
out.println( "----------------!" ); while(rs.next())
{
out.print(rs.getString("CustomerID") + " ");
out.print(rs.getString("CompanyName") + " ");
out.println(rs.getString("ContactName"));
}
rs.close();
st.close();
con.close();
}
catch(Exception err){
err.printStackTrace(System.out);
}
String url = "jdbc:microsoft:sqlserver://IP:1433;DatabaseName=Northwind";
这句是对还是错??
//其中IP为远程的IP地址值,例如202.202.201.201。
如果你的IP地址没有写错的话,建议你检查一下你的1433端口打开了没有。如果没有,可能是你没有打SQL SERVER的SP3/SP4的补丁。打了补丁,应该就OK了。