mysqlʱ¼ä¸ñʽµÄУÕý
ÎÒ²åÈëmysqlµÄʱ¼ä¸ñʽÊÇ£º2010-01-12 ¸Ã×Ö¶ÎÊÇdateÀàÐÍ£¬¿ÉÊÇ´ÓÊý¾Ý¿â²éѯ³öÀ´ÏÔʾÔÚÒ³ÃæµÄʱºòÈ´ÊÇ 2010-01-12 00:00:00.0£¬ÎÒ²»ÏëÒª00:00:00.0£¬¶øÇÒÖ±½ÓʹÓÃ${}À´¶ÁÈ¡sessionÖб£´æµÄstudentʵÌ壬Ôõô²ÅÄÜÈ¥µôÄØ
¿ÉÒÔÐÞ¸ÄÄãµÄstudentµÄgetter·½·¨¡£ ±ÈÈçÄãÒªÏÔʾµÄbirthdayµÄÈÕÆÚ Java code: public String getBirthday() { DateFormat format = new SimpleDateFormat("yyyy-MM-dd"); return format.format(birthday); } select DATE_FORMAT(DBdate,'%Y-%m-%d') from table SQLÎÄÖиñʽ»¯Ò»Ï¾ͿÉÒÔ <fmt:formatDate pattern="yyyy-MM-dd HH:mm:ss" value="${ap[5]}"/> ¶¥Ò»ÏÂһ¥¡£ °Ñ·µ»Ø¸ñʽ¸ÄΪStringÒýÓà ¿ÉÒÔÐÞ¸ÄÄãµÄstudentµÄgetter·½·¨¡£ ±ÈÈçÄãÒªÏÔʾµÄbirthdayµÄÈÕÆÚ Java codepublic String getBirthday() { DateFormat format=new SimpleDateFormat("yyyy-MM-dd");return format.format(birthday); } Õâ¸ö·½·¨²»ºÃʹÓã¬ÔÚpojoÀàÖÐÕâ¸öʵÌåµÄ¸Ã×Ö¶ÎÊÇdateÀàÐÍ£¬¶øformatµÄʱºò±¨´í Äã¿ÉÕæ²»»á±äͨ¡£ StudentÖж¨ÒåÒ»¸ödataToString·½·¨ Java code: public String dataToString(Date d) { DateFormat format = new Si
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â 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: ......
ÓÐÒ»¸öjsÎļþ£¬ÊÇʵÏÖÎÄ×Ö¹ö¶¯µÄ£¬ÆäÖеıäÁ¿ÐèÒªµ½mysqlÊý¾Ý¿âÖжÁÈ¡£¬ÄÇôÔõÑùʵÏÖÊý¾Ý¿âÁ¬½Ó¶ø¶ÁÈ¡Êý¾Ý£¿ ÎÒÊDzËÄñ£¬×îºÃÓÐÍêÕûµÄ´úÂëºÍ½âÊÍ£¬Ð»Ð»¸÷λ´óϺ°¡°¡°¡°¡°¡°¡£¡£¡£¡ http://blog.csdn.net/jemlee2002 ......
±íÁÐ×Ö¶ÎÔÚÎÞÖµµÄÇé¿öÏ ĬÈÏֵΪnullºÃ,»¹Êǿհ×ÖµºÃÄØ? 1)¶ÔÊý¾Ý²åÈë/²éѯ/µÄÓ°ÏìÈçºÎ? 2)¶Ô¸ÃÁнøÐÐË÷Òý,»áÓв»Í¬µÄЧÓÃô? ´ó¼ÒÒ»°ã¶Ô±êÌâ×ֶεÄλÊýÉèΪ¶àÉÙ?256 ÕýÎÄ×ֶεÄ?text? ¼¸Ç§ÍòÌõµÄÊý¾Ý´æ´¢,Òª ......