...
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 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
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.
...