mysql Àï¶àÉÙÌìÒÔÄÚÔõô±íʾ - Java / Web ¿ª·¢
ÎÒÒªÔÚÒ³Ãæ×ö¸öËÑË÷£¬°´Ê±¼ä²éÕÒNÌìÒÔÄÚµÄÐÅÏ¢¸ÃÔõôд£¬±íÀïÓС®·¢²¼Ê±¼ä¡¯µÄ×ֶΣ¬°´ÆäËüÀàÐͲéÕÒÒѾ×ö³öÀ´ÁË£¬¾ÍÊÇÕâ¸ö²»ÖªµÀÔõô×ö
date>·¢²¼Ê±¼ä¶Î1
date<·¢²¼Ê±¼ä¶Î2
ÄãºÃºÃ˼άһÏ ÓÃÒ»¸ö×Ö¶ÎÍêÈ«¿ÉÒÔʵÏÖ
È¡µ±Ç°Ê±¼ä ת»¯³É longÐÍ ¼ÓÉÏ»òÕß¼õÈ¥NÌì(ת»»³ÉÃë) È»ºóÊý¾Ý¿âÄÚ between ¹Ø¼ü×Ö
ÎÒÒѾ֪µÀÁËÊÇÕâÑùµÄ
select * from table where ·¢²¼Ê±¼ä>date_sub(date(now()),interval N day);
Ïà¹ØÎÊ´ð£º
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾÌá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......
ÎÒдÁ˸öjspÒ³Ãæ£¬È»ºó¸Ä¶¯ÁËһϣ¬¸Ä¶¯µÄÄÚÈݾÍÊÇÔÚjspÒ³ÃæµÄjsº¯ÊýÀï¼ÓÁ˸öalert()Óï¾ä£¬µ«ÊÇÎÒ·ÃÎÊÕâ¸öÒ³ÃæÊ±£¬ËÀ»î¶¼ÊÇÔÀ´Ò³ÃæµÄÄÚÈÝ£¬ÎÒ¼ÓÁ˺ܶàalertº¯Êý»¹ÊÇû¸Ä¶¯Ç°µÄÒ³ÃæÄÚÈÝ£»tomcatÖØÆôÁË£¬Ò²ÖØÐ²¿ÊðÕâ ......
sp ³ÌÐò
delimiter //
create procedure ma()
begin
declare i int default 0;
while i<11 do
set i=i+1;
select i;
end while;
end //
delimiter ;
1+2+...+9+10
ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û
/ ......