Tomcat5+MysqlÎÄÖÐÂÒÂëÎÊÌâµÄ½â¾ö·½·¨ (ת)
Tomcat ÏÂ×îÈÝÒ×µ½µÄÎÊÌâ¾ÍÊÇÖÐÎÄÂÒÂëÎÊÌâÁË , ÏÂÃæ¾ÍÀ´Ì¸Ì¸ÎÒÔÚ Windows +Tomcat5 ϵ÷ÊÔ JSP ³ÌÐòʱ , ËùÅöµ½µÄÎÊÌâÒÔ¼°½â¾ö°ì·¨¡£
Õâ´Îµ÷ÊÔËùÓöµ½µÄÂÒÂëÎÊÌâÖ÷ÒªÓÐÈýÀࣺ
Ò»¡¢ Ò³Ãæ×Ö·ûÂÒÂë¡£
¼´Õû¸öÒ³Ãæ³öÏÖºº×ÖÂÒÂ루²»¹ÜÊÇÓà HTML ¸ñʽдµÄ£¬»¹ÊÇÓà print() ·½·¨Êä³öµÄºº×Ö£¬È«²¿ÏÔʾΪÂÒÂ룩¡£
¶þ¡¢ Request ´«µÝÂÒÂë¡£
ÔÚÓà post £¬ get µÈ·½·¨£¬´«µÝ±äÁ¿Ê±³öÏÖÂÒÂ룻ÐèÒª½øÐÐ cookies »òÕß session µ÷ÓÃʱ³öÏÖÂÒÂë¡£
Èý¡¢ Êý¾Ý¿â´æÈ¡ÂÒÂë¡£
ÔÚ½øÐÐÊý¾Ý¿â´æÈ¡Ê±£¬»òÕß´æÈëÊý¾Ý¿â£¬»òÕß¶Á³öÊý¾Ýʱ³öÔÙÂÒÂë¡£
ÏÂÃæ¾ÍÕâÈýÀàÂÒÂë½øÐзÖÎö²¢Ì¸Ì¸ÎҵĽâ¾ö·½·¨£º
Ò»¡¢ Ò³Ãæ×Ö·ûÂÒÂë¡£
ÎÒÃÇÏÈдÏÂÕâÑùµÄÒ»¸ö jsp Îļþ£º
//testPagErr.jsp
<%
out.println(“ ÄÜÏÔʾÖÐÎÄÂ𣿠”);
%>
Èç¹ûÎÒÃÇÖ±½Ó°´ÕÕĬÈϵÄÅäÖÃÆô¶¯ Tomcat5 £¬È»ºó·ÃÎÊÕâÒ»¸öÒ³ÃæµÄʱ£¬½«Êä³öµÄÖÐÎĽ«ÏÔʾΪÂÒÂë¡£ÆäÔÒòºÜ¼òµ¥£¬ÕâÊÇÓÉÓÚÔÚ Tomcat5 ĬÈϵÄÉèÖÃÏ£¬½«°´ÕÕ ISO-8859-1 ½øÐбàÂë¡£½â¾öÕâ¸öÎÊÌâ×îÖ±½ÓµÄ×ö·¨ÊÇ£¬ÓÐÿ¸öÓÐÖÐÎÄÊä³öµÄ jsp ÎļþµÄ¿ªÍ·¼ÓÒ»¾ä£º
<%@ page contentType="text/html;charset=GBK" // £¨¸Ä³É GB2312 Òà¿É£¬±¾ÎÄÖоùÒÔ GBK ΪÀý£© %>
µ«ÊÇÕâÑù×ö´æÔںܶàÎÊÌ⣬Ê×ÏÈ£¬ÕâÒ»¾ä¿ªÖ¸ÁîÔÚ include µÄʱºò£¬²»Äܹ»±»×ÓÎļþ¼Ì³Ð£¬Òò´Ë£¬ÎÒÃDZØÐëÔÚ×ÓÎļþÖÐÖØÐ¼ÓÈëÕâÒ»¾ä»°£¬µ«Èç¹û´óСд²»»°£¬¾Í»á³öÏÖÀàËÆÓÚÒÔϵĴíÎó£º
org.apache.jasper.JasperException: /top.jsp(1,1) Page directive: i
Ïà¹ØÎĵµ£º
¼ÇÁËһЩÓà Windows µÄÃüÁîÐÐÀ´²Ù×÷ MySQL µÄÖ¸Áî¡£
ÕªÒª
Á¬½á MySQL
->mysql -u username -p
username ÊÇÄãµÄÕʺÅÃû³Æ¡£
Ô¶³ÌÁ¬½á
->mysql -h hostname -u username -p
hostname ÊÇ MySQL Ö÷»úµÄÃû³Æ¡£
ÏÔʾȫ²¿µÄÊý¾Ý¿â
SHOW DATABASES;
mysql ÊÇ MySQL ÓÃÀ´´¢´æÕʺźÍȨÏÞµÄÊý¾Ý¿â£¬²»ÄÜɾ³ý¡£
Ñ¡Ôñ ......
mysql µ¼³ö±í£º
mysqldump -u Óû§Ãû -p --opt Êý¾Ý¿âÓû§Ãû ±íÃû
> ±íÃû.sql
mysql µ¼³öÊý¾Ý¿â£º
mysqldump -u
Óû§Ãû -p --opt Êý¾Ý¿âÓû§Ãû
>
Êý¾Ý¿â
Ãû.sql
mysql µ¼Èë±í£º
>source e:\base\pet.sql;
mysql µ¼Èë±íÊý¾Ý£º
>LOAD DATA LOCAL INFILE 'e:path/pet.txt ......
½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......
ÏÔʾËùÓÐÊý¾Ý¿â show databases;
´´½¨Êý¾Ý¿â create dababase stu;
ɾ³ýÊý¾Ý¿âdrop database stu;
Çл»µ½Êý¾Ý¿âuse stu;
È¡µÃµ±Ç°µÄÊý¾Ý¿â,´ø£¨£©±íʾº¯Êý:select database();
´´½¨±í£¨ÒªÇл»µ½Êý¾Ý¿âÖУ©
mysql> create table stu_info(
-> stu_id int(8) ......
¹ØÓÚ·ÖÒ³µÄÓÅ»¯¡£
ÎÒÃÇÖªµÀ£¬ÔÚMySQLÖзÖÒ³ºÜ¼òµ¥£¬Ö±½ÓLIMIT page_no,page_total ¾Í¿ÉÒÔÁË¡£
¿ÉÊǵ±¼Ç¼ÊýÂýÂýÔö´óʱ£¬Ëý¾Í²»ÄÇôºÃʹÁË¡£
ÕâÀïÎÒÃÇ´´½¨ÕªÒª±íÀ´¼Ç¼ҳÂëºÍÔ±íÖ®¼äµÄ¹ØÁª¡£
ÏÂÃæÎª²âÊÔÊý¾Ý¡£
Ô±í£º
CREATE TABLE `t_group` (
`id` int(11) NOT NULL auto_increment,
`money` decim ......