JDBC connects to the database using myeclipse to obtain the driver name and connection string

When using JDBC to connect to the database (although there are not many large projects, but small projects do not use Hibernate and other frameworks, JDBC still needs to be used ), the following two basic fixed connection statements are required:

① First load the driver. Take MYSQL as an example: class. forname ("com. MySQL. JDBC. Driver ");

②. Then, get the connection drivermanager. getconnection (URL, user, password );

The driver name com. MySQL. JDBC. driver and the connection URL can be obtained using the following method:

Change the view of myeclipse to myeclipse Database Explorer, right-click the database blank space on the left-> New-> databasedriver dialog box, and select the database you are using in drivertemplate, at this time, you can see the connection URL in the connection URL and modify the URL as needed. For example, if MySQL is selected, the URL is JDBC: mysql: //

Click Add jars on the Right of driver jars to add the JAR file of the database to be connected. After the connection, you can obtain the driver name, that is, Com. mySQL. JDBC. driver. The retrieval is complete. The connection is successful.