Derby database and client sqleonardo

Recently, when the project came into contact with Java's open-source database Derby, I would like to summarize it:

It is an object-oriented relational database that is suitable for storing small amounts of data,

Embedded databases can be used.

Class. forname ("org. apache. derby. JDBC. embeddeddriver "); // load the driver connection conn = drivermanager. getconnection ("JDBC: Derby: mydb; Create = false"); // connect to the database statement ST = Conn. createstatement (); // st.exe cute ("create table City (ID int not null, cityname varchar (10) Not null )"); // create the st.exe cuteupdate ("insert into city (ID, cityname) values (3, 'beijing ')"); // insert data st.exe cuteupdate ("insert into city (ID, cityname) values (4, 'shanghai ')"); // insert data resultset rs = st.exe cutequery ("select * from city"); // read the newly inserted data

Of course, Derby is an object-oriented relational database. It is not like sqlserver. Oracle's installation tools also have open-source database clients to view the structure of data tables. sqleonardo is a good open-source database client.

You can view various databases.