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
Ïà¹ØÎÊ´ð£º
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......
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& ......
È磺 @superwaring("unchecked");
Õâ¸öÀïÃæ¶¼¿ÉÒÔÈ¡ÄÄЩֵ°¡£¬»¹ÓÐÀàËÆµÄ @superwaring±êÇ©ÓÐÄÄЩ°¡
ûÓùý¡£¡£
¿´jeeµÄapi
javax.persistenceÀï
@superwaring("unchecked");Ö»ÊǺöÂÔ ......
ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾÌá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......