ÐèÒªÓÐMySQL µÄ½¨¿âÔÂë!!
ÒªÄÜÔËÐÐ
Ã÷Ìì¾ÍÒª½Ð ×÷ÒµÁË !!!!
°ï°ïæ@!
Ë»¹ÓÃjsp+mysql£¬ÄÇÊÇʲôÄê´úµÄÁË¡£ÏÖÔڵĴóѧÉú°¡¡£¡£¡£
°¦
ºÍÎÒÁªÏµ°É£¬ÎÒ¸ÕÏÂÔØÁËÒ»¸ö¡£
csdnÏÂÔØÇøÈ¥ËÑÒ»¸ö
google
ÒýÓÃ
Ë»¹ÓÃjsp+mysql£¬ÄÇÊÇʲôÄê´úµÄÁË¡£ÏÖÔڵĴóѧÉú°¡¡£¡£¡£
ÄǸÃÓÃʲô£¿
ÒýÓÃ
......
ÎÒÏÖÔÚÒª×öÕâÑùÒ»¸ö²éѯ
2ÕÅ±í£ºA,B£¬A±íÓÐ×Ö¶Îid,name,B±íÓÐid,cid,content,uptime,ÆäÖÐA.id=B.cid£¬
ÏÖÒª²éѯA±íµÄname¶ÔÓ¦B±íµÄǰ3¸öconnect£¬°´ÕÕB±íµÄuptimeµ¹ÐòÅÅÁÐ
Select * from a t1
Inner join b t2 on t1.id=t2.cid and t2.content in (select top 3 b.content from b where b.c ......
`getPlayerRank`(IN inplayerid INTEGER(11), OUT rank INTEGER(11))
´æ´¢¹ý³ÌÃûÈçÉÏ£¬ÎÒÔÚvcÖÐÈçºÎµ÷ÓÃgetPlayerRank»ñÈ¡µ½´æ´¢¹ý³ÌÖеķµ»ØÖµ.....
int iRank = 0;
int iPlayerID = 1;
char szGetRank[256] = {0};
sprintf_s(szGetRank,sizeof(szGetRank),"call getPlayerRank_Test(%d,%d ......
ÏÖÓÐÖ÷±ía£¬×Ó±ísub_a,ÖмäÓÐa_id ´æÔÚ¹ØÁª£¬ÏÖÔÚjava³ÌÐòÖÐÐèÒªÖ÷×Ó±íͬʱ£´æ£¬¶øÇÒ´æÔÚ¶à¸ö×ӼǼ¡£
²»ÓÃhibernateµÄ´¦Àí·½Ê½£¬ÓÐÆäËû·½Ê½Â𣿴¦Àí·½Ê½²»ÄÜʹÓÃÏȱ£´æÖ÷±í£¬ºó»ñÈ¡id£¬ÔÙ¸³Öµ×Ó±íÍâ¼ü£¬±£´æµÄ·½Ê½¡£
±ØÐëͬʱ±£´æ¡£
ÄѵüûÄã·¢Ìù°¡¡£
´æ´¢¹ý³Ì¡£
³ý·ÇÄãµÄmysql°æ±¾²»Ö§³Ö´æ´¢¹ý³Ì¡£
²»¹Ü ......
ÏÖÓÐÖ÷±ía£¬×Ó±ísub_a,ÖмäÓÐa_id ´æÔÚ¹ØÁª£¬ÏÖÔÚjava³ÌÐòÖÐÐèÒªÖ÷×Ó±íͬʱ£´æ£¬¶øÇÒ´æÔÚ¶à¸ö×ӼǼ¡£
²»ÓÃhibernateµÄ´¦Àí·½Ê½£¬ÓÐÆäËû·½Ê½Â𣿴¦Àí·½Ê½²»ÄÜʹÓÃÏȱ£´æÖ÷±í£¬ºó»ñÈ¡id£¬ÔÙ¸³Öµ×Ó±íÍâ¼ü£¬±£´æµÄ·½Ê½¡£
±ØÐëͬʱ±£´æ¡£
ÎÒÒ²ÕýÔÚÑо¿£¬ ¶¯Ì¬Éú³ÉµÄ×ÔÔöidÖ»Ö§³ÖÖ÷¼ü£¬ Òª²»Í¬Ê±ÔÚÁÐÀï×ÔÔöÒ»¸öºÍÖ÷¼üÏàÍ ......
asp.netÁ¬½ÓmysqlÔõôдµÇ¼´úÂë
¹Ø¼üÊǰѵǼ´úÂëдÔÚ ÀàÖÐ
È»ºóǰ̨µÇ¼´úÂë¾ÍÖ»Óþ͵÷ÓÃÕâ¸ö ÀàC# code:
using System;//Õâ¸öÀàÖÐÒªÊÇÓдíÇëÖ¸³öÀ´£¬Ð»Ð»
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
usin ......