mysql´æ´¢¹ý³Ì

1¡¢Ð½¨±ítest create table test1( field1 int not null ) ENGINE=MyISAM DEFAULT CHARSET=gbk; insert into test1(field1) values(1); 2¡¢É¾³ýÒÑ´æÔڵĴ洢¹ý³Ì -- ɾ³ý´¢´æ¹ý³Ì delimiter // -- ¶¨Òå½áÊø·ûºÅ drop procedure p_test; 3¡¢mysql´æ´¢¹ý³Ì¶¨
1¡¢Ð½¨±ítest
create table test1(
field1 int not null
)
ENGINE=MyISAM DEFAULT CHARSET=gbk;
insert into test1(field1) values(1);
2¡¢É¾³ýÒÑ´æÔڵĴ洢¹ý³Ì
-- ɾ³ý´¢´æ¹ý³Ì
delimiter // -- ¶¨Òå½áÊø·ûºÅ
drop procedure p_test;
3¡¢mysql´æ´¢¹ý³Ì¶¨Òå
create procedure p_test(in temp int,out cc int)
begin
insert into test1 values(temp);
set cc=6;
end
4¡¢µ÷Ó÷½·¨
CallableStatement cStmt = conn.prepareCall("{call p_test()}");
cStmt.executeUpdate();
5. CallableStatement    ÓÃÀ´µ÷Óô洢¹ý³Ì(Á˽â)
ÔÚ JDBC Öе÷ÓÃÒÑ´¢´æ¹ý³ÌµÄÓï·¨ÈçÏÂËùʾ¡£×¢Ò⣬·½À¨ºÅ±íʾÆä¼äµÄÄÚÈÝÊÇ¿ÉÑ¡Ï·½À¨ºÅ±¾Éí²¢²»ÊÇÓï·¨µÄ×é³É²¿·Ý¡£
{call ¹ý³ÌÃû[(?, ?, ...)]}
·µ»Ø½á¹û²ÎÊýµÄ¹ý³ÌµÄÓ﷨Ϊ£º
{? = call ¹ý³ÌÃû[(?, ?, ...)]}
²»´ø²ÎÊýµÄÒÑ´¢´æ¹ý³ÌµÄÓï·¨ÀàËÆ£º
{call ¹ý³ÌÃû}
ʾÀý´úÂ룺
String procedure="{call Operator_login(?,?,?)}";
        //×¢²á´æ´¢¹ý³Ì
        CallableStatement callStmt=conn.prepareCall(procedure);
        //×¢²á´æ´¢¹ý³ÌÊä³ö²ÎÊýµÄÀàÐÍ
        callStmt.registerOutParameter(3,java.sql.Types.INTEGER);
        //ÌṩÊäÈë²ÎÊýµÄÖµ
        callStmt.setString(1,this.operatorID);
        callStmt.setString(2,this.password);
        //Ö´Ðд洢¹ý³Ì
        callStmt.execute();
        //·µ»ØÊä³ö²ÎÊý
        login_state=callStmt.getInt(3);
CallableStatement cs = conn.prepareCall("{call ec_get_cust_terms(?)}");
cs.setInt(1, cus