Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to connect JSP to mysql database". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how JSP connects to the mysql database.

I have been installing configuration and connecting to Mysql database for several days in a row, and today I finally succeeded. Looking back on these days, there are really both ups and downs. Mysql alone has been reinstalled no less than 10 times, and the program written on eclipse to connect to the database has always reported an error. I have already down oracal is ready to give up mysql, but. As in TV dramas, connecting planes always occur at this time. JSP connection mysql database strategy for several consecutive days to install configuration and connect to the Mysql database, today finally succeeded, looking back on these days, it is really sweet and bitter, mysql alone reinstalled no less than 10 times, and the program written on eclipse to connect to the database is always wrong. I have already down oracal is ready to give up mysql, but... as in TV dramas, connecting planes always occur at this time. First saw the installation introduction of the mysql4.1.11 version of saulzy, then found a good mysql interface plug-in, and finally matched and connected the JDBC driver of mysql with the help of netizens. 5 days in a row, life is really difficult, but in the process, I also feel that I have learned a lot, hehe, anyway, I will continue to move on. Now, let's sum up what we've done in the past few days. I hope it will be helpful to my colleagues who are learning JAVA technology. I once wrote an article called, and now these are its follow-up.

one。

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 plug-in: mysql-front download version Mirror: HongKong (I will come back to install the Chinese version) http://www.mysqlfront.de/download.html

two。

Software installation 1. Install mysql as I said above, I refer to saulzy's article, now give the link to this article of saulzy: http://blog.csdn.net/saulzy/archive/2005/04/23/359648.aspx is full of pictures and texts, it is very clear (thanks again to saulzy) 2.JDBC driver: mysql-connector-java-3.1.8 this is just a compressed package, do not need to install, just unzip it We use the files in the folder mysql-connector-java-3.1.8: mysql-connector-java-3.1.8-bin.jar. 3. Mysql interface plug-in: mysql-front this is an installer, just follow the prompts to install it.

three。

Environment configuration first, I would like to explain that my current tomcat installation path is: D:Program FilesJavaTomcat JDK installation path is: D:Program FilesJavaj2sdk here, the need to configure environment variables is the JDBC driver. Before configuration, put the mysql-connector-java-3.1.8-bin.jar local hard disk somewhere (where I put it: D:Program FilesJavamysqlforjdbc), and then configure classpath according to where you put it. My configuration is like this. D:Program filesJavaj2sdklib ools.jar;D:Program FilesJavaj2sdklibmysql-connector-java-3.1.8-bin-g.jar The purpose of D:Program FilesJavamysqlforjdbcmysql-connector-java-3.1.8-bin.jar configuration is to let your java application find the driver to connect to mysql. After configuring the environment variables, another important step is to configure the driver for the JSP connection database. This is actually very simple, which is to copy the mysql-connector-java-3.1.8-bin.jar to some folders. I read a lot of information on the Internet and asked a lot of people. There are all kinds of theories. I synthesized it. I did it all for insurance. Hehe, anyway, I just copied a 400K file. Now I list the folders to copy mysql-connector-java-3.1.8-bin.jar into, as follows: D:Program FilesJavaTomcatcommonlib D:Program FilesJavaTomcatsharedlib

four。

After the use of the database is installed by Mysql, there are still some points to pay attention to. Saulzy has also written an article here, and you will have a look at it. The connection is as follows: http://blog.csdn.net/saulzy/archive/2005/04/23/359811.aspx, as mentioned in saulzy's article, the most important thing after mysql installation is to see whether the database has been started as a system service, so before you do the database operation. You should see that at the beginning of the operating system-> run-> type services.msc to make sure that the service on mysql that you set up during installation has been started, so that you will not report a connection error when operating the database. A more convenient mysql interface plug-in is mentioned above, but I found this interface only after I have started using mysql At first, I operated on the command line under dos. Although that interface can also do operations such as building libraries and setting permissions, I think knowing how to use the command line is also a very important skill, so I start with the command line, how to simply use mysql. I will talk about the use of mysql-front later. Now I want to build a database shujuku in mysql. And create a table biao in the database. The specific commands are as follows (assuming I just installed mysql) 1. Enter the dos state (remember that the command line will run in the bin directory under the installation directory of mysql) as shown in figure 2. Connect mysql input: mysql-h localhost-u root-p appears the interface that requires a password (such as below) enter the password that has been set during installation, and enter the command editing interface of mysql nearby, as follows: 3. Use the basic command of mysql (at the mysql command line, you must have a semicolon at the end of each command, or you will report an error) to display the database: show databases; uses the database: use database name; examples are as follows: 4. Database building command: create database shujuku; 5. Set permissions for the database (user and password) command: grant all privileges on shujuku.* to test@localhost identified by "123456"; when you finish executing this command, as long as you log in with the user name: test, password: 123456, you can only operate on the shujuku database, so avoid using root, which is of great help to the security of the database.] 6. Table creation command: create table biao (id int (8) primary key,name varchar (10)); the rest is basically the same as the standard sqsl command. It is worth mentioning that you enter "?" on the command line. There will be the simple help of the mysql command, as follows: hehe, that way, we can also know that exit is "exit", hehe!

five。

About the use of mysql-front I found several mysql interface tools, I think the most concise and convenient is mysql-front, unfortunately, there is a fee, but fortunately there is a trial period, ha ha, you can feel it first, the most important point is that mysql-front has a simplified Chinese version, English is not good for me to use much more comfortable. first of all, there is no need to install, there is a wizard And it is very simple. After installation, a dialog box will pop up when you run for the first time, where you can add, for example, the shujuku that has been set above. The process is as follows: when you fill in the registration check box with the user name and password you set in mysql above, you will have shujuku database in the select database box. Select and press OK. After entering mysql-fron, you will see the following interface. This is where you can operate.

Undefined

At this point, I believe you have a deeper understanding of "how JSP connects to the mysql database". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.