概要:代码如下:public Map getorderdetail(String orderId ){String sql = "select * from orderdetails" ;sql += " where orderId=" + orderId ;sql += " order by orderDetailId" ;//注:getConnection为伪代码,用于获取数据库连接java.sql.Statement st = getConnection().createStatement() ;ResultSet rs = st.executeQuery(sql) ;Map a = new HashMap() ;OrderDetail orderDetail = new OrderDetail() ;while(rs.next()){orderDetail.setOrderDetailId(rs.getString(1)) ;orderDetail.setOrderId(rs.getString(2))
吉联新软件公司JAVA笔试题,标签:笔试大全,http://www.88haoxue.com代码如下:
public Map getorderdetail(String orderId ){
String sql = "select * from orderdetails" ;
sql += " where orderId=" + orderId ;
sql += " order by orderDetailId" ;
//注:getConnection为伪代码,用于获取数据库连接
java.sql.Statement st = getConnection().createStatement() ;
ResultSet rs = st.executeQuery(sql) ;
Map a = new HashMap() ;
OrderDetail orderDetail = new OrderDetail() ;
while(rs.next()){
orderDetail.setOrderDetailId(rs.getString(1)) ;
orderDetail.setOrderId(rs.getString(2)) ;
orderDetail.setBookId(rs.getString(3)) ;
orderDetail.setBookPrice(rs.getDouble(4)) ;
orderDetail.setBookRate(rs.getDouble (5)) ;
orderDetail.setMemo(rs.getString(6)) ;
a.put(orderDetailId , orderDetail) ;
}
return a ;
}
现需尽可能提高代码的运行效率及可维护性,请指出上面代码需改正(改进)的地方(共七种),并说明原因及改正(改进)的方法。
上一篇:人民银行财会类笔试
最新更新