myEclipse快捷键整理
- 快速生成代码: alt+shift+s
- ctrl+shift+x 转为大写 ctrl+shift+y 转为小写
- javaScript 中代码的注释: Ctrl +Shift +C
- 复制上面一行代码: ctrl+alt+向下箭头
- 快速定位类: ctrl+shift+t
- 快速定位资源:ctrl+shift+r
js中返回的map的key对应的value取值
//使用的是Dwr异步请求框架
SetDwr.getSetTypeById(typeId,function(rtn){
//直接使用返回的数据+key值
var pay = parseFloat(**rtn.mPay**).toFixed(2);
var mGift = parseFloat(**rtn.mGift**).toFixed(2);}
java调用oracle数据库中输出参数是cursor的存储过程
Connection con = null;
ResultSet rs = null;
CallableStatement call=null;
Map<String, String> map = new HashMap<>();
try {
con = DBUtil.getConnection();
String sql = "{call HFYS_SP_GETPREPAYINFO (?,?,?)}";
call = con.prepareCall(sql);
call.setString(1, vcAccNo);
call.setString(2, vcTel);
//声明第3个参数是游标类型,注意Oracle参数是从1开始的
call.registerOutParameter(3,
oracle.jdbc.OracleTypes.CURSOR);
call.execute();
rs = (ResultSet) call.getObject(3);
if(rs.next()) {
map.put("mBalance", rs.getString("mBalance"));
}else {
map.put("mBalance", "");
}
} catch(SQLException e) {
e.printStackTrace();
throw new SQLException();
} finally {
DBUtil.close(rs, call, con);
}
return map;