Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Enter AccountDB in the Create DB text box and click on Create button. This will create a new Database AccountDB and will be listed in the DB Viewer portlet. In my server, the database is already created.

In the textarea SQL Command/s: which is on the Run SQL portlet, enter the below SQL command, and select AccountDB in the Use DB combo box, and click on Run SQL button. This creates the Account1 table in the AccountDB database.

...

Insert some sample rows in the table as follows using the below SQL statements by following the same outlined procedure above.

Code Block
SQL
SQL
borderStylesolid
titleAccount1 table
insert into Account1 values (1111, 'Joe', 'NewYork', 10, 30000.0);
insert into Account1 values (2222, 'John', 'NewJersy', 11, 31000.0);
insert into Account1 values (3333, 'Jane', 'Raleigh', 13, 32000.0);

3. Export the Java project by name ApplicationClientJPA.jar as follows.
Right click on the java project and export it as jar file.

...