各位: 小弟最近在开发式碰到了一个问题,代码如下 private DB_Conn conn=new DB_Conn();
public Vector list_goods(){ ResultSet rs=null;
Vector v=new Vector();
conn.ConnectDB();
try{
Goods goods=null;
String sql="select * from goods";
rs=conn.sm.executeQuery(sql);
while(rs.next()){
goods=new Goods();
goods.setGoods_id(rs.getInt("Goods_id"));
goods.setGoods_name(rs.getString("Goods_name"));
goods.setTypeid(rs.getInt("typeid"));
goods.setGoods_price(rs.getFloat("Goods_price"));
goods.setGoods_discount(rs.getFloat("Goods_discount"));
goods.setGoods_desc(rs.getString("Goods_desc"));
goods.setSupplier(rs.getString("supplier"));
goods.setQty(rs.getInt("qty"));
goods.setIspreferred(rs.getInt("ispreferred"));
goods.setGoods_pic(rs.getString("Goods_pic"));
v.addElement(goods);
}
// 位置1
}catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(rs!=null){
rs.close();
rs=null;
}
if(conn!=null){
conn.CloseDB();
}
}catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}
}
return v;
}
我想把return v;放到位置1 ,可是eclipse 报错,说没有返回值,请问这是怎么回事啊
public Vector list_goods(){ ResultSet rs=null;
Vector v=new Vector();
conn.ConnectDB();
try{
Goods goods=null;
String sql="select * from goods";
rs=conn.sm.executeQuery(sql);
while(rs.next()){
goods=new Goods();
goods.setGoods_id(rs.getInt("Goods_id"));
goods.setGoods_name(rs.getString("Goods_name"));
goods.setTypeid(rs.getInt("typeid"));
goods.setGoods_price(rs.getFloat("Goods_price"));
goods.setGoods_discount(rs.getFloat("Goods_discount"));
goods.setGoods_desc(rs.getString("Goods_desc"));
goods.setSupplier(rs.getString("supplier"));
goods.setQty(rs.getInt("qty"));
goods.setIspreferred(rs.getInt("ispreferred"));
goods.setGoods_pic(rs.getString("Goods_pic"));
v.addElement(goods);
}
// 位置1
}catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(rs!=null){
rs.close();
rs=null;
}
if(conn!=null){
conn.CloseDB();
}
}catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}
}
return v;
}
我想把return v;放到位置1 ,可是eclipse 报错,说没有返回值,请问这是怎么回事啊
应该贴你DB_Conn的代码看看。
{}
catch()
{}
是紧接着关系,中间不能分开的。
if(conn!=null){
conn.CloseDB();
}
}catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}
}return v;
} 其中return v的位置,写一句return null即可