jspÁ¬½ÓmysqlÎÊÌâ
´ÓÍøÉÏÏÂÁ˸öÁôÑÔ°å³ÌÐò£¬µ«ÊÇÔËÐв»ÆðÀ´£¬Õ⼸ÐдúÂëµÄÖµÓ¦¸ÃÈçºÎÅäÖã¬Çë´óÏÀÃǰï°ï棬лл ϵͳÊÇlinuxµÄ
#news.txt
driver=org.gjt.mm.mysql.Driver
mysql.url=jdbc:mysql://localhost/news
mysql.user=
mysql.password=
mysql.maxconn=1000
logfile=C:\\ilog.txt
driver=com.mysql.jdbc.Driver
mysql.url=jdbc:mysql://localhost/Êý¾Ý¿âÃû
mysql.user="ÄãÉèµÄÓû§Ãû"
mysql.password="ÄãÉèµÄÃÜÂë"
mysql.maxconn=1000
logfile=C:\\ilog.txt
ΪʲôÎÒµÄÎÊÌâûÈ˰ïÎÒ°¡ ÊDz»ÊÇÎÒµÄÎÊÌâÌ«¹ý¼òµ¥ÁË ¸Â¸Â ÎÒÊÇÐÂÊÖ ²ËÄñ ´ó¼Ò°ï°ïæ лл
µ¼Èëmql-tomcat.jar°üÁËô
¶àл¥Éϵģ¬mql-tomcat.jarÕâ¸öÊÇʲô°ü£¬ÊDz»ÊÇmysql-connector-java-5.1.5-bin.jar Õâ¸ö£¬Òª°ÑÕâ¸ö°ü·ÅÔÚÄĸöλÖã¬ÎÒjavaÊÇ×°ÔÚ/usr/local/jdk1.6.0_01ÕâÀÊDz»ÊǰÑÕâ¸ö°ü·ÅÔÚÕâ¸ö°²×°Ä¿Â¼µÄlibÏ£¬È»ºó»·¾³±äÁ¿ÈçÏÂÕâÑùÉèÖã¬ÊÇ·ñÕýÈ·ÄØ
export JAVA_HOME=/usr/local/jdk1.6.0_01
export CLASSPATH=$CLASSPATH:$JAVA_HOME/lib:$JAVA_HOME/jre/lib
export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH:$HOMR/bin
export CATALINA_BASE=/usr/local/tomcat
export CATALINA_HOME=/usr/local/tomcat
driver=com.mysql.jdbc.Driver //Êý¾Ý¿âÇý¶¯
mysql.url=jdbc:mysql://localhost:3306/Êý¾Ý¿âÃû³Æ //Á¬½Ó×Ö·û´®
mysql.user= Óû§Ãû
mysql.password= ÃÜ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......
ÎÒÏëµÇ¼ºó£¬Èç¹ûµÇ¼³É¹¦¾ÍÈ¥Ö´ÐÐij¸öÒ³Ãæ
ÎÒÏÖÔڵĴúÂëÊÇÕâÑùµÄ£º
if(rs.next()){
session.setAttribute( "username" , user);
<jsp:include page="login.jsp" />// ......
ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ ËÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá
ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:
public void doPost(HttpServletRequest reque ......
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´
......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......