Home  >  Article  >  Backend Development  >  How to connect to mysql database using JSP (1) (2)_PHP tutorial

How to connect to mysql database using JSP (1) (2)_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 17:03:161003browse

5. Regarding the use of mysql-front

I have looked for several mysql interface tools, and I think the most concise and convenient is mysql-front. Unfortunately, there is a fee, but fortunately there is a trial period, haha, you can try it out first, and finally The important thing is that mysql-front has a simplified Chinese version, which makes it much more comfortable for me who is not good at English. Let’s briefly talk about its use. First of all, the installation goes without saying, there is a wizard, and it is very simple. When you run it for the first time after installation, a box asking to add a dialog box will pop up. Here you can add, for example, the shujuku that has been set above. The process is as follows:
When you fill in your registration check box After setting the user name and password in mysql above, there will be shujuku's database in the select database box. Select it and click OK. After entering mysql-fron, you will see the following interface, and you can operate it. It should be noted that you can also add the root user. To do this, you need to select Settings -> Dialog -> New on the mysql-fron interface, and then click on the above to proceed. You can still do it without root. To add more users, the method is still the same. Setting up different users is to facilitate the management of different databases. Haha, root has the highest authority. Do not let others use your root user casually to ensure the security of your database. Six. JSP connects to mysql
Now I try to use jsp to connect to mysql
I created a test_mysql.jsp page in eclipse, the code is as follows:



www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630980.htmlTechArticle5. Regarding the use of mysql-front, I have looked for several mysql interface tools. I think the most simple and convenient is mysql-front. Unfortunately, there is a fee, but fortunately there is a trial period, haha, it can be...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn