¶ÁÈ¡mysqlÊý¾ÝµÄÎÊÌâ
mysqlÀïÓÐÒ»ÕűíµÄÒ»¸öÈÕÆÚ×Ö¶Îdate£¬µ«ÊÇÓõÄint¡£ ÎÒÓÃÈçÏÂsqlÓï¾ä¶Á³öÀ´Ìî³äµ½datasetÀÎÒÒª°ÑÕâ¸öֵת»»³ÉdatetimeÀàÐÍ£¬µ«ÊÇʧ°Ü¡£SQL code: select from_UNIXTIME(date) from table1 C# code: //ÏÈÌî³äDataSet ds DateTime dt = Convert.ToDateTime(ds.Tables[0].Rows[0]["date"]); ³ÌÐò±¨´í£ºÎÞ·¨½«ÀàÐÍΪ¡°System.Byte[]¡±µÄ¶ÔÏóÇ¿ÖÆ×ª»»ÎªÀàÐÍ¡°System.IConvertible¡±¡£
´Ó¿âÖжÁ³öÀ´µÄ¶«Î÷ÒªÏÔʾת»»Ò»ÏÂÀàÐÍÔÙʹÓà ¸ñʽÎÊÌâ ¿´¿´ds.Tables[0].Rows[0]["date"]Êý¾Ý C# code: DateTime dt = Convert.ToDateTime(ds.Tables[0].Rows[0]["date"].ToString()); ÒªtostringÔÙת»»Îªdatetime Ö÷ÒªÊÇ¿´Êý¾ÝµÄ¸ñʽ ÄãÄܲ»Äܷż¸¸öÊý¾Ý³öÀ´¿´¿´Ñ½? 2009101? 20091001?? ѧϰһÏ ........ ²Î¿¼£º http://school.itzcn.com/special-spid-51.html ÉÏÃæ½²½âµÄ±È½ÏÏêϸ£¬Ï£Íû¶ÔÂ¥Ö÷ÓÐËù°ïÖú¡£ÒýÓà ¸ñʽÎÊÌâ ¿´¿´ds.Tables[0].Rows[0]["date"]Êý¾Ý object£¬byte[19] ±ÈÈç2010-02-07 10:20:00 ÒýÓà C# codeDateTime dt= Convert.ToDateTi
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ ¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ ÓóÌÐòÔ ......
iocpͬmysql´¦ÀíÊý¾Ý ¾ä±úÒ»Ö±Ôö¼Ó ·ÖÏí ³ÌÐòÔ±Ö®¼Ò£¨www.phome.asia£©¼¼Êõ¹Ù·½Èº£¬Ï£ÍûÓÐ־֮ʿµÄ¼ÓÈëŶ~~ºÙºÙ£¡ javaȺ£º javaÐÂÊÖȺ£º 19976477 javaÐÂÊÖȺ2£º61983722 ......