JDBC Connection MySQL code and connection failure resolution

Using JDBC to connect to the MySQL Tutorial database tutorial, the JDBC driver has been added to the project "build path" of Eclips tutorial E, which is supposed to be normal. Prompts "Unable to load driver" after running the project.

The final solution is to put the Mysql-connector-java-5.1.7-bin.jar into the "D:javajdk1.6.0_22jrelibext", and then compile and run the above program, it succeeds. As for why, I don't know yet.

Seemingly in the "build path" does not add a driver can also, as long as "%java_home%jrelibext" in the driver can be.

To establish a Connection object

String url= "Jdbc:mysql://localhost:3306/sample_db?user=root&password=your_password";

Connection con = drivermanager.getconnection (URL);

Create SQL Statement object (statement object)

Statement stmt = Con.createstatement ();

Execute SQL statement

ExecuteQuery ()

string query = "SELECT * from Test";

ResultSet rs=stmt.executequery (query);

Result set resultset

while (Rs.next ())

{rs.getstring (1); Rs.getint (2);}

Executeupdate ()

String upd= "INSERT into Test (id,name) VALUES (1001,xuzhaori)";

int con=stmt.executeupdate (UPD);

Execute ()

are not the same in Java programs and Web programs.
There is one of the simplest common methods:
Put the downloaded driver (my Mysql-connector-java-3.1.14-bin.jar) into
In the%java_home%jre/lib/ext directory, the jar package in the Ext directory is automatically loaded when the Java command is executed, so this is a once and for all way, and it works for any one of these operations.
The following is specific:
1. At the command line
Add JDBC-driven (such as Mysql-connector-java-3.1.14-bin.jar) packages to Classpath
2. Using the IDE
If Eclipse can import an external jar package and join the build path, this simple principle
3. Using in Web Programs
Simply put the JDBC driver Jar pack under/web-inf/lib, and of course there's a convenient way to
%tomcat_home%common/lib directory, so Tomcat will automatically load this jar every time it is started, but it is recommended to put it under/web-inf/lib