ÇëÎÊÕâÌõSQLÓï¾ä£¬ÔõôÀí½â£¿ÊÇACCESSµÄÊý¾Ý¿â
SELECT A.* ,EMPNAM,EMPCAR,DEPNAM from WEEKSHIFT A,EMPLOYEE,DEPT WHERE WEEEMP=EMPLID AND EMPDEP=DEPTID AND ((EMPENT <%F+2 AND EMPLEA IS NULL) OR (EMPLEA>=%F+2) AND (EMPENT <%F+2)) %S ORDER BY EMPLID
²»¶® %F %S £¬
ÄѵÀFºÍS¶¼ÊÇÊý×ÖÀàÐ͵ÄÁУ¿%È¡ÓàÊý£¿
׸ɳ·¢£¬µÈÈ˽â´ð
¾ÍÊÇѽ,Õ¦ÓÃÕâ¸öÊý¾Ý¿âÁË,ÄãҲ̫ÎÞÁÄÁË
ÄãÕâ²»ÊÇpbÀïÓõÄsql°É£¬»³ÒÉ%¼Ó¸ö×ÖĸÊDzÎÊý
%FÊÇfloatÐ͵ģ¬%SÊÇ×Ö·û´®µÄ£¿µ«ÊÇ%s¾ÍÕâôֱ½Ó·ÅÔÚÄÇÀïÓÖ²»ºÃÀí½â
Äã°ÑÕâ¸öÓï¾äµÄʹÓû·¾³Ò²½éÉÜһϣ¿
ѧϰ
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......