static final String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
static final String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=javadb";
static final String userName = "sa";
static final String userPwd = "1234";
Database database = new Database();
QueryDataSet queryDataSet = new QueryDataSet();
Connection Conn = null;
try {
Class.forName(driverName);
Conn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
database.setJdbcConnection(Conn);
queryDataSet.setQuery(new QueryDescriptor(database,
"select ID,NAME from T_student", null, true,
Load.ALL));
queryDataSet.open();//------------数据库连接是成功的,但执行到queryDataSet.open();时候,提示
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'T_student' 无效,事实上改表是存在的,怎么回事啊?
static final String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=javadb";
static final String userName = "sa";
static final String userPwd = "1234";
Database database = new Database();
QueryDataSet queryDataSet = new QueryDataSet();
Connection Conn = null;
try {
Class.forName(driverName);
Conn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
database.setJdbcConnection(Conn);
queryDataSet.setQuery(new QueryDescriptor(database,
"select ID,NAME from T_student", null, true,
Load.ALL));
queryDataSet.open();//------------数据库连接是成功的,但执行到queryDataSet.open();时候,提示
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'T_student' 无效,事实上改表是存在的,怎么回事啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货