给各位大哥看一下我的源程序import java.sql.*;
public class DBConn {
public static void main(String[] args) throws Exception {
String id=null;
String name=null;
String sql="select * from student";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xing","","");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
id=rs.getString(1);
name=rs.getString(2);
System.out.println("id"+id);
System.out.println("name"+name);
}
rs.close();
stmt.close();
}
} 帮帮忙~~~
public class DBConn {
public static void main(String[] args) throws Exception {
String id=null;
String name=null;
String sql="select * from student";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xing","","");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
id=rs.getString(1);
name=rs.getString(2);
System.out.println("id"+id);
System.out.println("name"+name);
}
rs.close();
stmt.close();
}
} 帮帮忙~~~
看是不是防火墙什么的造成的.
或者是你的sqlserver是不是不是1433端口的.
用JCREATE连接JDBC,第一次看过~~
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=NGSoft","sa",""); 再请问一下,这里的DatabaseName写的是数据库名还是数据源名呢???
谢谢大家的帮忙!!