ÄÄÀïÓÐÃâ·ÑµÄÖ§³Ö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¡£
Ïà¹ØÎÊ´ð£º
<?php
include("adodb/adodb.inc.php");
$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......
ÔÚASPϵıäÁ¿£¬Èç¡°2009-09-09¡°£¬×÷Ϊ²ÎÊý£¬´«ÈëJSPº¯ÊýÄÚ£¬±äΪÂÒÂ룬ÇëÎÊÈçºÎ½â¾ö
asp´«µ½jsp?ûÅö¹ý...up up
¸ñʽ»¯°¡£¡
ASPÖÐÈÕÆÚÊDz»ÊÇÒÔ×Ö·û´®µÄÐÎʽ´«ÈëJSPº¯ÊýÖеģ¿
Èç¹û²»ÊÇ×Ö·û´®µÄ»°£ ......
ÎÒÏÖÔÚÏëÓÃsshÕûºÏÀ´×öÒ»¸öÂÛ̳£¬µ«Êý¾Ý¿â·½Ãæ²»ÐУ¬ÎÒÖ÷Òª²»»áÉæ¼°Êý¾Ý¿â£¬²»ÖªµÀ·¢Ìû±í£¬ºÍ»ØÌû±íÒªÈçºÎÉè¼ÆºÍÇø·Ö¡£²»ÖªµÀËÓÐÒ»¸ö¼òµ¥µÄ˼·£¬À´Éè¼ÆÕâЩ±í¡£Ð»Ð»ÁË¡£
·¢ÌûºÍ»ØÌûÓÃͬһÕÅ±í ¡£·¢Ìû id user ......
ÎҵĿª·¢µÄƽ̨ÊÇMyeclipes6.0 + tomcat5.x + mysql
ÎÒËùÓеıàÂ뷽ʽ¶¼ÊÇÓõÄUTF-8
ÎÒÖ»ÓÃÁËStrtus¿ò¼Ü
ÔÚÒ»¸öformÖÐÈçÏÂÓõÄÊÇpostµÄÌá½»·½Ê½£º
<form class="form" action=&quo ......
ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......