Java开发网 - [求助]关于getTableName返回""

Topic: [求助]关于getTableName返回""

1.[求助]关于getTableName返回""

Posted by: RockWang
Posted on: 2006-03-29 17:52

小弟近日在做一个项目,JAVA挂SQL的一个MIS
在写UPDATE语句的时候遇到了困难,就是不论怎么样,getTableName返回的全是"".(注意,不是空值,下面我验证过了)
(getTableName是java.sql.ResultSetMetaData的方法)
public abstract String getTableName(int column) throws SQLException

其他的方法,比如getColumnName(int) ,getColumnLabel(int) 都可以正确的取得我想要的值.唯有getTableName是死活不行啊~~~郁闷~~~

请各位高手帮我解决下,谢鸟~~~

另:我的开发环境
JCreator 3.50 Pro
Microsoft SQL Server 2000 SP4
Microsoft SQL Server 2000 Driver for JDBC SP3

连接语句:
public static Connection getConnection() throws SQLException {
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=northwind";
try {
Class.forName(("com.microsoft.jdbc.sqlserver.SQLServerDriver"));
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
return null;
}
return DriverManager.getConnection(url,"sa","");
}

声明:
ResultSetMetaData metaData;

赋值:
String tableName = metaData.getTableName(column+1);

""验证得到的结果......
if (tableName == "") {
System.out.println("Table name returned null.");
}
每次都很给面子的输出Table name returned null.

null验证得到的结果......
if (tableName == null) {
System.out.println("Table name returned null.");
}
这个就死活不给我面子了,""和null是不是不一样啊.

2.Re:[求助]关于getTableName返回"" [Re: RockWang]	Copy to clipboard
Posted by: RockWang Posted on: 2006-03-31 08:35 - - 试了好几种方法了,还是不能取得结果的说......高手来啊

3.Re:[求助]关于getTableName返回"" [Re: RockWang]	Copy to clipboard
Posted by: zcjl Posted on: 2006-03-31 09:28 也许是jdbc驱动的问题？我使用MySQL4.1.0 with mysql-connector-java-3.0.10-stable-bin就可以正确取得tableName

4.Re:[求助]关于getTableName返回"" [Re: RockWang]	Copy to clipboard
Posted by: RockWang Posted on: 2006-03-31 09:55 也许真的是M$的驱动不支持tableName? 那么还有问题,挂SQL的话JDBC ODBC的桥接好还是jTDS更好呢?

5.Re:[求助]关于getTableName返回"" [Re: RockWang]	Copy to clipboard
Posted by: zcjl Posted on: 2006-03-31 10:19 还是使用jtds吧，对ms sql的支持很不错的当然，也有付费版的ms sql jdbc驱动

6.Re:[求助]关于getTableName返回"" [Re: RockWang]	Copy to clipboard
Posted by: RockWang Posted on: 2006-03-31 15:42 郁闷,jTDS同样无法取得表名.......开始怀疑是不是自己的语句有问题了.......

7.Re:[求助]关于getTableName返回"" [Re: RockWang]

Copy to clipboard

Posted by: zcjl
Posted on: 2006-03-31 16:22

public void testGetTableName() throws SQLException {
    Connection conn  = getConnection();
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("select * from table1");
    ResultSetMetaData rsmd = rs.getMetaData();
    String tName = rsmd.getTableName(1);
    System.out.println(tName);
    //close()...
}

8.Re:[求助]关于getTableName返回"" [Re: RockWang]	Copy to clipboard
Posted by: RockWang Posted on: 2006-04-01 21:31 还是不成.郁闷了郁闷了,不过还是谢谢zcjl 兄的帮助,我换个方法实现好了