MySQL ÖÐÎÄ´¦ÀíÎÊÌ⣿ - MS-SQL Server / Ó¦ÓÃʵÀý
select TableName_Eng from tablenameengtochi where TableName_Chi = ¹Ý²ØÍ¼ÊéÐÅÏ¢±í £»²éѯûÓз´Ó¦ ҲûÓб¨´í
£¿Çë¸ßÊÖÖ¸µã£¡
ÉÙµ¥ÒýºÅ
SQL code:
select TableName_Eng from tablenameengtochi where TableName_Chi = '¹Ý²ØÍ¼ÊéÐÅÏ¢±í'
MySQL£¿
²»¹ýÒ²Ò»Ñù£¬±ê×¼SQL
MSSQL:
SQL code:
select TableName_Eng from tablenameengtochi where TableName_Chi = N'¹Ý²ØÍ¼ÊéÐÅÏ¢±í'
SQL code:
select TableName_Eng from tablenameengtochi where TableName_Chi = '¹Ý²ØÍ¼ÊéÐÅÏ¢±í'
....
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
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-- ......