Logo 
Search:

Oracle Article

Submit Article
Comments on Example to view records of student, course and SC tables

Example to view records of student, course and SC tables

Category: Oracle (Select Query)    Author: Ella Brown

This article provides an example to view records of student, course and SC tables.


Mike Juma
Mike Juma from KenyaMar 24
THANK-YOU in advance for you kindness and help on this question.

Display Input-Output from database to device, phone and input new data


OnlineClass
IdNumber First LastName Course City DateEnrolled


2101 Rajesh Khan PHP London 05/03/2012
2102 Mohamed Sarwar vbnet Mahwah 06/03/2011
2103 Hamisi Juma Csharp Mombasa 08/03/2010
2104 Erik Dell cplusplus JeseyCity 09/03/2009
2105 David Maina php Nairobi 10/03/2008
2106 Mahesh Shah java NewDelhi 05/03/2007
2107 John Stevens mysql Dearborn 05/03/2006
2108 Anthony Rwandiga sql Kigali 07/03/2005





How can I write a code in Java using above input from access or sql and display that information on a phone? Update student information to the database via hand held device and phone.
1. For example when I enter student id on the phone it displays the rest of the information (name, course) as it interacts with the database.
2. I would like if I scan a student ID using a hand held device it gives me the name course etc., while being at the same time being able to input and update new student information to the database through handheld device or phone. Prosperity and peace to you.

AGAIN THANK-YOU FOR YOUR KIND ASSITANCE AND INSIGHT.
PEACE AND PROSPERITY TO YOU.


Please enter your Comment
  • Comment should be atleast 15 Characters.
  • Please put code inside [Code] your code [/Code].