摘要:
1、Oracle存储过程实例 CREATE OR REPLACE PROCEDURE proc_page( p_tblName IN VARCHAR, p_fields IN VARCHAR, p_order IN VARCHAR, p_pageSize IN INT := 10, p_pageIn 阅读全文
摘要:
1、含有参数的游标 declare cursor cur_my (mv number) is select * from Person where no<mv;begin for tem in cur_my(4) loop DBMS_OUTPUT.put_line('name:'||tem.name 阅读全文
摘要:
1、在数据库中创建存储过程 create or replace procedure p_proc is begin insert into testTable (id,name,age) values(seq_getid.nextval,'tiger','25'); end p_proc;2、在Hibernate中的调用publicvoidinsertInfo() { Session ses =HibernateSessionFactory.getSession();try{Connection conn = ses.connection();conn.setA 阅读全文