Formosa Studio ??????????

use a java code like this:

import java.sql.*;

public class JdbcExample1 {

public static void main(String args[]) {
Connection con = null;

try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql:///test", "root", "secret");

if(!con.isClosed())
System.out.println("Successfully connected to MySQL server...");

} catch(Exception e) {
System.err.println("Exception: " + e.getMessage());
} finally {
try {
if(con != null)
con.close();
} catch(SQLException e) {}
}
}
}

1. Download mySQL from mySQL.com

2. Get mySQL Connector/J from http://www.mysql.com/products/connector/j/

3. Get Tomcat and mySQL work together. detail:

http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html

[MySQL DBCP Example] section.

Please don’t forget to put JDBC Driver’s jar

(mysql-connector-java-3.1.13-bin.jar)

to $Tomcat_Home/common/lib.

Then set CLASSPATH to something like: TOMCAT_HOME%\common\lib\mysql-connector-java-3.1.13-bin.jar?

4. Before you try the example code on that [MySQL DBCP Example] section,

please go get JSTL (Java Server Pages Tag Lab) at:

http://jakarta.apache.org/site/downloads/downloads_taglibs-standard.cgi

and copy jstl.jar and standard.jar to your web app’s WEB-INF/lib directory.

Failure of doing this will generate an error page.

== Setup Apache 2.2 ==

1. Get Apache 2.2 from here: http://httpd.apache.org/

2. Install to anywhere you like. ex: D:\Apache

3. You can also set DocumentRoot in httpd.conf file

(D:\Apache\conf\httpd.conf for example) and Type in:

?DocumentRoot 『D:/www/abcd/webApp/』

Note: Remember that when adding path values in the Apache

configuration files on Windows, all backslashes such as c:\directory\file.ext

must be converted to forward slashes, as c:/directory/file.ext. A trailing slash

may also be necessary for directories.

4. Make an index.html file and put it under you DocumentRoot. Open your Browser and

type http://localhost/ to see if you can see the page.

== Setup PHP ==

1. Download PHP 5.2 at : http://snaps.php.net/

(Please note that only PHP 5.2 work with Apache 2.2)

2. Put the .zip anywhere you like. ex: D:\PHP

3. Rename D:\PHP\php.ini-recommended to php.ini

4. Add D:\php to the PATH (Control Panel)

5. Set the doc_root to point to your web servers document_root.

For example:

doc_root = c:apachehtdocs // for Apache

(or doc_root = D:wwwabcdwebApp in our case)

6. Install PHP as an Apache Module:

you need to insert these two lines to

your Apache httpd.conf configuration file to set

up the PHP module for Apache 2.2:

# For PHP 5.2 do something like this:

LoadModule php5_module "D:/PHP/php5apache2_2.dll"

AddType application/x-httpd-php .php

# configure the path to php.ini

PHPIniDir "D:/PHP"

7. make a php page and put it under your document root.

Some Example can be found at:

http://www.php.net/manual/en/tutorial.firstpage.php