jsp Á¬½ÓÊý¾Ý¿âMySQLÏà¹ØÇý¶¯µÄÅäÖÃ
֮ǰ¶àÉÙÌ죬ÍüÁË£¬ÅäÖùýÒ»´Î£¬ÓÉÓÚ֨װ¹ýϵͳ£¬»¹µÃÔÙÅäÖã¬ÓÖÕÒÁ˰ëÌì¡£¸É´à¼ÇÏÂÀ´£¬µ½Ê±ºòÖ±½ÓÀ´ÕÒÁË¡£
Ê×ÏÈ£¬ÏÂÔØÇý¶¯£ºmysql-connector-java-5.0.4-bin.jar
°Ñmysql-connector-java-5.0.4-bin.jar¿½±´µ½D:\Tomcat 6.0\libÏ£¬È»ºóÔÚclasspathÀïÃæ¼ÓÈëD:\Tomcat
6.0\lib\mysql-connector-java-5.0.4-bin.jar¼´¿É¡£
ÅäÖÃÕâ¸öµÄÄ¿µÄÊÇÈÃÄãµÄjavaÓ¦ÓóÌÐòÕÒµ½Á¬½ÓmysqlµÄÇý¶¯¡£
¿½±´ÕâÒ»²½¾ÍÊÇΪJSPÁ¬½ÓÊý¾Ý¿âÅäÖÃÇý¶¯¡£
Õâ¾ÍºÃÁË£¬¼«Æäeasy.
Ïà¹ØÎĵµ£º
Ò»ÏÂÊÇÒ»¸öSQLµÄСÎÊÌ⣬À§ÈÅÁË3·ÖÖÓ£¬Ð´ÏÂÀ´¼Ç¼һÏ¡£
Êý¾Ý¿âÊÇMYSQL 5, ±íµÄ½á¹¹ºÜ¼òµ¥, ¾ÍÒ»¸ö×Ö¶ÎÊÇabc£¬ÕûÐÍ¡£
Ò»ÏÂÓï¾äÔËÐеĽá¹ûÊÇÒ»ÑùµÄ¡£×Ô¼º²»ÁôÉñ£¬µ¼ÖÂÀ§ÈÅÁË3·ÖÖÓ¡£
select * from table1 from abc = '123'
select * from table1 from abc = '123_1'
ÒÔÉÏÓï¾äÔÀ´ÊDzéÕÒÊÇ·ñÊý¾Ý´æÔÚ£¬½á¹û123_1ºÍ1 ......
ÉϺ£ÔóÎäÍøÂçÓÐÏÞ¹«Ë¾
ÕÐÆ¸£ºÕÐÆ¸jsp\phpÍøÕ¾¿ª·¢³ÌÐòÔ±
ÒªÇóÓÐÈýÄêÒÔÉÏ¿ª·¢¾Ñé
¶ÔTomcat+Apache¼¯Èº¼¼ÊõÓÐÊìϤµÄ¾Ñé.¶ÔËÑË÷ÒýÇæ¼¼Êõ(Lucene)±È½ÏÁ˽⡣
-ÊìÁ·Ê¹ÓÃUML½¨Ä£¹¤¾ß¡¢°æ±¾¿ØÖƹ¤¾ß; ÊìÁ·Ê¹ÓÃEclipseµÈIDE¿ª·¢¹¤¾ß;
-¾«Í¨JAVA,php,ÉîÈëÀí½âOOP˼Ïë,ÊìϤÉè¼ÆÄ£Ê½¡£
-ÊìÁ·ÔËÓÃJ2EE¼¼Êõ¡¢WEB·þÎñÆ÷ºÍ¹ØÏµÐ ......
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-tiles.tld" prefix="tiles" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> ......
<html:html>
<HEAD>
<tiles:insert attribute="header" />
</HEAD>
<body>
<tiles:insert attribute="top" />
<table width="100%" height="400" border="0" align="center"
cellpadding="0" cellspacing="0">
<tr>
<td width="178" ......
<table width=100% border="0" align="center" cellpadding="0"
cellspacing="0">
<tr>
<td height="1" class="gray1"></td>
</tr>
</table>
<tiles:insert attribute="footer" />
</body>
</html:html> ......