在oracle自定义一个对象类型如下
create type SDPERMISSION as object
(
UserName char(32),
UserPassword char(32),
AccessPermission char(12),
UserReserved char(32)
);
在java程序里定义一个对应得类
public class SDPermission{ String UserName;
String UserPassword;
String AccessPermission;
String UserReserved;
)然后如下访问:
ArrayList myList=new ArrayList();
......
while (rs.next()) {
myList.add(rs.getObject(1));
}int lenMyList=myList.size();
SDPermission[] sDPermission=new SDPermission[lenMyList];
for(int i=0;i<lenMyList;i++){
sDPermission[i]=(SDPermission)myList.get(i);
}
编译通过,运行会出现转型异常,为什么,应该怎么做?
create type SDPERMISSION as object
(
UserName char(32),
UserPassword char(32),
AccessPermission char(12),
UserReserved char(32)
);
在java程序里定义一个对应得类
public class SDPermission{ String UserName;
String UserPassword;
String AccessPermission;
String UserReserved;
)然后如下访问:
ArrayList myList=new ArrayList();
......
while (rs.next()) {
myList.add(rs.getObject(1));
}int lenMyList=myList.size();
SDPermission[] sDPermission=new SDPermission[lenMyList];
for(int i=0;i<lenMyList;i++){
sDPermission[i]=(SDPermission)myList.get(i);
}
编译通过,运行会出现转型异常,为什么,应该怎么做?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货