A Software download
Mysql
Download version: 4.1.11
Http://dev.mysql.com/downloads/mysql/4.1.html
JDBC Driver
Download version: 3.1.8
Http://dev.mysql.com/downloads/connector/j/3.1.html
MySQL Interface plugin: mysql-front
Download version Image: HongKong (next to install is the Chinese version)
Http://www.mysqlfront.de/download.html
Two Software Installation
1. Install MySQL
Please refer to the related articles in the Data edition area
Http://info.mysql.cn/install/2006/0208/81.html
2.JDBC Drive: mysql-connector-java-3.1.8
This is just a compressed package, do not need to install, just unzip it, I am using the folder mysql-connector-java-3.1.8 files: Mysql-connector-java-3.1.8-bin.jar.
3. mysql Interface plugin: mysql-front
This is a setup program, follow the prompts to install it.
Three Environment configuration
First of all, I want to explain that I am now the installation path of Tomcat is: D:program filesjavatomcat;jdk installation path is: D:program filesjavaj2sdk.
In this case, the JDBC driver is required to configure the environment variables. Before you configure the Mysql-connector-java-3.1.8-bin.jar local hard drive somewhere (I put the place: D:program Filesjavamysqlforjdbc), and then depending on where you put it, Configure Classpath, my configuration is this:
D:program Filesjavaj2sdklibools.jar;
D:program Filesjavaj2sdklibmysql-connector-java-3.1.8-bin-g.jar;
D:program Filesjavamysqlforjdbcmysql-connector-java-3.1.8-bin.jar
The purpose of this configuration is to have your Java application find the driver to connect to MySQL.
After configuring the environment variables, there is an important step is to configure the driver for the JSP connection database, this is actually very simple, is to put mysql-connector-java-3.1.8- Bin.jar to some folder on the line, I read a lot of information on the internet asked a lot of people, all kinds of statements have, I synthesized a bit, in order to insure, I have all done, hehe, is a copy of a 400K file just, Now list the folders to be copied into the Mysql-connector-java-3.1.8-bin.jar, as follows:
D:program Filesjavatomcatcommonlib
D:program Filesjavatomcatsharedlib
Four Use of the database
After the installation of MySQL, there are some places to note (see):
Http://info.mysql.cn/install/2006/0208/82.html
As mentioned in the article, MySQL installed after the most important thing is to see if the database has been started as a system service, so before you do the database operation, should look, At the beginning of the operating system, run-> Input services.msc, and make sure that the service you set up for MySQL at the time of installation is started, so that you do not report-> errors when you operate the database.
The above mentioned a more convenient MySQL interface plug-in, but this interface is I have started to use the MySQL only found, at first I was in DOS under the command line to operate. Although the interface can also be built in the library Ah, set permissions and other operations, but I think it is very important to know how to use the command line is also a significant skill, so I start from the command line, how to use MySQL simple. To the later talks and the use of Mysql-front.
Now I want to build a database Shujuku in MySQL and build a table Biao in the database. The specific commands are as follows (assuming MySQL I was just installing)
1. Enter the DOS status (remember the command line to run in the bin directory of the MySQL installation directory)
2. Connect to MySQL
http://www.bkjia.com/PHPjc/630981.html www.bkjia.com true http://www.bkjia.com/PHPjc/630981.html techarticle A. Software download Mysql download version: 4.1.11 http://dev.mysql.com/downloads/mysql/4.1.html jdbc Driver download version: 3.1.8 http://dev.mysql.com/ Downloads/connector/j/3.1.html My ...