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¿ª·¢¾ÑéµÄÅóÓÑÃÇÒ»¶¨Åöµ½¹ýÏÂÃæµÄÕâÖÖÇé¿ö,ÄǾÍÊÇ×Ô¼ºËù¿ª·¢µÄÓ¦ÓÃÔËÐÐÁËÒ»¶Îʱ¼äºóÆäÐÔÄÜ»ò ÕßÏìÓ¦ËÙ¶È»áÓÐÃ÷ÏԵĽµµÍ.ÕâÊÇÓÉ¶à·½ÃæµÄÔÒòÔì³ÉµÄ¼´ÓгÌÐò±¾ÉíµÄÓÅ»¯ÎÊÌâ,Ò²ÓÐÔËÐл·¾³ÎÊÌâ.´ËÔËÐл·¾³¼´°üÀ¨Ó²¼þ»·¾³Ò²°üÀ¨Èí¼þ»·¾³.´ó¶àÊýÈ˵ÚÒ» ¸öÄÜÏëµ½µÄ½â¾ö·½·¨ÊÇÌáÉýÓ²¼þµÄÅäÖöøºöÂÔÁ˳ÌÐò±¾ÉíµÄÔËÐл·¾ ......
ʹÓÃÒ»ÖÖ³ÌÐòÉè¼ÆÓïÑÔ£¬¾ÍÓ¦¸ÃרҵµØÊ¹ÓÃËü¡£±¾ÎÄÊÇIBM developerWorksÖеÄһƪÎÄÕ£¬ËüÃèÊöµÄ¶¼ÊÇJava±à³ÌÖеÄϸ½ÚÎÊÌ⣬¾¡¹ÜÈç´Ë£¬»¹ÊÇÖµµÃ´ó¼ÒÍæÎ¶Ò»·¬£¬ÖÁÉÙÎÒ×÷ΪһÃûÀÏÄñ»¹ÊÇ´ÓÖÐÊÜÒæÁË¡£(2010.02.09×îºó¸üÐÂ)
ѧϰһÖÖеijÌÐòÉè¼ÆÓïÑÔ±ÈѧϰһÖÖеĿÚÍ·ÓïÑÔÒªÈÝÒס£µ«ÊÇ£¬ÔÚÕâÁ½ÖÖŬÁ¦ÖУ¬¶¼Ð ......
JAVA·´Éä»úÖÆ
JAVA·´Éä»úÖÆÊÇÔÚÔËÐÐ״̬ÖУ¬¶ÔÓÚÈÎÒâÒ»¸öÀ࣬¶¼Äܹ»ÖªµÀÕâ¸öÀàµÄËùÓÐÊôÐԺͷ½·¨£»¶ÔÓÚÈÎÒâÒ»¸ö¶ÔÏ󣬶¼Äܹ»µ÷ÓÃËüµÄÈÎÒâÒ»¸ö·½·¨£»ÕâÖÖ¶¯Ì¬»ñÈ¡µÄÐÅÏ¢ÒÔ¼°¶¯Ì¬µ÷ÓöÔÏóµÄ·½·¨µÄ¹¦ÄܳÆÎªjavaÓïÑԵķ´Éä»úÖÆ¡£
Java·´Éä»úÖÆÖ÷ÒªÌṩÁËÒÔϹ¦ÄÜ£º ÔÚÔËÐÐʱÅжÏÈÎÒâÒ»¸ö¶ÔÏóËùÊô ......