ÄÄÀïÓÐÃâ·ÑµÄÖ§³Ö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¡£
Ïà¹ØÎÊ´ð£º
ÔÚ²éѯºó½«²éѯ³öÀ´µÄÖµ¸³¸ø¸÷ÊäÈë¿ò
<c:if test="${not empty dataValue}">
fm.SAMPLING_DATE.value=" <c:out value='${dataValue.SAMPLING_DATE}'/ ......
<%@ page contentType = "text/html;charset =gb2312"%>
<%!
public String codeToString(String str)
{
String s =str;
&nbs ......
ÎҵĿª·¢µÄƽ̨ÊÇMyeclipes6.0 + tomcat5.x + mysql
ÎÒËùÓеıàÂ뷽ʽ¶¼ÊÇÓõÄUTF-8
ÎÒÖ»ÓÃÁËStrtus¿ò¼Ü
ÔÚÒ»¸öformÖÐÈçÏÂÓõÄÊÇpostµÄÌá½»·½Ê½£º
<form class="form" action=&quo ......
ÏÂÃæcategoryTreeCont.jsp ´úÂë
----------------------------------------
Java code:
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
< ......
ÎÒ°ÑjavabeanµÄÔ´´úÂëSetGetPropertytest.Java·ÅÔÚC:\tomcat\webapps\mywork\WEB-
INF\classes\comÖÐ ÊDz»ÊÇÎҵİü´´½¨´íÁË»¹ÊÇ£¿ÒªÊǽ¨´íÁË,ËÄܸæËßÎÒÔõô½¨Âð? лл´ó¼Ò
ǰÀ´°ï棬ͬʱף´ó¼ÒÖÐÇï¿ ......