ÄÄÀïÓÐÃâ·ÑµÄÖ§³ÖACCESSµÄJSPÍøÕ¾¿Õ¼ä
´ó¶àÊýµÄÃâ·ÑJSPÍøÕ¾¿Õ¼ä¶¼Ö»Ö§³ÖMYSQL£¬ÔÏÈ×öºÃµÄÍøÕ¾ÊÇACCESS£¬Ö»ºÃ¿¼ÂÇ»»³ÉMYSQLÁË£¬µ«ÊÇÕûÕûŪÁËÒ»Ìì¶¼×°²»ÉÏMYSQL£¬Í·¶¼ÔÎÁË¡£
JSPÍøÕ¾¿Õ¼äÖ§³ÖACCESSºÃÏñÊÇûÓн¨¹ýµÄ£¬JspÒ»°ãÖ§³ÖMysql£¬OracleµÄ±È½Ï¶à¡£
ÕâÖ÷ÒªÒ²ÊÇΪÁË¿¼ÂÇ×ÛºÏÐÔÄÜÒÔ¼°²¿ÊðµÄ·½±ãÐÔ°É¡£
javaûÓÐÖ§³ÖaccessµÄjdbcÇý¶¯£¬Ö»ÄÜÓÃodbc£¬ÕâÑùÐÔÄÜÓ¦¸Ã¾ÍÒªµÍһЩ£¬¶øÇÒ²¿ÊðÒ²²»·½±ã¡£
Java ¿ª·¢Ã»ÓÐÈË»áÈ¥Óà Access µÄ£¬Access ¾ÍÊÇÒ»Öְ칫ÓÃÆ·£¬»¹³Æ²»ÉÏÊý¾Ý¿â¡£
mysql µÄÊý¾Ý¿âÎļþºÃÏñºÜÂÒŶ£¬ÎÒ½¨Á¢ÁËÒ»¸öÊý¾Ý¿âmydata£¬²¢½¨Á¢ÁËÒ»¸ö±ídept£»
È»ºó´ò¿ª´æ·ÅĿ¼£¬¾Í¿´µ½Ò»¸öÎļþ¼Ðmydata£¬ÀïÃæÓÐÁ½¸öÎļþdb.opt¡¢dept.frm£»ÁíÍ⣬ÔÚmysqlĿ¼Ï»¹ÓÐdb.MYD¡¢db.MYI¡¢user.MYD¡¢user.MYIËĸöÎļþ¡£
ÄÇô£¬Èç¹ûÒª°ÑÏîÄ¿ÉÏ´«µ½ÍøÕ¾¿Õ¼ä£¬ÊÇ·ñÊǰÑÕâЩÎļþ¸´ÖƵ½ÏîÄ¿µÄĿ¼ÏÂÈ»ºóÔÙÒ»Æð´ò³Éwar°üÔÙÉÏ´«ÄØ£¿
лл£¡
MySqlµÄÊý¾Ý¿â²¿ÊðºÜ¼òµ¥~
н¨Ò»¸öÊý¾Ý¿â¾Í»áÔÚdatabase£¨ºÃÏñÊÇÕâ¸öÃû×Ö£©Îļþ¼ÐÏÂн¨Ò»¸öºÍÊý¾Ý¿âÃûͬÃûµÄÎļþ¼Ð
Ö»Òª°ÑÕâ¸öÎļþ¼Ð¿½µ½±ðµÄMySqlµÄdatabaseÎļþ¼ÐϾÍOKÁË~
Ò»°ã²»»áÕâÑùÈ¥½¨±í£¡
Ò»°ãÊÇʹÓà SQL Óï¾äÈ¥½¨¿â¡¢½¨±í¡£
access×öСϵͳµÄ»°¿ÉÒÔ×÷ΪÊý¾Ý¿â£¬´óµãµÄ¾Í²»ÐÐÁË¡£ÔÚmysqlÖÐÒ»°ã¶¼ÊÇͨ¹ýsqlÓï¾äÀ´½øÐÐÏà¹ØµÄ²Ù×÷¡£
ACCESS¿ÉÒÔʹÓã¬ÓÃÄǸöʲôOJDBC¡£¡£Ö®ÀàµÄ¡£¡£¡£¡£µ«ÊÇ£¬ÓÃACCESSÕâ¸ö²»Âײ»ÀàµÄ¶«Î÷ÓбØÒªÃ´¡£¡£Óó¬Ð¡µÄpointBase¶¼±ÈACCESSºÃ¡£¡£¶øÇÒÄãÈÏΪLuNIX»òÕßUNIXÉÏ»áÈ¥×°ACCESSô£¿´ó¶àÊýµÄJSP·þÎñÆ÷¶¼ÊÇLUNIX»òÕßUNIX¡£
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
<%@ page contentType = "text/html;charset =gb2312"%>
<%!
public String codeToString(String str)
{
String s =str;
&nbs ......
ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ ......
ÈçÌ⣬ÎÒÊÇÓÃstruts2×öµÄÍøÒ³£¬ÓÃÁËradio±êÇ©£¬Ã¿¸öÑ¡Ïîǰ¶¼ÓÐÒ»¸öСԲȦ£¬ÎÒÐèÒª°ÑСԲȦȥµô£¬µ¥»÷×־ͺ㬱»Ñ¡ÖеÄÑ¡Ïî±³¾°±äÉ«¡£
¾ÍÏñ´ó¶àÊýÍøÕ¾µÄ·ÖÀà¼ìË÷£¬±ÈÈçÕâ¸öÍøÕ¾µÄÄÇÑùµÄ¸ù¾Ý¸÷ÖÖÌõ¼þµÄʵʱËÑË÷£º
ht ......
ÎÒµãºóÍËʱÊǿհ×Ò³Ãæ
ÐèˢвÅÄÜÏÔʾ
Õâ¸öÔõô´¦Àí°¡
Çë´ó¼Ò°ï°ïæ
°ÑÎÊÌâ˵µÄÏêϸһЩ£¬ÕâÑùÓÐÖúÓÚÎÊÌâµÄ»Ø¸´£¬¼°´ð°¸µÄ׼ȷÐÔ£¡
ÎÒ¾õµÃÊÇÄãµÄä¯ÀÀÆ÷Æ÷µÄÎÊÌâ°É£¬ÎÒÒÔǰÓöµ½¹ýÕâÑùµÄÎÊÌ⣬°ÑIEµÄËùÓÐÊôÐÔÖ ......