Eclipse + tomcat + MySQL

Reprint please indicate the source of the original, http://www.cnblogs.com/flyingcloude/p/6992320.html

This weekend, to help friends configure Eclipse + tomcat + MySQL environment, has not used this thing, and now do not do these things, but feel that they do not have any problems, and now the network so developed, what information can be found, so agreed.

Let's talk about some of the procedures below:

MySQL configuration: The first to go to www.mysql.org downloaded the installation version, but always after the installation is not going to go, and then did not go into what the problem. Later went to a free installation version, decompression and put to the C packing directory (C:\MYSQL), followed by the configuration of MySQL;

1) Run cmd, enter the C:\mysql\bin directory;

2) Install MySQL service, command: Mysqld-install mysql (uninstall MySQL service, command: Mysqld-remove MySQL)

3) Start MySQL service, command: net start mysql (stop MySQL service, command: net stop MySQL)

4) Log in as Administrator, command: mysql-h localhost-u root-p (password is empty, that is, direct return)

5) View database, command: show databases; (Remember to have a semicolon, a complete SQL command needs to end with a semicolon, except for some special things like MySQL, quit)

6) Enter a specified database, command: use test; (CREATE DATABASE, command: Create DB name;)

7) View the table in the database, command: show tables;

8) Other commands are the same as SQL Server. such as SELECT, Insert, Del, UPDATE, and so on.

Tomcat configuration: This is the most tragic thing, spent nearly half a day to get to the end has not done well, fortunately finally met a master pointing the next (the original is the installation of the directory with a space for the sake of AH), tragedy ah, wasted half a day of time. It seems that the future installation of software should be careful of this situation. Because MySQL database is used, it is necessary to add Mysql-connector-java-3.1.13-bin.jar in Tomcat's lib directory, and download it online.

At first, because the Tomcat installation directory has a space, although Tomcat service has been up, (view port can use netstat-a), found 8080 also listen, but with IE to access http://localhost:8080, is not access, in the process, Installed and uninstalled, uninstalled and installed, for a different version, according to the online set up a lot of environmental variables, and ultimately did not succeed, fortunately to get expert guidance, so after installing the software or to be careful path name space problem.

But the strange thing is that my computer can actually start several 8080 ports, do not know why.

Eclipse configuration: This requires the installation of a Tomcatplugin plugin so that Tomcat can be used, but it has not been used to deploy with eclipse, so it is not yet available. Installing the Tomcatplugin plugin puts Tomcatplugin's plug-in package under Eclipse's plugins. After that, you should be able to run up.

Reprint please indicate the source of the original, http://www.cnblogs.com/flyingcloude/p/6992320.html

Eclipse + tomcat + MySQL