PRACTICAL QUESTION


---------------------------------------------------------------------------------------------------------------------------- Q1.Write a java program to display IP Address and Name of client machine.

Q2. Write a JSP script to accept username, store it into the session, compare it with password in another jsp file, if username matches with password then display appropriate message in html file.

Q3. Write a PHP program to create a simple calculator that can accept two numbers and perform operations like add, subtract, multiplication and divide (using Self Processing form)

Q4. Write class declarations and member function definitions for following
employee(code, name, designation). Design derived classes as
emp_account(account_no, joining_date) from employee and
emp_sal(basic_pay, earnings, deduction) from emp_account.
Write a PHP Script to create 5 objects (pass details using parameterized constructor)    and Display details of Employees who having Maximum and Minimum Salary.

---------------------------------------------------------------------------------------------------------------------------- Q1.Write a multithreading program in java to display all the vowels from a given String.(Use Thread Class)

Q2. Write a SERVLET program which counts how many times a user has visited a web page. If user is visiting the page for the first time, display a welcome message. If the user is revisiting the page, display the number of times visited. (Use Cookie)
Q3. A college has given roll number to each student, The roll number is six digit number where first two digits are faculty(B.Sc., BCA, BA) third digit is year (Ist(1), IInd(2) and IIIrd(3)) and last three digit are actual number. Write PHP script to accept a number and print faculty, year and roll number of student.(e.g Rollno=BC1004,faculty=BCA, year=1st,rollno=004)
Q4.      Define an interface which has methods area(), volume(). Define constant PI. Create a class cylinder which implements this interface and calculate area and volume. (Use define())
-------------------------------------------------------------------------------------------------------------------Q1.Write a JDBC program to displays the details of employees (eno, ename, department, sal) whose department is “Computer Science”.

Q2. Write a java program to simulate traffic signal using multithreading.

Q3. Write a PHP script to demonstrate the introspection for examining class(use function get_declared_classes() ,get_class_methods() and get_class_vars()).

Q4. Derive a class square from class Rectangle. Create one more class circle. Create an interface with only one method called area (). Implement this interface in all the classes. Include appropriate data members and constructors in all classes. Write a program to accept details of a square, circle and rectangle and display the area.

Guideline:
Q2. Allow the students to use either Applet or AWT for writing an application.




--------------------------------------------------------------------------------------------------------------------- Q1.Write a java program to display “Hello Java” message n times on the screen. (Use Runnable Interface).

Q2. Write a JSP program to create an online shopping mall. User must be allowed to do purchase from two pages. Each page should have a page total. The third page should display a bill, which consists of a page total of whatever the purchase has been done and print the total.          (Use Session)


Q3. Write a Calculator class that can accept two values, then add them, subtract them, multiply them together, or divide them on request. For example:
$calc = new Calculator( 3, 4 );
echo $calc- >add(); // Displays “7”
echo $calc- >multiply(); // Displays “12”

Q4.  Create a login form with a username and password. Once the user logs in, the second form should be displayed to accept user details (name, city, phoneno). If the user doesn’t enter information within a specified time limit, expire his session and give a warning otherwise Display Details($_SESSION).

--------------------------------------------------------------------------------------------------------------------- Q1.Write a java program to create Teacher table(TNo.TName, Sal, Desg) and insert a record in it.

Q2.  Write a MultiThreading program in java using Runnable interface to draw temple flag on an applet container.

Q3. Write an PHP script to search customer name from customer.dat file(Use AJAX concept)

Q4. Define a class Employee having private members – id, name, department, salary. Define parameterized constructors. Create a subclass called “Manager” with private member bonus. Create 6 objects of the Manager class and display the details of the manager having the maximum total salary (salary + bonus).



--------------------------------------------------------------------------------------------------------------------- Q1.Write a JDBC program to accept the details of customer (CID, CName, Address, Ph_No) and store it into the database (Use PreparedStatement interface)


Q2. Write a SOCKET program in java to check whether given file is present on server or not, If it is present then display its content on the server’s machine otherwise display error message.


Q3. Write a PHP Script create login form and validate it (Use database and Sticky form concept)

Q4. Write a PHP Script to create a super class Vehicle having members Company and price. Derive 2 different classes LightMotorVehicle (members – mileage) and HeavyMotorVehicle (members – capacity-in-tons). Define 5 Object of each subclass and display details in table format
--------------------------------------------------------------------------------------------------------------------- Q1.Write a JSP program to calculate sum of first and last digit of a given number. Display sum in Red Color with font size 18.

Q2. Write a Multithreading program in java for Racing Car. (Use AWT)

Q3. Create a form to accept employee details like name, address and mobile number. Once  the employee information is accepted, then accept LIC information like policy_no, name, premium. Display employee details and LIC details on next form.(use COOKIE)

Q4. Create employee table as follows
Bus(bno, bname, source, designation ).
Write Ajax program to select the bus name and print the selected bus details.
---------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------- Q1.Write a Multithreading program using Runnable interface to blink Text on the frame.

Q2. Write a SERVLET application to accept username and password, search them into database, if found then display appropriate message on the browser otherwise display error message.

Q3. Write a script to keep track of number of times the web page has been accessed
(use $_COOKIE).


Q4. Write Ajax program to carry out validation for a username entered in textbox. If the textbox is blank, print ‘Enter username’. If the number of characters is less than three, print’ Username is too short’. If value entered is appropriate the print ‘Valid username’.










---------------------------------------------------------------------------------------------------------------------  Q1.Write a JDBC program to delete the records of employees whose names are starting with ‘A’ character.

Q2.  Write a Multithreading program in java using Runnable interface to move text on the frame as follow:

 



Starting Position of Text


Q3 Create an abstract class Shape with methods calc_area( )  and calc_volume( ). Derive three classes Sphere(radius) , Cone(radius, height) and Cylinder(radius, height), Calculate area and volume of all. (Use Method overriding).



Q4.  Write an Ajax program to print the content of the myfile.dat. This code asks the user to click a button, fetches data from the server using Ajax techniques and displays that data in the same web page as the button without refreshing the page




---------------------------------------------------------------------------------------------------------------------  Q1.Write a JDBC program to count the number of records in table. (Without using standard method)

Q2.  Write a Multithreading program in java for bouncing ball. For each bounce, Change the color of ball randomly.

Q3. Write a PHP script to accept username and password. If in the first three chances, username and password entered is correct, then display second form, otherwise display error message.
(Use Session)

Q4. Create a form to accept student information (name, class, address). Once the student information is accepted, accept marks in next form (Java, PHP, ST, IT, pract1, and project). Display the mark sheet for the student in the next form containing name, class, marks of the subject, total and percentage(Use $_COOKIE).






--------------------------------------------------------------------------------------------------------------------- Q1.Write a JDBC program to remove “percentage” column from student (rno, sname, percentage) table.

Q2. Write a SERVLET program to change inactive time interval of session.

Q3. Write PHP script to create a CD catalog using XML file.

Q4. Write a program to create a shopping mall. User must be allowed to do purchase from three pages. Each page should have a page total. The fourth page should display a bill, which consists of a page total of whatever the purchase has been done and print the total. (Use $_SESSION).

-------------------------------------------------------------------------------------------------------------------- Q1.Write a Multithreading program in java to display the number’s between 1 to 100 continuously in a TextField by clicking on button. (use Runnable Interface).

Q2. Write a JSP program to accept the details of Account (ANo, Type, Bal) and store it into database and display it in tabular form. (Use PreparedStatement interface)

Q3. Write a PHP script for the following: Design a form to accept a number from the user. Perform the operations and  show the results.
1)      Factorial of a number using Recursion.
2)      Add the digits of that number to reduce it to single digit.
(use the concept of self processing page.)

Q4. Create student  table as follows
Student(sno, sname, per).
Write Ajax program to select the student name and print the selected student’s details.







--------------------------------------------------------------------------------------------------------------------- Q1.Write a JDBC program to create a Mobile (Model_No, Company_Name, Price, Color) table and insert a  record in it.

Q2.  Write a Socket program in java for simple stand alone chatting application.

Q3. Write a PHP script using AJAX concept, to develop user-friendly and interactive search engine         (like a google search engine)

Q4.  Considerer the following entities and their relationships
Student (Stud_id,name,class)
Competition (c_no,c_name,type)
Relationship between student and competition is many-many with attribute rank and year.
Create a RDB in 3NF for the above and solve the following. Using above database write a script in PHP to accept a competition name from user and display information of student who has secured 1st rank in that competition.

Guidelines:


Q2.     Client and Server programs should be executed on different machine.


--------------------------------------------------------------------------------------------------------------------- Q1.Write a Socket program in java which displays the server machine’s date and time on the client machine.

Q2. Write a JDBC program in java to display details of Book_Sales(SalesID, Date, Amount)  of selected month in JTable. Book_sales table is already created.  (Use JCombo component for Month selection)


Q3. Create student registration form and display details in the next page. (Use sticky form concept).

Q4. Write Ajax program to print Movie details by selecting an Actor’s name.
Create table MOVIE and ACTOR as follows with 1 : M cardinality
MOVIE (mno, mname, release_yr) and ACTOR(ano, aname)






--------------------------------------------------------------------------------------------------------------------- Q1.Write a JDBC program in java to update an address of given customer(cid,cname,address) and display updated details.

Q2. Write a SERVLET program in java to accept details of student (SeatNo, Stud_Name, Class, Total_Marks). Calculate percentage and grade obtained and display details on page.

Q3. Write a PHP Script to Upload the file and display its information.(use $_FILES).
Q4. Write Ajax program to fetch suggestions when is user is typing in a textbox. (eg like Google suggestions. Hint create array of suggestions and matching string will be displayed)






--------------------------------------------------------------------------------------------------------------------- Q1.Write a JSP program which accept UserName in a TextBox and greets the user
according to the time on server machine.

Q2. Write a program in java which will show lifecycle (creation, sleep, and dead) of a thread. Program should print randomly the name of thread and value of sleep time. The name of the thread should be hard coded through constructor. The sleep time of a thread will be a random integer in the range 0 to 4999.

Q3. Write a PHP Script to display Server information in table format (Use $_SERVER).

Q4. Write Ajax program to get book details from XML file when user select a book name. Create XML file for storing details of book(title, author, year, price).



---------------------------------------------------------------------------------------------------------------------  Q1.Write a java program which will display name and priority of current thread. Change name of Thread to MyThread and priority to 2. Display the details of Thread.
Q2.  Write a JDBC application using swing for the following:


Type DDL Query

Create Table

Alter Table

Drop Table
 












Q3. To create form that accept the user details. write php program to capitalize of first letter of each name and check user email address contain @ symbol.

Q4. Write a PHP program to accept username and password from the user. Validate it against the login table in the database. If there is a mismatch between username and password, then, display the error message as ―invalid user name and password; else display the message as ―Login successful‖ on the browser.



--------------------------------------------------------------------------------------------------------------------- Q1.Write a java program using multithreading to execute the threads sequentially.
(Use Synchronized Method)

Q2.  Write a SERVLET program that provides information about a HTTP request from a client, such as IP address and browser type. The servlet also provides information about the server on which the servlet is running, such as the operating system type, and the names of currently loaded servlets.

Q3. Create a XML file which gives details of books available in “ABC Bookstore” from following categories
1) Technical
2) Cooking
3) YOGA

Q4. Write a PHP program to implement Create, Read, Update and Display operations on Teacher table with attributes(tid, tname, address, subject). (Use Radio Buttons)




Guideline:

Q1:  Allow the students to write any java multithreading application using synchronized method.




--------------------------------------------------------------------------------------------------------------------- Q1.Create a JSP page to accept a number from an user and display it in words:
Example: 123 – One Two Three. The output should be in red color.


Q2. Write a Multithreading program in java to convert smile face into the crying face after 5 seconds and vice versa(Use Applet).

Q3. Write a PHP script to accept a string and then display each word of string in reverse order.    (use concept of self processing form)

Q4. Consider the following relational database:
Project (P_Group_No, Project_Title)
Student (Seat no, Name, Class, P_Group_No)
Write a PHP script to accept project title and display list of students those who are working in a particular project.



1. Write a JSP program to display the details of Hospital (HNo, HName, Address) in tabular form on browser.

Q2. Write a Socket program in java for chatting application.  (Use AWT)


Q3. Write PHP program to select list of subjects (use multivalued parameter) displays on next page.(Use listbox to select subject)


Q4. Consider the following entities and their relationships
Emp (emp_no,emp_name,address,phone,salary)
Dept (dept_no,dept_name,location)
Emp-Dept are related with one-many relationship
Create a RDB in 3NF for the above and solve following
Using above database write a PHP script which will
a)      Insert employee records in table .
b)      Print a salary statement in the format given below, for a given department. (Accept department name from the user).

Maximum Salary
Minimum Salary
Sum Salary







uidelines:
Q2:  Client and Server programs should be executed on different machine.


-------------------------------------------------------------------------------------------------------------------- Q1.Write a JDBC Program in java to display the names of Employees starting with ‘S’ character.

Q2. Write a SERVLET program to Design an HTML page containing 4 option buttons (Painting, Drawing, Singing and swimming) and 2 buttons reset and submit. When the user clicks submit, the server responds by adding cookie containing the selected hobby and sends the HTML page to the client. Program should not allow duplicate cookies to be written.

Q3. Write a PHP program to accept two string from user and check whether entered strings are matching or not.(use sticky form concept)

Q4. Consider the following entities and their relationships
Doctor (doc_no, doc_name, address, city, area)
Hospital (hosp_no, hosp_name, hosp_city)

Doctor and Hospital are related with many-many relationship
Create a RDB in 3 NF for the above and solve following
Using above database, write a PHP script which accepts hospital name and   print information about doctors visiting / working in that hospital in tabular format.





--------------------------------------------------------------------------------------------------------------------- Q1.Write a Socket program in java in which client accept a number, send it to the server, server calculates its factorial and sends result to the client.

Q2. Write a java program to create a student table with field’s rno, name and per. Insert values in the table. Display all the details of the student on screen. (Use PreparedStatement Interface)

Q3. Write a script to keep track of number of times the web page has been accessed.(Use $_SESSION[ ] )
Q4. Consider the following entities and their relationships
Movie (movie_no, movie_name, release_year)
Actor (actor_no, name)
Relationship between movie and actor is many – many with attribute rate in Rs. Create a RDB in 3 NF for the above and solve following Using above database, write PHP scripts for the following:
(Hint: Create HTML form having two radio buttons)
a)      Accept actor name and display the names of the movies in which he has acted.
b)  Insert new movie information.







--------------------------------------------------------------------------------------------------------------------- Q1.Write a JSP script to accept the details of Student (RNo, SName, Gender, Computer_ Knowledge , Class)        and display it on the browser. Use appropriate controls for accepting data.
Q2. Write a Java Program to Read, Update and Delete any record from “Elements” table. The table has following fields (Atomic_weight , Name (primary key), Chemical_Symbol). The input should be provided through Command Line Arguments along with the appropriate data.
The operations are: R : Read, U: Update, D: Delete.
The syntax for Read: R
The syntax for Delete: D name

Assume Elements table is already created.

Q3. Write a PHP script to generate an XML in the following format
<?xml version = “1.0” ?>
<BookStore>
<Books>
<PHP>
<title>Programming PHP</title>
<publication>O’RELLY</publication>
</PHP>
<PHP>
<title>Beginners PHP</title>
<publication>WROX</publication>
</PHP>
</Books>
</BookStore>

Q4. Consider the following entities and their relationships
BillMaster(billno, custname, billdate )
BillDetails(itemname, qty, rate, discount)
BillMaster and BillDetails are related with one-to-many relationship.
Create a RDB in 3 NF for the above and solve following
Write PHP script to print the bill in following format Accept the Bill number from user.
BillNo :                                                                       BillDate :
Customer Name :
Sr. No.
Particular
Quantity
Rate
Discount
Total












Gross Amount :



Q6.  Journal                                                                                                                             [10]


--------------------------------------------------------------------------------------------------------------------- Q1.Write a JSP script to check whether given mail ID is valid or not. (Mail ID should contain one @ symbol and atleast one Dot(.) symbol)

Q2. Write a java program to accept the details of college (CID, CName, Address, year) and store it into database (Use Swing and PreparedStatement interface)

Q3. Write a simple PHP program which implements Ajax for addition of two numbers.


Q4. Create  an application that reads “Book.xml” file into simple XML object. Display attributes and elements(Hint: use simple_xml_load_file() function)




--------------------------------------------------------------------------------------------------------------------- Q1.Write a JSP script to accept UserName and his NickName through html page and then displays username when visit count to page is odd and displays nickname when the visit count to the page is even.

Q2. Write a JDBC program for implementation of scrollable ResultSet. Consider Emp table (eno ename, sal)
-          moveFirst
-          moveNext
-          movePrevious
-          moveLast
-           
Q3. Write PHP script to demonstrate the concept of introspection for examining object.

Q4. Create a XML file which gives details of books available in “ABC Bookstore” from following categories.
1) Technical
2) Cooking
3) Yoga
and elements in each category are in  the following  format
<Book>
<Book_PubYear>       --------------</Book_PubYear>
<Book_Title>  --------------</Book_Title>
<Book_Author>         ---------------</Book_Author>
</Book>
Save the file as “Book.xml”
Create an application that reads “Book.xml” file into simple XML object. Display attributes and elements.
(Hint: Use simple_xml_load_file() function)





1. Write a Multithreading program in java to display all the alphabets from A to Z after 3 seconds.

Q2.  Write a java program to display sales details of products between two dates in JTable(use database).  Consider product table (pid, pname, amount).


Q3. Write a PHP script to accept student details(rno, name, class) and store them in student table (Max 10) , print them  in sorted order of name on the browser in table format .

Q4. Write a script to solve following questions (Use “Book.xml” file)
a) Create a DOM Document object and load this XML file.
b) Get the output of this Document to the browser
c) Save this [. XML] document in another format i.e. in [.doc]
d) Write a XML program to print the names of the books available in “Book.xml” file.


Guidelines:
Q2.  Use Calendar class or Choice / JCombo class for Dates selection.















--------------------------------------------------------------------------------------------------------------------- Q1.Write a JDBC program to delete the details of given employee (ENo EName Salary). Accept employee ID through command line.

Q2.  Write a Multithreading  program in java to create an applet that contains a TextField to show time. The time should be displayed in the hh:mm:ss format. The thread should start when the user clicks the Start button and stop when the user clicks the stop button. Initialize the values to current time.


Q3. Write an Ajax program to display list of games stored in an array on clicking OK button.


Q4. Write a script to create “cricket.xml” file with multiple elements as shown below:
<CricketTeam>
<Team country=”India”>
<player>____</player>
<runs>______</runs>
<wicket>____</wicket>
</Team>
</CricketTeam>
Write a script to add multiple elements in “cricket.xml” file of category, country=”Australia”.






--------------------------------------------------------------------------------------------------------------------- Q1.Write a JSP program to check whether given number is Armstrong or not. (Use Include directive).


Q2. Write a java program to display the selected employee details in JTable. (use database, combo box for employee selection )  Employee having fields eno, ename, sal, desg.


Q3. Change the preferences of your web page like font style, font size, font color, background color using cookie. Display selected settings on next web page and actual implementation (with new settings) on third web page.

Q4. Write a PHP script to accept an .XML file which should comprise the following:
<cricket>
<player>abc</player>
<runs>1000</runs>
<wickets>50</wickets>
<noofnotout>10</noofnotout>
</cricket>
For at least 5 players.
Display the details of players who have scored more than 1000 runs and at least 50 wickets.






--------------------------------------------------------------------------------------------------------------------- Q1.Write a JSP program to accept Name and Age of Voter and check whether he is eligible for voting or not.


Q2. Write a menu driven java program for the following:
Insert
Update
Delete
Search
Display
Exit
Consider Student (rno, sname, per) table for this.


Q3.                  Write a script to create XML file named “Course.xml”
<Course>
<Computer Science>
<Student name>.......</Student name>
<Class name>......</Class name>
<percentage>.....</percentage>
</Computer Science>
</Course>
Store the details of 5 students who are in TYBCA.

Q4. Write a PHP script using AJAX concept, to check user name and password are valid or Invalid (use database to store user name and password).



--------------------------------------------------------------------------------------------------------------------- Q1.Write a JSP program to display all the prime number’s between 1 to n in “Blue” Color.

Q2. Write a SERVLET program to display the details of Product (ProdCode, PName, Price) on the browser in tabular format. (Use database)

Q3. Write a PHP Script to display response header information for any text file using $_http_response_header.


Q4.      Write a script to create “vehicle.xml” file with multiple elements as given below
<Vehicle>
<Type = Two Wheeler>
<Vehicler Name >-------- </Vehicle Name >
<Company >--------- </Company>
<Color>--------</Color>
<Average>------</Average>
</Type>
</Vehicle>
Also add Type = “Four Wheeler” and its elements








No comments:

Ebook

Ebook
Ebook