How to connect to mysql database using JSP (1)_PHP tutorial
1. Software download
Mysql
Download version: 4.1.11
http://dev.mysql.com/downloads/mysql/4.1.html
Download version: 3.1.8
http://dev.mysql.com/downloads/connector/j/3.1.html Mysql interface plug-in: mysql-front
Download version image: HongKong (the Chinese version will be installed next time)
http://www.mysqlfront.de/download.html 2. Software installation
1. Install mysql
Please refer to the relevant articles in the information section http://info.mysql.cn/install/2006/0208/81.html 2. JDBC driver: mysql -connector-java-3.1.8
This is just a compressed package and does not need to be installed. Just unzip it. We are using the file 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 installation program, just follow the prompts to install it. Three. Environment configuration
First of all, I want to explain that my current installation path of tomcat is: D:Program FilesJavaTomcat; the installation path of JDK is: D:Program FilesJavaj2sdk. Here, the environment variables that need to be configured are the JDBC drivers. Before configuring, first put the mysql-connector-java-3.1.8-bin.jar mentioned just somewhere on your local hard disk (where I put it: D:Program FilesJavamysqlforjdbc), and then configure the classpath according to where you put it. The configuration is like this: D: Program filesJavaj2sdklib ools.jar; D: Program FilesJavaj2sdklibmysql-connector-java-3.1.8-bin-g.jar; -3.1.8-bin.jar The purpose of configuring this is to allow your java application to find the driver that connects to mysql. After configuring the environment variables, another very important step is to configure the driver for JSP to connect to the database. This is actually very simple, just copy mysql-connector-java-3.1.8-bin.jar to some folder. , I read a lot of information on the Internet and asked a lot of people, and there are various opinions. I summarized it, and I did it all for the sake of insurance. Haha, anyway, it is just copying a 400K file. Now I list the mysql The folder copied into -connector-java-3.1.8-bin.jar is as follows: D: Program FilesJavaTomcatcommonlib
D: Program FilesJavaTomcatsharedlib
4. Use of database After Mysql is installed, there are still some things to pay attention to (reference): http://info.mysql.cn/install/2006/0208/82.html Just like in As mentioned in the article, after MySQL is installed, the most important thing is to check whether the database has been started as a system service. Therefore, before you perform database operations, you should check and enter services at the start of the operating system -> Run -> Enter services. msc, make sure that the mysql service you set during installation has been started, so that you will not get a connection failure error when operating the database. A more convenient mysql interface plug-in is mentioned above, but I only found this interface after I started using mysql. At first, I used the command line to operate it under dos. Although that interface can also be used to create databases, set permissions, etc., I think knowing how to use the command line is also a very important skill, so I will start with the command line and talk about how to use mysql simply. We will talk about the use of mysql-front later. Now I want to build a database shujuku in mysql and a table biao in the database. The specific commands are as follows (assuming that I have just installed mysql) 1. Enter the dos state (remember that the command line must be run in the bin directory under the installation directory of mysql) 2. Connect to mysql
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to use MySQL backup and restore in PHP?
Jun 03, 2024 pm 12:19 PM
Backing up and restoring a MySQL database in PHP can be achieved by following these steps: Back up the database: Use the mysqldump command to dump the database into a SQL file. Restore database: Use the mysql command to restore the database from SQL files.
How to optimize MySQL query performance in PHP?
Jun 03, 2024 pm 08:11 PM
MySQL query performance can be optimized by building indexes that reduce lookup time from linear complexity to logarithmic complexity. Use PreparedStatements to prevent SQL injection and improve query performance. Limit query results and reduce the amount of data processed by the server. Optimize join queries, including using appropriate join types, creating indexes, and considering using subqueries. Analyze queries to identify bottlenecks; use caching to reduce database load; optimize PHP code to minimize overhead.
How to create a MySQL table using PHP?
Jun 04, 2024 pm 01:57 PM
Creating a MySQL table using PHP requires the following steps: Connect to the database. Create the database if it does not exist. Select a database. Create table. Execute the query. Close the connection.
How to fix mysql_native_password not loaded errors on MySQL 8.4
Dec 09, 2024 am 11:42 AM
One of the major changes introduced in MySQL 8.4 (the latest LTS release as of 2024) is that the "MySQL Native Password" plugin is no longer enabled by default. Further, MySQL 9.0 removes this plugin completely. This change affects PHP and other app
iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos
Jul 18, 2024 am 05:48 AM
Apple's latest releases of iOS18, iPadOS18 and macOS Sequoia systems have added an important feature to the Photos application, designed to help users easily recover photos and videos lost or damaged due to various reasons. The new feature introduces an album called "Recovered" in the Tools section of the Photos app that will automatically appear when a user has pictures or videos on their device that are not part of their photo library. The emergence of the "Recovered" album provides a solution for photos and videos lost due to database corruption, the camera application not saving to the photo library correctly, or a third-party application managing the photo library. Users only need a few simple steps
Detailed tutorial on establishing a database connection using MySQLi in PHP
Jun 04, 2024 pm 01:42 PM
How to use MySQLi to establish a database connection in PHP: Include MySQLi extension (require_once) Create connection function (functionconnect_to_db) Call connection function ($conn=connect_to_db()) Execute query ($result=$conn->query()) Close connection ( $conn->close())
How to handle database connection errors in PHP
Jun 05, 2024 pm 02:16 PM
To handle database connection errors in PHP, you can use the following steps: Use mysqli_connect_errno() to obtain the error code. Use mysqli_connect_error() to get the error message. By capturing and logging these error messages, database connection issues can be easily identified and resolved, ensuring the smooth running of your application.
Apple Vision Pro receives major update, visionOS 1.3 RC version released
Jul 25, 2024 pm 04:25 PM
According to news on July 24, Apple recently pushed the highly anticipated visionOS1.3RC version update to VisionPro headset users. This update marks Apple’s continued innovation and progress in the field of virtual reality. Although the official did not clearly disclose the specific content of this update, users generally expect it to include performance optimization, functional improvements, and bug fixes. The internal version number of this update is 21O771, 141 days have passed since the last update. However, due to caching issues with node server configurations in Apple's various regions, some users may experience delays in upgrades and updates. Apple recommends users to back up their data before installing updates to ensure information security. 1.VisionPro users can use the "
