V. Use of mysql-front
I found several mysql interface tools and thought it was the most concise and convenient mysql-front, but it was a pity that I had to pay for it, but fortunately I had a trial period, the most important thing is that mysql-front has a Simplified Chinese version. If the English is not good, I will be much more comfortable to use. the following is a brief introduction.
First of all, the installation is needless to say, there is a wizard, and it is very simple. after installation, a dialog box is displayed during the first running. Here you can add shujuku as set above. The process is as follows:
After you fill in the user name and password you set in mysql above in the check box for registration, there will be a database for shujuku in the select database box. Select and press OK. after entering mysql-fron, you will see the following interface. You can perform this operation.
It should be noted that you can also add the root user, which requires you to select Settings on the mysql-fron interface-> dialog-> Create, and then press the above button, with root, you can add more users. The method is the same. Setting different users makes it easy to manage different databases, do not allow others to use your root user to ensure the security of your database.
Vi. JSP connection to mysql
Now we are trying to connect to mysql Using jsp.
I created a test_mysql.jsp page in eclipse. The Code is as follows: