Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......

JavaScriptÔõÑùÁ¬½ÓMySQLÊý¾Ý¿â£¿

ÓÐÒ»¸öjsÎļþ£¬ÊÇʵÏÖÎÄ×Ö¹ö¶¯µÄ£¬ÆäÖеıäÁ¿ÐèÒªµ½mysqlÊý¾Ý¿âÖжÁÈ¡£¬ÄÇôÔõÑùʵÏÖÊý¾Ý¿âÁ¬½Ó¶ø¶ÁÈ¡Êý¾Ý£¿
ÎÒÊDzËÄñ£¬×îºÃÓÐÍêÕûµÄ´úÂëºÍ½âÊÍ£¬Ð»Ð»¸÷λ´óϺ°¡°¡°¡°¡°¡°¡£¡£¡£¡
http://blog.csdn.net/jemlee2002 ......

mysqlÊý¾Ý±íÖÐnullÓë¿Õ°×ÖµµÄÇø±ð

±íÁÐ×Ö¶ÎÔÚÎÞÖµµÄÇé¿öÏÂ
ĬÈÏֵΪnullºÃ,»¹Êǿհ×ÖµºÃÄØ?
1)¶ÔÊý¾Ý²åÈë/²éѯ/µÄÓ°ÏìÈçºÎ?
2)¶Ô¸ÃÁнøÐÐË÷Òý,»áÓв»Í¬µÄЧÓÃô?
´ó¼ÒÒ»°ã¶Ô±êÌâ×ֶεÄλÊýÉèΪ¶àÉÙ?256
ÕýÎÄ×ֶεÄ?text?
¼¸Ç§ÍòÌõµÄÊý¾Ý´æ´¢,Òª ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ