Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

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: ......

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

¹ØÓÚMySQLɾ³ý¼Ç¼ºóIDÈçºÎÁªÏµ

id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿
ÔËÐÐ
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ