javaÖе÷Óô洢¹ý³Ì
public int ExecProcAdd()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "adduser";//Äõ½´æ´¢¹ý³ÌµÄÃû×Ö
//--------------------------------´ø²ÎÊýµÄ´æ´¢¹ý³Ì(3¸ö)-----------------------------------------
SqlParameter p1 = new SqlParameter("@username",typeof(string));
SqlParameter p2 = new SqlParameter("@userpwd",typeof(string));
//-----------------------------------------------------------------------------------------
//ÓÃsqldbtype.int²»»á³ö´í£¬×îºÃÓÃËü
SqlParameter p3 = new SqlParameter("@userid",SqlDbType.Int);
//Óзµ»ØÖµµÄ´æ´¢¹ý³Ì
p3.Direction = ParameterDirection.Output;
p1.Value = "ÕÅÈý";//¸ø´øµÄ²ÎÊý¸³Öµ
p2.Value = "123456";
//½«Æä¼ÓÈëµ½
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Connection = Conn;
//-------------------------------------------------------------
Ïà¹ØÎĵµ£º
ÒýÑÔ
ÓÐJAVA¿ª·¢¾ÑéµÄÅóÓÑÃÇÒ»¶¨Åöµ½¹ýÏÂÃæµÄÕâÖÖÇé¿ö,ÄǾÍÊÇ×Ô¼ºËù¿ª·¢µÄÓ¦ÓÃÔËÐÐÁËÒ»¶Îʱ¼äºóÆäÐÔÄÜ»ò ÕßÏìÓ¦ËÙ¶È»áÓÐÃ÷ÏԵĽµµÍ.ÕâÊÇÓÉ¶à·½ÃæµÄÔÒòÔì³ÉµÄ¼´ÓгÌÐò±¾ÉíµÄÓÅ»¯ÎÊÌâ,Ò²ÓÐÔËÐл·¾³ÎÊÌâ.´ËÔËÐл·¾³¼´°üÀ¨Ó²¼þ»·¾³Ò²°üÀ¨Èí¼þ»·¾³.´ó¶àÊýÈ˵ÚÒ» ¸öÄÜÏëµ½µÄ½â¾ö·½·¨ÊÇÌáÉýÓ²¼þµÄÅäÖöøºöÂÔÁ˳ÌÐò±¾ÉíµÄÔËÐл·¾ ......
JAVA·´Éä»úÖÆÊÇÔÚÔËÐÐ״̬ÖÐ,¶ÔÓÚÈÎÒâÒ»¸öÀà,¶¼Äܹ»µÃµ½Õâ¸öÀàµÄËùÓÐÊôÐԺͷ½·¨;¶ÔÓÚÈÎÒâÒ»¸ö¶ÔÏó,¶¼Äܹ»µ÷ÓÃËüµÄÈÎÒâÒ»¸ö·½·¨;ÕâÖÖ¶¯Ì¬»ñÈ¡µÄÐÅÏ¢ÒÔ¼°¶¯Ì¬µ÷ÓöÔÏóµÄ·½·¨µÄ¹¦ÄܳÆÎªjavaÓïÑԵķ´Éä»úÖÆ.
¸ÅÀ¨Ò»ÏÂ:
·´Éä¾ÍÊÇÈÃÄã¿ÉÒÔͨ¹ýÃû³ÆÀ´µÃµ½¶ÔÏó(Àà,ÊôÐÔ,·½·¨)µÄ¼¼ ......
finalµÄ×÷ÓÃËæ×ÅËùÐÞÊεÄÀàÐͶø²»Í¬
1¡¢finalÐÞÊÎÀàÖеÄÊôÐÔ»òÕß±äÁ¿
ÎÞÂÛÊôÐÔÊÇ»ù±¾ÀàÐÍ»¹ÊÇÒýÓÃÀàÐÍ£¬finalËùÆðµÄ×÷Óö¼ÊDZäÁ¿ÀïÃæ´æ·ÅµÄ“Öµ”²»Äܱ䡣
&n ......