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

jsp²éѯÏÔʾµÄÎÊÌâ - Java / Web ¿ª·¢

String sql="select distinct xfdate from xiaofei where regname like '%"+userid+"%' order by xfdate";
 ResultSet rs = stmt.executeQuery(sql);

°´ÒÔÉϲéѯµÄ½á¹ûÊÇ
2009/9/7
2009/9/10
2009/10/12
2010/1/3
2010/10/23

µ«ÊÇÎÒÏë°ÑËüÏÔʾ³É

2009/9/
2009/9/
2009/10/
2010/1/
2010/10/

Çë½Ì´úÂëÓ¦¸ÃÔõôд£¿
Äã´æ´¢ÀàÐÍÊÇʲôѽ? È¡³öÀ´Ö±½ÓÊä³öÊÇ2009/9/7Õâ¸öÑùʽµÄ?

Èç¹ûÄãµÄÊý¾Ý¿â´æ´¢ÀàÐÍΪʱ¼äÀàÐÍ,Äã¿ÉÒÔʹÓÃSimpleDateFormatÕâ¸öÀà,´ó¸ÅÊÇÕâÑù×ö
Java code:

SimpleDateFormat sdf=new SimpleDateFormat("YYYY/MM/");
sdf.format(date);



¶Ô£¬Ö±½ÓÊä³ö¾ÍÊÇ2009/9/7Õâ¸öʽÑùµÄ£¬ÖÁÓÚÀàÐͲ»ÊÇÈÕÆÚÀàÐ͵ģ¬ËùÒÔ²»ÖªµÀ¸ÃÔõô¸Ä

ÊÇÔÚÓÃORACLEÂ𣿠ºÜ¼òµ¥£¬Èç¹û²éѯ³öÀ´µÄÊÇstring Ö±½Ó sqlÓï¾ä¸ÄΪ String sql="select distinct to_char(xfdate,'yyyy/mm/') from xiaofei where regname like '%"+userid+"%' order by xfdate";Èç¹û²éѯ³öÀ´µÄÊÇdate ¸ÄΪsqlÓï¾ä¸ÄΪ String sql="select distinct to_date(to_char(xfdate,'yyyy/mm/'),'yyyy/mm/') from xiaofei where regname like '%"+userid+"%' order by xfdate";


ÓöþÂ¥µÄ·½·¨

Æäʵһ°ã¶¼ÊÇÊä³ö£¨yyyy-mm-dd£©2010-01-05 ÕâÖÖÐÎʽµÄ

ÖÁÓÚ²»ÊÇÈÕÆÚÀàÐÍ£¬¾Í¿ÉÒÔÔÚ¶Á³öÀ´Ö®ºóʹÓÃStringÀàµÄsubstringº¯Êý´¦ÀíÒ»ÏÂÔÙÏÔʾ

°ÑÄãµÄsqlÐ޸ijɣº

Str


Ïà¹ØÎÊ´ð£º

¹ØÓÚAJAXºÍJSPµÄһЩСÎÊÌâ¡« - Java / Web ¿ª·¢

ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
  %>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......

FCKÉÏ´«Îļþµ½linux·þÎñÆ÷ÎÊÌâ - Java / Java EE

ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£

ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......

tomcat»·¾³ÏÂjsp±àÒë´íÎó£¬Çó½â£¡ - Java / Web ¿ª·¢

org.apache.jasper.JasperException: Unable to compile class for JSP: 
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......

javaÖеÄ×¢½â¿ÉÒÔÓÐÄÄЩ£¿ - Java / Java EE

È磺 @superwaring("unchecked");
Õâ¸öÀïÃæ¶¼¿ÉÒÔÈ¡ÄÄЩֵ°¡£¬»¹ÓÐÀàËÆµÄ @superwaring±êÇ©ÓÐÄÄЩ°¡
ûÓùý¡£¡£

¿´jeeµÄapi
javax.persistenceÀï
@superwaring("unchecked");Ö»ÊǺöÂÔ ......

c/sºÍb/sÖ®¼äÔõôͨѶ. - Java / Web ¿ª·¢

ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾­ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾ­Ìá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ