How to connect MySQL database with JSP (1) _php tutorial

Source: Internet
Author: User
Tags mysql download
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 ...

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.