mysql datetimeµÄÎÊÌâ
ÎÒÔÚmysqlÊý¾Ý¿âÖÐÓÃdatetime×÷Ϊ×ֶεÄÀàÐÍ£¬²éѯµÄ½á¹û¼¯ÖУ¬¸Ã×ֶεÄÖµºóÃæ¶àÓàÁË.0 ÀýÈ磺 Êý¾Ý¿â´æ´¢µÄÊÇ2010-03-09 10:25:20 µ«ÊÇ´Ó½á¹û¼¯ÖÐÈ¡³öµÄÈ´ÊÇ2010-03-09 10:25:20.0 ÇëÎÊ´ó¼ÒÕâÊÇÔõôһ»ØÊÂÄØ£¿ÓÃʲô°ì·¨Äܽâ¾öÄØ£¬³ýÁË×Ö·û´®½ØÈ¡Ö®Íâ~~ ллà¶~
Java code: <%=new java.text.SimpleDateFormat("yyyy-MM-dd").format(rs.getTimestamp("rdate")%> Java code: <%=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(rs.getTimestamp("rdate")%> û·¢ÏÖÄã˵µÄÎÊÌ⣡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡ÒýÓà û·¢ÏÖÄã˵µÄÎÊÌ⣡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡ °¡¡£¡£¡£¡£¡£ ÎÒÓÃdatetimeÀàÐÍ£¬²éѯ´òÓ¡µÄʱºò¾Í¶à³öÁ˸ö.0 °¡ £¬ÕæÊÇÓôÃÆËÀÁË£¬¸É´àÖ±½Ó½ØµôµÃÁËÒýÓà Java code<%=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(rs.getTimestamp("rdate")%> ÄãµÄÕâÖнâ¾ö·½·¨¿ÉÒÔ£¬ ÎÒÊÇÏëÎÊÈçºÎ´ÓÊý¾Ý¿â±¾Éí½â¾ö£¬ ÊDz»ÊÇÊý¾Ý¿â·½ÃæµÄÎÊÌ⣬ ±¾À´ÊDz»Ó¦¸Ã³öÏÖÄÇÖÖÇé¿öµÄѾ ¶øÎÒÔÚ¿ØÖÆÌ¨Êä³ö´òÓ¡µÄʱºò È´³öÏÖà¶
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml <Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡ Íò·Ö¸Ðл£¡ String SQL=&q ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ ¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ ÓóÌÐòÔ ......