ÇëÎÊʹÓÃado¿Ø¼þÁ¬½ÓmysqlÊý¾Ý¿âµÄ²½ÖèÊÇʲô
ÈçÌâ¡£ÎÒÒѾ°²×°ÁËmysqlodbcÇý¶¯¡£
adodc¿Ø¼þÊôÐÔÀïÃ棬Á¬½Ó×ÊÔ´£¬
ÓÐ
ʹÓÃDataLinkÎļþ
ʹÓÃODBCÊý¾Ý×ÊÔ´Ãû³Æ
ʹÓÃÁ¬½Ó×Ö·û´®
ÊÇÑ¡ÔñÄĸö£¿
È»ºóµÃ²½ÖèÊÇÔõôÑùµÄ£¿
HTML code:
http://www.connectionstrings.com/mysql
ʹÓÃÁ¬½Ó×Ö·û´®£¡
ÕÒµ½ÁË
ʹÓÃODBCÊý¾Ý×ÊÔ´Ãû³Æ
½áÌù
Ïà¹ØÎÊ´ð£º
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æҲûÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
½ñÌìÀÏ´ó²¼ÖøöÈÎÎñ£¬ÒªÎÒÔÚÎÒÃǵIJúÆ·Öа²×°Ò»¸öMYSQLÊý¾Ý¿â£¬ÒªÇóÊÇÈí¼þÕ¼Óÿռ䲻Äܳ¬¹ý5M¡£
ÔÚÍøÉÏÕÒÁ˺þÃҲûÓÐÕÒµ½¹ØÓÚǶÈëʽϵͳÖÐMySQLÊý¾Ý¿âµÄ×ÊÁÏ£¬ÓеÄÒ²Ö»ÊǼòµ¥Ìáһϡ£
ÏÖÌØÏò¸÷λÇë½ÌÒÔÏÂÎÊÌ⣺
......