JDBC问题:如何得到一个联查结果?
awers 2005-01-01 10:20:46 例如我有2个表,SQL的查询语句如下(在查询分析器里执行无误)
String sqlSearch="select a.categoryID,a.categoryName,b.freightName
from categoryTable as a,freightTable as b
where a.categoryID='"+userInputNumber+"'";
在方法里,我的userInputNumber是获取用户输入的数值
我在编译时是正确的,但运行时,总是在获得ResultSet时抛SQL异常~~
Statement stmt = conn.createStatement();
Result rst = stmt.executeQuery(sqlSearch);
while(rst.next()){
Category category = new Category();//Category.java是放set && get的类,对应categoryTable
Freight freight = new Freight();//Freight.java同上,对应的是freightTable
category.setCategoryID(rst.getInt("a.categoryID"));//从这里抛的SQL异常
category.setCategoryName(rst.getString("a.categoryName"));
freight.setFreightName(rst.getString("b.freightName"));
}
用什么方法才能获取象这样的虚拟列名的返回结果呢……?
先谢过大家了