´î½¨JSP ×éºÏMyEclipse£«MySQL£«Tomcat¿ª·¢»·¾³
Ò»¡¢°²×°JDK ¡¡¡¡Ê×ÏÈÏÂÔØJDK 5.0£¨JDK 5.0µÄÏÂÔØÒ³ÃæÎª£ºhttp://java.sun.com/j2se/1.5.0/download.jsp£©£» È»ºóÔËÐÐJDK 5.0°²×°³ÌÐòjdk-1_5_0_06-windows-i586-p.exe£¬°²×°¹ý³ÌÖÐËùÓÐÑ¡Ïî±£³ÖĬÈÏ£»×îºóÅäÖÃJDKµÄ»·¾³±äÁ¿£ºÔÚ“ÎҵĵçÄÔ”ÉϵãÓÒ¼ü—>“ÊôÐÔ”—>“¸ß¼¶”—> “»·¾³±äÁ¿(N)”¡£ ¡¡¡¡Ð½¨ÏµÍ³±äÁ¿JAVA_HOME£ºC:\Program Files\Java\jdk1.5.0_06£» ¡¡¡¡Ð½¨ÏµÍ³±äÁ¿CLASSPATH£º.;%JAVA_HOME%\lib;£¨×¢Ò⣺µãºÅ±íʾµ±Ç°Ä¿Â¼£¬²»ÄÜÊ¡ÂÔ£© ¡¡¡¡ÔÚϵͳ±äÁ¿PathµÄÖµµÄÇ°Ãæ¼ÓÈëÒÔÏÂÄÚÈÝ£º%JAVA_HOME%\bin;(×¢Òâ:ÕâÀïµÄ·ÖºÅ²»ÄÜÊ¡ÂÔ) ¡¡¡¡µ½ÕâÀJDK°²×°Íê±Ï¡£ ¡¡¡¡ÏÂÃæÎÒÃDzâÊÔÒ»ÏÂJDKÊÇ·ñ°²×°³É¹¦£º ¡¡¡¡½«ÒÔÏÂÄÚÈݸ´ÖƵ½¼Çʱ¾ÖУº public class HelloJAVA { public static void main(String srg[]) { System.out.println("Hello JAVA!"); } } ¡¡¡¡Áí´æÎª“HelloJAVA.java”£¨²»º¬ÒýºÅ£¬ÏÂͬ£©£¬²¢±£´æµ½DÅ̸ùĿ¼Ï¡£ ¡¡¡¡ÔÚÃüÁîÐÐÒÀ´ÎÊäÈëÏÂͼÖкìÏßËù±ê×¢µÄÃüÁ ¡¡¡¡Èç¹û³öÏÖÉÏͼºì¿òÖÐËù±ê×¢µÄÄÚÈÝ£¬Ôò˵Ã÷JDK°²×°³É¹¦£¡ ¡¡¡¡×¢Òâ:Èç¹ûÒÔºóÒª°²×°ÖîÈçEclipse¡¢Borland JBuilder¡¢JCreator¡¢IntelliJ IDEAµÈ¼¯³É¿ª·¢»·¾³(IDE,Integrated Development Environment),Ó¦¸ÃÔÚIDEÖбàÒëÔËÐÐÒ»¸ö¼òµ¥µÄHelloWorld³ÌÐò£¬ÒÔ±£Ö¤IDE¿ÉÒÔʶ±ð³öJDKµÄλÖᣠ¡¡¡¡¶þ¡¢°²×°Tomcat ¡¡¡¡Ê×ÏÈÏÂÔØjakarta-tomcat-5.0.30.zip£¬Ö®ËùÒÔÏÂÔØÃâ°²×°°æµÄºÃ´¦ÊÇ¿ÉÒÔʹÓöà¸öTomcat£¨jakarta-tomcat-5.0.30.zipµÄÏÂÔØÒ³ÃæÎª£º http://apache.linuxforum.net/tomcat/tomcat-5/v5.0.30/bin/£©£» ¡¡¡¡È»ºó½«jakarta-tomcat-5.0.30.zipÖ±½Ó½âѹµ½DÅ̸ùĿ¼£º ¡¡¡¡×îºóÅäÖÃTomcatµÄ»·¾³±äÁ¿£ºÔÚ“ÎҵĵçÄÔ”ÉϵãÓÒ¼ü—>“ÊôÐÔ”—>“¸ß¼¶”—> “»·¾³±äÁ¿(N)”¡£ ¡¡¡¡Ð½¨ÏµÍ³±äÁ¿CATALINA_HOME£ºD:\jakarta-tomcat-5.0.30 ¡¡¡¡ÔÚϵͳ±äÁ¿CLASSPATHµÄÖµµÄºóÃæ¼ÓÈ룺%CATALINA_HOME%\common\lib; ¡¡¡¡ÔÚϵͳ±äÁ¿PathµÄÖµÖÐ"%JAVA_HOME%\bin;"µÄºóÃæ¼ÓÈëÒÔÏÂÄÚÈÝ£º%CATALINA_HOME%\bin; ¡¡¡¡µ½ÕâÀTomcat°²×°Íê±Ï¡£ ¡¡¡¡½øÐÐÍêÒ»¡¢¶þÁ½²½µÄÉèÖÃÒԺ󣬸÷ϵͳ±äÁ¿µÄÖµÈçÏ£º JAVA_HOME:C:\Program Files\Java\jdk1.5.0_06 CATALINA_HOME:D:\jakarta-tomcat-5.0.30 CLASSPATH:.;%JAVA_HOME%\lib;%CATALINA_HOME%\common
Ïà¹ØÎĵµ£º
Doing INTERSECT and MINUS in MySQL
By Carsten | October 3, 2005
Doing an INTERSECT
An INTERSECT is simply an inner join where we compare the tuples of one table with those of the other, and select those that appear in both while weeding out duplicates. So
SELECT member_id, name from a
INTERSECT ......
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>index</title>
<meta http-equiv="pragma" content="no-cache"&g ......
ÍøÕ¾µÄÊý¾Ý¿âÊǵ÷ÓÃÔ¶³Ì·þÎñÆ÷ÉϵÄ,²»ÊDZ¾»úµÄ.ÍøÕ¾´ò¿ª±È½ÏÂý.ÔÚÍøÉÏËÑË÷ÁË·½·¨,Õâ¸ö·½·¨¿ÉÒÔ½â¾ö,µ«ÊÇÓÐÁíÍâµÄÎÊÌâ³öÏÖ:
-----------------------------------------------------------------------
ÔÚ¾ÖÓòÍøÄÚÁ¬½ÓÆäËû»úÆ÷µÄMYSQL,·¢ÏÖËÙ¶ÈÂýµÄºÜ,²»ÖªµÀʲôÔÒò,×ÜÓм¸ÃëµÄÑÓ³Ù.
ºóÀ´ÔÚÍøÉÏ·¢ÏÖ½â¾ö·½·¨,my.iniÀïÃæÌ ......
Ò»¡¢MySQL°²×°£º
Ìí¼ÓϵͳÓû§£º
groupadd mysql (/usr/sbin/groupadd)
useradd -g mysql mysql
°²×°²½Ö裺
tar zxfv mysql-*.tar.gz(mysql-5.0.51a)
./configure --prefix=/usr/local/mysql
make
make install
cp support-files/my-medium.cnf /etc/my.cnf
cd /usr/local/mysql
bin/mysql_install_db --user ......
1.
ǰÑÔ
ÎÒʹÓõÄÖ÷»úÃûΪserver1.example.com
£¬ip
µØÖ·ÊÇ192.168.0.100
¡£ÕâЩÉèÖÿÉÄÜÓëÄãÏëÒªµÄÓÐËù²»Í¬£¬ËùÒÔÄã±ØÐëÔÚÊʵ±µÄµØ·½ÐÞ¸Äһϡ£
2
°²×°MySQL5
ÓÃÏÂÁÐÃüÁî°²×°MySQL
£º
yum install mysql mysql-server
È»ºóÎÒÃÇΪMySQL
´´½¨ÏµÍ³Æô¶¯Á´½Ó£¨ÕâÑùµÄ»°£¬MySQL
¾Í»áËæ×ÅϵͳÆô¶¯¶øÆô¶¯£©£¬²¢Æô¶¯ ......