Java--sql2000µÄ³ÌÐòÓÃÔÚsql2005
¸÷룬¸ø¿´¿´°É~~~Îҳ̶ȲÇë¶àµãÌáʾ¡£
Çé¿öÊǽ´µÄ£º
ÔÀ´µÄ³ÌÐòÊÇÔÚsql2000Ï¿ª·¢µÄ£¬¸Ã³ÌÐò¾¹ýºÜ¶à²âÊÔ¶øÇÒ¶¼Ó¦ÓÃÔÚsql2000Ï£¬Ã»ÓÐÎÊÌâ¡£¸Ã³ÌÐòÊÇJAVAµÄ¡£
ÏÖÔÚÎÒÓÃÁËsql2005£¬tomcatÆô¶¯Ê±Ã»ÎÊÌ⣬µ«ÊÇÔڵǼÁ¬½ÓÊý¾Ý¿âʱ¾Í»á±¨´í£¬±¨Á¬½ÓÊý¾Ý¿âÒì³£¡£
ÎҲ²âÊÇÁ½¸ö°æ±¾µÄÊý¾Ý¿âÁ´½Ó·½·¨²»Í¬£¬ÊÇÂð£¿ÏÖÔÚÎÒÖ»ÄÜ¿´µ½classÎļþ£¬²»Äܸü¸ÄÔ´Âë¡£ËùÒÔ£¬ÈçºÎÔÚ²»¸ü»»Êý¾Ý¿âµÄÇé¿öϽâ¾öÕâ¸öÎÊÌâÄØ£¿
ÎÒÔÚweb-inf/libÏÂҲûÓÐÕÒµ½sqljdbc.jar~ΪʲôÄØ£¿ºÃÓôÃÆ
ÓÐÇëÀîêÏ
¶ÔÁË£¬Òª²¹³ä¸öÇé¿ö£º
ÔÚÊý¾Ý¿âÖÐÒѾ½¨Á¢ÁË±í£¬°²×°µÄʱºò½¨Á¢µÄ¡£Ö»ÊÇÔÚ°²×°Íê±ÏµÚÒ»´ÎµÇ¼ʱ¾Í»á³öÕâ¸ö¡£
¶ö~~»¹ÓУÂ/£Ó½á¹¹£¬Õâ¸öÓÐÓÃô......
±§Ç¸£¬¸÷룬¾²éÎÒµÄsqlserverÆäʵÊÇ2000µÄ¡£¡£¡£
¿´ÆðÀ´²»ÊÇÊý¾Ý¿â°æ±¾ÎÊÌ⣬ÊÇÆäËû³ÌÐòµÄÎÊÌâ¡£
ºÇºÇ
Ïà¹ØÎÊ´ð£º
ÎÒÄ¿Ç°ÔÚ±¾µØµÄlinuxÉÏдÁËÒ»¸öswingµÄ½çÃ棬Ïëͨ¹ýÕâ¸ö½çÃæÀ´¿ØÖÆÆäËüµçÄÔµÄlinuxÖØÆô¡£
ÎÒÖªµÀÓÃRuntime.getRuntime().exec("shutdown -r");¿ÉÒÔ¿ØÖƱ¾»úLinuxÖØÆô£¬µ«ÊÇÔõô¿ØÖÆÔ¶³ÌµÄlinuxÖØÆôÄØ£¿ ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεĻ°¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿
¿ÉÒÔµÄ
10¸ö¶¼Ã»ÎÊÌâ
¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......
ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ ËÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá
ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:
public void doPost(HttpServletRequest reque ......