JAVA´æ´¢¹ý³ÌºÍµ÷ÓÃ
´úÂëÄÚÈÝ
create or replace procedure batchUpdateCustomer(p_age in number) as
begin
update CUSTOMERS set AGE=AGE+1 where AGE>p_age;
end;
ÒÔÉÏ´æ´¢¹ý³ÌÓÐÒ»¸ö²ÎÊýp_age£¬´ú±í¿Í»§µÄÄêÁ䣬ӦÓóÌÐò¿É°´ÕÕÒÔÏ·½Ê½µ÷Óô洢¹ý³Ì£º
´úÂëÄÚÈÝ
tx = session.beginTransaction();
Connection con=session.connection();
String procedure = "{call batchUpdateCustomer(?) }";
CallableStatement cstmt = con.prepareCall(procedure);
cstmt.setInt(1,0); //°ÑÄêÁä²ÎÊýÉèΪ0
cstmt.executeUpdate();
tx.commit();
create or replace produre batchUpdateStudent(a in number) as
begin
update STUDENT set AGE=AGE+1 where AGE>a;
end;
µ÷ÓôúÂëÈçÏ£º
Transaction tx=session.beginSession();
Connection conn=session.connection();
String pd=”...{call batchUpdateStudent(?)}”;
CallableStatement cstmt=conn.PrepareCall(pd);
cstmt.setInt(1,20); //°ÑÄêÁäÕâ¸ö²ÎÊýÉèΪ20
tx.commit()£»
Ïà¹ØÎĵµ£º
ÒÔǰÔÚ¼ÒÌýÕÅТÏéÀÏʦµÄÊÓÆµÊ±,ÂÅ´ÎÌýµ½ÕÅÀÏʦ½²µ½ÕÆÎÕJAVA»ù´¡¶ÔÓÚÎÒÃÇÒªÀ´´«ÖDzμӾÍÒµÅàѵҪѧϰµÄпγ̵ÄÖØÒª.ÏÖÔÚ¿´À´,ÕâЩ»°ÕæµÄÒ»µã¶¼²»Îª¹ý!ÓÐЩͬѧ»òÐíûÓÐÉî¿ÌÈÏʶÕÅÀÏʦ˵µÄÕâ·¬»°,×Ô¼ºÆ½Ê±¶¯ÊÖÓÖÌ«ÉÙ.¾ÍÄÃÏÖÔÚѧµÄ¾ÍÒµÅàѵ°àµÄ¿Î³ÌÀ´Ëµ,JAVA¿ª·¢ÓõŤ¾ßÏñMYECLIPSEµÈ,ÆäʹÓÃÕæµÄÊÇÈÃÈ˸е½¾ªÏ²,ÒÔǰÕÅÀÏʦÔÚ ......
java»Øµ÷»úÖÆ£º
Èí¼þÄ£¿éÖ®¼ä×ÜÊÇ´æÔÚ×ÅÒ»¶¨µÄ½Ó¿Ú£¬´Óµ÷Ó÷½Ê½ÉÏ£¬¿ÉÒÔ°ÑËûÃÇ·ÖΪÈýÀࣺͬ²½µ÷Óᢻص÷ºÍÒì²½µ÷Óá£
ͬ²½µ÷ÓÃÊÇÒ»ÖÖ×èÈûʽµ÷Ó㬵÷Óà ·½ÒªµÈ´ý¶Ô·½Ö´ÐÐÍê±Ï²Å·µ»Ø£¬ËüÊÇÒ»ÖÖµ¥Ïòµ÷Óã»
»Øµ÷ÊÇÒ»ÖÖË«Ïòµ÷ÓÃģʽ£¬Ò²¾ÍÊÇ˵£¬±»µ÷Ó÷½ÔÚ½Ó¿Ú±»µ÷ÓÃʱҲ»áµ÷ÓöԷ½µÄ½Ó¿Ú£»
Òì²½µ÷ÓÃÊÇÒ»ÖÖÀàËÆÏûÏ¢»òʼþµÄ» ......
JavaµÄ»Øµ÷·½·¨²»ÏñcÄÇÑù¿ÉÒÔÖ±½Ó´«µÝÒ»¸ö·½·¨£¬java´«µÝµÄÊÇÒýÓã¬ËùÒÔjava¶Ô·½·¨»Øµ÷µÄ½â¾ö°ì·¨ÊÇÖ±½Ó´«µÝÒ»¸ö½Ó¿Ú£¬¶Ô½Ó¿Ú½øÐÐʵÏÖ¡£ÏÂÃæÊÇÒ»¸öÀý×Ó
Ê×Ïȶ¨ÒåÒ»¸ö½Ó¿ÚCar£¬ÓÐÒ»¸örunµÄ·½·¨ÉùÃ÷
Java´úÂë
package ocm.callback;
public interface Car {
& ......
Õ⼸Ìì¿´ÁËÍøÉÏһЩǰ±²µÄ´úÂ룬×Ô¼º¶ÔJavaʵÏÖzipÎļþµÄ½âѹ£¬Ñ¹ËõÓÐÒ»µãÀí½â£¬¹ÊдÏÂÁô×ÅÒÔºó²Î¿¼¡£
ΪÁË´¦ÀíÖÐÎÄÂÒÂëÎÊÌ⣬ʹÓÃant.jar°ü¡£
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
......