tomcat6.0 + JSP + mysqlÊý¾Ý¿âÁ¬½Ó³ØÅäÖÃ
tomcat6.0 + JSP + mysqlÊý¾Ý¿âÁ¬½Ó³ØÅäÖÃ
»·¾³£ºtomcat6.0 £¬mySQL 5.021
°ÑmysqlÇý¶¯°ü·Ö±ð·Åµ½%TOMCAT_HOME%/lib ºÍÄãµÄÓ¦ÓõÄWEB-INF\libÎļþ¼ÐÏÂÃæ
1¡¢ÐÞ¸Ä%TOMCAT_HOME%/conf/server.xml,Ìí¼ÓÈçÏÂÄÚÈÝ£¨²¿·Ö²ÎÊýÇë±¾µØ»¯£©£º
<Context path="/web" docBase="web" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/query" auth="Container"
type="javax.sql.DataSource" driverClassName="org.gjt.mm.mysql.Driver"
maxIdle="20" maxWait="5000" username="username" password="password"
url="jdbc:mysql://localhost:3306/DataBaseName" maxActive="100"
removeAbandoned="true" removeAbandonedTimeout="60"
logAbandoned="true"/>
</Context>
2¡¢Ð޸ĶÔÓ¦Ó¦ÓõÄweb.xml£¬ÔÚ</web-app>Ç°Ìí¼ÓÈçÏÂÄÚÈÝ£º
<ResourceLink name="jdbc/query" global="jdbc/query" type="javax.sql.DataSourcer"/>
ÖØÆôtomcat£¬´ó¹¦¸ã³É£¡
Ó¦ÓÃʵÀýÈçÏ£º
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="javax.naming.Context" %>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.sql.*"%>
<html>
<body>
123
<%
DataSource ds = null;
try{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
//´ÓContextÖÐlookupÊý¾ÝÔ´¡£
ds = (DataSource)envCtx.lookup("jdbc/query");
Ïà¹ØÎĵµ£º
1¡¢ÆÕͨË÷Òý
¡¡¡¡ÆÕͨË÷Òý£¨Óɹؼü×ÖKEY»òINDEX¶¨ÒåµÄË÷Òý£©µÄΨһÈÎÎñÊǼӿì¶ÔÊý¾ÝµÄ·ÃÎÊËٶȡ£Òò´Ë£¬Ó¦¸ÃֻΪÄÇЩ×î¾³£³öÏÖÔÚ²éѯÌõ¼þ£¨WHEREcolumn=£©»òÅÅÐòÌõ¼þ£¨ORDERBYcolumn£©ÖеÄÊý¾ÝÁд´½¨Ë÷Òý¡£Ö»ÒªÓпÉÄÜ£¬¾ÍÓ¦¸ÃÑ¡ÔñÒ»¸öÊý¾Ý×îÕûÆë¡¢×î½ô´ÕµÄÊý¾ÝÁУ¨ÈçÒ»¸öÕûÊýÀàÐ͵ÄÊý¾ÝÁУ©À´´´½¨Ë÷Òý¡£
¡¡¡¡2¡¢Î¨Ò»Ë÷Òý
......
MySQLµÄ×Ö·û¼¯Ö§³Ö(Character Set Support)ÓÐÁ½¸ö·½Ã棺
×Ö·û¼¯(Character set)ºÍÁ¬½ÓУ¶Ô(Collation)¡£
¶ÔÓÚ×Ö·û¼¯µÄÖ§³Öϸ»¯µ½Ëĸö²ã´Î:
·þÎñÆ÷(server)£¬Êý¾Ý¿â(database)£¬Êý¾Ý±í(table)ºÍÁ¬½Ó(connection)¡£
1.MySQLĬÈÏ×Ö·û¼¯
MySQL¶ÔÓÚ×Ö·û¼¯µÄ ......
×î½üÊÕµ½Ò»¸öÏîÄ¿µÄÔ´´úÂ룬²¿ÊðÒÔºó´ò¿ªÒ³Ãæ·¢ÏÖJSPÒ³ÃæÖеÄEL±í´ïʽ¶¼Ã»ÓнâÎö£¬¶¼ÊÇÔÑùÏÔʾ¡£
ÉÏÍøËÑË÷ÁËÒ»ÏÂÔÒò£¬ÔÀ´ÊÇServlet°æ±¾µÄÎÊÌâ¡£ÔÀ´ServletÖпÉÒÔÉ趨ÊÇ·ñ½âÎöEL±í´ïʽ£¬Ö»ÓÐ2.4°æ±¾µÄServletĬÈÏÊǽâÎöEL±í´ïʽµÄ£¬¶øÆäËû°æ±¾ÊÇĬÈϲ»½âÎöEL±í´ïʽ£¬²éÁËһϳÌÐò£ ......
jspѧϰÐĵÃ
ѧϰJSP¼¼ÊõÒ²¿ì°ëÄê¶àÁË°É£¬×Ô¼ºÒ²¶¯ÊÖ±àдÁËһЩ¼òµ¥µÄ¶¯Ì¬ÍøÒ³°É¡£ÖÚËùÖÜÖª¶¯Ì¬ÍøÒ³Èý´ó¼¼ÊõASP£¬JSP£¬PHP»ù±¾ÉÏÊÇÈý·ÖÌìÏ£¬µ±È»»¹ÓÐÆäËûÓïÑÔÏñRuby£¬PythonµÈÒ²Õ¼¾Ý²»Ð¡µÄ·Ý¶î¡£
ѧϰJSP¹ý³ÌÖÐÎҸд¥×îÉîµÄÊÇÈçϼ¸µã£º
1.JSPÊÇÒ»ÖÖ±íʾ²ãµÄ¼¼Êõ
&nb ......
MySQL 4.1.12°²×°Æª
[Ïà¹ØÈí¼þÏÂÔØ£º]
Mysql 4.1.12-win32 -
For Windows ( Mysql 4.1.12-win32.exe ) -- Êý¾Ý¿â·þÎñ
ÏÂÔصØÖ·£º
http://cdgwbn.downloadsky.com:8080/down/mysql-4.1.12-win32.zip
Connector/ODBC
- MySQL ODBC driver ( MyODBC-3.51.11-1-win.exe ) -- Êý¾ÝÔ´
ÏÂÔصØÖ·£º
http://down.21sun.ne ......