Oracle常用代码总结(8)

java开发中的总结 大家可以看看哦

ypes.CURSOR );
cst.setInt(2, 24);*/


/**
cst = conn.prepareCall("{call select_pro(?,?,?)}");
cst.setInt(1, 2);
cst.registerOutParameter(2, java.sql.Types.VARCHAR);
cst.registerOutParameter(3, java.sql.Types.INTEGER);

cst.executeUpdate();
//System.out.println(cst.getInt(1));
System.out.println(cst.getString(2));
System.out.println(cst.getString(3));
*/


cst = conn.prepareCall("{call select_pro2(?,?)}");
cst.registerOutParameter(1, oracle.jdbc.OracleTypes.CURSOR);

cst.setInt(2, 2);
cst.setInt(2, 6);
//cst.setInt(2, 4);
cst.executeUpdate();
rs = (ResultSet) cst.getObject(1);

while(rs.next()){


System.out.println("id= "+rs.getInt(1));
System.out.println("name="+rs.getString(2));
System.out.println("age= "+rs.getInt(3));

}


} catch (SQLException e) {

e.printStackTrace();
}

}



小孙：
json的使用方法：
function shuchu(){
var j = {"城市名":"{"北京市":"昌平区","河北省":"保定市","天津市":"西城区"}};
alert(j.城市名.北京市);
alert(j.城市名.河北省);
}
注解：前面的是控件的名称，后面是值value。

--兰志琴代码--
create or replace trigger insunmoney
after update on customer
for each row
declare
-- local variables here
begin
insert into trade values(trade_seq.n
extval,:ame,'存款'
,abs(:new.money1-:old.money1),sysdate,'银行',
:new.money1,:old.money1,:new.baddress);
end insunmoney;