mysqlÖÐÈçºÎ²éѯ±íµÄ×ÜÁÐÊý - MS-SQL Server / »ù´¡Àà
±ÈÈçÒ»ÕűíÖÐÓÐname,idÁ½ÁÐ,ÒªµÃµ½2ÕâÑùµÄ½á¹û Ö»ÒªsqlÓï¾ä,²»ÒªÆäËüµÄ³ÌÐòÐÖú
È¥mysqlµÄ°æÈ¥Î桃 ÎÒûÕÒµ½mysqlµÄ°æ,,,ÒýÓà ȥmysqlµÄ°æÈ¥ÎÊ°É Í¬Òâ. ллjosy,ÎÒ¸ÕÕÒµ½mysql°æÇø,²»¹ýÎҵķֲ»¹»ÁË,ÓôÃÆ
Ïà¹ØÎÊ´ð£º
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£© tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname ½á¹û£º µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
String sqlCount="select count(*) from usertable where username='"+ userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡ Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã ´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ ÖÁÉٵø½¼Óµ½sqlserverÉÏ ¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿ Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£ sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
Ö´ÐÐÊý¾Ý¿â²Ù×÷ʱ£¬Ö±½ÓÓÃSQL Óï¾äºÃһЩ »¹ÊÇÓô洢¹ý³Ì¸ü¼ÑÄØ£¿ ¸÷ÊãÆð¼û Õâ¸öµÄ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö ¼òµ¥µÄselect ¡¢updateºÍinsertµ±È»sql½â¾öÁË ¸´ÔӵķÅÔÚsql·þÎñ¶ËÓ¦¸ÃºÃµã Â¥Ö÷Çë²ÎÔÄ http://msdn.micr ......