在SQL 语句中可以用别名的。
Sql = "select a.name,a.sex,b.companyName,b.address from test a,company b";改为:
Sql = "select a.name as Name,a.sex as Sex,b.companyName as ComName,b.address as Address from test a,company b";get 时就用:Name, Sex, ComName, Address
Sql = "select a.name,a.sex,b.companyName,b.address from test a,company b";改为:
Sql = "select a.name as Name,a.sex as Sex,b.companyName as ComName,b.address as Address from test a,company b";get 时就用:Name, Sex, ComName, Address
而ComName,Addrss等信息在 Company类中呢?
但是最好都重命名一下
或者用一下ResultSetMetaData和DatabaseMetaData来看看取得的每列的列名是什么
Iterator iterator = testList.getTestList().iterator();
while(iterator.hasNext()){
Hashtable httitle = (Hashtable) iterator.next();
String name = (String) httitle.get("name");
........
} 不用自己写类,java提供了,且随便你的结果集是什么