JDBC Link MySQL

First, the javaweb using JDBC is similar to the way Java is used, but there are differences:

1. After importing the driver package in Java, get the connection object directly with Drivermanager.getconnection ().

In Javaweb, you must first register the driver:

Class.forName ("Com.mysql.jdbc.Driver");

Drivermanager.registerdriver (New Com.mysql.jdbc.Driver ());

The rest is basically the same!

Note: When using the INSERT INTO statement, if values () are used variables, especially strings, you need to be aware of the concatenation of the strings:

As in the following SQL statement, where username, passwd is a string type.

"INSERT into member (userName, password) VALUES ('" +username+ "', '" +passwd+ "')";

Note that any string in the SQL statement needs to be wrapped in single quotes!

JDBC Link MySQL