Java DB and JDBC(Embedded Derby)

There are two patterns of Derby, Embedded and Network Server.

 

Pattern I:

how to connect to the database?

1. load the embedded driver;

2. wanna create a DB? then set some properites;

3. create and connect to the database using DriverManager;

 

how to operate on the DB?

1. create a statement from the connection;

2. execute the statement and put the results into result set;

3. do something on the result;

 

some cleaning work?

1. I know you remember this, aha~

 

where to get the code?

http://www.qqread.com/java/2008/08/w427265.html

 

Pattern II:

How it works?

It is just for application of different JVM, the classic client/server framework.

 

How to develop?

Client-code: nothing serious difference from the embedded pattern, other than some String arguments;

Server-code: just run a command to start up the server.

where to get the code?

http://www.qqread.com/java/2008/08/w427265.html

 

I wanna do some practice, but…

It took me for more than one hour to install Mysql database, see it? haha~~