In this tutorial I will demonstrate how we can insert data into the database. For this purpose I have used the HR Schema. We will create a new application called HumanResource. We will automate the process to create all entity and view. There will be approximately 20 steps to follow.
Model is the Business components of your application. You can put any name here.
After successfully create the model and view controller your projects will look like similar to this:
Your application overview page should be open as soon as you create your projects Model and View Controller. Now Here we have option to create connection for the database and also Build the business services.
Make sure before you follow up the tutorial you have oracle database installed and have a database which has the HR Schema.
You can provide any Connection name as you like. Please provide HR user name and its password correctly. Also SID is the database name that contain your HR Schema. Don't forget to test connection before going to the next step.
In the next step, we will configure our Business Services. Go to the Sup steps:
Make sure you select model in the pop up
Here it will ask again to configure the database which we already did previous step.
When you come up to this point press the Query button to get all the tables.
Select tables according to your needs and click the blue arrow to put them from left to right. You can also Name the entity as you like
We are not creating any Query based view object here so skip to the next step
Rename the Application module if you like:
You can create a diagram if you like but that's not required
Before you finalize these process you will have an option to see the summery
After successfully create the model and View controller projects, your application will look like the following:
Download: HumanResource.zip
Post a Comment