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()£»
Ïà¹ØÎĵµ£º
ϱßÊÇ×Ô¼º¶ÔÀàµÄһЩʹÓÃÈÏʶ£¬Èç¹ûÓв»¶ÔµÄ£¬¾´Çë´ïÈËÖ¸Õý¡£
ÈκÎÀàµÄʹÓö¼¾Àú£ºÀà¼ÓÔØºÍÀà³õʼ»¯µÄ½×¶Î¡£
Àà³õʼ»¯:
*ÆÕͨ³ÉÔ±ÊôÐÔ£º
1.ϵͳĬÈϳõʼ»¯£¬»ù±¾ÀàÐÍĬÈÏΪ0»òfalse£¬ÒýÓÃÀàÐÍĬÈÏΪnull¡£
2.ÉùÃ÷ʱÏÔʾ³õʼ»¯»òÆÕͨ³õʼ»¯¿é(×¢Ò⣺ÆÕͨ³õʼ»¯Ö»ÓÐÔÚnew¹¹Ô캯Êý´´½¨ÊµÀýʱ£¬²Å»á±»×Ô¶¯µ÷ ......
//ÇóÁ½ÊýµÄ×î´ó¹«Ô¼ÊýºÍ×îС¹«±¶Êý
import java.util.*;
public class Dais02
{
public static void main(String args[])
{
int m,n;
Scanner s = new Scanner(System.in);
System.out.println("ÇëÊäÈëÄãÏëÒªÊÇÊý×Ö");
m = s.nextInt();
n ......
java»Øµ÷»úÖÆ£º
Èí¼þÄ£¿éÖ®¼ä×ÜÊÇ´æÔÚ×ÅÒ»¶¨µÄ½Ó¿Ú£¬´Óµ÷Ó÷½Ê½ÉÏ£¬¿ÉÒÔ°ÑËûÃÇ·ÖΪÈýÀࣺͬ²½µ÷Óᢻص÷ºÍÒì²½µ÷Óá£
ͬ²½µ÷ÓÃÊÇÒ»ÖÖ×èÈûʽµ÷Ó㬵÷Óà ·½ÒªµÈ´ý¶Ô·½Ö´ÐÐÍê±Ï²Å·µ»Ø£¬ËüÊÇÒ»ÖÖµ¥Ïòµ÷Óã»
»Øµ÷ÊÇÒ»ÖÖË«Ïòµ÷ÓÃģʽ£¬Ò²¾ÍÊÇ˵£¬±»µ÷Ó÷½ÔÚ½Ó¿Ú±»µ÷ÓÃʱҲ»áµ÷ÓöԷ½µÄ½Ó¿Ú£»
Òì²½µ÷ÓÃÊÇÒ»ÖÖÀàËÆÏûÏ¢»òʼþµÄ» ......