MyEclipse and MySQL Exercises

For the use of MyEclipse and MySQL I am still blind, these days have been studying how to use between the two, now the only certainty, to let them practice, you must first create a database

Now, I do two exercises, one is a new database in MySQL, shown in MyEclipse, a new database in MyEclipse, displayed in MySQL.

First, create the BOOKDB database in MySQL, and then build the books table, as follows

Then add the driver to the myeclipse, connect MySQL,

Display its established database in MyEclipse, find Test1, find the established database BOOKDB, click Open, there will be a table, click Open Table, is the data sheet we created

Below, we continue to create additional tables under the BOOKDB

Writer

Here is actually just a simple conversion between them. The following will be connected to it, according to the data, to build a class, write the following information, this is for the books table:

After this, a lot of information on the internet has been broken, so I still continue to research, this homework to the end of it

Database Connection Reference:

Http://www.cnblogs.com/yidong/archive/2009/04/02/1427893.html

Http://www.cnblogs.com/loudyten/archive/2012/09/25/2701649.html

Http://www.cnblogs.com/hongten/archive/2011/03/29/1998311.html

MyEclipse and MySQL Exercises