¡¾Çó½Ì¡¿SQLÓï¾äÓï·¨¡£
C# code: //±äÁ¿ÀàÐÍ£¨¶ÔÓ¦±íÀïµÄÀàÐÍ£© int batchNo = 0; int expirydate = 0; string codevalue = ""; int SerialNumber = 0; string codecheck = ""; //SQLÓï¾ä insertString = "INSERT INTO web_recharge(rec_batch,rec_usedate,rec_pwd,rec_flownumber,rec_check_code,rec_value) VALUES (" + batchNo + ",'" + expirydate + "','" + codevalue + "','" + SerialNumber + "','" + codecheck + "'," + tbx_pointnumber.Text + ")"; Õâ¸öÓï¾äÊÇ¿ÉÒÔµ÷ÊԳɹ¦µÄ¡£ ÎÒ´òËãÔÚÊý¾Ý¿âÖÐÌí¼ÓÒ»¸öintÐ͵ÄÁУ¨ºÍÉÏÃæµÄrec_batchÁÐÒ»Ñù£©£¬ÁÐÃûΪrec_state. È»ºóÔÚ³ÌÐòÖж¨ÒåÒ»¸ö±äÁ¿ int state =0; ÎÒµÄÄ¿µÄÊÇÏë°Ñ±äÁ¿state ²åÈëµ½rec_stateÖС£ ÎÒÕÕè»»¢µÄ°Ñrec_stateдÔÚÀ¨ºÅÀ°Ñstate дµ½ºóÃæ¶ÔÓ¦µÄλÖ㬿ÉÊdz¢ÊÔÁ˺ü¸±é£¬¶¼ËµÓï·¨´íÎó¡£ Ï£Íû¶®SQLÓï¾äµÄ¸ßÊÖÖ¸µãһϣ¬µ½µ×Ôõôд²Å¶Ô°¡¡£Ð»Ð»ÁË£¡£¡ ¸Ð¼¤²»¾¡£¡£¡£¡£¡ PS:ÎÒÓõÄÊÇMySQLÊý¾Ý¿â£¬±íÖл¹ÓиöÁеÄÀàÐÍÊÇsmallint ÔÚ³ÌÐòÀï¶ÔÓ¦µÄÀàÐÍÊÇʲôÀàÐÍ£¿
ÄãÔõôдµÄ,Êý¾Ý¿âµÄ±íÔö¼Ó×Ö¶ÎÁËûÒýÓà ÄãÔõôдµÄ,Êý¾Ý¿âµÄ±íÔö¼Ó×Ö¶ÎÁËû Ôö¼ÓÁ˸öÁÐ ºÍÆäËüINTÐÍÁÐÒ»ÑùµÄ ÎÒ¾ÍÕÕè»»¢¶¨ÒåÁË int state = 0; È»ºóдµ½µ¹ÊýµÚ¶þ¸öλÖÃÁË ·ûºÅÌ«¶àʵÔÚ²»Àí½âÊÇɶÒâ˼ ÎÒµÄд·¨ÈçÏ C#
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ' select cast(convert(numeric(18,2),1275674000000/100000000)as real) ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jas ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡ ¸Õ×°ÁËSQL2000 sp3 ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3 ËüÏÔʾµÄÊÇ javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд ORACLEÖУº select floor(months_between(date1,date2)) from A date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ DB2ÖÐÈçºÎʹÓÃÐ ......