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= ÃÜ
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚÏëÓÃsshÕûºÏÀ´×öÒ»¸öÂÛ̳£¬µ«Êý¾Ý¿â·½Ãæ²»ÐУ¬ÎÒÖ÷Òª²»»áÉæ¼°Êý¾Ý¿â£¬²»ÖªµÀ·¢Ìû±í£¬ºÍ»ØÌû±íÒªÈçºÎÉè¼ÆºÍÇø·Ö¡£²»ÖªµÀËÓÐÒ»¸ö¼òµ¥µÄ˼·£¬À´Éè¼ÆÕâЩ±í¡£Ð»Ð»ÁË¡£
·¢ÌûºÍ»ØÌûÓÃͬһÕÅ±í ¡£·¢Ìû id user ......
//Óÿͻ§µÄsessionµÄid½¨Á¢Ò»¸öÁÙʱÎļþ£º
//String tempFileName=(String)session.getId();
String tempFileName = (String)session.getId();
//out.println(& ......
ÎÒÏëµÇ¼ºó£¬Èç¹ûµÇ¼³É¹¦¾ÍÈ¥Ö´ÐÐij¸öÒ³Ãæ
ÎÒÏÖÔڵĴúÂëÊÇÕâÑùµÄ£º
if(rs.next()){
session.setAttribute( "username" , user);
<jsp:include page="login.jsp" />// ......
jsÖеķ½·¨£¬²»ÄÜÔÚjspÖе÷ÓÃÔõô½â¾ö£¿¼±£¡£¡!
²»Ã÷°×Òâ˼
ºÃºÃ¼ì²éÊDz»ÊÇ·¾¶µÄÎÊÌ⣬ºÜÓпÉÄÜ·¾¶²»¶Ôµ¼Öµ÷Óò»µ½
Ìùһϵ÷ÓõĴúÂë¿´¿´°¡~~
ÓÐûÓÐÕýÈ·ÒýÓÃjs£¿º¯ÊýÓÐûÓгõʼ»¯£¿....
jsp´úÂë±¾À´¾ ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......