tag:blogger.com,1999:blog-50498973161236693662024-03-14T00:22:11.977-07:00Mr. Bipin S. Rupadiya[M.C.A.]<br>Graphics Designer, Freelancer <br>Assistant Professor, JVIMS-MCA CollegeBipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.comBlogger187125tag:blogger.com,1999:blog-5049897316123669366.post-1079902908945898352023-01-16T23:50:00.003-08:002023-01-17T00:09:05.543-08:00RDBMS question bank as per GTU MCA new syllabus<p style="text-align: center;">Subject Name: Relational Database Management Systems (RDBMS) </p><p style="text-align: center;">Subject Code: 619404
</p><p class="MsoNoSpacing" style="text-align: center;"><span face="".Helvetica Neue Interface",sans-serif" style="font-size: 16pt;">Unit-1<o:p></o:p></span></p>
<p align="center" class="MsoNoSpacing" style="text-align: center;"><o:p> </o:p></p>
<p class="MsoNoSpacing">1. Define following definitions<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>A.
Database, B. Data, C. Database Management System (DBMS), D. Database System<o:p></o:p></p>
<p class="MsoNoSpacing">2. Draw Simplified database system environment diagram
and explain DBMS Functionality<o:p></o:p></p>
<p class="MsoNoSpacing">3. Explain Main Characteristics of the Database Approach<o:p></o:p></p>
<p class="MsoNoSpacing">4. Explain Types of Database Users in details<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(1).
Actors on the scene<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(2).
Actors behind the Scene<o:p></o:p></p>
<p class="MsoNoSpacing">5. Explain advantages of the Database Approach<span></span></p><a name='more'></a><o:p></o:p><p></p>
<p class="MsoNoSpacing">6. Define the following terms: <o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>data,
database, DBMS, database system, database catalog, program-data independence,
user view, DBA, end user<o:p></o:p></p>
<p class="MsoNoSpacing">7. What four main types of actions involve databases?
Briefly discuss each.<o:p></o:p></p>
<p class="MsoNoSpacing">8. Discuss the main characteristics of the database
approach and how it differs from traditional file systems.<o:p></o:p></p>
<p class="MsoNoSpacing">9. What are the responsibilities of the DBA and the
database designers?<o:p></o:p></p>
<p class="MsoNoSpacing">10. What are the different types of database end users?
Discuss the main activities of each.<o:p></o:p></p>
<p class="MsoNoSpacing">11. Discuss the capabilities that should be provided by a
DBMS.<o:p></o:p></p>
<p class="MsoNoSpacing">12. What is Data Model? Explain Categories of Data
Models.<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>A.
Define the terms, B. Database Schema, C. Schema Diagram, D. Database State,<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>E.
Initial Database State, F. Valid State<o:p></o:p></p>
<p class="MsoNoSpacing">13. Explain Deference between Database Schema vs. State<o:p></o:p></p>
<p class="MsoNoSpacing">14. Explain Three-Schema Architecture in detail<o:p></o:p></p>
<p class="MsoNoSpacing">15. What is Data Independence explain in detail<o:p></o:p></p>
<p class="MsoNoSpacing">16. Explain DBMS Languages in detail<o:p></o:p></p>
<p class="MsoNoSpacing">17. Explain DBMS Interfaces in detail<o:p></o:p></p>
<p class="MsoNoSpacing">18. Explain Classification of DBMSs in detail.<o:p></o:p></p>
<p class="MsoNoSpacing">19. Explain Centralized and Client-Server DBMS
Architectures<o:p></o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p class="MsoNoSpacing">20. What is the difference between logical data
independence and physical data independence? Which one is harder to achieve?
Why?<o:p></o:p></p>
<p class="MsoNoSpacing">21. Discuss the different types of user-friendly
interfaces and the types of users who typically use each.<o:p></o:p></p>
<p class="MsoNoSpacing">22. With what other computer system software does a DBMS
interact?<o:p></o:p></p>
<p class="MsoNoSpacing">23. What is the difference between the two-tier and
three-tier client/server architectures?<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-spacerun: yes;"> </span><o:p></o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p align="center" class="MsoNoSpacing" style="text-align: center;"><span face="".Helvetica Neue Interface",sans-serif" style="font-size: 16pt;">Unit-2<o:p></o:p></span></p>
<p class="MsoNoSpacing">1. What is<span style="mso-spacerun: yes;">
</span>Entities & Attributes in ER Model and explain Types of Attributes<o:p></o:p></p>
<p class="MsoNoSpacing">2. List, draw and explain notation/symbols of ER diagrams
with example<o:p></o:p></p>
<p class="MsoNoSpacing">3. Draw an ER diagram for COMPANY database schema by
following instruction<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(a).
The database will store each EMPLOYEE’s social security number, address,
salary, sex, and birthdate.<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(b).
Each employee works for one department but may work on several projects.<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(c).
The DB will keep track of the number of hours per week that an employee
currently works on each project.<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(d).
It is required to keep track of the direct supervisor of each employee.<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(e).
Each employee may have a number of DEPENDENTs.<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(f).
For each dependent, the DB keeps a record of name, sex, birthdate, and
relationship to the employee.<o:p></o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p class="MsoNoSpacing">4.What is relationship in ER diagram? Explain following
terms related to relationship<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(a).
relationship type, (b). relationship set (c). Constraints on Relationships<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span><o:p></o:p></p>
<p class="MsoNoSpacing">5. Draw and UML class diagram for COMPANY database schema
by following instruction bellow<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(a).
The database will store each EMPLOYEE’s social security number, address,
salary, sex, and birthdate.<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(b).
Each employee works for one department but may work on several projects.<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(c).
The DB will keep track of the number of hours per week that an employee
currently works on each project.<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(d).
It is required to keep track of the direct supervisor of each employee.<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(e).
Each employee may have a number of DEPENDENTs.<o:p></o:p></p>
<p class="MsoNoSpacing"><span style="mso-tab-count: 1;"> </span>(f).
For each dependent, the DB keeps a record of name, sex, birthdate, and relationship
to the employee.<o:p></o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p class="MsoNoSpacing">6. What is an entity type? What is an entity set? Explain
the differences among an entity, an entity type, and an entity set<o:p></o:p></p>
<p class="MsoNoSpacing">7. Explain the attribute and a value set.<o:p></o:p></p>
<p class="MsoNoSpacing">8. What is meant by a recursive relationship type? Give
some examples of recursive relationship types.<o:p></o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p align="center" class="MsoNoSpacing" style="text-align: center;"><o:p> </o:p></p>
<p align="center" class="MsoNoSpacing" style="text-align: center;"><span face="".Helvetica Neue Interface",sans-serif" style="font-size: 16pt;">Unit-3<o:p></o:p></span></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p class="MsoNoSpacing">1. Explain Informal Design Guidelines for Relational
Databases.<o:p></o:p></p>
<p class="MsoNoSpacing">2. What is insert, update and delete Anomalies? Explain
it in detail.<o:p></o:p></p>
<p class="MsoNoSpacing">3. What is Spurious Tuples? Explain with example.<o:p></o:p></p>
<p class="MsoNoSpacing">4. What is Functional Dependencies (FD)? Explain it in
detail.<o:p></o:p></p>
<p class="MsoNoSpacing">5. Explain General Normal Forms Based on Primary Keys in
detail.<o:p></o:p></p>
<p class="MsoNoSpacing">6. Explain Super Key, Candidate Key and Primary Key in
detail.<o:p></o:p></p>
<p class="MsoNoSpacing">7. Explain Primary Key, Foreign Key and Alternate Key in
detail.<o:p></o:p></p>
<p class="MsoNoSpacing">8. Explain General Normal Form Definitions using Multiple
Keys.<o:p></o:p></p>
<p class="MsoNoSpacing">9. Explain Boyce-Codd normal form in detail.<o:p></o:p></p>
<p class="MsoNoSpacing">10.Explain Multivalued Dependencies (MVD) and Fourth
Normal Form.<o:p></o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p align="center" class="MsoNoSpacing" style="text-align: center;"><o:p> </o:p></p>
<p align="center" class="MsoNoSpacing" style="text-align: center;"><span face="".Helvetica Neue Interface",sans-serif" style="font-size: 16pt;">Unit-4<o:p></o:p></span></p>
<p class="MsoNoSpacing">1. Write Formal Definitions of - Schema, Tuple, Domain,
State<o:p></o:p></p>
<p class="MsoNoSpacing">2. Explain Characteristics of Relations.<o:p></o:p></p>
<p class="MsoNoSpacing">3. Explain database Constraints in detail.<o:p></o:p></p>
<p class="MsoNoSpacing">4. Explain Relational Integrity Constraints in detail.<o:p></o:p></p>
<p class="MsoNoSpacing">5. Explain, what is Relational Database State and
Populated database state?<o:p></o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p class="MsoNoSpacing">6. what is Transaction? Explain transaction processing.<o:p></o:p></p>
<p class="MsoNoSpacing">7. what is Transaction? Explain Why Concurrency Control
is needed?<o:p></o:p></p>
<p class="MsoNoSpacing">8. Explain Transaction Concurrency in detail.<o:p></o:p></p>
<p class="MsoNoSpacing">9. What is Recovery? Why Recovery is Needed?<o:p></o:p></p>
<p class="MsoNoSpacing">10.What is Transaction? Explain Transaction states with
diagram.<o:p></o:p></p>
<p class="MsoNoSpacing">11.Explain DBMS Buffer Replacement Policies.<o:p></o:p></p>
<p class="MsoNoSpacing">12.Explain Desirable Properties of Transactions.<o:p></o:p></p>
<p class="MsoNoSpacing">13 Explain ACID properties of Transactions.<o:p></o:p></p>
<p class="MsoNoSpacing">14.Explain Characterizing Schedules Based on
Recoverability<o:p></o:p></p>
<p class="MsoNoSpacing">15.Explain Characterizing Schedules Based on
Serializability <o:p></o:p></p>
<p class="MsoNoSpacing">16.Explain, How Serializability is Used for Concurrency
Control?<o:p></o:p></p>
<p class="MsoNoSpacing">17. Explain View Equivalence and View Serializability in
schedules of transaction<o:p></o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p align="center" class="MsoNoSpacing" style="text-align: center;"><span face="".Helvetica Neue Interface",sans-serif" style="font-size: 16pt;">Unit-5<o:p></o:p></span></p>
<p class="MsoNoSpacing">1. What is SQL? Explain DDL, DML, DCL and TQL<o:p></o:p></p>
<p class="MsoNoSpacing">2. Explain DDL commands in detail.<o:p></o:p></p>
<p class="MsoNoSpacing">3. Explain DML commands in detail.<o:p></o:p></p>
<p class="MsoNoSpacing">4. Explain DQL commands in detail.<o:p></o:p></p>
<p class="MsoNoSpacing">5. Explain TCL commands in detail.<o:p></o:p></p>
<p class="MsoNoSpacing">6. What is constraints and how to define various
constraints?<o:p></o:p></p>
<p class="MsoNoSpacing">7. Explain Primary key, foreign key constraints with
example.<o:p></o:p></p>
<p class="MsoNoSpacing">8. Explain check and default constraints with example.<o:p></o:p></p>
<p class="MsoNoSpacing">9. Explain SQL operator in detail with example.<o:p></o:p></p>
<p class="MsoNoSpacing">10. Explain built in SQL functions with example.<o:p></o:p></p>
<p class="MsoNoSpacing">11. Explain aggregate functions SQL functions with
example.<o:p></o:p></p>
<p class="MsoNoSpacing">12. Explain numeric SQL functions with example.<o:p></o:p></p>
<p class="MsoNoSpacing">13. Explain string SQL functions with example.<o:p></o:p></p>
<p class="MsoNoSpacing">14. Explain set operations with example.<o:p></o:p></p>
<p class="MsoNoSpacing">15. What is subqueries explain it with example.<o:p></o:p></p>
<p class="MsoNoSpacing">16. Explain use of group by, having and order by SQL
clause.<o:p></o:p></p>
<p class="MsoNoSpacing">17. What is join? Explain Type of join with example.<o:p></o:p></p>
<p class="MsoNoSpacing">18. What is View? Explain type of view.<o:p></o:p></p>
<p class="MsoNoSpacing">19. Explain transaction control commands – Commit,
Rollback, Savepoint.<o:p></o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p class="MsoNoSpacing"><o:p> </o:p></p>
<p align="center" class="MsoNoSpacing" style="text-align: center;"><span face="".Helvetica Neue Interface",sans-serif" style="font-size: 16pt;">Unit-6<o:p></o:p></span></p>
<p class="MsoNoSpacing">1. What is PLSQL block? Explain with example.<o:p></o:p></p>
<p class="MsoNoSpacing">2. What is Stored Procedure? Explain with example.<o:p></o:p></p>
<p class="MsoNoSpacing">3. What is Function? Explain with example.<o:p></o:p></p>
<p class="MsoNoSpacing">4. What is Package? Explain with example.<o:p></o:p></p><p class="MsoNoSpacing"><br /></p><p class="MsoNoSpacing"><a href="http://drive.google.com/uc?export=download&id=11V__sjN_yDJkRXO6FbwuCwFNqEmhx8RC">Download RDBMS question bank PDF</a></p>
<p class="MsoNoSpacing"><o:p><span style="font-size: medium;"><br /></span></o:p></p><p class="MsoNoSpacing"><o:p><span style="font-size: medium;">RDBMS GTU old question paper </span></o:p></p><p class="MsoNoSpacing"><a href="https://drive.google.com/file/d/1wCyZHgfHE-BlOzTQfpaIXrrLjqDHrpbK/view?usp=sharing">Download RDBMS winter 2021 old question paper</a></p><p class="MsoNoSpacing"><a href="https://drive.google.com/file/d/1TCICgzcFZ_lJPiWR4jCYBNNRtKDkjE6Y/view?usp=sharing">Download RDBMS summer 2022 old question paper</a></p><p class="MsoNoSpacing"><br /></p>Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com0tag:blogger.com,1999:blog-5049897316123669366.post-48265592073288985292021-03-16T00:01:00.004-07:002021-03-16T00:02:51.456-07:00MIS - Ethical Issues pertaining to Information System<p></p><div style="text-align: center;"><b>GUJARAT TECHNOLOGICAL UNIVERSITY - (GTU)</b></div><div style="text-align: center;"><b>MBA ( Master of Business Administration) Sem.-1</b></div><div style="text-align: center;"><b>Subject : Management Information Systems (MIS) </b></div><div style="text-align: center;"><b><i>Module: 4</i></b></div><div style="text-align: center;"><br /></div><ul style="text-align: left;"><li><b>Ethical Issues pertaining to IS:</b></li><li><b>Ethical responsibilities of business professionals</b></li><li><b>Computer crime</b></li><ul><li>hacking & cracking, </li><li>cyber theft, </li><li>unauthorized use at work, </li><li>software piracy, </li><li>theft of intellectual property, </li><li>viruses & worms, </li><li>adware and spyware</li></ul><li><b>Information Security:</b></li><ul><li><i>First line of defense</i></li><ul><li>People / employees</li></ul><li><i>Second line of defense</i></li><ul><li>Technology for authorization, </li><li>prevention, detection and response</li></ul></ul><li><b>Contemporary/ emerging technologies:</b></li><ul><li>Cloud and mobile computing</li><li>E-commerce, m-commerce</li><li>Internet of Things</li></ul></ul><div style="text-align: center;"><a href="http://drive.google.com/uc?export=download&id=1NusXHPuPs9YGJl7nMwY9BINTpO6eBYpL" rel="nofollow" target="_blank">DOWNLOAD PPT / Lecture Notes</a></div><p></p>Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com0tag:blogger.com,1999:blog-5049897316123669366.post-84146149783492322802019-11-21T23:12:00.002-08:002022-04-03T23:16:41.733-07:00GTU MCA Programming in Python 4639304<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<b><br /></b>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-APBZ5pO8No4/Xhvzi3hqFAI/AAAAAAAAA7s/Vu7OBVSLZvoJZWlhTt_FONRf20Pp0Dg9wCLcBGAsYHQ/s1600/gtu-mca-python-programing-bipin-rupadiya.png" style="clear: left; float: left; margin-bottom: 1em; margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="768" data-original-width="1366" height="356" src="https://1.bp.blogspot.com/-APBZ5pO8No4/Xhvzi3hqFAI/AAAAAAAAA7s/Vu7OBVSLZvoJZWlhTt_FONRf20Pp0Dg9wCLcBGAsYHQ/s640/gtu-mca-python-programing-bipin-rupadiya.png" width="80%" /></a>
</div>
<b><br /></b>
</div>
<div style="text-align: center;">
<b>GUJARAT TECHNOLOGICAL UNIVERSITY (GTU)</b>
</div>
<div style="text-align: center;">
<b>MASTERS IN COMPUTER APPLICATION (MCA)</b>
</div>
<div style="text-align: center;">
Year – 2 (Semester – 3) (W.E.F. JULY 2018)
</div>
<h3 style="text-align: center;">
<b>Programming in Python - 4639304</b>
</h3>
<br />
<a href="https://drive.google.com/uc?export=download&id=16wR7rPOFjVhktnUq4dFb3fwYlhUnG1gH" target="_blank"><b>Unit-1 Introduction to Python:</b> <b>[ Download Lecture PPT ]</b></a><br />
<br />
<ul style="text-align: left;">
<li><b>The basic elements of Python</b>,</li>
<ul>
<li>
Objects, expressions and numerical Types, Variables and assignments,
IDLE, Branching programs, Strings and Input, Iteration
</li>
</ul>
<li><b>Structured Types, Mutability and Higher-order Functions:</b></li>
<ul>
<li>
Tuples, Lists and Mutability, Functions as Objects, Strings, Tuples and
Lists, Dictionaries
</li>
</ul>
</ul>
<br />
<br />
<a name='more'></a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1JgqT0HwkMV8gqN_xuPwI6R7uY2PLsJJ4" target="_blank"><b>Unit-2 Functions, Exception, Modules and Files</b>
<b>[ Download Lecture PPT ]</b></a><br />
<br />
<ul style="text-align: left;">
<li><b>Functions: </b></li>
<ul>
<li>
Difference between a Function and a Method, Defining a Function, Calling
a Function, Returning Results from a Function, Returning Multiple Values
from a Function, Functions are First Class Objects, Pass by Object
Reference, Formal and Actual Arguments, Positional Arguments, Keyword
Arguments, Default Arguments, Variable Length Arguments, Local and
Global Variables, The Global Keyword, Passing a Group of Elements to a
Function, Recursive Functions, Anonymous Functions or Lambdas (Using
Lambdas with filter() Function, Using Lambdas with map() Function, Using
Lambdas with reduce() Function), Function Decorators, Generators,
Structured Programming, Creating our Own Modules in Python, The Special
Variable __name__
</li>
</ul>
<li><b>Exceptions: </b></li>
<ul>
<li>
Errors in a Python Program (Compile-Time Errors, Runtime Errors, Logical
Errors),Exceptions, Exception Handling, Types of Exceptions, The Except
Block, The assert Statement, User-Defined Exceptions, Logging the
Exceptions
</li>
</ul>
<li><b>Files: </b></li>
<ul>
<li>
Files, Types of Files in Python, Opening a File, Closing a File, Working
with Text Files Containing Strings, Knowing Whether a File Exists or
Not, Working with Binary Files, The with Statement, Pickle in Python,
The seek() and tell() Methods, Random Accessing of Binary Files, Random
Accessing of Binary Files using mmap, Zipping and Unzipping Files,
Working with Directories, Running Other Programs from Python Program
</li>
</ul>
</ul>
<br />
<br />
<a href="https://drive.google.com/uc?export=download&id=15c33klxDiitMuDH_l-YdOTIiHmfHg14p" target="_blank"><b>Unit-3 Classes and Object-oriented Programming:</b>
<b>[ Download Lecture PPT ]</b></a><br />
<br />
<ul style="text-align: left;">
<li><b>Classes: </b></li>
<ul>
<li>
Creating a Class, The Self Variable, Constructor, Types of Variables,
Namespaces, Types of Methods (Instance Methods, Class Methods, Static
Methods), Passing Members of One Class to Another Class, Inner Classes
</li>
</ul>
<li><b>Inheritance and Polymorphism: </b></li>
<ul>
<li>
Constructors in Inheritance, Overriding Super Class Constructors and
Methods, The super() Method, Types of Inheritance, Single Inheritance,
Multiple Inheritance, Method Resolution Order (MRO), Polymorphism, Duck
Typing Philosophy of Python, Operator Overloading, Method Overloading,
Method Overriding
</li>
</ul>
<li><b>Abstract Classes and Interfaces</b>:</li>
<ul>
<li>
Abstract Method and Abstract Class, Interfaces in Python, Abstract
Classes vs. Interfaces,
</li>
</ul>
</ul>
<br />
<br />
<b><a href="https://drive.google.com/uc?export=download&id=1aPWBNCZgkl-y20Fu0X84sYDzBdVXYfKm" target="_blank">Unit-4 Advanced Topics I: Plotting and Data Science [ Download Lecture PPT ]</a></b><br />
<br />
<ul style="text-align: left;">
<li>
<b>Plotting using PyLab</b>, Plotting mortgages and extended examples
</li>
<ul>
<li>Data Science Using Python:</li>
<li>
Data Frame (Creating Data Frame from an Excel Spreadsheet, Creating Data
Frame from .csv Files, Creating Data Frame from a Python Dictionary,
Creating Data from Python List of Tuples, Operations on Data Frames),
</li>
</ul>
<li><b>Data Visualization : </b></li>
<ul>
<li>Bar Graph, Histogram, Creating a Pie Chart, Creating Line Graph</li>
</ul>
</ul>
<br />
<br />
<b><a href="https://drive.google.com/uc?export=download&id=1eJebaTb83JYuwA7ROZYmgEX480RmkqKW" target="_blank">Unit-5 Advanced Topics II: Regular Expressions [ Download Lecture PPT ]</a></b><br />
<br />
<ul style="text-align: left;">
<li><b>REs and Python:</b></li>
<ul>
<li>
Regular Expressions, Sequence Characters in Regular Expressions,
Quantifiers in Regular Expressions, Special Characters in Regular
Expressions, Using Regular Expressions on Files, Retrieving Information
from a HTML File
</li>
</ul>
<li><b>Threading : </b></li>
<ul>
<li>
Concurrent Programming and GIL, Uses of Threads, Creating Threads in
Python, Thread Class Methods, Single Tasking using a Thread,
Multitasking using Multiple Threads, Thread Synchronization Deadlock of
Threads, Avoiding Deadlocks in a Program, Communication between Threads,
Thread Communication using notify() and wait() Methods, Thread
Communication using a Queue, Daemon Threads
</li>
</ul>
<li><b>Networking:</b></li>
<ul>
<li>
Protocol, Sockets, Knowing IP Address, URL, Reading the Source Code of a
Web Page, Downloading a Web Page from Internet, Downloading an Image
from Internet, A TCP/IP Server, A TCP/IP Client, A UDP Server, A UDP
Client, File Server, File Client, Two-Way Communication between Server
and Client, Sending a Simple Mail,
</li>
</ul>
</ul>
<br />
<br />
<b><a href="https://drive.google.com/uc?export=download&id=1bYzEO98fA6d0EZ6ZGW4Ntl0V-h0OgRtb" target="_blank">Unit-6 Python's Database Connectivity [ Download Lecture PPT ]</a></b><br />
<br />
<ul style="text-align: left;">
<li>
Verifying the MySQLdb Interface Installation, Working with MySQL Database,
Using MySQL from Python, Retrieving All Rows from a Table, Inserting Rows
into a Table, Deleting Rows from a Table, Updating Rows in a Table,
Creating Database Tables through Python
</li>
</ul>
<br />
<br />
<b>Text Books:</b><br />
<br />
<ol style="text-align: left;">
<li>
John V Guttag. “Introduction to Computation and Programming Using Python”,
Prentice Hall of India
</li>
<li>
R Nageswara Rao, Core Python Programming, 2nd Edition, Dreamtech Press
</li>
</ol>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com4tag:blogger.com,1999:blog-5049897316123669366.post-76969890615611924542019-07-09T21:27:00.008-07:002022-01-14T22:06:27.193-08:00GTU MCA JAVA Practical<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-Oif0reqbu3M/Xhv0ngXgYWI/AAAAAAAAA74/fS820YAYVD0vIMcSt5xJVJMqwDxlRAXyQCLcBGAsYHQ/s1600/gtu-mca-java-programing-bipin-rupadiya.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="590" data-original-width="779" height="484" src="https://1.bp.blogspot.com/-Oif0reqbu3M/Xhv0ngXgYWI/AAAAAAAAA74/fS820YAYVD0vIMcSt5xJVJMqwDxlRAXyQCLcBGAsYHQ/s640/gtu-mca-java-programing-bipin-rupadiya.png" width="80%" /></a>
</div>
<b><br /></b>
<b>GUJARAT TECHNOLOGICAL UNIVERSITY (GTU)</b>
</div>
<div style="text-align: center;">
<b>MASTERS IN COMPUTER APPLICATION (MCA)</b>
</div>
<div style="text-align: center;">
<b>Year – 2 ( MCA Semester – 3) (W.E.F. JULY 2018)</b>
</div>
<div style="text-align: center;">
<br />
</div>
<div style="text-align: center;">
<b>Programming in JAVA (4639302 )</b>
</div>
<div style="text-align: center;">
<b><br /></b>
</div>
<div style="text-align: center;">
<b>Practical List</b>
</div>
<br />
<a href="https://drive.google.com/uc?export=download&id=1Be5pk00J9vjRG7NCbQn6gqBKLV-0VN8G" rel="nofollow" target="_blank">1 Write a simple “Hello World” java program, compilation, debugging, executing using java compiler and interpreter.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1IEID_NHAQAjKB3Bo16B_9FSvfSEci6Pw" rel="nofollow" target="_blank">2 Write a program to pass Starting and Ending limit and print all prime numbers and Fibonacci numbers between this range.</a><br />
<br />
<a name='more'></a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1mNKQQbIVnW2tvCNVEyQjjJR5KulPZDqM" rel="nofollow" target="_blank">3 Write a java program to check palindrome number.</a><br />
<a href="https://drive.google.com/uc?export=download&id=1mNKQQbIVnW2tvCNVEyQjjJR5KulPZDqM" rel="nofollow" target="_blank">Input: 329 Output: not palindrome number</a><br />
<a href="https://drive.google.com/uc?export=download&id=1mNKQQbIVnW2tvCNVEyQjjJR5KulPZDqM" rel="nofollow" target="_blank">Input: 12321 Output: palindrome number</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=16nWUw1VCjBB_OVBOPjeBQDirviJSesYU" rel="nofollow" target="_blank">4 Write a java program to print factorial of a number.</a><br />
<a href="https://drive.google.com/uc?export=download&id=16nWUw1VCjBB_OVBOPjeBQDirviJSesYU" rel="nofollow" target="_blank">Input: 5 Output: 120</a><br />
<a href="https://drive.google.com/uc?export=download&id=16nWUw1VCjBB_OVBOPjeBQDirviJSesYU" rel="nofollow" target="_blank">Input: 6 Output: 720</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1eyMJwiWyFJiDI5S46MXcSoayFilBejzG" rel="nofollow" target="_blank">5 Write a java program to check Armstrong number.</a><br />
<a href="https://drive.google.com/uc?export=download&id=1eyMJwiWyFJiDI5S46MXcSoayFilBejzG" rel="nofollow" target="_blank">Input: 153 Output: Armstrong number</a><br />
<a href="https://drive.google.com/uc?export=download&id=1eyMJwiWyFJiDI5S46MXcSoayFilBejzG" rel="nofollow" target="_blank">Input: 22 Output: not Armstrong number</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1R8l00b6ciU3mo_BD_8qedxU5wcMPUU7v" rel="nofollow" target="_blank">6 Write a program in Java to find maximum of three numbers using conditional operator</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1KzKkovqa4ZsR5f9i4tKO6mcTlga3NwVf" rel="nofollow" target="_blank">7 Write a java program which should display maximum and minimum number of given 3 numbers.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1lzpcUHq685HUmjVcwkK82YPbVTzocsjO" rel="nofollow" target="_blank">8 Write a program in Java to multiply two matrix</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1cMitDlhmFTEGN-8_775ldqZ2pa386MI0" rel="nofollow" target="_blank">9 Write a java program to create a class “Matrix” that would contain integer values having varied numbers of columns for each row. Print row-wise sum of the integer values for each row.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=10MK_4O1YlaPs8FHEpgaHnWNFZ_L2xmUa" rel="nofollow" target="_blank">10 Write a Java application which takes several command line arguments, which are supposed to be names of students and prints output as given below:</a><br />
<a href="http://drive.google.com/uc?export=download&id=10MK_4O1YlaPs8FHEpgaHnWNFZ_L2xmUa" rel="nofollow" target="_blank">(Suppose we enter 3 names then output should be as follows)..</a><br />
<a href="http://drive.google.com/uc?export=download&id=10MK_4O1YlaPs8FHEpgaHnWNFZ_L2xmUa" rel="nofollow" target="_blank">Number of arguments = 3</a><br />
<a href="http://drive.google.com/uc?export=download&id=10MK_4O1YlaPs8FHEpgaHnWNFZ_L2xmUa" rel="nofollow" target="_blank">1.: First Student Name is = Tom</a><br />
<a href="http://drive.google.com/uc?export=download&id=10MK_4O1YlaPs8FHEpgaHnWNFZ_L2xmUa" rel="nofollow" target="_blank">2.: Second Student Name is = Dick</a><br />
<a href="http://drive.google.com/uc?export=download&id=10MK_4O1YlaPs8FHEpgaHnWNFZ_L2xmUa" rel="nofollow" target="_blank">3.: Third Student Name is = Harry</a><br />
<a href="http://drive.google.com/uc?export=download&id=10MK_4O1YlaPs8FHEpgaHnWNFZ_L2xmUa" rel="nofollow" target="_blank">Hint: An array may be used for converting from numeric values from 1 to 20
into String</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1WtD48phrA2KGxlNl85iCkCDNXWRiSzKx" rel="nofollow" target="_blank">11 Write a Java application to count and display frequency of letters and digits from the String</a><br />
<a href="http://drive.google.com/uc?export=download&id=1WtD48phrA2KGxlNl85iCkCDNXWRiSzKx" rel="nofollow" target="_blank">given by user as command-line argument.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=18BCtyV0mmX_p5FoePBlu-iX7zA6IOu0Q" rel="nofollow" target="_blank">12 Create a class “Student” that would contain enrollmentNo, name, and gender as data members. Create appropriate getter and setter methods for the “Student” class and constructors to initialize the data members. Also demonstrate constructor chaining.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1L-zfUsJ6E8pkJv3Vkenx6IjRJ_OekMIG" rel="nofollow" target="_blank">13 Write a program in Java to demonstrate use of this keyword. Check whether this can access the private members of the class or not. [Refer class student in Q12 to perform the task]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1LOVVUwcKg3P4yoIklNxI4ZMfWsvwZQHp" rel="nofollow" target="_blank">14 Create a class “Rectangle” that would contain length and width as data members.</a><br />
<a href="http://drive.google.com/uc?export=download&id=1LOVVUwcKg3P4yoIklNxI4ZMfWsvwZQHp" rel="nofollow" target="_blank">Define constructors [constructor overloading (default, parameterized and
copy)] to initialize the data members. Define the member functions to find
area and to display the number of objects created.</a><br />
<a href="http://drive.google.com/uc?export=download&id=1LOVVUwcKg3P4yoIklNxI4ZMfWsvwZQHp" rel="nofollow" target="_blank">[Note: define initializer block, static initializer block and the static
data member and member function. Also demonstrate the sequence of execution
of initializer block and static initializer block]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1UfEfLmBPCTGGmHEQJKXsNV_dk_LiF7JN" rel="nofollow" target="_blank">15 Write a java program static block which will be executed before main ( ) method in a class.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1dpmQpDlWRh81eXsTsJNk9q_Y8lhuSfG7" rel="nofollow" target="_blank">16 Write programs in Java to use Wrapper class of each primitive data types</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1uSDtJUIqGpLQh8kPO7cqLsNsk8_dGH-K" rel="nofollow" target="_blank">17 Write a class “circle” with radius as data member and count the number of instances created using default constructor only. [Constructor Chaining]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=10obDGYUtiVA0j-_spYZ0z9ZTgwEHPY2D" rel="nofollow" target="_blank">18 Create a class Vehicle with data member vehicle_type. Inherit the class in a class called car with data member model_type, company name etc. display the information of the vehicle by defining the display function in both super and sub class [ Method Overriding]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=15ySbYuvFzVxVawNufj1Y0XdAZX08tERp" rel="nofollow" target="_blank">19 Create a class “Account” containing accountNo, and balance as data members.</a><br />
<a href="http://drive.google.com/uc?export=download&id=15ySbYuvFzVxVawNufj1Y0XdAZX08tERp" rel="nofollow" target="_blank">Derive the Account class into two classes named “Savings” and “Current”.
The “Savings” class should contain a data member named interestRate, and the
“Current” class should contain a data member called overdraftLimit. Create
appropriate member functions for all the classes to enable functionalities
to check balance, deposit, and withdraw amount in Savings and Current
account.</a><br />
<a href="http://drive.google.com/uc?export=download&id=15ySbYuvFzVxVawNufj1Y0XdAZX08tERp" rel="nofollow" target="_blank">[Ensure that the Account class cannot be instantiated.]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1Lg6YpoQTM_tIccw3SSDu5cmye9RMiPIj" target="_blank">20 Write a program in Java in which a subclass constructor invokes the constructor of the super class and instantiate the values. [ refer class Account and sub classes savingAccount and CurrentAccount in Q 19 for this task]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1iPPyrgS6idKo6VPTPnTDg28EwUl_sLMW" target="_blank">21 Write a program in Java to demonstrate the use of 'final' keyword in the field declaration. How it is accessed using the objects.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1athnr5SG4F2ARF_zv6Kc7MjCdNdX3FC5" rel="nofollow" target="_blank">22 Write a java program to illustrates how to access a hidden variable. Class A declares a static variable x. The class B extends A and declares an instance variable x. display ( ) method in B displays both of these variables.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1DEuSMUXIljp3iF7r7pOwG8UVqfNuuCDx" target="_blank">23 Describe abstract class called Shape which has three subclasses say Triangle,Rectangle, and Circle. Define one method area () in the abstract class and override this area () in these three subclasses to calculate for specific object i.e. area () of Triangle subclass should calculate area of triangle etc. Same for Rectangle and Circle</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1bVV6jfsE2-DhYM0MEUOyB-HOvgAiCh22" rel="nofollow" target="_blank">24 Write a java program to implement an interface called Exam with a method Pass (int mark) that returns a boolean. Write another interface called Classify with a method Division (int average) which returns a String. Write a class called Result which implements both Exam and Classify. The Pass method should return true if the mark is greater than or equal to 50 else false. The Division method must return “First” when the parameter average is 60 or more, “Second” when average is 50 or more but below 60, “No division” when average is less than 50.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1tOnytRUPeqvykCVLEJViqfACxo6BZNHA" rel="nofollow" target="_blank">25 Assume that there are two packages, student and exam. A student package contains Student class</a><br />
<a href="http://drive.google.com/uc?export=download&id=1tOnytRUPeqvykCVLEJViqfACxo6BZNHA" rel="nofollow" target="_blank">and the exam package contains Result class. Write a program that generates
mark sheet for students.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1_q6hDDoFMZFXn1L17AC_xmwGVMzEbXLO" rel="nofollow" target="_blank">26 Define a class A in package apack. In class A, three variables are defined of access modifiers protected, private and public. Define class B in package bpack which extends A and write display method which accesses variables of class A.</a><br />
<a href="http://drive.google.com/uc?export=download&id=1_q6hDDoFMZFXn1L17AC_xmwGVMzEbXLO" rel="nofollow" target="_blank">Define class C in package cpack which has one method display() in that
create one object of class A and display its variables. Define class
ProtectedDemo in package dpack in which write main () method. Create objects
of class B and C and class display method for both these objects.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1_3U8BbBD6BAP_mZQMpIjCjUFjk0a6LpY" target="_blank">27 Write a java program to implement lambda expression with functional interface in java</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1N2VQD-V7r5rML3gwtH4bE-1DPgpTHh0L" rel="nofollow" target="_blank">28 Write a java program to accept string check whether it is in Upper or Lower case. As per case change it in according vise versa.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1ePO8eTILcqGZwzDRHY-N69DvOwzkomjp" rel="nofollow" target="_blank">29 Write a java program to use important methods of String class.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1SBlFR86C50PKgH952BOn840Ye0jAMhQX" target="_blank">30 Write a program in Java to demonstrate use of final class.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1a6EOeVur10nZZwrLpV0jWoMbk6IcNiLj" rel="nofollow" target="_blank">31 Write a program in Java to develop user defined exception for 'Divide by Zero' error</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1gY3zIKxf5qfMpHMPmWcyninOFLPC0ZjD" rel="nofollow" target="_blank">32 Write a program in Java to demonstrate throw, throws, finally, multiple try block and multiple catch exception.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1MZ45DQ6C55-Yd8NyS4oeK606z0NgMH14" rel="nofollow" target="_blank">33 Write a small application in Java to develop Banking Application in which user deposits the amount Rs 1000.00 and then start withdrawing of Rs 400.00, Rs 300.00 and it throws exception "Not Sufficient Fund" when user withdraws Rs. 500 thereafter.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1dQuGICQPZ9uwxBAKXnRdo_iL37F3Srr5" rel="nofollow" target="_blank">34 Write a program to write at least 10 objects of the Circle class in a File using ObjectOutputStream and perform basic operations: adding, retrieving, updating, removing elements.</a><br />
<a href="http://drive.google.com/uc?export=download&id=1dQuGICQPZ9uwxBAKXnRdo_iL37F3Srr5" rel="nofollow" target="_blank">[ Use Generic Data types and Collections for the this task]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1mLnNtxRzgLntBDlNS1h_64nsymhyAt7D" rel="nofollow" target="_blank">35 Write a program for Java Generics and Collections Sorting operations:</a><br />
<a href="https://drive.google.com/uc?export=download&id=1mLnNtxRzgLntBDlNS1h_64nsymhyAt7D" rel="nofollow" target="_blank">1. Sorting a list according to natural ordering of elements</a><br />
<a href="https://drive.google.com/uc?export=download&id=1mLnNtxRzgLntBDlNS1h_64nsymhyAt7D" rel="nofollow" target="_blank">2. Reversing sort order</a><br />
<a href="https://drive.google.com/uc?export=download&id=1mLnNtxRzgLntBDlNS1h_64nsymhyAt7D" rel="nofollow" target="_blank">3. Sorting a list whose elements of a custom type</a><br />
<a href="https://drive.google.com/uc?export=download&id=1mLnNtxRzgLntBDlNS1h_64nsymhyAt7D" rel="nofollow" target="_blank">4. Sorting a list using a Comparator</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=19MPGOIg1GYK8VqjcWsR-WJVngq-1leYZ" rel="nofollow" target="_blank">36 Write a program in Java to create, write, modify, read operations on a Text file.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1KRfHhOPy8EEi5RMC4_M-W6cGNyLUkZWz" rel="nofollow" target="_blank">37 Write a java program to illustrates use of standard input stream to read the user input.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1KjRZ9zoqciexPGzWEX0opZ_V-zV-ki2z" rel="nofollow" target="_blank">38 Write a java program to checks the existence of a specified file.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1H2edj9TiirkvgSflV3dVG9voRx6CqL8h" rel="nofollow" target="_blank">39 Write a java program to create a file to the specified location.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1ltizPOQWS2NJ_7d2lkxGmH_kQsa_ReWE" target="_blank">40 Write a java program to demonstrate the way contents are read from a file.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1KlcfZKLLVWiqgpKfjGTpEaprnJBOfVxb" rel="nofollow" target="_blank">41 Write a java program to first checks the existence of the specified file. If the file exists, the data is written to the file through the object of the FileOutputStream class.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1fswbUrR5aJTJdJI9X1YRfUnFb2omMvNg" rel="nofollow" target="_blank">42 Write a java program to count the availability of text lines in the particular file. A file is read before counting lines of a particular file.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1gjEC3Dk_cLGyWXdXrbTgu-s2Sfzz7Eyj" rel="nofollow" target="_blank">43 Write a generic method to count the number of elements in a collection that have a specific property (for example, odd integers, prime numbers, palindromes).</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1bT2RoDdZcjMu-9gGa1S8nf0FjHvD1hDN" rel="nofollow" target="_blank">44 Write a generic method to exchange the positions of two different elements in an array.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1nSy7AkpZhANwEIJrWm0hMjBJ9KsqVPHQ" rel="nofollow" target="_blank">45 Write a generic method to find the maximal element in the range [begin, end) of a list.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1P8nwNMy59W_YxCd3Lscnt73_9Z6enp99" rel="nofollow" target="_blank">46 Write a program to implement JDBC/ODBC connectivity to data base using java program.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1bg_LxYjW4oNd92JD8l8sERofn1RCy9c_" rel="nofollow" target="_blank">47 Write a java program to connect any of database e.g. MYSQL / Oracle /MS Access/ etc.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1rmN_O22la6yry270aWZJ6xR8j09ruzuG" rel="nofollow" target="_blank">48 Write a java program to create Employee table(Empno., Name, Designation, Salary) and insert a record in it.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1UH6S2GNnsGOdy2bdGEfLcZxeNBYevKd0" target="_blank">49 Write a JAVA program to accept the details of student (Rno , SName , Per) from the user and insert it into the table. (use PreparedStatement Class).</a><br />
<br />
<a href="http://drive.google.com/uc?export=download&id=1mwPC92s861SxaQjxcbM3qM9Qmt-4DQlG" rel="nofollow" target="_blank">50 Write a Menu driven program in Java for the following.</a><br />
<a href="https://drive.google.com/uc?export=download&id=1mwPC92s861SxaQjxcbM3qM9Qmt-4DQlG" rel="nofollow" target="_blank">1. Create a Library Table (BookID, ISSNNo., Author, BookTitle, Price, Publisher, Year) .</a><br />
<a href="https://drive.google.com/uc?export=download&id=1mwPC92s861SxaQjxcbM3qM9Qmt-4DQlG" rel="nofollow" target="_blank">2. Insert Record into the Library Table. </a><br />
<a href="https://drive.google.com/uc?export=download&id=1mwPC92s861SxaQjxcbM3qM9Qmt-4DQlG" rel="nofollow" target="_blank">3. Update The Existing Record. </a><br />
<a href="https://drive.google.com/uc?export=download&id=1mwPC92s861SxaQjxcbM3qM9Qmt-4DQlG" rel="nofollow" target="_blank">4. Display all the Records from the Table. </a><br />
<a href="https://drive.google.com/uc?export=download&id=1mwPC92s861SxaQjxcbM3qM9Qmt-4DQlG" rel="nofollow" target="_blank">5. Display names of books stating with “J” character </a><br />
<a href="https://drive.google.com/uc?export=download&id=1mwPC92s861SxaQjxcbM3qM9Qmt-4DQlG" rel="nofollow" target="_blank">6. Delete the record 7. Exit from the program.</a><br />
<br />
<div style="text-align: center;">
<b>Desirable : Thread Programming</b>
</div>
<br />
<a href="https://drive.google.com/uc?export=download&id=1SQCPBfajDMpi8eYqP7pjbO8AD-BeJ17p" rel="nofollow" target="_blank">1 Write a program to implement the concept of threading by extending Thread Class</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1g7YhozvGi4GADWZFDlufGtM_d5GQwqRS" rel="nofollow" target="_blank">2 Write a program to implement the concept of threading by implementing Runnable Interface</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1jUsk9qzJbZ6rsxbLOMXGhOmUY_aTAeIC" rel="nofollow" target="_blank">3 Write a program that executes two threads. One thread displays “Thread1” every 2,000 milliseconds, and the other displays “Thread2” every 4,000 milliseconds.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=10IsHrICQhEz_dmcWYjKAQxkJK1mmFjs-" rel="nofollow" target="_blank">4 Write a program that executes two threads. One thread will print the even numbers and another thread will print odd numbers from 1 to 50.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1fVlA77XYxkHmbXYjU-N63YuRmBHcM0Gp" rel="nofollow" target="_blank">5 Write java program that create and runs following threads:</a><br />
<a href="https://drive.google.com/uc?export=download&id=1fVlA77XYxkHmbXYjU-N63YuRmBHcM0Gp" rel="nofollow" target="_blank">i) print "A" 20 times</a><br />
<a href="https://drive.google.com/uc?export=download&id=1fVlA77XYxkHmbXYjU-N63YuRmBHcM0Gp" rel="nofollow" target="_blank">ii) print "B" 30 times</a><br />
<a href="https://drive.google.com/uc?export=download&id=1fVlA77XYxkHmbXYjU-N63YuRmBHcM0Gp" rel="nofollow" target="_blank">iii) print "C" 15 times</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=18vAWDXLvingNEXbb0oOTEjG5nAfXSvkd" rel="nofollow" target="_blank">6 Write a program in Java to demonstrate use of synchronization of threads when multiple threads are trying to update common variable</a>
</div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com6tag:blogger.com,1999:blog-5049897316123669366.post-41827685563637077812019-07-04T20:51:00.002-07:002022-04-03T23:25:55.782-07:00GTU MCA Programming in JAVA - 4639302<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-Oif0reqbu3M/Xhv0ngXgYWI/AAAAAAAAA74/iT4zYSwRju8a1WU8GaKQVeyc9GAVThGLQCEwYBhgL/s1600/gtu-mca-java-programing-bipin-rupadiya.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="590" data-original-width="779" height="484" src="https://1.bp.blogspot.com/-Oif0reqbu3M/Xhv0ngXgYWI/AAAAAAAAA74/iT4zYSwRju8a1WU8GaKQVeyc9GAVThGLQCEwYBhgL/s640/gtu-mca-java-programing-bipin-rupadiya.png" width="80%" /></a>
</div>
<b><br /></b>
<b>GUJARAT TECHNOLOGICAL UNIVERSITY'S (GTU)</b>
</div>
<div style="text-align: center;">
<b>MASTERS IN COMPUTER APPLICATION (MCA)</b>
</div>
<div style="text-align: center;">
Year – 2 (Semester - 3 ) (W.E.F. JULY 2018)
</div>
<div style="text-align: center;">
<b>Programming in JAVA - 4639302</b>
</div>
<br />
<br />
<b>Unit I :
<a href="https://drive.google.com/uc?export=download&id=1yBWaVyhYvNtFnOqoVFqUjFb-dnnqg5JO" rel="nofollow" target="_blank">Introduction to Java</a> </b><br />
Programming Platform,Java Buzzwords, overview of applet and internet, History
of Java, common misconception about Java, The Java Programming Environment:
installing JDK, using the command line tools, using IDE, Programming
Structures in Java: data types, operators, working with Strings, working with
Scanner class for input and output, control flow, big number and Arrays.<br />
<br />
<a name='more'></a><br />
<br />
<b>Unit II :
<a href="https://drive.google.com/uc?export=download&id=1ANwp0XZbE2x5S0s-dB2uOawXZOlVtjYL" rel="nofollow" target="_blank">Objects and Classes, Inheritance, Interface</a></b><br />
Objects and Classes: classes, objects, objects and object variables, LocalDate
Class, Mutator and Accessor methods, defining your own classes, static fields
and methods, method parameters, object construction, packages and the class
path.<br />
Inheritance: classes, superclasses, and subclasses, overriding methods,
inheritance hierarchies, polymorphism, final class and methods, casting,
abstract classes and, protected access, Object: Cosmic superclass, Object
Wrappers and Autobxing and Enumeration classes. Interface.<br />
<br />
<b>Unit III :
<a href="https://drive.google.com/uc?export=download&id=194y4N0bIvbqJZCUookDB2wyGn1lsed2T" rel="nofollow" target="_blank">Lambda Expressions, Inner classes.</a></b><br />
Lambda Expressions, Inner classes: Interfaces, examples of interfaces, Why
Lambdas? Syntex of lambda expression, functional interfaces, method reference,
constructor reference, variable scope, processing lambda expression and inner
classes.<br />
<br />
<b>Unit IV :
<a href="https://drive.google.com/uc?export=download&id=1V4kOVVkJcCB_LA-5lk6eaGImwyy68kxz" rel="nofollow" target="_blank">Exception Handling, Generic Programming</a></b><br />
Exception Handling: dealing with errors, catching exceptions, tips for using
exceptions:<br />
Generic Programming: A Simple Generic class, generic methods, bounds for type
variables, generic code and the VM, restrictions and limitations and
inheritance rules for generic types.<br />
<br />
<b>Unit V:
<a href="https://drive.google.com/uc?export=download&id=12WTla3L4n1QZ9uz9J1tKZy6gni289K5U" rel="nofollow" target="_blank">Input and Output</a></b><br />
Input/Output Streams: reading writing bytes, combining IO steam filers, Text
Input and Output: write text output, read text outpout, saving object in text
format, character encoding, Reading and Writing, Working with Files: paths,
reading and writing files, creating files and directories, copying, moving and
deleting files and getting file info.<br />
<br />
<b>Unit VI:
<a href="https://drive.google.com/uc?export=download&id=1u0EVaGZtYt24-LhA1NOlBOl7d2Ou-_iI" rel="nofollow" target="_blank">Database Programming</a></b><br />
The Design of JDBC, JDBC Driver Types, SQL, JDBC Configuration: URL, driver
jar files, starting the database, registering the driver class, connecting to
the database, Working with JDBC Statements: executing SQL statement, managing
connections, statements, resultsets, SQL exceptions, Query Execution: prepared
statement.<br />
<br />
<b>Text Book(s):</b><br />
1. Cay S. Horstmann “Core Java , Volume I – Fundamentals”, 10th Edition,
Pearson Education , 2017<br />
2. Cay S. Horstmann “Core Java , Volume II – Advanced Features”, 10th Edition,
Pearson Education , 2017<br />
<br />
<br />
<br />
<div style="text-align: center;">
<span style="font-size: large;">Question Bank</span>
</div>
<br />
<b>Unit-1: Introduction to Java</b><br />
<br />
<ul style="text-align: left;">
<li>What is JAVA? </li>
<li>Explain History of JAVA</li>
<li>Explain Feature of JAVA </li>
<li>Explain JAVA Buzzwords</li>
<li>Explain common misconception about Java</li>
<li>Write steps to install JDK.</li>
<li>Explain JAVA jargons</li>
<li>Explain general structure of java program with block diagram.</li>
<li>Explain JAVA data types in detail.</li>
<li>What is operator? Explain types of Operator in JAVA.</li>
<li>Explain how to generate formatted output in Java.</li>
<li>Explain String API in detail.</li>
<li>What is Array? Explain Types of Array with example</li>
<li>What is big number? Explain it in detail.</li>
<li>Explain Control structure in Java?</li>
<li>Explain Looping structure in Java.</li>
<li>Explain decision structure in Java.</li>
<li>Explain difference between break V/S continue.</li>
<li>Explain variable size array with in an example.</li>
<li>Explain conditional operator (ternary operator) with an example.</li>
<li>Explain unary operator with an example.</li>
<li>Explain Type Conversions in detail</li>
<li>Explain String API in detail</li>
<li>Explain Scanner class and its input method.</li>
<li>Explain System.out.printf() in detail</li>
<li>Explain Big number in java.</li>
</ul>
<br />
<br />
<b>Unit-2: Objects and Classes, Inheritance, Interface </b><br />
<br />
<ul style="text-align: left;">
<li>What is Classes and Objects explain deference between it</li>
<li>Explain method of LocalDate class</li>
<li>What is constructor? Explain Type of constructor.</li>
<li>What is Encapsulation? Explain Benefits of Encapsulation</li>
<li>Explain use of Final keyword in detail.</li>
<li>Explain static field and static method in detail</li>
<li>What is Call by Value and Call by Reference explain in detail?</li>
<li>What is Overloading and Overriding Explain deference between it?</li>
<li>What is Overloading and Overriding Explain with example?</li>
<li>Explain object Initialization Blocks and static block in detail</li>
<li>Explain package with example.</li>
<li>Explain how to package java classed and how to import it</li>
<li>Explain import and static import.</li>
<li>What is Inheritance explain type of inheritance in detail</li>
<li>What is Polymorphism? Explain types of Polymorphism.</li>
<li>Explain final class and final method.</li>
<li>Explain instanceOf operator with example</li>
<li>
What is Abstraction? Explain abstract class and method with example.
</li>
<li>
Explain four access modifiers default, private, protected and public in
detail
</li>
<li>Explain methods of cosmic superclass / object class</li>
<li>Explain Wrapper class with example.</li>
<li>What is autoboxing explain with example.</li>
<li>Explain enum data type with example.</li>
<li>What is interface explain</li>
<li>Explain Comparable, Comparator and cloneable Interface in detail</li>
</ul>
<br />
<br />
<b>Unit-3: Lambda Expressions, Inner classes.</b><br />
<br />
<ul style="text-align: left;">
<li>
What is Lamda? Explain important characteristics of a lambda
expression/syntax
</li>
<li>
What is Functional Interfaces how it use with Lamda? Explain with example.
</li>
<li>What is Inner class? Explain type of inner class.</li>
<li>What is static inner class explain with example</li>
</ul>
<br />
<br />
<br />
<br />
<b>Unit-4: Exception Handling, Generic Programming </b><br />
<ul style="text-align: left;">
<li>What is Exception Handling?</li>
<li>What is Exception? Give Classification of Exceptions.</li>
<li>What is Exceptions? Explain Types of Java Exceptions</li>
<li>What is checked and unchecked exceptions explain with example</li>
<li>Explain keywords: try, catch, finally, throw, throws</li>
<li>What is Custom / user-defined Exception explain with example</li>
<li>Difference between throw and throws</li>
<li>
What is Generic Programming? Explain Advantage of Generic Programming in
java
</li>
<li>What is Generic Methods? Explain with example?</li>
<li>Explain how generic code is translated to run on the JVM</li>
<li>What is Bridge Methods? Explain with example</li>
<li>Explain restrictions and limitations of Java generic programming.</li>
</ul>
<br />
<br />
<b>Unit-5 Input and Output </b><br />
<ul style="text-align: left;">
<li>What is Stream? Explain IO Stream in detail.</li>
<li>Explain InputStream in detail</li>
<li>Explain OutputStream in detail</li>
<li>Explain How to read file by Byte by Byte with example?</li>
<li>Explain How to write file by Byte by Byte with example?</li>
<li>Explain with code, How to read char from file?</li>
<li>Explain FileOutputStream with example.</li>
<li>Write code to write string in to file using FileOutputStream.</li>
<li>Explain BufferedInputStream and BufferedOutputStream</li>
<li>Explain SequanceInputStream with example</li>
<li>Explain ByteArrayOutputStream with its important function</li>
<li>Explain ByteArrayInputStream with its important function</li>
<li>Explain DataOutputStream with its important function</li>
<li>Explain DataInputStream with its important function</li>
<li>Explain FilterOutputStream with its important function</li>
<li>Explain FilterInputStream with its important function</li>
<li>Explain RandomAccessFile with its important function</li>
<li>Explain FileReader with its important function</li>
<li>Explain FileWriter with its important function</li>
<li>Explain Path class methods with example</li>
<li>Explain File class with its important function</li>
<li>Write a code to list files and directory of current directory.</li>
<li>Explain how to create files and directory using Files class?</li>
<li>Explain how to do copy, move and delete file using Files class?</li>
<li>Explain BasicFileAttributes with its important methods</li>
</ul>
<br />
<br />
<b>Unit-6: Database Programming </b><br />
<br />
<ul style="text-align: left;">
<li>What is JDBC? Explain its JDBC driver types</li>
<li>Explain Difference between JDBC vs ODBC</li>
<li>Explain common JDBC SQL data types</li>
<li>Explain important method of ResultSet</li>
<li>Explain how to navigate in ResultSet</li>
<li>Explain 3 types of Statement available in JDBC</li>
<li>Explain 3 types of Query method</li>
<li>Explain difference between Statement and Prepare statement </li>
<li>Explain SQL Exceptions and warning in detail</li>
<li>Write a JAVA code to establish connection to the DataBase</li>
<li>Write a JAVA code to create table and insert record in it.</li>
</ul>
<br />
<div>
<br />
</div>
<br />
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com3tag:blogger.com,1999:blog-5049897316123669366.post-18126792790035193522019-06-18T22:18:00.001-07:002020-06-12T21:15:47.011-07:00BCA Sem-4 Word Press Saurashtra University<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<div class="separator" style="clear: both; text-align: center;">
<a
href="https://1.bp.blogspot.com/-HURs-LKl5xc/Xhv2tIGVQjI/AAAAAAAAA8E/ynY2MYxi6dEHYuvSDofW_mjJAviqzuhFQCLcBGAsYHQ/s1600/BCA-Wordpress-bipin-rupadiya.png"
imageanchor="1"
style="margin-left: 1em; margin-right: 1em;"
><img
border="0"
data-original-height="768"
data-original-width="1366"
height="358"
src="https://1.bp.blogspot.com/-HURs-LKl5xc/Xhv2tIGVQjI/AAAAAAAAA8E/ynY2MYxi6dEHYuvSDofW_mjJAviqzuhFQCLcBGAsYHQ/s640/BCA-Wordpress-bipin-rupadiya.png"
width="80%"
/></a>
</div>
<span style="font-size: large;"><br /></span>
<span style="font-size: large;"
>Bachelor of Computer Application (BCA)</span
>
</div>
<div style="text-align: center;">
<span style="font-size: large;">(Semester – III)</span>
</div>
<div style="text-align: center;">
<span style="font-size: large;">Saurashtra University, Rajkot</span>
</div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span>
</div>
<div style="text-align: center;">
<span style="font-size: large;"
>CS – 16: Content Management System using Word Press </span
>
</div>
<br />
<br />
<a
href="http://drive.google.com/uc?export=download&id=1VViDV6-LFH3slab-7tsI6hamDuVyajut"
rel="nofollow"
target="_blank"
>Introduction of WordPress</a
><br />
<br />
<a name='more'></a><br />
<br />
<a
href="http://drive.google.com/uc?export=download&id=1xg-WzaelNSb3TakHtkppHKNjpEZ5YDP_"
rel="nofollow"
target="_blank"
>Unit - 1 OOP (Object Oriented Programming) in PHP</a
><br />
<br />
<a
href="http://drive.google.com/uc?export=download&id=1xCQdBUqHok1ABeLrKJb72xtvbhnTTprM"
rel="nofollow"
target="_blank"
>Unit - 2 WordPress Introduction Installation & Configuration</a
><br />
<br />
<a
href="http://drive.google.com/uc?export=download&id=1iuPsNGUq067YZgiJtDxnf8r2vKZUlHXD"
rel="nofollow"
target="_blank"
>Unit - 3 WordPress Theme, Widget, Plugin</a
><br />
<br />
<a
href="http://drive.google.com/uc?export=download&id=10MpxXF11hs0wx4ukoLyiUljAjdGYhn8L"
target="_blank"
>Unit - 4 WordPress Theme development</a
><br />
<br />
<a
href="http://drive.google.com/uc?export=download&id=108DRIsIopVqCc5trJ4zDBeCiOULwX4MU"
rel="nofollow"
target="_blank"
>Unit - 5 WordPress Advanced development</a
><br />
<br />
<a
href="http://drive.google.com/uc?export=download&id=17kuf_GmFR1jGEAbChL9QZMCZJXMNw8lm"
rel="nofollow"
target="_blank"
>Question Bank of WordPress for BCA Student</a
><br />
<br />
<a
href="http://drive.google.com/uc?export=download&id=1iuPsNGUq067YZgiJtDxnf8r2vKZUlHXD"
rel="nofollow"
target="_blank"
>WordPress Syllabus of BCA Sem-4 Saurashtra University, Rajkot</a
><br />
<br />
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com3tag:blogger.com,1999:blog-5049897316123669366.post-71656545137642010622019-05-31T22:04:00.004-07:002022-04-03T23:44:48.612-07:00GTU Mobile Computing - 4649303 Practical Solution<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-bQGH5DA2tak/Xhv3NDrHGTI/AAAAAAAAA8M/M8PF-RAmrycIK8uL5rKw9NQ6mX6MiqCFQCLcBGAsYHQ/s1600/gtu-mca-android-programing-bipin-rupadiya.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="768" data-original-width="1366" height="358" src="https://1.bp.blogspot.com/-bQGH5DA2tak/Xhv3NDrHGTI/AAAAAAAAA8M/M8PF-RAmrycIK8uL5rKw9NQ6mX6MiqCFQCLcBGAsYHQ/s640/gtu-mca-android-programing-bipin-rupadiya.png" width="640" /></a></div>
<div style="text-align: center;">
<br /></div>
<br />
<div style="text-align: center;">
GUJARAT TECHNOLOGICAL UNIVERSITY’S</div>
<div style="text-align: center;">
Syllabus for Master of Computer Applications, 4th Semester</div>
<div style="text-align: center;">
Subject Name: Mobile Computing (MC)</div>
<div style="text-align: center;">
Subject Code: 4649303</div>
<div style="text-align: center;">
With effective from academic year 2018-19</div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<b>Practical Solution</b></div>
<br />
<a href="https://drive.google.com/uc?export=download&id=1JyI_l1WdEvVBjcd07H53q47f77NgsqaO" rel="nofollow" target="_blank">1.<span style="white-space: pre;"> </span>Installing "Android Studio IDE" and "Android SDK" [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=18zzf9khkwWWFugk7mgM0RWRomd2Kzgtp" rel="nofollow" target="_blank">2.<span style="white-space: pre;"> </span>Write your First Android App [ Download Example ]</a><br />
<br />
<a name='more'></a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1AmQh8hLpvbXCTxv7MN3pxA_7GfXk_XLE" rel="nofollow" target="_blank">3.<span style="white-space: pre;"> </span>Create “Hello World” application. That will display “Hello World” in the middle of the screen in the red color with white background. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1g8OzT5FsbeEq5oodrDQcAs4zrq7gNENZ" rel="nofollow" target="_blank">4.<span style="white-space: pre;"> </span>Create an application that designs a layout with a text box and button named Submit. The user should enter the text in the text box. When the submit button is clicked then the text in the text box should be displayed in the toast. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=18VymYZ9FSXvo9e-vmQd_qaV75PJYrIw2" rel="nofollow" target="_blank">5.<span style="white-space: pre;"> </span>Create an application to demonstrate Android Activity Life Cycle. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1IQIfREUTkvn-ZIz1C9DDIPzqu4amx_C0" rel="nofollow" target="_blank">6.<span style="white-space: pre;"> </span>To understand Activity,Intent Create sample application with login module.(Check username and password) On successful login, go to next screen. And on failing login, alert user using Toast. Also pass username to next screen. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1LtmEXUVwIGBhFq3QebqrUdYxZSG5ZcPp" rel="nofollow" target="_blank">7.<span style="white-space: pre;"> </span>Create an application that designs a layout having two text boxes user name and password. The user and password will be taken from the user. The username and password will be verified from the username and password stored in the resources folder. If the verification is successful then a new layout will appear which will open any URL in browser. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1SCdWM6zuW01ieIql7cqjOodegEiLFHYR" rel="nofollow" target="_blank">8.<span style="white-space: pre;"> </span>Create an application to call specific entered number by user in the Edit Text [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1xbv5Vcy-FmoHvnyfs4llSf92I3Xhb-EW" rel="nofollow" target="_blank">9.<span style="white-space: pre;"> </span>Create an application that will show List of Countries in One fragment , and on selecting one country, second fragment should be displayed with name selected country and its flag. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1lEx_iEJRU45hCHqSXQUQfq1WSXXgDtUa" rel="nofollow" target="_blank">10.<span style="white-space: pre;"> </span>Understanding of UI : [ Download Example ]</a><br />
<a href="https://drive.google.com/uc?export=download&id=1lEx_iEJRU45hCHqSXQUQfq1WSXXgDtUa" rel="nofollow" target="_blank">a.<span style="white-space: pre;"> </span>Create an UI such that, one fragment of screen have list of all the types of cars.</a><br />
<a href="https://drive.google.com/uc?export=download&id=1lEx_iEJRU45hCHqSXQUQfq1WSXXgDtUa" rel="nofollow" target="_blank">b.<span style="white-space: pre;"> </span>On selecting of any car name, second fragment of screen should show Car details Like: name, launched date, company name, images (using gallery) if available, show different colors in which it is available.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1cJQGT5lQifF6cyEzQ2rzX8i_FS1rTRpO" rel="nofollow" target="_blank">11.<span style="white-space: pre;"> </span>Android Program to Perform all Operations using Calculators [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1wK9Mo3hEj5BzN5cgGlK-U7_OJELTEFxn" rel="nofollow" target="_blank">12.<span style="white-space: pre;"> </span>Understand resource folder & Adapter : [ Download Example ]</a><br />
<a href="https://drive.google.com/uc?export=download&id=1wK9Mo3hEj5BzN5cgGlK-U7_OJELTEFxn" rel="nofollow" target="_blank">a.<span style="white-space: pre;"> </span>Create spinner with strings taken from resource folder (res >> value folder).</a><br />
<a href="https://drive.google.com/uc?export=download&id=1wK9Mo3hEj5BzN5cgGlK-U7_OJELTEFxn" rel="nofollow" target="_blank">b.<span style="white-space: pre;"> </span>On changing spinner value, change image.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1n8Byz3bcnezdVDI3qN_OLMbsYGQrw7gn" rel="nofollow" target="_blank">13.<span style="white-space: pre;"> </span>Create an application that parses given XML File. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=18kzKyug5mZBHW2fBDiKs9hcpnR-vfgIm" rel="nofollow" target="_blank">14.<span style="white-space: pre;"> </span>Create an application that parses given JSON File. [ Download Example ] </a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1hCMTpu9wmBJLTwdOPzWUHbS2ACx5BiFG" rel="nofollow" target="_blank">15.<span style="white-space: pre;"> </span>Create an application that fetches foreground and background colors from User. Save it as preference. On the next screen change background color and font color based on values passed by user. If no preferences are set then use Black and White as default background and foreground color respectively. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=12Xjka4Xl1DjKRbFoguKCfF2blmag99P5" rel="nofollow" target="_blank">16.<span style="white-space: pre;"> </span>Create an application that designs a layout having two text boxes user name and password. The user and password will be taken from the user. The username and password will be verified from database. If the verification is successful then a new layout will appear which will contain text "Welcome ,<UserName>" otherwise displays error message. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1Nb-Iwx9uRCSJq-QmEfdPjys6Wgwhp8Ii" target="_blank">17.<span style="white-space: pre;"> </span>Create an application that will create database with country table( Country short Name ( IND), Name). Create an application to make Insert, update, Delete and retrieve operation on the database. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1Dk9XfvKOHHtohU_PvCXr7zMXf6T4nDtm" rel="nofollow" target="_blank">18.<span style="white-space: pre;"> </span>Understanding content providers and permissions: Read phonebook contacts using content providers and display in list. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1rMFa4ewFta2E1WyDMyEV1dTJluSWx9g7" target="_blank">19.<span style="white-space: pre;"> </span>Android Program to Demonstrate Layouts in an Activity and Nesting of Layouts and Demonstrate List View Activity [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1184R6jcVrF44awU93XBllw-eBXNDc96O" target="_blank">20.<span style="white-space: pre;"> </span>Create application that works like an alarm. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1iGAx-Jn0IClR2gKKtOmJnr0nZuD0f-Rr" target="_blank">21.<span style="white-space: pre;"> </span>Understand Menu option and Context Menu : Create an application that will change color of the screen, based on selected options from the menu. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1t09ujFXDZ_nZj8AiIbjvxKkqLuGbLXn3" target="_blank">22.<span style="white-space: pre;"> </span>Create an application that will have spinner with list of animation names. On selecting animation name, that animation should affect on the images displayed below. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1oSFrMaVdBsxID7VmFffRopKA1owdpcbf" target="_blank">23.<span style="white-space: pre;"> </span>Android Program to Demonstrate an Adapter and Advanced Adapter. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1DDo4qVwl9JXLGiUWqITKYl8YegVS4Wlq" target="_blank">24.<span style="white-space: pre;"> </span>Android Program to Demonstrate Broadcast Receiver, Broadcast Receiver to Intercept Custom Intent, Pending Intent, OrderedBroadcast. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1PbxnEaOPfyD1aPxAvLbr1Nc6rQ-c9UyH" target="_blank">25.<span style="white-space: pre;"> </span>Android Program to Demonstrate Intent Filter, Local Broadcast Manager, to Monitoring Device State Changes Using Broadcast Intents. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1WOwL_bNtfvN4Yy9ZohgChcelJwXJm_N" target="_blank">26.<span style="white-space: pre;"> </span>Android Program to Open an Internet Data Stream. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=14SU4wYGkO45FeCaOX5S4WKRqN-lfwOpb" target="_blank">27.<span style="white-space: pre;"> </span>Android Program to Parse Xml Using Xml Pull Parser, Parse Xml Using Dom Parser. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1xHk18eG52aa92VnxvMmtoavg9GBwTX8c" target="_blank">28.<span style="white-space: pre;"> </span>Android to demonstrate Download Manager in Android, Android Program to Demonstrate Connection to an Internet Resource. [ Download Example ]</a><br />
<br />
<a href="https://www.bipinrupadiya.com/" target="_blank">29.<span style="white-space: pre;"> </span>Android Program to Demonstrate Creating and Saving Shared Preferences and Demonstrate Preference Screen and Sub-screen in a Preference Screen and Intent in Preference Screen. [ Download Example ]</a><br />
<br />
<a href="https://www.bipinrupadiya.com/" target="_blank">30.<span style="white-space: pre;"> </span>Android Program to Demonstrate Preference Fragment, Preference Headers Preference Activity. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1o7xBQKA7R38aP1msyvzENnbAGSbwk_xM" target="_blank">31.<span style="white-space: pre;"> </span>Android Program to Demonstrate Reading a File on SD Card, Reading and Writing to a File in Android and Instance Save State. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1Ifm0lfJeBC3PO2Jkv-flQpZsBDjUrigI" target="_blank">32.<span style="white-space: pre;"> </span>Create an application that will play a media file from the memory card. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1AJ5PWGxWJ1VcDKFRtADzQcj1pG1rN7vK" target="_blank">33.<span style="white-space: pre;"> </span>Create an application to take picture using native application. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1rR2kM8B-vkU7CsrxvHjXwe8dltPFSRPc" target="_blank">34.<span style="white-space: pre;"> </span>Create an application to pick up any image from the native application gallery and display it on the screen. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1Dqxo1WNK3tX_iom3fQw-sFCiXLip8761" target="_blank">35.<span style="white-space: pre;"> </span>Read messages from the mobile and display it on the screen. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1q6ncKVE81vUpgSeNxAMIDNXnw0um8eAE" target="_blank">36.<span style="white-space: pre;"> </span>Create an application to send message between two emulators. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=18ohJF8Nx68thnK_TmSqUYjVWIfcrdKls" target="_blank">37.<span style="white-space: pre;"> </span>Android Program to Demonstrate Action Bar in Android, Disable the Action Bar in an Activity, Hide Title Label of Action Bar in Android, Add Actions in Action Bar, Respond to Added Actions in Action Bar in Android, Change the Displayed Text alongside the Application Icon at Runtime, Change the Background of Action Bar in Android. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=17ex4QB3G0z4PqcvXOY_Nr91topgWG0XA" target="_blank">38.<span style="white-space: pre;"> </span>Android Program to Demonstrate Shape Drawables, Gradient Drawables, Radial Gradient, Sweep Gradient in Android. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1_GBiNYVmagUshD1vkPp8LwI8VQID-ALY" target="_blank">39.<span style="white-space: pre;"> </span>Create an application that designs a layout having a rating bar. Whenever user gives the rating then a dialog box should appear with a message and button OK. The message in the rating bar should be displayed (e.g.: 1.5 rating selected) ‘You have given 1.5 Rating’. When button OK is pressed than the dialog box should disappear. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=16-hOjgdA7VjHHIXntuvzDOjEkhNHMpJw" target="_blank">40.<span style="white-space: pre;"> </span>Create an application that designs a layout to take contact label (name) and phone no from the user and store in the contacts using content provider. Also design a layout to read phone contacts stored using content provider and display contact label (name) in list view. When the user selects any contact label (name) from the list view dialer application should be launched and call should be made using dialer application. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=12TsKHaQjwohPmrap2EqgoVhjEwZMAj4A" target="_blank">41.<span style="white-space: pre;"> </span>Create an application that designs a layout with spinner and an image view. The spinner should contain various shapes like circle, rectangle and rounded rectangle. When a shape is selected from the spinner that shape should be drawn in the image view. (Hint: Use shape Drawable or xml files for shapes on image view) [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1YRRBKmc-2f6dpCppp2jINv2lk8Z0UK29" target="_blank">42.<span style="white-space: pre;"> </span>Create an application that designs a layout containing a list view having options: [ Download Example ]</a><br />
<a href="https://drive.google.com/uc?export=download&id=1YRRBKmc-2f6dpCppp2jINv2lk8Z0UK29" target="_blank">a.<span style="white-space: pre;"> </span>Create File: By clicking on first option Create file a new layout should be displayed having two text boxes file name and file data and one button save. Both file name and data of the file should be entered by the user and on clicking save the file should be saved and proper message should be displayed on saving a file.</a><br />
<a href="https://drive.google.com/uc?export=download&id=1YRRBKmc-2f6dpCppp2jINv2lk8Z0UK29" target="_blank">b.<span style="white-space: pre;"> </span>Delete File: By clicking on second option delete file a new layout should be displayed having one text box file name and one button delete. The file name should be entered by the user and on clicking delete the file should be deleted and proper message should be displayed on deleting a file.</a><br />
<a href="https://drive.google.com/uc?export=download&id=1YRRBKmc-2f6dpCppp2jINv2lk8Z0UK29" target="_blank">c.<span style="white-space: pre;"> </span>Display File: By clicking on third option display file a new layout should be displayed having one text box for file name and one text view for file data and one button display. The file name should be entered by the user and on clicking the display button the contents of the file should be displayed in text view.</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=15syrTxHB2L9cMeAZ5FrkvTC5-nJMyLSl" target="_blank">43.<span style="white-space: pre;"> </span>Create an application that designs a layout with 3 text boxes and an options menu. The options menu should contain options like Simple Interest and compound Interest. The text boxes should be used for the input of information like the principle amount, rate of interest and number of years. Then clicking on the option from menu appropriate operation should be performed and correct result should be displayed. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1mTK4yAqz-QxLwStGCcge3w3Khg3VEMQz" target="_blank">44.<span style="white-space: pre;"> </span>Create an application that designs a layout having text boxes and button submit. The details of doctor like doctor’s first name, last name, mobile number, address, city and specialization should be entered by the user in the textboxes and on clicking on the button submit the data should be saved into the database. Create another layout that contains a text box, a button search and a text view that gives searching facility. User can search doctor’s full information by providing doctor’s name in the text box. On clicking on button search the information of the doctor should be displayed in text view. Doc_detail (doc_id, firstname, lastname, mob, add, city, specialization) [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1UjHxNc-lWkGXyVJCxpUi4sup_azds69d" target="_blank">45.<span style="white-space: pre;"> </span>Create an application that designs a layout with a list view and fetches the audio files stored in the SD Card. The names of the Audio files should be displayed in the list view. When the user clicks on the specific file name the title and duration of the audio should be displayed in the next layout. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1VHl3HH2A9G0WGPyg2ZNgpC2OupBOtM9C" target="_blank">46.<span style="white-space: pre;"> </span>Create an application that designs a layout having gallery of images and an image view. The gallery contains number of images. Whenever an image is selected from the gallery it should be displayed in the image view. The images should be fetched from the resources folder. (You can take any readymade image available or you can create your own) [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1V3kpFVEkKYxzWq-gMwWnnPdSGaJ8kFTg" target="_blank">47.<span style="white-space: pre;"> </span>Create an application that designs a layout having options menu and 2 text boxes for currency converter which allows user to select a particular conversion from following options.</a><br />
<a href="https://drive.google.com/uc?export=download&id=1V3kpFVEkKYxzWq-gMwWnnPdSGaJ8kFTg" target="_blank">a.<span style="white-space: pre;"> </span>Rupees to dollars</a><br />
<a href="https://drive.google.com/uc?export=download&id=1V3kpFVEkKYxzWq-gMwWnnPdSGaJ8kFTg" target="_blank">b.<span style="white-space: pre;"> </span>dollars to Rupees</a><br />
<a href="https://drive.google.com/uc?export=download&id=1V3kpFVEkKYxzWq-gMwWnnPdSGaJ8kFTg" target="_blank">c.<span style="white-space: pre;"> </span>Rupees to pound</a><br />
<a href="https://drive.google.com/uc?export=download&id=1V3kpFVEkKYxzWq-gMwWnnPdSGaJ8kFTg" target="_blank">d.<span style="white-space: pre;"> </span>Pound to Rupees</a><br />
<a href="https://drive.google.com/uc?export=download&id=1V3kpFVEkKYxzWq-gMwWnnPdSGaJ8kFTg" target="_blank">e.<span style="white-space: pre;"> </span>The data for conversion should be entered by the user in textbox. Then clicking on the option from menu appropriate operation should be performed and correct result should be displayed. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=197_pVLlCrf-_NFK4LthTHePZrHmYXhKQ" target="_blank">48.<span style="white-space: pre;"> </span>Create an application that designs a layout which provides field for enrollment number (text box), student’s name (text box), course (radio buttons), semester (radio buttons)) and marks for sub1 (text box), sub2 (text box), sub3 (text box) and a button name submit. When user clicks on submit button data should be added to database. Design a layout which displays current record and previously added record in a tabular manner. Total should be calculated automatically and then stored into the database. [ Download Example ] </a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1dYZ5PsdgZldSv1u_FaiacNJgt8OJajl2" target="_blank">49.<span style="white-space: pre;"> </span>Create an application that designs a layout having a list view having two options: [ Download Example ]</a><br />
<a href="https://drive.google.com/uc?export=download&id=1dYZ5PsdgZldSv1u_FaiacNJgt8OJajl2" target="_blank">1.<span style="white-space: pre;"> </span>Add contacts: On selection of the first option a new layout should be displayed containing two text boxes name and phone no and a button save. The name and phone no should be entered by the user and on clicking the save button the contact should be saved in the contacts directory and appropriate message should be displayed.</a><br />
<a href="https://drive.google.com/uc?export=download&id=1dYZ5PsdgZldSv1u_FaiacNJgt8OJajl2" target="_blank">2.<span style="white-space: pre;"> </span>Display contacts: On selection of second option display contacts a new layout should be displayed with list view and all the names from the contacts should be fetched and displayed in the list view. (Hint: Use Contacts Contract Content Provider).</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1SoITfDO-KyIpMetcYLUK6_qSP9B1wvGx" target="_blank">50.<span style="white-space: pre;"> </span>Create an application that designs a layout of a student registration form. The layout should contain fields like first name, last name, phone no, date of birth (use date control) gender (use radio buttons), hobbies (use check boxes) and a button register. On clicking register an alert dialog box should appear with a message “do you want to register” and with two buttons yes or no. If yes is clicked then a new layout should appear where all the entered details should be displayed and also calculate the age (in years only) of the student and display it. If no is clicked than the alert dialog box should disappear. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1Wu4XxKgDdQj7udu3vDW-QMUfOCKcxJtR" target="_blank">51.<span style="white-space: pre;"> </span>Create an application that designs a layout for making an Admission Form. The layout should contain details like student enrollment no (textbox), Sem (spinner), Course (spinner), Date (date control), DOB (Date picker), SSC marks (textbox), HSC Marks (spinner), CMAT Score (Textbox) and a button named Submit. When the button submit is clicked than a new layout should be opened that displays all the student details as a summary and also display Merit Score. Merit Score should be calculated when the submit button is clicked.Merit score = Average of (SSC marks, HSC Marks, CMAT score) [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1x4Txziw53sq6aVyqSr_EWjUJykqMAPR7" target="_blank">52.<span style="white-space: pre;"> </span>Create an application that designs a layout to store Result Details for MCA. The layout must contain details like name (textbox), Sem 1 Marks(spinner), Sem 2 Marks(spinner), Sem 3 Marks(spinner) , Sem 4 Marks(spinner), Sem 5 Marks(spinner) , Sem 6 Marks(spinner) and a Button named Submit.Note: Marks must be from (AA, AB, BB, BC, CC and FF) When the submit button is selected all the details should be saved in the database. Also provide a layout to perform the following operations:a. Update the Marks /grade. b. Search the Students on basis of his marks / grade. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=11MLyCF-RvqgwiVZ0bdb_66g6j_xTNmUv" target="_blank">53.<span style="white-space: pre;"> </span>Create an application that designs a layout to store Student Details. The layout should contain information like: Roll number (textbox), Name (textbox), Birth date (Date Picker), Marks1 (textbox), Marks2 (textbox), Marks3 (textbox) and button submit. When button submit is clicked than all the details must be saved in the database. Also percentage and total should be calculated automatically and saved into the database. Also design a layout to perform following operations:a. Update Any student’s marks b. Search the student details by roll no c. Delete any student by roll no [ Download Example ]</a><br />
<br />
<a href="http://www.bipinrupadiya.com/" target="_blank">54.<span style="white-space: pre;"> </span>Create an application to implement shopping cart. [ Download Example ]</a><br />
<br />
<a href="https://drive.google.com/uc?export=download&id=1CV1Im6v8xT-yUz-0fv5ZpXtT-ppj46Bh" target="_blank">55.<span style="white-space: pre;"> </span>Create an application to provide feedback using text and rating( do not use text box). [ Download Example ]</a><br />
<div>
<br /></div>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com3tag:blogger.com,1999:blog-5049897316123669366.post-44571710903558031522018-05-02T22:36:00.001-07:002020-01-12T20:52:46.648-08:00GTU 3640015 Android Programming sample Question Bank<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-bQGH5DA2tak/Xhv3NDrHGTI/AAAAAAAAA8M/pfFvdtjDx8cwmV_XHeAZ0mBm9TmcNZPuACEwYBhgL/s1600/gtu-mca-android-programing-bipin-rupadiya.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="768" data-original-width="1366" height="358" src="https://1.bp.blogspot.com/-bQGH5DA2tak/Xhv3NDrHGTI/AAAAAAAAA8M/pfFvdtjDx8cwmV_XHeAZ0mBm9TmcNZPuACEwYBhgL/s640/gtu-mca-android-programing-bipin-rupadiya.png" width="640" /></a></div>
<b><br /></b>
<b>GUJARAT TECHNOLOGICAL UNIVERSITY</b></div>
<div style="text-align: center;">
Master in Computer Application</div>
<div style="text-align: center;">
<b>Subject Name: Android Programming</b></div>
<div style="text-align: center;">
Subject Code: 3640015</div>
<div style="text-align: center;">
<b>Sample Question Bank</b> </div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<b>UNIT - 1</b></div>
<b>Chapter-1</b><br />
<br />
<ul style="text-align: left;">
<li>What is android?</li>
<li>Explain Android SDK feature</li>
<li>What is OHA? explain in detail</li>
<li>Explain Android software stack in detail.</li>
<li>Explain with diagram the Android platform architecture. </li>
<li>The Dalvik Virtual Machine</li>
<li>Explain hardware abstraction layer(HAL)<a name='more'></a></li>
</ul>
<br />
<b>Chapter-2</b><br />
<br />
<ul style="text-align: left;">
<li>List and describe in detail Android development tools (ADT)</li>
<li>Write steps to create AVD (Android Virtual Device)</li>
<li>Write steps to create Android Application</li>
<li>Explain Dalvik Debug Monitor Service (DDBMS)</li>
<li>Explain Android Debug Bridge (ADB)</li>
<li>Explain Hierarchy Viewer and Lint Tool</li>
<li>Explain Monkey and Monkey Runner android Tool</li>
</ul>
<br />
<b>Chapter-3</b><br />
<br />
<ul style="text-align: left;">
<li>What makes an Android Application?</li>
<li>Describe components of an Android application.</li>
<li>Android Manifest File and its common settings in detail</li>
<li>What are resources? Explain different types of resources in detail.</li>
<li>Explain the Android Application Lifecycle with Lifecycle Events?</li>
<li>Explain the lifecycle of Android Activity Lifecycle Events.</li>
</ul>
<br />
<br />
<div style="text-align: center;">
<b>UNIT - 2</b></div>
<b>Chapter-4</b><br />
<br />
<ul style="text-align: left;">
<li>Explain types of XML Layout to Create User Interfaces</li>
<li>What is Fragment? Explain Fragment lifecycle event</li>
<li>Explain Fragment Transactions in detail</li>
<li>Explain any Five ANDROID WIDGET</li>
<li>What is VIEW? Explain Creating and modifying Views?</li>
<li>What is Adapters? Explain types of Native Adapters with Example</li>
<li>Explain How to create custom Views</li>
</ul>
<br />
<br />
<b>Chapter-5</b><br />
<br />
<ul style="text-align: left;">
<li>Explain Types of intent with example</li>
<li>Explain Linkify</li>
<li>Explain Pending Intents in details.</li>
<li>Explain Broadcast Receivers in detail</li>
<li>What is Sticky Intents? Explain how to Broadcasting Sticky Intents</li>
<li>Explain Native Android Intent Actions</li>
<li>Explain Intent Filters to Service Implicit Intents</li>
<li>Explain how to listen Native Broadcast Intents</li>
<li>Explain Listening for Battery Changes</li>
<li>Explain Listening for Connectivity Changes</li>
</ul>
<br />
<b>Chapter-6</b><br />
<br />
<ul style="text-align: left;">
<li>Explain XML Parsing Using the XML Pull Parser</li>
<li>Explain Download Manager</li>
</ul>
<br />
<br />
<div style="text-align: center;">
<b>UNIT - 3</b></div>
<b>Chapter-7</b><br />
<br />
<ul style="text-align: left;">
<li>Explain persistence data storage techniques available in android</li>
<li>What is Shared Preferences? Explain how to read, write and Search in Shared Preferences</li>
<li>Explain Creating Private Application Files</li>
<li>Explain any Five file related function</li>
</ul>
<br />
<br />
<b>Chapter-8</b><br />
<br />
<ul style="text-align: left;">
<li>What is SQLite write a short note on it</li>
<li>What is Cursor? Explain methods of Cursor class</li>
<li>Explain SQLite Open Helper with example</li>
<li>Explain Opening and Creating Databases with the SQLite Open Helper</li>
<li>Explain Opening and Creating Databases without the SQLite Open Helper</li>
<li>Explain how to Query, insert, update and delete rows from Database?</li>
<li>What is Content Provider? Explain step to create Content Providers?</li>
<li>Explain How to Store Files in a Content Provider</li>
<li>What is Content Provider? Several native Content Providers?</li>
<li>Explain Media Store Content Provider using example</li>
<li>Explain Contacts Contract Content Provider using example</li>
<li>Explain How to Creating and Pick Contacts Using Intents?</li>
<li>Explain Calendar Content Provider using example</li>
<li>Explain Browser Content Provider using example</li>
<li>Explain CallLog Content Provider using example</li>
</ul>
<br />
<b>Chapter-9</b><br />
<br />
<ul style="text-align: left;">
<li>What is service? Explain Service Life Cycle.</li>
<li>Explain Type of Services</li>
<li>Explain Restart Behavior of Android Service</li>
<li>What is AsyncTask? Explain it in detail.</li>
<li>Explain Alarm Service of Android.</li>
<li>List and Explain Types of Alarm.</li>
</ul>
<br />
<br />
<div style="text-align: center;">
<b>UNIT - 4</b></div>
<b>Chapter-10</b><br />
<br />
<ul style="text-align: left;">
<li>What is ActionBar? Explain any five method of it?</li>
<li>Explain How to Disabling the Action Bar</li>
<li>Explain Types of Menu Available in Android</li>
<li>Explain Option Menu with Example</li>
<li>Explain Context Menu with Example</li>
<li>Explain Popup Menu with Example</li>
<li>Explain add() of Menu</li>
<li>Explain various Menu Item Options</li>
<li>Explain types of Dialog available in android</li>
<li>Explain Alert Dialog in detail</li>
<li>Explain how to view Activity as Dialog?</li>
<li>What is Toast? Explain How to customize it?</li>
</ul>
<br />
<b>Chapter-11</b><br />
<br />
<ul style="text-align: left;">
<li>Explain Drawable resource types in detail</li>
<li>Explain Shape Drawables in detail</li>
<li>Explain Gradient Drawables in detail</li>
<li>Explain Types of Animation available in Android</li>
<li>Explain Tweened Animations with Example</li>
<li>Explain Frame Animations with Example</li>
<li>Explain Interpolated Property Animations with Example</li>
</ul>
<br />
<b>Chapter-12</b><br />
<br />
<ul style="text-align: left;">
<li>List and Explain Supported Android Sensors</li>
<li>Explain how to Monitoring Sensors using SensorEventListener</li>
<li>Explain how to monitor a device's movement and orientation</li>
<li>What is Natural Orientation of a Device in android?</li>
</ul>
<br />
<b>Chapter-13</b><br />
<br />
<ul style="text-align: left;">
<li>Explain available location provider in detail?</li>
<li>Explain how to find location provider by specifying criteria?</li>
<li>Explain how to find the Last Known Location of device?</li>
</ul>
<br />
<br />
<div style="text-align: center;">
<b>UNIT - 5</b></div>
<b>Chapter-15</b><br />
<br />
<ul style="text-align: left;">
<li>What is Media Player in android? Explain transitions through the state machine.</li>
<li>Explain how to play audio using Media Player</li>
<li>Explain VideoView in detail</li>
<li>Explain Recording Sound with Audio Record</li>
<li>Explain Playing Sound with Audio Track</li>
<li>Explain how to take picture from Camera in android?</li>
<li>Explain how to record video using an Intent?</li>
<li>Explain how to record Video using Media Recorder?</li>
<li>Explain how to add media to MediaStore?</li>
</ul>
<b>Chapter-17</b><br />
<br />
<ul style="text-align: left;">
<li>What is TelephonyManager? explain its use in detail</li>
<li>Explain how to replace the Native Dialer</li>
<li>Explain how to Monitoring Changes in Phone State</li>
<li>Explain how to Monitoring Incoming Phone Calls</li>
<li>Explain how to Track Cell Location Changes</li>
<li>Explain how to Track Service Changes</li>
<li>Explain how to Send SMS</li>
<li>Explain how to Send MMS</li>
<li>Explain how to Send SMS Using the SMS Manager</li>
<li>Explain how to Track and Confirm SMS Message Delivery</li>
<li>Explain how to Send Data Messages</li>
<li>Explain how to Listen or read Incoming SMS Messages</li>
</ul>
<br />
<b>Chapter-19</b><br />
<br />
<ul style="text-align: left;">
<li>Write steps to Signing applications</li>
<li>Write steps to publishing applications</li>
<li>Discuss application marketing, promotion and distribution strategies</li>
<li>What is monetizing in android application?</li>
</ul>
<br />
<br />
<b>Text Book:</b><br />
<br />
<ul style="text-align: left;">
<li>Reto Meier Professional ANDROID 4 Application Development, WROX Latest Edition</li>
</ul>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br /></div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com2tag:blogger.com,1999:blog-5049897316123669366.post-3725070039345111922017-06-02T00:12:00.000-07:002020-01-12T20:53:13.667-08:00GTU Android Programming - 3640015 (New syllabus) <div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-bQGH5DA2tak/Xhv3NDrHGTI/AAAAAAAAA8Q/M0VLQYqoJ9MRQX1rwIUCYzsTIgvqxCKogCEwYBhgL/s1600/gtu-mca-android-programing-bipin-rupadiya.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="768" data-original-width="1366" height="358" src="https://1.bp.blogspot.com/-bQGH5DA2tak/Xhv3NDrHGTI/AAAAAAAAA8Q/M0VLQYqoJ9MRQX1rwIUCYzsTIgvqxCKogCEwYBhgL/s640/gtu-mca-android-programing-bipin-rupadiya.png" width="640" /></a></div>
<br /></div>
<h3 style="text-align: center;">
Lecture Notes of Android Programming</h3>
<div style="text-align: center;">
GUJARAT TECHNOLOGICAL UNIVERSITY</div>
<div style="text-align: center;">
Master in Computer Application</div>
<div style="text-align: center;">
Year II – (Semester-IV) (W.E.F. January 2017)</div>
<div style="text-align: center;">
<b>Subject Name: Android Programming</b></div>
<div style="text-align: center;">
<b>Subject Code: 3640015</b></div>
<div style="text-align: center;">
<b><br />
</b></div>
<br />
<a name='more'></a><br />
<br />
<b>UNIT: 1 [ <a href="http://drive.google.com/uc?export=download&id=0B_vJeoLuovmYRHpVZ3I2RzdCUzg">Download Lecture PPT</a> ]</b><br />
<br />
<ul style="text-align: left;">
<li><b>Introduction to ANDROID</b></li>
<ul>
<li>ANDROID SDK Features, </li>
<li>Introduction to Development Features</li>
</ul>
<li><b>Basics of ANDROID</b></li>
<ul>
<li>Developing for ANDROID, </li>
<li>developing for mobile and embedded devices, </li>
<li>ANDROID development tools</li>
</ul>
<li><b>Creating Applications using ANDROID</b></li>
<ul>
<li>Basics of an ANDROID application, introduction to manifest, </li>
<li>externalizing resources, </li>
<li>application lifecycle, </li>
<li>ANDROID activities</li>
</ul>
</ul>
<br />
<br />
<b>UNIT: 2</b><b> [ <a href="http://drive.google.com/uc?export=download&id=0B_vJeoLuovmYWEdXUEVoc0s2WDA">Download Lecture PPT</a> ]</b><br />
<br />
<ul style="text-align: left;">
<li><b>Building user interfaces</b></li>
<ul>
<li>Introduction to layouts, </li>
<li>introduction to fragments, </li>
<li>creating new views, </li>
<li>introduction to adapters</li>
</ul>
<li><b>Intents and broadcast receivers</b></li>
<ul>
<li>Introduction to intents, </li>
<li>creating intents and </li>
<li>broadcast receivers </li>
</ul>
<li><b>Using Internet resources</b></li>
<ul>
<li>Downloading and parsing internet resources, </li>
<li>using the download manager, </li>
<li>using internet services</li>
</ul>
</ul>
<br />
<br />
<b>UNIT: 3</b><b> [ <a href="http://drive.google.com/uc?export=download&id=0B_vJeoLuovmYZ0E3czNoRGktOFk">Download Lecture PPT</a> ]</b><br />
<br />
<ul style="text-align: left;">
<li><b>Files, saving state and preferences</b></li>
<ul>
<li>Creating, saving and retrieving shares preferences, </li>
<li>including static files as resources, </li>
<li>working with the file system</li>
</ul>
<li><b>Database and content providers</b></li>
<ul>
<li>Introducing ANDROID databases, </li>
<li>content values and cursors, </li>
<li>working with SQLite databases, </li>
<li>creating content providers, </li>
<li>using content providers, </li>
<li>native ANDROID content providers</li>
</ul>
<li><b>Working in background</b></li>
<ul>
<li>Introducing services, </li>
<li>using background threads, </li>
<li>using alarms</li>
</ul>
</ul>
<br />
<b>UNIT: 4</b><b> [ <a href="http://drive.google.com/uc?export=download&id=0B_vJeoLuovmYel81QXFCMjdJc00">Download Lecture PPT</a> ]</b><br />
<br />
<ul style="text-align: left;">
<li><b>Enhancing user experience</b></li>
<ul>
<li>Introduction and addition of action bar, </li>
<li>menus and dialogs, </li>
<li>drawables and gradients, </li>
<li>custom animations</li>
</ul>
<li><b>Hardware sensors</b></li>
<ul>
<li>Sensors and sensor manager, </li>
<li>monitoring devices’ movement and orientation</li>
</ul>
<li><b>Maps and location based services</b></li>
<ul>
<li>Using location based services, </li>
<li>selecting a location provider,</li>
<li>finding your current location, </li>
<li>creating map based activities</li>
</ul>
</ul>
<br />
<br />
<b>UNIT: 5</b><b> [ <a href="http://drive.google.com/uc?export=download&id=0B_vJeoLuovmYZlUyaWl0eXpFM3M">Download Lecture PPT</a> ]</b><br />
<br />
<ul style="text-align: left;">
<li><b>Audio, video and using the camera</b></li>
<ul>
<li>Playing audio and video, </li>
<li>manipulating raw audio, </li>
<li>using camera to take pictures, </li>
<li>recording video, </li>
<li>adding media to media store</li>
</ul>
<li><b>Telephony and SMS</b></li>
<ul>
<li>Hardware support for telephony API, </li>
<li>using telephony API, </li>
<li>introducing, how to send and receive SMS and MMS</li>
</ul>
<li><b>Monetizing, promoting and distributing the applications</b></li>
<ul>
<li>Signing and publishing applications, </li>
<li>distributing applications,</li>
<li>introduction to monetizing applications</li>
</ul>
</ul>
<div>
<h2 style="text-align: center;">
</h2>
<h2 style="text-align: center;">
</h2>
</div>
<ol style="text-align: left;">
</ol>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com13tag:blogger.com,1999:blog-5049897316123669366.post-82192391668999904642016-12-07T20:45:00.000-08:002020-01-12T21:04:02.057-08:00GTU LAMP Question Bank<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-Y6Kq31Mo1_E/Xhv5_GkFuSI/AAAAAAAAA8Y/K-_mp69036AG8qZTbUb7IrJDc4A1It0jwCEwYBhgL/s1600/gtu-mca-LAMPP-bipin-rupadiya.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="596" data-original-width="778" height="490" src="https://1.bp.blogspot.com/-Y6Kq31Mo1_E/Xhv5_GkFuSI/AAAAAAAAA8Y/K-_mp69036AG8qZTbUb7IrJDc4A1It0jwCEwYBhgL/s640/gtu-mca-LAMPP-bipin-rupadiya.png" width="640" /></a></div>
<h2>
<br /></h2>
<h2>
Programming with Linux, Apache, MySQL, and PHP (LAMP)</h2>
</div>
<h3 style="text-align: center;">
<b>UNIT-1 Setting up Apache Web Server, MySQL and PHP Basics Apache Installation and Configuration</b></h3>
<div style="text-align: center;">
<br /></div>
<b>Chapter -3 Installing and Configuring MySQL</b><br />
<br />
<ol style="text-align: left;">
<li>Explain how to install Apache on LINUX/ UNIX?</li>
<li>Explain apache configuration in detail.</li>
<li>Explain Pre-directory configuration in detail.</li>
</ol>
<br />
<br />
<a name='more'></a><br />
<br />
<b>Chapter -4 Installing and Configuring Apache</b><br />
<br />
<ol style="text-align: left;">
<li>Explain how to install PHP on LINUX/ UNIX?</li>
<li>Explain how to install MySQL on LINUX/ UNIX?</li>
</ol>
<br />
<h3 style="text-align: center;">
<br /><b>UNIT-2 Working with Forms</b></h3>
<br />
<b>Chapter -5 The Building Blocks of PHP</b><br />
<br />
<ol style="text-align: left;">
<li>Explain any five super global variable</li>
<li>Explain PHP standard data type in detail</li>
<li>Explain functions to Testing the Type of a Variable</li>
<li>How we can Chang or set data Type of any Variable in PHP</li>
<li>Explain operator in PHP</li>
<li>Explain constant and variable in PHP</li>
</ol>
<br />
<br />
<b>Chapter -6 Flow Control Functions in PHP</b><br />
<br />
<ol style="text-align: left;">
<li>Explain Switching Flow in detail </li>
<li>Explain looping structure / looping in detail</li>
<li>Explain how to create and call user define function in PHP</li>
<li>Explain variable scope in detail (local global and static)</li>
</ol>
<br />
<br />
<b>Chapter -7 Working with Functions</b><br />
<br />
<ol style="text-align: left;">
<li>Explain default or optional argument in User define function</li>
<li>Explain pass by value and pass by reference in UDF</li>
</ol>
<br />
<br />
<b>Chapter -8 Working with Arrays</b><br />
<br />
<ol style="text-align: left;">
<li>What is array? Explain type different array type and different ways to create array in PHP</li>
<li>Explain Array-Related Constructs and Functions with example.</li>
</ol>
<br />
<br />
<b>Chapter -9 Working with Objects</b><br />
<br />
<ol style="text-align: left;">
<li>Explain how following Object oriented concepts with example</li>
<ul>
<li>class, </li>
<li>object,</li>
<li>contractor,</li>
<li>properties,<span class="Apple-tab-span" style="white-space: pre;"> </span></li>
<li>method.</li>
</ul>
<li>Explain Inheritance with method Overriding in PHP with example.</li>
</ol>
<br />
<br />
<b>Chapter -10 Working with Strings, Dates and Time</b><br />
<br />
<ol style="text-align: left;">
<li>Explain five string related function in PHP with example.</li>
<li>Explain five date and time related function in PHP with example</li>
<li>Explain printf() function in detail</li>
</ol>
<br />
<br />
<br />
<b>HTML and JavaScript</b><br />
<br />
<ol style="text-align: left;">
<li>What is JavaScript? Explain different ways to add it on webpage.</li>
<li>How to validate HTML form using JavaScript?</li>
<li>Explain JavaScript KeyPress event with example.</li>
<li>Explain DOM in detail.</li>
<li>Explain HTML Form element in detail.</li>
<li>Explain an HTML Table with Example.</li>
<li>Difference between GET vs POST method</li>
<li>Explain various HTML List in detail.</li>
</ol>
<br />
<h3 style="text-align: center;">
<br /><b>UNIT-3 Interacting with MySQL</b></h3>
<br />
<b>Chapter -11 Working with Forms</b><br />
<br />
<ol style="text-align: left;">
<li>Explain accessing Form Input with User-Defined Arrays with an example</li>
<li>Explain various HTML form elements to take input from user</li>
<li>Explain Hidden Fields to save state with an example.</li>
<li>Explain how to redirect user in PHP</li>
<li>Explain how to send mail from PHP</li>
<li>Explain how to send mail using example.</li>
<li>Explain File Upload Global Variables in detail</li>
<li>Explain how to upload file using example.</li>
</ol>
<br />
<br />
<b>UNIT-4 Interacting with MySQL</b><br />
<br />
<ol style="text-align: left;">
<li>Chapter -16 Learning Basic SQL Commands</li>
<li>Explain MySQL Data Types in detail</li>
<li>Explain MySQL String functions in detail</li>
<li>Explain MySQL Date and Time functions in detail</li>
</ol>
<br />
<br />
<b>Chapter -17 Using Transactions and Stored Procedures in MySQL</b><br />
<br />
<ol style="text-align: left;">
<li>Explain Transactions in detail</li>
<li>Explain Stored Procedures in MySQL and PHP</li>
</ol>
<br />
<br />
<b>Chapter -18 Interacting with MySQL Using PHP</b><br />
<br />
<ol style="text-align: left;">
<li>Explain how to create connection with MySQL using mysqli function</li>
<li>Explain following function</li>
<ul>
<li> mysqli_connect_errno()</li>
<li> mysqli_connect_error()</li>
<li> mysqli_get_host_info()</li>
</ul>
<li>How to execute SQL query (mysqli_query()) in PHP with example</li>
<li>How to do insert, update delete in MySQL table using mysqli_query() explain with example</li>
<li>Write a PHP Script to Retrieve Data and Display Results from MySQL</li>
<li>What is SQL injection? Explain mysqli_real_escape_string() to prevent it with example </li>
</ol>
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<h3 style="text-align: center;">
<b>UNIT-5 Working with Cookies, User Sessions, Files, Directories and Images</b></h3>
<b><br /></b>
<b>Chapter -12 Working with Cookies and User Sessions</b><br />
<br />
<ol style="text-align: left;">
<li>What is Cookie? Explain its all attributes.</li>
<li>Explain setcookie() with all its argument in detail</li>
<li>What is Cookie? Explain how to read and write cookies with example.</li>
<li>Explain how to create persistent cookie with example.</li>
<li>Explain difference between Cookies vs. Session</li>
<li>Explain how to setting, unsetting and destroying session variable with example.</li>
<li>Explain session related function with example </li>
</ol>
<br />
<br />
<b>Chapter -13 Working with Files and Directories</b><br />
<br />
<ol style="text-align: left;">
<li>Explain file including function available in PHP</li>
<li>Explain any five file related function available in PHP.</li>
<li>Explain various file reading function with example</li>
<li>Explain various file writing function with example</li>
<li>Explain how to create, read, write and delete file with example.</li>
<li>Explain file_get_contents(), file_put_contents() in detail.</li>
<li>Explain any five directory related function available in PHP.</li>
<li>How to execute UNIX / LINUX command using PHP exec(),system() and passthru()</li>
</ol>
<br />
<br />
<b>Chapter -14 Working with Images</b><br />
<br />
<ol style="text-align: left;">
<li>Explain Several PHP functions Drawing Shapes and Line</li>
<li>Explain how to create, store and destroy image in PHP</li>
<li>Write a code to create image that write GTU inside the circle.</li>
</ol>
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<h3 style="text-align: center;">
<b>UNIT-6 JSON</b></h3>
<br />
<ol style="text-align: left;">
<li>What is JSON explain it with an example.</li>
<li>Explain Data Type available in JSON.</li>
<li>Explain JSON schema keyword in detail.</li>
<li>How to create and parse JSON using JavaScript?</li>
<li>How to create and parse JSON using PHP?</li>
</ol>
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<div>
<br /></div>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com3tag:blogger.com,1999:blog-5049897316123669366.post-36325986514478861692016-12-07T20:11:00.001-08:002020-01-12T21:03:06.519-08:00GTU LAMP 3630010 Programming with Linux Apache MySQL and PHP<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-Y6Kq31Mo1_E/Xhv5_GkFuSI/AAAAAAAAA8Y/VwNpRD4bSa8TMvXXzRdHgAJF8Q2MxzT6ACLcBGAsYHQ/s1600/gtu-mca-LAMPP-bipin-rupadiya.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="596" data-original-width="778" height="490" src="https://1.bp.blogspot.com/-Y6Kq31Mo1_E/Xhv5_GkFuSI/AAAAAAAAA8Y/VwNpRD4bSa8TMvXXzRdHgAJF8Q2MxzT6ACLcBGAsYHQ/s640/gtu-mca-LAMPP-bipin-rupadiya.png" width="640" /></a></div>
<br />
<br /></div>
<b>Subject Name: Programming with Linux, Apache, MySQL, and PHP (LAMP)</b><br />
<b>Subject Code: 3630010</b><br />
<br />
<br />
<b>UNIT-1 Setting up Apache Web Server, MySQL and PHP Basics Apache Installation and Configuration [<a href="http://drive.google.com/uc?export=download&id=0B_vJeoLuovmYRE1xZzN2LUdickU">DOWNLOAD PPT</a>]</b><br />
<a name='more'></a><br />
<br />
<ul style="text-align: left;">
<li>Current and future versions of Apache, </li>
<li>Choosing the Appropriate installation method, </li>
<li>Installing apache on Linux platforms, </li>
<li>Apache configuration file structure, </li>
<li>Apache log files, </li>
<li>Apache-related commands, </li>
<li>Starting apache for the first time</li>
</ul>
<br />
<br />
<b> PHP Installation and Configuration</b><br />
<br />
<ul style="text-align: left;">
<li>Current and Future version of PHP/MySQL, </li>
<li>Installing / Building PHP/MySQL on different platforms with apache,</li>
<li>Php.ini Basics, </li>
<li>The basics of PHP scripts</li>
</ul>
<br />
<br />
<b>UNIT-2 PHP Overview Flow control and building blocks </b><b> [<a href="http://drive.google.com/uc?export=download&id=0B_vJeoLuovmYajlFTWVwcnNNcEU">DOWNLOAD PPT</a>]</b><br />
<br />
<ul style="text-align: left;">
<li>Variables, </li>
<li>Data types, </li>
<li>Operators and expressions, </li>
<li>Constants,</li>
<li>Switching flow, </li>
<li>Loops, </li>
<li>Code blocks and browser Output.</li>
<li>Working with Functions, Arrays and Objects</li>
<li>What is a function, </li>
<li>Calling function, </li>
<li>Defining a function,</li>
<li>Returning values from User-defined functions, </li>
<li>Variable scope,</li>
<li>Saving state between function calls with the static Statement,</li>
<li>More about arguments, </li>
<li>Testing for the existence of a function,</li>
<li>What are Arrays, </li>
<li>Creating arrays, </li>
<li>Some array related</li>
<li>functions,</li>
<li>Creating an Object, </li>
<li>Object inheritance </li>
<li>Formatting Strings with PHP, </li>
<li>Investigating Strings in PHP,</li>
<li>Manipulating Strings with PHP, </li>
<li>Using Date and Time functions in PHP, </li>
<li>Other String, </li>
<li>Date and Time Functions</li>
</ul>
<br />
<br />
<b>UNIT-3 Working with Forms </b><b> [<a href="http://drive.google.com/uc?export=download&id=0B_vJeoLuovmYUDVlNmRsXzh6X0U">DOWNLOAD PPT</a>]</b><br />
<br />
<ul style="text-align: left;">
<li>Creating a Simple Input Form, </li>
<li>Accessing Form Input with User-Defined Arrays, </li>
<li>Combining HTML and PHP Code on a Single Page, </li>
<li>Using Hidden Fields to Save State, </li>
<li>Redirecting the User, </li>
<li>Sending Mail on form Submission, </li>
<li>Working with File Uploads</li>
</ul>
<br />
<b> JavaScript</b><br />
<br />
<ul style="text-align: left;">
<li>Understanding JavaScript, </li>
<li>uses of JavaScript, </li>
<li>attaching external JavaScript, </li>
<li>validating form fields using JavaScript,</li>
<li>extending functionalities of form fields using JavaScript</li>
</ul>
<br />
<br />
<b>UNIT-4 Interacting with MySQL </b><b> [<a href="http://drive.google.com/uc?export=download&id=0B_vJeoLuovmYNVprby00cVI0STQ">DOWNLOAD PPT</a>]</b><br />
<br />
<ul style="text-align: left;">
<li>Learning the MySQL Data Types, </li>
<li>Frequently used String functions in MySQL, </li>
<li>Using Date and Time functions in MySQL, </li>
<li>Using Transactions and Stored Procedures in MySQL. </li>
<li>Interacting with MySQL using PHP, </li>
<li>MySQL Versus MySQLi Functions, </li>
<li>Connecting to MySQL with PHP, </li>
<li>Working with MySQL Data</li>
</ul>
<br />
<br />
<b>UNIT-5 Working with Cookies, User Sessions, Files, Directories and Images </b><b> [<a href="http://drive.google.com/uc?export=download&id=0B_vJeoLuovmYcmVlbHhoMW16NU0">DOWNLOAD PPT</a>]</b><br />
<br />
<ul style="text-align: left;">
<li>Introducing Cookies, Setting a Cookie with PHP, </li>
<li>Deleting a Cookie with PHP Session Function(s) Overview, </li>
<li>Starting a Session, </li>
<li>Working with Session Variables, </li>
<li>Passing Session IDs in the Query String,</li>
<li>Destroying Sessions and Un-setting Variables, </li>
<li>Using Sessions in an Environment with Registered Users Including Files with include(), </li>
<li>Validating Files, </li>
<li>Creating and Deleting Files,</li>
<li>Opening a File for Writing, </li>
<li>Reading or Appending, </li>
<li>Reading from files, </li>
<li>Writing or Appending to a file,</li>
<li>Working with Directories Opening Pipes to and from Processes Using popen(), </li>
<li>Executing System Commands Understanding the Image Creation Process, </li>
<li>Necessary Modifications to PHP, </li>
<li>Drawing a New Image, </li>
<li>Getting fancy with Pie Charts, </li>
<li>Modifying Existing Images, </li>
<li>Image Creation from User Input, </li>
<li>Using Images Created by Scripts</li>
</ul>
<br />
<br />
<b>UNIT-6 JSON </b><b> [<a href="http://drive.google.com/uc?export=download&id=0B_vJeoLuovmYd2FZLVB5NXlpeUE">DOWNLOAD PPT</a>]</b><br />
<br />
<ul style="text-align: left;">
<li>Overview, </li>
<li>Syntax, </li>
<li>Data Types, </li>
<li>Objects, </li>
<li>Schema, </li>
<li>Serializing into JSON, </li>
<li>Parsing JSON</li>
</ul>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com18tag:blogger.com,1999:blog-5049897316123669366.post-26289373449807634922015-09-16T00:04:00.002-07:002020-01-12T21:04:44.133-08:00GTU Mobile Computing Important Questions<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="text-align: left;">
</h3>
<div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-bQGH5DA2tak/Xhv3NDrHGTI/AAAAAAAAA8Q/M0VLQYqoJ9MRQX1rwIUCYzsTIgvqxCKogCEwYBhgL/s1600/gtu-mca-android-programing-bipin-rupadiya.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="768" data-original-width="1366" height="358" src="https://1.bp.blogspot.com/-bQGH5DA2tak/Xhv3NDrHGTI/AAAAAAAAA8Q/M0VLQYqoJ9MRQX1rwIUCYzsTIgvqxCKogCEwYBhgL/s640/gtu-mca-android-programing-bipin-rupadiya.png" width="640" /></a></div>
<div style="text-align: center;">
<br /></div>
</div>
<div style="text-align: justify;">
As per the request of all my students community, I have tried my best to arrange all the important GTU Question Papers's questions of Mobile Computing or Android subject of MCA (Master of Computer Application ) Semester 5, Gujarat Technological University. I have arrange all these question Unit wise as well as the GTU Academic Year wise in which those were asked in GTU examination.</div>
<h3 style="text-align: center;">
GTU Mobile Computing Question Bank</h3>
</div>
<div>
<br />
<a name='more'></a><br /></div>
<h3 style="text-align: left;">
Unit-1 Introduction to Android</h3>
<br />
<br />
<br />
<b>Dec.-2011</b><br />
<ol style="text-align: left;">
<li>Explain Android platform architecture. 07</li>
</ol>
<b>JUNE -2012</b><br />
<ol style="text-align: left;">
<li>Comment “Android is hailed as the first complete, open, and free mobile platform”: 2</li>
<li>What is AVD? 02</li>
<li>Explain Android platform architecture with diagram. 07</li>
</ol>
<b>WINTER 2012</b><br />
<ol style="text-align: left;">
<li>Explain Android software stack in detail. 7</li>
<li>List and describe in detail Android development tools.07</li>
</ol>
<br />
<br />
<b>SUMMER 2013</b><br />
<ul style="text-align: left;">
<li>None</li>
</ul>
<br />
<b>WINTER 2013</b><br />
<ol style="text-align: left;">
<li>Explain Android software stack in detail. 07</li>
<li>List and describe in detail Android development tools. 07</li>
</ol>
<br />
<b>SUMMER 2014</b><br />
<ul style="text-align: left;">
<li>None</li>
</ul>
<b>WINTER 2014</b><br />
<ol style="text-align: left;">
<li>Why there are less chances of device corruption with Android Applications? 2</li>
<li>What is the role of hardware abstraction layer(HAL)? 2</li>
<li>Explain with diagram the Android platform architecture. 3</li>
</ol>
<br />
<br />
<h3 style="text-align: left;">
Unit-2 Android Application Design Essentials</h3>
<b><br />
</b> <b>Dec.-2011</b><br />
<div style="text-align: left;">
</div>
<ol style="text-align: left;">
<li>What is the use of <activity> tag and <intent-filter> tag. 07</li>
<li>Explain the lifecycle of Android Activity. 07</li>
<li>Explain the use of following helpful methods of android.util.Log class 7</li>
<ul>
<li>Log.e() </li>
<li>Log.w() </li>
<li>Log.i() </li>
<li>Log.d() </li>
<li>Log.v()</li>
</ul>
<li>Explain the following color formats. 4</li>
<ol>
<li>#RGB</li>
<li>#ARGB</li>
<li>#RRGGBB</li>
<li>#AARRGGBB</li>
</ol>
</ol>
<br />
<br />
<b>JUNE -2012</b><br />
<br />
<ol style="text-align: left;">
<li>List image formats supported in Android 02</li>
<li>What is the use of the strings.xml file? 02</li>
<li>Define: Context, Activity 02</li>
<li>Explain life cycle of android activity with suitable diagram 07</li>
<li>What is AndroidManifest.xml file? What kind of information is stored in it? Explain structure of it. 7</li>
<li>What are resources? List different types of resources with required directory filename and xml tag. 7</li>
</ol>
<br />
<br />
<b>WINTER 2012</b><br />
<br />
<ol style="text-align: left;">
<li>Draw and explain Activity Life cycle of an Android application. 7</li>
<li>Describe six components of an Android application. 7</li>
<li>What is Intent? How are they used to Broadcast and Receive Events? 7</li>
</ol>
<br />
<b>SUMMER 2013</b><br />
<br />
<br />
<ol style="text-align: left;">
<li>The resources are stored in which directory? Which resource types are supported by Android SDK? 7</li>
<li>Explain the lifecycle of the Android activity. 07</li>
<li>Which methods of the android.util.Log class can be used to add logging support to Android application? 7</li>
</ol>
<br />
<b>WINTER 2013</b><br />
<br />
<ol style="text-align: left;">
<li>Draw and explain Activity Life cycle of an Android application. 07</li>
<li>Describe six components of an Android application. 07</li>
<li>Describe different types of Drawable resources with example. 07</li>
<li>What is Intent? How are they used to Broadcast and Receive Events? 07</li>
</ol>
<br />
<b>SUMMER 2014</b><br />
<br />
<ol style="text-align: left;">
<li>What is Intent? How can Intent include two extra piece of information – a string value and a Boolean value? 04</li>
<li>Where and which tag is used by developers to specify which versions of Android platform an application supports? Explain the three attributes associated with that tag. 3</li>
<li>Explain the use of following Android Tools. 4</li>
<ul>
<li>Dalvik Debug Monitor Server</li>
<li>Android Debug Bridge</li>
</ul>
<li>What will the following lines do and also explain the parameters passed. 3</li>
<ul>
<li>Log.i(DEBUG_TAG,”MyfirstAndroidApp is running”);</li>
<li>Log.e(DEBUG_TAG,”application failed”,e)</li>
</ul>
<li>How a primary entry point activity can be designated for an Android application? 4</li>
<li>What are default resources and what are alternative resources? Explain the Android mechanism for loading the appropriate resources at run time? How color resource, dimension resource, drawable resource can be added and retrieved? What data structure will be used for defining three types of flavors – vanilla, chocolate, strawberry? 7</li>
</ol>
<br />
<b>WINTER 2014</b><br />
<br />
<ol style="text-align: left;">
<li>How can an Android application use the String, Boolean and Integer resources programmatically? Show the use of method only. 3</li>
<li>Explain the important callbacks of the Activity class in Android Application. 07</li>
<li>How can an application start activity with startActivity() method with an explicit intent? Explain with line of code. 2</li>
<li>Explain the line of code that create an intent Filter and register it within Android Manifest file? 2</li>
<li>How an additional data can be included in Intent? 3</li>
<li>Explain the important Android Project Files and Directories. 07</li>
<li>What is the use of Run Configurations and Debug configurations? 2</li>
<li>What lines should be written in Android application to force a new unhandled error? 2</li>
<li>Which methods are available to add logging support to Android Application? 3</li>
</ol>
<br />
<br />
<h3 style="text-align: left;">
Unit-3 Android User Interface Design Essentials</h3>
<b>Dec.-2011</b><br />
<br />
<ol style="text-align: left;">
<li>For what purpose Chronometer is used? Explain the Chronometer object’s format attribute and explain the different methods associated with Chronometer. 07</li>
<li>Explain the Different tweening Transformation. 07</li>
<li>How can you Data-Binding to the Gallery Control? 07</li>
<li>Which method and attribute is used to set image of ImageView? 3</li>
<li>Write a code to create animation given as below: 7</li>
<ul>
<li>Duration for animation is 5000.</li>
<li>Take one rectangle (set it in to ImageView as src)</li>
<li>Now translate it in X direction with rotation.</li>
<li>Up to half time, shrink the rectangle than grow it for remaining time.</li>
<li>During this whole animation, set its transparency 4 times. (Means make the rectangle 2 times light and 2 times dark)</li>
</ul>
<li>What is menu? Which two types of menu available in Android? 04</li>
<li>Explain different types of Dialogs. 07</li>
<li>List the data driven containers. For what purpose ListView control is used? Which is the base class and list the methods available 7</li>
</ol>
<br />
<br />
<b>JUNE -2012</b><br />
<br />
<ol style="text-align: left;">
<li>What is notification? How it is differ from Toast? 02</li>
<li>Define: Style, theme 02</li>
<li>Explain animation supported by Android taking suitable example 07 </li>
<li>Differentiate: 7</li>
<ul>
<li>Context Menu and Option Menu</li>
<li>List and Spinner</li>
<li>ViewFlipper and ViewSwitcher</li>
</ul>
<li>Write detailed note on different types of layouts 07</li>
<li>Explain with code snippet Gallery view? How it is differ from Image View? 07</li>
<li>What is uses of following widgets and list its important properties and event 7</li>
<ul>
<li>Progressbar</li>
<li>SeekBar</li>
<li>RatingBar</li>
<li>VideoView</li>
<li>Chronometer</li>
<li>ImageView</li>
<li>ToggleButton</li>
</ul>
</ol>
<br />
<br />
<b>WINTER 2012</b><br />
<br />
<ol style="text-align: left;">
<li>Explain context menu with example. 07</li>
<li>Describe different types of Drawable resources with example. 07</li>
<li>Explain different types of Animation in Android. 07</li>
<li>Explain how to apply Style and Theme to User Interface. 07</li>
<li>Give an example to show use of Progress Bar. 07</li>
<li>Give an example to show Alert Dialog. 07</li>
</ol>
<br />
<br />
<b>SUMMER 2013</b><br />
<br />
<ol style="text-align: left;">
<li>How many permissions Android application has by default? What should be added, where, to gain access to the built in camera? 4</li>
<li>What special permission is needed to access the private user information provided by the Contacts content provider? Also write the code to start reading contact data from Contacts application.3</li>
<li>What is the difference between AutoCompleteTextView and MultiAutoCompleteTextView? Show how to provide an AutoCompleteTextView for the user that can help them type some of the basic colors from an array in the code. Also show the layout resource definition for this AutoCompleteTextView control. 7</li>
<li>Explain the setFilters() method that can be used with EditText control.4</li>
<li>How indicator progress status can be set programmatically? 3</li>
<li>Which methods can be used with Chronometer object? 4</li>
<li>Explain onCreateContextMenu() and registerForContextMenu() methods. 3</li>
<li>Explain the key methods that Activity must use to manage a Dialog. 07</li>
<li>Explain TableLayout and TableRow view attributes. 7</li>
<li>Write an outline code to show frame by frame animation. Load 2 Bitmap resources and create AnimationDrawable. What is the purpose of setOneShot() method. 7</li>
<li>Explain the four different tweening transformations. 7</li>
</ol>
<br />
<b>WINTER 2013</b><br />
<br />
<ol style="text-align: left;">
<li>Explain context menu with example. 07</li>
<li>Explain different types of Animation in Android. 07</li>
<li>Explain how to apply Style and Theme to User Interface. 07</li>
<li>Give an example to show use of Rating Bar. 07</li>
<li>Give an example to show DatePicker Dialog. 07</li>
</ol>
<br />
<br />
<b>SUMMER 2014</b><br />
<br />
<ol style="text-align: left;">
<li>Which layout is called to be horizontally oriented LinearLayout? Explain the following view attributes and also mention this attribute is applied to whom? a.) android:collapseColumns b.) android:layout_span 4</li>
<li>What lines should be written to programmatically create green rectangle?03</li>
<li>Write a code snippet that clears entire RadioGroup so that none of the RadioButton objects are selected. 3</li>
<li>Explain the two clock controls available to display the current time. 4</li>
<li>What attribute of the SeekBar should be defined in XML layout resource definition so that the user can drag the thumb to any value between 0 and 250? Which method should be used to show what exact value has been selected by the user? 3</li>
<li>Explain with code snippet creation of the options menu and how to handle the event when a menu option item is selected? 7</li>
<li>Explain the key methods that an Activity must use to manage a Dialog. Write the steps involved in adding the dialog to an activity. 7</li>
<li>Explain with code snippet creation of context menu for Chronometer control and how to handle the ContextMenu clicks? 7</li>
<li>Which methods should be used to load 2 Bitmap resources and to start animation in case of Frame-by-Frame Animation? Which method should be used to loop continuously for animation? 7</li>
<li>Write XML resource file excerpts for following. 7</li>
<ul>
<li>Transparency change animation taking 10 seconds to fade in fully transparent to fully opaque.</li>
<li>Scaling animation, taking 5 seconds to double an object’s size, pivoting from the center of the object.</li>
<li>Translate animation, taking 5 seconds to move an object up by 100 on the y axis and object should not jump back to its starting position when the animation finishes.</li>
</ul>
<li>For what purpose animation interpolator is used? How it can be specified programmatically? 3</li>
<li>What is the use of Adapter object in Android sdk. Explain ArrayAdapter in detail.</li>
</ol>
<br />
<b>WINTER 2014</b><br />
<br />
<ol style="text-align: left;">
<li>Write the code example of an AutoCompleteTextView that can help user to type month names from an array. 4</li>
<li>Write the XML file excerpts for the following. 7</li>
<ul>
<li>Translate animation, taking 7 seconds to move an object up by 100 on y axis.</li>
<li>Transparency change animation, taking 7 seconds to fade from fully transparent to fully opaque.</li>
<li>Rotation animation, taking 7 seconds to make one full clockwise rotation, pivoting from the center of the object.</li>
</ul>
<li>Explain with example how permission can be granted for shared resources or privileged access? 4</li>
<li>What is the use of <permission> tag? Where permission can be enforced? 3</li>
<li>Which types of progress bar does Android SDK provide? 2</li>
<li>How to set the indicator progress status programmatically? 2</li>
<li>What line of code need to be written to place indeterminate progress indicator on activity screen? 3</li>
<li>Write a code example that creates context menu for the Chronometer control. Also explain how to handle the ContextMenu clicks in the Activity. 7</li>
<li>For what purpose FrameLayout view is designed? Explain the important FrameLayout View attributes. 7</li>
<li>What is the purpose of Canvas and Paint object? Which methods should be used to set paint color to red, paint style to STROKE? Also write the code example to draw circle with linear gradient. 7</li>
<li>Explain the steps involved in frame by frame animation. 07</li>
</ol>
<br />
<br />
<h3 style="text-align: left;">
Unit-4 Using Common Android APIs</h3>
<b>Dec.-2011</b><br />
<br />
<ol style="text-align: left;">
<li>Explain the use of ContentValues to insert the record and Which four arguments are taken by update()? 03</li>
<li>Explain the use of WebView control to load content from a specific website. 3</li>
<li>Explain the following methods. 04</li>
<ul>
<li>PhoneNumberUtils.formatNumber()</li>
<li>SmsManager.getDefault()</li>
</ul>
<li>What do you mean by Androides Android’s Content Providers? List Out the Useful Built-In Content Providers and explain any two of them. 7</li>
</ol>
<br />
<br />
<b>JUNE -2012</b><br />
<br />
<ol style="text-align: left;">
<li>What is shared preferences? Explain methods for create, search, read, add, update and delete shared preference? 07</li>
<li>What is SQLite Databse? Explain methods for creating, updating, and deleting and querying database records 07</li>
<li>List permission required for following task 7</li>
<ul>
<li>Send SMS</li>
<li>To access phone state Information</li>
<li>Add contact details</li>
<li>Write file to SD Card</li>
<li>To access online URL</li>
<li>To dial number</li>
<li>Read contacts</li>
</ul>
<li>What is content provider? List useful built-in content providers with its purpose and explain any one of them in details 07</li>
<li>What is WebView? How can we load content into WebView? How can we handle WebView events? 7</li>
<li>Write code snippet for following 7</li>
<ul>
<li>Sending an SMS</li>
<li>Dial a number</li>
</ul>
</ol>
<br />
<br />
<b>WINTER 2012</b><br />
<br />
<ol style="text-align: left;">
<li>Explain Media Store Content Provider with example. 07</li>
<li>Describe Telephony API of Android and the classes used for the same? 07</li>
<li>What are Content providers? How do you create your own content provider in Android? 7</li>
<li>How is Handler class used for Background thread processing? 7</li>
<li>Describe the process of Creating, Saving and then Retrieving Shared Preferences. 7</li>
<li>Describe Web-API of Android and classes used for the same. 7</li>
</ol>
<br />
<b>SUMMER 2013</b><br />
<br />
<ol style="text-align: left;">
<li>How ContentValues object can be used to insert firstname and lastname in authors table? 4</li>
<li>What is needed by the application to send an SMS? 3</li>
<li>Explain with example how SQLiteQueryBuilder can be used to build and execute INNER JOIN between two tables? 7</li>
<li>Write line of code that must be inserted in Activity to read a fixed amount of text from a file on a web server. 7</li>
<li>Explain with example how SQL UNION query can be executed with rawQuery() method? 7</li>
</ol>
<br />
<br />
<b>WINTER 2013</b><br />
<br />
<ol style="text-align: left;">
<li>Explain Media Store Content Provider with example. 07</li>
<li>Describe the process of Creating, Saving and then Retrieving User Shared Preferences. 7</li>
<li>Describe Web-API of Android and classes used for the same. 07</li>
<li>What are Content providers? How do you create your own content provider in Android? 7</li>
<li>How is Handler class used for Background thread processing? 07</li>
<li>Describe SMS API of Android and the classes used for the same? 07</li>
<li>Explain how to use WebView control to load content from a specific website? What should be written to render raw HTML to webview control? 7</li>
</ol>
<br />
<br />
<b>SUMMER 2014</b><br />
<br />
<ol style="text-align: left;">
<li>Explain insert(),update() and delete() methods of SQLiteDatabase class. 07</li>
<li>How content can be loaded into WebView control in the following 3 cases 7</li>
<ul>
<li>To load content from a specific web site.</li>
<li>To load an HTML file</li>
<li>To render raw HTML.</li>
</ul>
<li>What permission is needed and how to specify that for the following? 4</li>
<ul>
<li>To access the private user information provided by the Contacts content provider.</li>
<li>For networking to work in any Android application.</li>
</ul>
<li>Explain the block of code that show how to query for the call state and all possible values. 3</li>
<li>Which methods of ConnectivityManager class should be used to determine if cellular and WiFi network is available and connected? 4</li>
</ol>
<br />
<b>WINTER 2014</b><br />
<br />
<ol style="text-align: left;">
<li>Explain how SQLite database can be created in Android application using the Application Context. 4</li>
<li>How ContentValues object can be used to insert new data to table? 3</li>
<li>Write a code example that reads some data from a website if web address of that data is provided. 4</li>
<li>Which are the built in useful content providers in Android? 3</li>
<li>How to retrieve the state of the phone and which permission is needed to access basic phone state information? 3</li>
<li>How content can be loaded into a WebView control? Include loading of content from a specific website or render raw HTML. 7</li>
</ol>
<br />
<br />
<br />
<h3 style="text-align: left;">
Unit-5 Deploying Android Application to the World</h3>
<b>Dec.-2011</b><br />
<br />
<ol style="text-align: left;">
<li>Which steps are required for publishing an Android application? 7</li>
</ol>
<br />
<br />
<b>JUNE -2012</b><br />
<br />
<ul style="text-align: left;">
<li>None</li>
</ul>
<br />
<br />
<b>WINTER 2012</b><br />
<br />
<ul style="text-align: left;">
<li>None</li>
</ul>
<br />
<br />
<b>SUMMER 2013</b><br />
<br />
<ol style="text-align: left;">
<li>What steps are required for publishing an application? 4</li>
<li>Which fields need to be entered in the form while uploading the application package? 3</li>
</ol>
<br />
<br />
<b>WINTER 2013</b><br />
<br />
<ul style="text-align: left;">
<li>None</li>
</ul>
<br />
<b>SUMMER 2014</b><br />
<br />
<ol style="text-align: left;">
<li>Which steps are required for publishing an application and guaranteed successful deployment? 7</li>
</ol>
<br />
<b>WINTER 2014</b><br />
<br />
<ol style="text-align: left;">
<li>Which steps are required for a developer to prepare an Android application for publication and distribution? 4</li>
</ol>
<br />
<br /></div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com6tag:blogger.com,1999:blog-5049897316123669366.post-43751629758429182142015-08-23T22:54:00.004-07:002015-08-23T22:56:35.482-07:00Android Character Picker Dialog Example<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<h3 style="text-align: center;">
An Example of Character Picker Dialog in Android.</h3>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-Y66rxEZTHWE/VdqxdSDpB5I/AAAAAAAAAzA/K28AZkWJw60/s1600/charachterpickerdemo-bipin-rupadiya.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://1.bp.blogspot.com/-Y66rxEZTHWE/VdqxdSDpB5I/AAAAAAAAAzA/K28AZkWJw60/s320/charachterpickerdemo-bipin-rupadiya.PNG" width="200" /></a></div>
<br />
<a name='more'></a><br />
<br />
<h3 style="text-align: center;">
<span style="color: red;">File Name : </span><span style="text-align: left;"><span style="color: red;">MainActivity.java</span></span></h3>
<br />
<div class="codeview">
package com.bipinrupadiya.charachterpickerdemo;<br />
<br />
import android.app.Activity;<br />
import android.os.Bundle;<br />
import android.text.method.CharacterPickerDialog;<br />
import android.view.View;<br />
import android.widget.AdapterView;<br />
import android.widget.Button;<br />
import android.widget.EditText;<br />
import android.widget.Toast;<br />
<br />
public class MainActivity extends Activity {<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>private CharacterPickerDialog CPD = null;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>String chrOptions = "0123456789";<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>@Override<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>public void onCreate(Bundle savedInstanceState) {<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>super.onCreate(savedInstanceState);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>setContentView(R.layout.activity_main);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>final EditText t = (EditText) findViewById(R.id.editText1);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Button button = (Button) this.findViewById(R.id.button1);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>button.setOnClickListener(new View.OnClickListener() {<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>@Override<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>public void onClick(View v) {<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>CPD.setTitle("Select Charecter");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>CPD.show();<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>});<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>CPD = new CharacterPickerDialog(this, new View(this), null, chrOptions,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>true) {<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>public void onClick(View v) {<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>String c = "";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>c = ((Button) v).getText().toString();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Toast.makeText(getApplicationContext(), "" + c,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Toast.LENGTH_SHORT).show();<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>t.setText(t.getText().toString() + c);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>dismiss();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>};<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
}</div>
<br />
<h3 style="text-align: center;">
<span style="color: red;">File Name : </span><span style="text-align: left;"><span style="color: red;">activity_main.xml</span></span></h3>
<br />
<div class="codeview">
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"<br />
xmlns:tools="http://schemas.android.com/tools"<br />
android:layout_width="match_parent"<br />
android:layout_height="match_parent"<br />
tools:context=".MainActivity" ><br />
<br />
<Button<br />
android:id="@+id/button1"<br />
android:layout_width="wrap_content"<br />
android:layout_height="wrap_content"<br />
android:layout_alignParentTop="true"<br />
android:layout_centerHorizontal="true"<br />
android:layout_marginTop="142dp"<br />
android:text="Button" /><br />
<br />
<EditText<br />
android:id="@+id/editText1"<br />
android:layout_width="wrap_content"<br />
android:layout_height="wrap_content"<br />
android:layout_alignParentLeft="true"<br />
android:layout_alignParentRight="true"<br />
android:layout_alignParentTop="true"<br />
android:layout_marginTop="55dp"<br />
android:ems="10" ><br />
<br />
<requestFocus /><br />
</EditText><br />
<br />
</RelativeLayout></div>
<br />
<br />
<br />
<br /></div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com2tag:blogger.com,1999:blog-5049897316123669366.post-65756101535161133612015-07-29T23:05:00.001-07:002016-05-29T21:39:34.066-07:00PHP-Delete Record using prepared statement in PDO<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: left;">
</h2>
<h2 style="text-align: center;">
Part-7: Delete Record using prepared statement in PDO.</h2>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-DHqWhsl8vZg/Vbr2HMqC3TI/AAAAAAAAAyI/727GEtMX_BQ/s1600/insert%2Bupdate%2Bdelete%2Busing%2BPHP%2Band%2BPDO.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="199" src="https://3.bp.blogspot.com/-DHqWhsl8vZg/Vbr2HMqC3TI/AAAAAAAAAyI/727GEtMX_BQ/s320/insert%2Bupdate%2Bdelete%2Busing%2BPHP%2Band%2BPDO.png" width="320" /></a></div>
<br />
<br />
In the last and part number seven, explain how to delete record using prepared statement. To keep delete operation simple I have not added any prompting for the confirmation of record deletion from user side. This can be done by little bit <b>JavaScript</b> coding.<br />
<br />
To delete a record first we have to select that which record we want to delete from <b>MySQL</b> table. Like our previous update operation we again utilize the result of search or display operation where a like delete is there to do the delete operation. When user click on that delete link the id of record is pass as a <b>GET</b> request to <b>delete.php</b> file where the actual delete statement execute of database and delete operation performed using prepared statement.<br />
<br />
<a name='more'></a><br />
<br />
<h3 style="text-align: left;">
delete.php</h3>
<br />
<?php<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>require("conn.php");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>try<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt = $conn->prepare("delete from tbl where id=?");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$a=$stmt->execute(array($_GET["id"]));<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>if($a==true)<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<br> Record deleted" ;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>else<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<br> Problem in deleted" ;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>catch(PDOException $e)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Error: " . $e->getMessage();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn = null;<br />
?><br />
<br />
<h3 style="text-align: left;">
This example is divided in multiple part.</h3>
<br />
<a href="http://www.bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-1.html" rel="nofollow" target="_blank">Part-1: Configure and Setup the MySQL database connection using PDO.</a><br />
<a href="http://www.bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-2.html" rel="nofollow" target="_blank">Part-2: Create a MySQL Database and a table using PDO.</a><br />
<a href="http://www.bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-3.html" rel="nofollow" target="_blank">Part-3: Insert record using prepared statement in PDO.</a><br />
<a href="http://www.bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-4.html" rel="nofollow" target="_blank">Part-4: Display Records using prepared statement.</a><br />
<a href="http://www.bipinrupadiya.blogspot.in/2015/07/php-search-records-using-ajax-and-pdo-part-5.html" rel="nofollow" target="_blank">Part-5: Search records using AJAX and PDO in PHP.</a><br />
<a href="http://www.bipinrupadiya.blogspot.in/2015/07/php-update-record-using-prepared-part-6.html" rel="nofollow" target="_blank">Part-6: Update Record using prepared statement in PDO.</a><br />
<a href="http://www.bipinrupadiya.blogspot.in/2015/07/php-delete-record-using-prepared-part-7.html" rel="nofollow" target="_blank">Part-7: Delete Record using prepared statement in PDO.</a><br />
<br />
<br />
<div>
<br /></div>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com3tag:blogger.com,1999:blog-5049897316123669366.post-37585540868066071702015-07-29T22:55:00.002-07:002016-05-29T21:40:42.894-07:00PHP - Update Record using prepared statement in PDO<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: center;">
</h2>
<h2 style="text-align: center;">
Part-6: Update Record using prepared statement in PDO</h2>
<div style="text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-SmK2w--HZhg/Vbr-UPkJo4I/AAAAAAAAAyo/z_Df96nn7sk/s1600/insert%2Bupdate%2Bdelete%2Busing%2BPHP%2Band%2BPDO-5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="188" src="https://4.bp.blogspot.com/-SmK2w--HZhg/Vbr-UPkJo4I/AAAAAAAAAyo/z_Df96nn7sk/s320/insert%2Bupdate%2Bdelete%2Busing%2BPHP%2Band%2BPDO-5.png" width="320" /></a></div>
<br />
I part six, we do the update operation. To do the update we need to select a record which user want to update. From search or display operation that we discuss in previous part user click on edit link and select record for edit. When user select or click on edit link it will pass the id field in GET request to our edit.php file. With the help of record id we retrieve the entire record from table and fill it in to a HTML form where user can do the update operation. After updating information in HTML form user submit the update value by Update button. It pass all the information to our update.php file where the actual update SQL query execute on MySQL table and update the record using prepared statement of PDO. </div>
<div>
<a name='more'></a><br /></div>
<h3 style="text-align: left;">
edit.php</h3>
<div>
<br /></div>
<div>
<div>
<!DOCTYPE html></div>
<div>
<html></div>
<div>
<body></div>
<div>
<form method="GET" action="update.php"></div>
<div>
<?php</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>require "conn.php";</div>
<div>
<br /></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>try </div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>{</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$id=$_GET["id"];</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt = $conn->prepare("SELECT id, name, email, phone FROM tbl where id=?"); </div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->execute(array($id));</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span># setting the fetch mode</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span> </div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<table border='0' align='center' cellpadding='5px' cellspacing='2px'>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>while($row = $stmt->fetch()) </div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>{</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<tr>";<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$val=$row['id'];</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<input type='hidden' name='txtId' required value=$val>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</tr>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<tr>";<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$val=$row['name'];</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Name : <input type='text' name='txtName' required value=$val>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</tr>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<tr>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$val=$row['email'];</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Email :<input type='email' name='txtEmail' required value=$val>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</tr>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<tr>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$val=$row['phone'];</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Phone :<input type='number' name='txtPhone' required value=$val>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</tr>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<tr>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<input type='submit' value='Update'>&nbsp;<input type='reset' value='Clear'><span class="Apple-tab-span" style="white-space: pre;"> </span>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</tr>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</table>";</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>catch(PDOException $e) </div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>{</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Error: " . $e->getMessage();</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn = null;</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</table>";</div>
<div>
?></div>
<div>
<br /></div>
<div>
</form></div>
<div>
</body></div>
<div>
</html></div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<h3 style="text-align: left;">
update.php</h3>
<div>
<br /></div>
<div>
<div>
<?php</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>require("conn.php");</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>try </div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt = $conn->prepare("update tbl SET name=?, email=?, phone=? where id=?");</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$a=$stmt->execute(</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>array($_GET["txtName"],</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$_GET["txtEmail"],</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$_GET["txtPhone"],<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$_GET["txtId"]));</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>if($a==true)<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>{</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<br> Record update" ;</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>else</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>{</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<br> Problem in update" ;</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>catch(PDOException $e)</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>{</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Error: " . $e->getMessage();</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn = null;</div>
<div>
?></div>
</div>
<div>
<br /></div>
<div>
<h3 style="text-align: left;">
This example is divided in multiple part.</h3>
<br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-1.html" rel="" target="_blank">Part-1: Configure and Setup the MySQL database connection using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-2.html" rel="" target="_blank">Part-2: Create a MySQL Database and a table using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-3.html" rel="" target="_blank">Part-3: Insert record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-4.html" rel="" target="_blank">Part-4: Display Records using prepared statement.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-search-records-using-ajax-and-pdo-part-5.html" rel="" target="_blank">Part-5: Search records using AJAX and PDO in PHP.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-update-record-using-prepared-part-6.html" rel="" target="_blank">Part-6: Update Record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-delete-record-using-prepared-part-7.html" rel="" target="_blank">Part-7: Delete Record using prepared statement in PDO.</a></div>
<div>
<br /></div>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com1tag:blogger.com,1999:blog-5049897316123669366.post-9522358284888877972015-07-29T22:17:00.003-07:002016-05-29T21:41:18.801-07:00PHP - Search records using AJAX and PDO<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<h2 style="text-align: center;">
Part-5: Search records using AJAX and PDO in PHP</h2>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-SmK2w--HZhg/Vbr-UPkJo4I/AAAAAAAAAyk/U1BURgFl0SE/s1600/insert%2Bupdate%2Bdelete%2Busing%2BPHP%2Band%2BPDO-5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="188" src="https://3.bp.blogspot.com/-SmK2w--HZhg/Vbr-UPkJo4I/AAAAAAAAAyk/U1BURgFl0SE/s320/insert%2Bupdate%2Bdelete%2Busing%2BPHP%2Band%2BPDO-5.png" width="320" /></a></div>
<br />
In part five, we do the search operation on our <b>MySQL</b> table. We use prepared statement to execute our query using<b> PHP-PDO</b> object. In <b>SQL</b> query we use like operator so it match record like the input we get from <b>search.html</b> file. To do the search object we use the <b>AJAX</b> technology to pass the request to <b>search.php</b> file. The file <b>search.php</b> is exactly similar to <b>display.php</b> file, just a where condition is added to do the search operation. If we do the smart work then one file <b>display.php</b> or <b>search.php</b> is enough to do both operation just an if condition is required that check the request parameter whether search criteria is provided or not? To keep it simple I have use to separate file that would be helpful to beginners.<br />
<br />
<a name='more'></a><br />
<br />
In search operation we use two file<br />
<br />
<ol style="text-align: left;">
<li>search.html and </li>
<li>search.php</li>
</ol>
<br />
for search.html, I am writing two code. One that does not use AJAX to make the simple search and Second then utilize the power of AJAX in search operation.<br />
<br />
<br />
<h3 style="text-align: left;">
1. search.html </h3>
<!DOCTYPE html><br />
<html><br />
<body><br />
<form method="GET" action="search.php"><br />
Name :<input type="text" name="txtName" required><br/><br />
<input type="submit" value="Search"><br />
<input type="reset" value="Clear"><br/><br />
</form><br />
</body><br />
</html><br />
<br />
<br />
<h3 style="text-align: left;">
2. search-ajax.html</h3>
<html><br />
<head><br />
<script><br />
function doSearch(str)<br />
{ <br />
if (str.length == 0)<br />
{ <br />
document.getElementById("txtSearchResult").innerHTML = ""; <br />
return; <br />
}<br />
else<br />
{ <br />
var xmlhttp = new XMLHttpRequest(); <br />
xmlhttp.onreadystatechange = function()<br />
{<br />
if (xmlhttp.readyState == 4 && xmlhttp.status == 200)<br />
{ <br />
document.getElementById("txtSearchResult").innerHTML = xmlhttp.responseText; } <br />
} <br />
xmlhttp.open("GET", "search.php?txtName=" + str, true); <br />
xmlhttp.send(); <br />
}<br />
}<br />
</script><br />
</head><br />
<body><br />
<center><br />
<form> <br />
Search Name: <input type="text" onkeyup="doSearch(this.value)"> <br />
</form><br />
<p><br />
<span id="txtSearchResult"></span><br />
</p><br />
</center><br />
</body><br />
</html><br />
<br />
<br />
<h3 style="text-align: left;">
3. search.php</h3>
<?php<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>require "conn.php";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>try<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$name="%".$_GET["txtName"]."%";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt = $conn->prepare("SELECT id, name, email, phone FROM tbl where name LIKE ?");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->execute(array($name));<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$result = $stmt->fetchAll();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>if( ! $result)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>print('No Records Found');<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>else<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>/*<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$cc=$stmt->columnCount(); // count total number of columns<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$rc=$stmt->rowCount(); // count total number of rows<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "row count = $rc";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Column count = $cc";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>*/<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<table border='1' align='center' cellpadding='5px' cellspacing='2px'>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>//while($row = $stmt->fetch())<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<tr><th>Name</th><th>Email</th><th>Phone</th><th colspan='2'></th></tr>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>foreach($result as $row)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<tr>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo $row['name'];<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo $row['email'];<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo $row['phone'];<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$search_str=$row['id'];<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<a href='edit.php?id=$search_str'>Edit</a>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$search_str=$row['id'];<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<a href='delete.php?id=$search_str'>Delete</a>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</tr>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</table>";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>catch(PDOException $e)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Error: " . $e->getMessage();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn = null;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</table>";<br />
?><br />
<div>
<br /></div>
<div>
<br />
<h3 style="text-align: left;">
This example is divided in multiple part.</h3>
<br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-1.html" rel="" target="_blank">Part-1: Configure and Setup the MySQL database connection using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-2.html" rel="" target="_blank">Part-2: Create a MySQL Database and a table using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-3.html" rel="" target="_blank">Part-3: Insert record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-4.html" rel="" target="_blank">Part-4: Display Records using prepared statement.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-search-records-using-ajax-and-pdo-part-5.html" rel="" target="_blank">Part-5: Search records using AJAX and PDO in PHP.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-update-record-using-prepared-part-6.html" rel="" target="_blank">Part-6: Update Record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-delete-record-using-prepared-part-7.html" rel="" target="_blank">Part-7: Delete Record using prepared statement in PDO.</a></div>
<div>
<br /></div>
<div>
<br /></div>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com5tag:blogger.com,1999:blog-5049897316123669366.post-50233890194963743912015-07-29T21:37:00.000-07:002016-05-29T21:48:49.688-07:00Part-4: Display Records using prepared statement<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<h2 style="text-align: center;">
Part-4: Display Records using prepared statement.</h2>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-DHqWhsl8vZg/Vbr2HMqC3TI/AAAAAAAAAyM/A5xcKRrrWZA/s1600/insert%2Bupdate%2Bdelete%2Busing%2BPHP%2Band%2BPDO.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="199" src="https://4.bp.blogspot.com/-DHqWhsl8vZg/Vbr2HMqC3TI/AAAAAAAAAyM/A5xcKRrrWZA/s320/insert%2Bupdate%2Bdelete%2Busing%2BPHP%2Band%2BPDO.png" width="320" /></a></div>
<br />
<div style="text-align: justify;">
In part four, we concentrate on fetching record from database using prepared statement. We use select <b>SQL</b> statement to retrieve all record from table. After executing our query using <b>PDO</b> object we check whether it return the rows or not. If it does not return records then “No record found.” Message will be shown otherwise record will be display in <b>HTML</b> table. Last two column have link for Edit and Update record. When user click on it, it pass id to edit or delete page using default <b>GET</b> method. </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br />
<a name='more'></a><br /></div>
<h3 style="text-align: justify;">
display.php</h3>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<?php</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>require "conn.php";</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>try </div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>{</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt = $conn->prepare("SELECT id, name, email, phone FROM tbl"); </div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->execute();</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span># setting the fetch mode<span class="Apple-tab-span" style="white-space: pre;"> </span> </div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>$result = $stmt->fetchAll();</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>if( ! $result)</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>{</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>print('No Records Found');</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>} </div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>else</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<table border='1' align='center' cellpadding='5px' cellspacing='2px'>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>//while($row = $stmt->fetch()) </div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<tr><th>ID</th><th>Name</th><th>Email</th><th>Phone</th><th colspan='2'></th></tr>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>foreach($result as $row)</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>{</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<tr>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo $row['id'];</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo $row['name'];</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo $row['email'];</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo $row['phone'];</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>$search_str=$row['id'];</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<a href='edit.php?id=$search_str'>Edit</a>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<td>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>$search_str=$row['id'];</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<a href='delete.php?id=$search_str'>Delete</a>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</td>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</tr>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</table>";</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>catch(PDOException $e) </div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>{</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Error: " . $e->getMessage();</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>}</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn = null;</div>
<div style="text-align: justify;">
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "</table>";</div>
<div style="text-align: justify;">
?></div>
<div style="text-align: justify;">
<br />
<br />
<br />
<h3 style="text-align: left;">
This example is divided in multiple part.</h3>
<br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-1.html" rel="" target="_blank">Part-1: Configure and Setup the MySQL database connection using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-2.html" rel="" target="_blank">Part-2: Create a MySQL Database and a table using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-3.html" rel="" target="_blank">Part-3: Insert record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-4.html" rel="" target="_blank">Part-4: Display Records using prepared statement.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-search-records-using-ajax-and-pdo-part-5.html" rel="" target="_blank">Part-5: Search records using AJAX and PDO in PHP.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-update-record-using-prepared-part-6.html" rel="" target="_blank">Part-6: Update Record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-delete-record-using-prepared-part-7.html" rel="" target="_blank">Part-7: Delete Record using prepared statement in PDO.</a><br />
<br />
<br /></div>
<br />
<div style="text-align: justify;">
<br /></div>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com1tag:blogger.com,1999:blog-5049897316123669366.post-78440659729536727792015-07-24T00:36:00.001-07:002016-05-29T21:49:31.681-07:00PHP insert update, delete using PDO part-3<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<h2 style="text-align: center;">
Part-3: Insert record using prepared statement in PDO.</h2>
<br />
<div style="text-align: justify;">
In part three, I am creating two file one is the HTML file (insert.html) to define form to get the information and second one (insert.php) is the code behind file to retrieve the values from HTML and insert those values in database using prepared statement with the help of PDO.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-NPSPGndH0bo/Vbr9a7owHMI/AAAAAAAAAyY/cjQixWMiRsQ/s1600/insert%2Bupdate%2Bdelete%2Busing%2BPHP%2Band%2BPDO1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="309" src="https://2.bp.blogspot.com/-NPSPGndH0bo/Vbr9a7owHMI/AAAAAAAAAyY/cjQixWMiRsQ/s320/insert%2Bupdate%2Bdelete%2Busing%2BPHP%2Band%2BPDO1.png" width="320" /></a></div>
<a name='more'></a><br />
<h3 style="text-align: left;">
insert.html</h3>
<br />
<!DOCTYPE html><br />
<html><br />
<body><br />
<form method="GET" action="insert.php"><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Name :<input type="text" name="txtName" required><br/><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Email :<input type="email" name="txtEmail" required><br/><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Phone :<input type="number" name="txtPhone" required><br/><span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><input type="submit" value="Insert"><input type="reset" value="Clear"><br/><br />
</form><br />
</body><br />
</html><br />
<br />
<br />
<br />
<br />
<h3 style="text-align: left;">
insert.php</h3>
<br />
<?php<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>require("conn.php");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>try<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$tbl="tbl";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$name = $_GET["txtName"];<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$email = $_GET["txtEmail"];<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$phone = $_GET["txtPhone"];<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>/*<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>// prepare sql and bind parameters<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt = $conn->prepare("INSERT INTO $tbl (name, email, phone)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>VALUES (:name, :email, :phone, :message)");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->bindParam(':name', $name);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->bindParam(':email', $email);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->bindParam(':phone', $phone);<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->execute();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>*/<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt = $conn->prepare("INSERT INTO $tbl (name, email, phone) VALUES (?, ?, ?)");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->execute(array($name,$email,$phone));<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$last_id = $conn->lastInsertId();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<br> Record [ $last_id ] inserted" ;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>catch(PDOException $e)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Error: " . $e->getMessage();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn = null;<br />
?><br />
<br />
<br />
<br />
<h3 style="text-align: left;">
This example is divided in multiple part.</h3>
<br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-1.html" rel="" target="_blank">Part-1: Configure and Setup the MySQL database connection using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-2.html" rel="" target="_blank">Part-2: Create a MySQL Database and a table using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-3.html" rel="" target="_blank">Part-3: Insert record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-4.html" rel="" target="_blank">Part-4: Display Records using prepared statement.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-search-records-using-ajax-and-pdo-part-5.html" rel="" target="_blank">Part-5: Search records using AJAX and PDO in PHP.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-update-record-using-prepared-part-6.html" rel="" target="_blank">Part-6: Update Record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-delete-record-using-prepared-part-7.html" rel="" target="_blank">Part-7: Delete Record using prepared statement in PDO.</a><br />
<br />
<br />
<br /></div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com1tag:blogger.com,1999:blog-5049897316123669366.post-22634808882153945302015-07-24T00:14:00.001-07:002016-05-29T21:51:38.243-07:00PHP insert update, delete using PDO part-2<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<h2 style="text-align: center;">
Part-2: Create a MySQL Database and a table using PDO.</h2>
<br />
<h3 style="text-align: left;">
In part two, I am going to create a setupdb.php file where I do following task.</h3>
1.<span class="Apple-tab-span" style="white-space: pre;"> </span>Database connection in PHP and MySQL using PDO,<br />
2.<span class="Apple-tab-span" style="white-space: pre;"> </span>Create database in MySQL which name we define in config.php<br />
3.<span class="Apple-tab-span" style="white-space: pre;"> </span>Create table in MySQL using PDO<br />
4.<span class="Apple-tab-span" style="white-space: pre;"> </span>Insert sample records using prepared statements.<br />
<br />
<a name='more'></a><br />
<br />
Setupdb.php file will be really helpful to create sample database to test our web application. It is also useful to those who does not have enough working knowledge to deal with database management .<br />
<br />
<h3 style="text-align: left;">
setupdb.php</h3>
<br />
<?php<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>require("config.php");<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>try<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn = new PDO("mysql:host=localhost", username, password);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn->query("CREATE DATABASE IF NOT EXISTS ".mydb);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn->query("use ".mydb);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Database [ ".mydb." ] Successfully Connected"; <span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$tbl="tbl";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>// sql to create table<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$sql = "CREATE TABLE IF NOT EXISTS $tbl (<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>name VARCHAR(30) NOT NULL,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>email VARCHAR(50) NOT NULL,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>phone VARCHAR(30),<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>)";<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>// use exec() because no results are returned<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn->exec($sql);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<br>Table [ $tbl ] created successfully";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>// prepare sql and bind parameters<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt = $conn->prepare("INSERT INTO $tbl (name, email, phone, message)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>VALUES (:name, :email, :phone, :message)");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->bindParam(':name', $name);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->bindParam(':email', $email);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->bindParam(':phone', $phone);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>// insert a row<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$name = "bipin";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$email = "bipin@gmail.com";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$phone = "+919999999999";<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->execute();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$last_id = $conn->lastInsertId();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<br> Record [ $last_id ] created successfully" ;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>// insert a row<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$name = "hitesh";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$email = "hitesh@gmail.com";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$phone = "+919999999999";<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->execute();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$last_id = $conn->lastInsertId();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<br> Record [ $last_id ] created successfully" ;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>// insert a row<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$name = "jignesh";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$email = "jignesh@gmail.com";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$phone = "+919999999999";<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$stmt->execute();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$last_id = $conn->lastInsertId();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "<br> Record [ $last_id ] created successfully" ;<br />
}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>catch(PDOException $e)<br />
{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Connection failed: " . $e->getMessage();<br />
}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn = null;<br />
?><br />
<br />
<br />
<h3 style="text-align: left;">
This example is divided in multiple part.</h3>
<br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-1.html" rel="" target="_blank">Part-1: Configure and Setup the MySQL database connection using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-2.html" rel="" target="_blank">Part-2: Create a MySQL Database and a table using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-3.html" rel="" target="_blank">Part-3: Insert record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-4.html" rel="" target="_blank">Part-4: Display Records using prepared statement.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-search-records-using-ajax-and-pdo-part-5.html" rel="" target="_blank">Part-5: Search records using AJAX and PDO in PHP.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-update-record-using-prepared-part-6.html" rel="" target="_blank">Part-6: Update Record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-delete-record-using-prepared-part-7.html" rel="" target="_blank">Part-7: Delete Record using prepared statement in PDO.</a><br />
<br />
<br />
<div>
<br /></div>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.comtag:blogger.com,1999:blog-5049897316123669366.post-68799417825724166582015-07-23T23:59:00.000-07:002016-05-29T21:53:18.638-07:00PHP insert update, delete using PDO part-1<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: center;">
</h2>
<h2 style="text-align: center;">
Part-1: Configure and Setup the MySQL database connection using PDO.</h2>
In this example, I am going to create separate files for each database operations which require to do database connection. In part one, I define few constant that is going to use throw-out the application in config.php and conn.php where I define the $conn connection object.<br />
<br />
<h3 style="text-align: left;">
config.php</h3>
<br />
<?php<br />
define("servername","localhost");<br />
define("username","root");<br />
define("password","admin");<br />
define("mydb","bsrdb");<br />
?><br />
<br />
<a name='more'></a><br />
<br />
1.<span class="Apple-tab-span" style="white-space: pre;"> </span>servername = Domain name<br />
2.<span class="Apple-tab-span" style="white-space: pre;"> </span>username = Database User Name<br />
3.<span class="Apple-tab-span" style="white-space: pre;"> </span>password = Database Password<br />
4.<span class="Apple-tab-span" style="white-space: pre;"> </span>mydb = Database Name<br />
<br />
These constants are use in our connection file that is conn.php<br />
<br />
<h3 style="text-align: left;">
conn.php</h3>
<?php<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>require("config.php");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>try<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn = new PDO("mysql:host=".servername.";dbname=".mydb, username, password);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);<br />
}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>catch(PDOException $e)<br />
{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Connection failed: " . $e->getMessage();<br />
}<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
?><br />
<br />
Here in connection file I create the $conn connection object using PDO. In second step we set the error mode on PDO for debugging environment.<br />
<br />
<br />
<h3 style="text-align: left;">
This example is divided in multiple part.</h3>
<br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-1.html" rel="" target="_blank">Part-1: Configure and Setup the MySQL database connection using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-2.html" rel="" target="_blank">Part-2: Create a MySQL Database and a table using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-3.html" rel="" target="_blank">Part-3: Insert record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-4.html" rel="" target="_blank">Part-4: Display Records using prepared statement.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-search-records-using-ajax-and-pdo-part-5.html" rel="" target="_blank">Part-5: Search records using AJAX and PDO in PHP.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-update-record-using-prepared-part-6.html" rel="" target="_blank">Part-6: Update Record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-delete-record-using-prepared-part-7.html" rel="" target="_blank">Part-7: Delete Record using prepared statement in PDO.</a><br />
<br />
<div>
<br /></div>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com0tag:blogger.com,1999:blog-5049897316123669366.post-15414508502940084392015-07-23T22:40:00.000-07:002016-05-29T21:54:58.900-07:00PHP PDO : insert, update delete example for beginners<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
<br />
<br />
<br />
Creating a web application using <b>PHP (Hyper Text Preprocessor)</b> and <b>PDO (PHP Data Object)</b>. Here in this article I am exploring the latest feature of PHP to do better deal with databases. Yes, it’s PDO. After the many feature of MySQL function are improved or depreciated the <b>MySQLi (MySQL improved)</b> introduce. Still MySQLi is doing well but problem is you can connect to only one database using it that is MySQL. To improvise the better database connectivity option for most popular web server side scripting language PHP. PHP introduce PHP data object (PDO). So, Question is -, </div>
<br />
<h3 style="text-align: left;">
What is this PDO?</h3>
<blockquote class="tr_bq">
PDO is PHP data object which provide the data access layer. PDO have uniform and most powerful API methods to access multiple web databases using PHP.</blockquote>
<br />
<a name='more'></a><br />
<br />
<h3 style="text-align: left;">
PDO have many benefit as compare to MySQL and MySQLi. </h3>
<br />
<ol style="text-align: left;">
<li>PDO can connect 12+ popular database product.</li>
<li>It have all the feature of MySQL functions.</li>
<li>It is free from SQL injection.</li>
<li>It is safe and robust.</li>
<li>It is fast in execution.</li>
<li>It is portable. No need to rewrite code on database product change</li>
<li>It provide extreme use of Object Oriented Programming (OOP).</li>
<li>It support database transections in PHP.</li>
</ol>
<br />
<h4 style="text-align: left;">
Let’s Experience the power and beauty of PDO using a simple example.</h4>
<div style="text-align: justify;">
I have targeted this example to PHP and PDO beginners. In this example I am going to explore a web application which do insert, update, delete, search and display operations using PDO in PHP on MySQL database. Here I have used the prepared statement to do insert, update, delete, search and display records in MySQL database. </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
I have try to keep my code as simple as possible so even beginners can also understand the example. I have organized PHP code in such a way that can be the stat up of any new simple PHP project. I have try to keep separate HTML and PHP portion as much possible. </div>
<br />
<h3 style="text-align: left;">
This example is divided in multiple part.</h3>
<br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-1.html" rel="" target="_blank">Part-1: Configure and Setup the MySQL database connection using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-2.html" rel="" target="_blank">Part-2: Create a MySQL Database and a table using PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-3.html" rel="" target="_blank">Part-3: Insert record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-insert-update-delete-using-pdo-part-4.html" rel="" target="_blank">Part-4: Display Records using prepared statement.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-search-records-using-ajax-and-pdo-part-5.html" rel="" target="_blank">Part-5: Search records using AJAX and PDO in PHP.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-update-record-using-prepared-part-6.html" rel="" target="_blank">Part-6: Update Record using prepared statement in PDO.</a><br />
<a href="http://bipinrupadiya.blogspot.in/2015/07/php-delete-record-using-prepared-part-7.html" rel="" target="_blank">Part-7: Delete Record using prepared statement in PDO.</a><br />
<br />
<br />
<br />
<br />
<br /></div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com1tag:blogger.com,1999:blog-5049897316123669366.post-86381428479382759302015-03-15T21:21:00.001-07:002015-08-16T21:02:54.620-07:00Android Phone Call Example<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<h3>
Definition: Create an application to call specific entered number by user in the EditText</h3>
<br />
<h3 style="text-align: center;">
<span style="color: red;">Ex14.java</span></h3>
<br />
<div class="codeview">
package bsr.exa;<br />
<br />
import android.app.Activity;<br />
import android.content.Intent;<br />
import android.net.Uri;<br />
import android.os.Bundle;<br />
import android.view.View;<br />
import android.view.View.OnClickListener;<br />
import android.widget.Button;<br />
import android.widget.EditText;<br />
import android.widget.Toast;<br />
<br />
<a name='more'></a><br />
<br />
public class E14 extends Activity {<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>/** @author Bipin S Rupadiya , www.BipinRupadiya.com<br />
*<br />
* 14) Create an application to call specific entered number by user in the EditText<br />
*<br />
* */<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Button btnCall;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> EditText txtNo;<br />
// @Override<br />
public void onCreate(Bundle savedInstanceState)<br />
{<br />
super.onCreate(savedInstanceState);<br />
setContentView(R.layout.main);<br />
<br />
<br />
btnCall=(Button)findViewById(R.id.btnCall);<br />
txtNo=(EditText)findViewById(R.id.txtNumber);<br />
btnCall.setOnClickListener(new OnClickListener() {<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>public void onClick(View arg0)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>if(txtNo.getText().toString().equals(""))<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Toast.makeText(E14.this, "Enter Number", Toast.LENGTH_LONG).show();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>txtNo.requestFocus();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>else<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> <span class="Apple-tab-span" style="white-space: pre;"> </span>try<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Intent callIntent = new Intent(Intent.ACTION_CALL);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> callIntent.setData(Uri.parse("tel:"+txtNo.getText().toString()));<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> startActivity(callIntent);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> }<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>catch (Exception e)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> {<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Toast.makeText(E14.this, " "+e.toString(), Toast.LENGTH_LONG).show();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> }<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>});<br />
<br />
}<br />
//@Override<br />
public void onDestroy()<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>super.onDestroy();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
}<br />
<div>
</div>
<div>
<br /></div>
</div>
<h3 style="text-align: center;">
<span style="color: red;">AndroidManifest.xml </span></h3>
<br />
<div class="codeview">
<?xml version="1.0" encoding="utf-8"?><br />
<manifest xmlns:android="http://schemas.android.com/apk/res/android"<br />
package="bsr.exa"<br />
android:versionCode="1"<br />
android:versionName="1.0"><br />
<uses-sdk android:minSdkVersion="8" /><br />
<uses-permission android:name="android.permission.CALL_PHONE"></uses-permission><br />
<br />
<application android:icon="@drawable/icon" android:label="@string/app_name"><br />
<activity android:name=".E14"<br />
android:label="@string/app_name"><br />
<intent-filter><br />
<action android:name="android.intent.action.MAIN" /><br />
<category android:name="android.intent.category.LAUNCHER" /><br />
</intent-filter><br />
</activity><br />
<br />
</application><br />
</manifest></div>
<br />
<br />
<br />
<br /></div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com0tag:blogger.com,1999:blog-5049897316123669366.post-53761658469848888112015-03-15T21:16:00.004-07:002015-08-16T21:03:44.196-07:00Read SMS in Android<div dir="ltr" style="text-align: left;" trbidi="on">
<h3>
Definition: Read messages from the mobile and display it on the screen</h3>
<br />
<h3 style="text-align: center;">
<span style="text-align: left;"><span style="color: red;">E13Activity.java</span></span></h3>
<br />
<div class="codeview">
package bsr.exa;<br />
<br />
import android.app.Activity;<br />
import android.database.Cursor;<br />
import android.net.Uri;<br />
import android.os.Bundle;<br />
import android.widget.TextView;<br />
<br />
<a name='more'></a><br />
<br />
public class E13Activity extends Activity<br />
{<br />
/** @author Bipin S Rupadiya , www.bipinrupadiya.com<br />
*<br />
* 13) Read messages from the mobile and display it on the screen<br />
* <br />
* */<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>@Override<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>public void onCreate(Bundle savedInstanceState)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> super.onCreate(savedInstanceState);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> TextView view = new TextView(this);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Uri uriSMS = Uri.parse("content://sms/inbox");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> Cursor c = getContentResolver().query(uriSMS, null, null, null,null);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> String sms = "";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> while (c.moveToNext()) {<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> sms += "From :" + c.getString(2) + " : " + c.getString(11)+"\n"; <br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> }<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> view.setText(sms);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> setContentView(view);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
}</div>
<br />
<h3 style="text-align: center;">
</h3>
<h3 style="text-align: center;">
<span style="color: red;">AndroidManifest.xml </span></h3>
<br />
<div class="codeview">
<?xml version="1.0" encoding="utf-8"?><br />
<manifest xmlns:android="http://schemas.android.com/apk/res/android"<br />
package="bsr.exa"<br />
android:versionCode="1"<br />
android:versionName="1.0"><br />
<uses-sdk android:minSdkVersion="8" /><br />
<uses-permission android:name="android.permission.READ_SMS"></uses-permission><br />
<uses-permission android:name="android.permission.SEND_SMS"></uses-permission><br />
<br />
<application android:icon="@drawable/icon" android:label="@string/app_name"><br />
<activity android:name=".E13Activity"<br />
android:label="@string/app_name"><br />
<intent-filter><br />
<action android:name="android.intent.action.MAIN" /><br />
<category android:name="android.intent.category.LAUNCHER" /><br />
</intent-filter><br />
</activity><br />
<br />
</application><br />
</manifest></div>
<div class="codeview">
<div style="text-align: center;">
<br />
<br />
<br /></div>
</div>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com0tag:blogger.com,1999:blog-5049897316123669366.post-9457675699769073372015-01-02T21:10:00.002-08:002015-08-16T21:05:06.579-07:00GTU WTAD Old Question Paper<div dir="ltr" style="text-align: left;" trbidi="on">
<div>
<div>
<br /></div>
</div>
<div>
<ul style="text-align: left;">
<li><b style="text-align: -webkit-center;">Winter - 2014</b></li>
<ul>
<li><b style="text-align: -webkit-center;"><a href="http://gtu.ac.in/GTU_Papers/MCA/Winter_Exam_2014/640002.zip" rel="nofollow" style="font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif; font-size: 12px; font-weight: normal; text-align: left;" target="_blank">640002</a></b></li>
<li><a href="http://gtu.ac.in/GTU_Papers/MCA/Winter_Exam_2014/2640002.zip" rel="nofollow" style="font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif; font-size: 12px;" target="_blank">2640002<a name='more'></a></a></li>
</ul>
<li><b style="text-align: -webkit-center;"><b>Summer- 2014</b></b></li>
<ul>
<li><b style="text-align: -webkit-center;"><b><a href="http://gtu.ac.in/GTU_Papers/MCA/Summer_Exam_2014/2640002.zip" rel="nofollow" style="font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif; font-size: 12px; font-weight: normal; text-align: left;" target="_blank">2640002</a></b></b></li>
<li><b style="text-align: -webkit-center;"><a href="http://gtu.ac.in/GTU_Papers/MCA/Summer_Exam_2014/640002.zip" rel="nofollow" style="font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif; font-size: 12px; font-weight: normal; text-align: left;" target="_blank">640002</a></b></li>
</ul>
<li><b style="text-align: -webkit-center;"><b><b>Winter- 2013</b></b></b></li>
<ul>
<li><b style="text-align: -webkit-center;"><b><b><a href="http://gtu.ac.in/GTU_Papers/MCA/Winter_Exam_2013/640002.zip" rel="nofollow" style="font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif; font-size: 12px; font-weight: normal; text-align: left;" target="_blank">640002</a></b></b></b></li>
</ul>
<li><b style="text-align: -webkit-center;"><b><b><b>Summer- 2013</b></b></b></b></li>
<ul>
<li><b style="text-align: -webkit-center;"><b><b><b><a href="http://gtu.ac.in/GTU_Papers/MCA/Summer_Exam_2013/640002.zip" rel="nofollow" style="font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif; font-size: 12px; font-weight: normal; text-align: left;" target="_blank">640002</a></b></b></b></b></li>
</ul>
<li><b style="text-align: -webkit-center;"><b><b><b><b>Winter - 2012</b></b></b></b></b></li>
<ul>
<li><b style="text-align: -webkit-center;"><b><b><b><b><a href="http://gtu.ac.in/GTU_Papers/MCA/Winter_Exam_2012/640002.zip" rel="nofollow" style="font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif; font-size: 12px; font-weight: normal; text-align: left;" target="_blank">640002</a></b></b></b></b></b></li>
</ul>
<li><b style="text-align: -webkit-center;"><b><b><b><b><b>May-July 2012</b></b></b></b></b></b></li>
<ul>
<li><b style="text-align: -webkit-center;"><b><b><b><b><b><a href="http://gtu.ac.in/GTU_Papers/MCA/Summmer_Exam_2012/640002.zip" rel="nofollow" style="font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif; font-size: 12px; font-weight: normal; text-align: left;" target="_blank">640002</a></b></b></b></b></b></b></li>
</ul>
<li><b style="text-align: -webkit-center;"><b><b><b><b><b><b>Nov-Dec - 2011 & Jan-Feb-2012</b></b></b></b></b></b></b></li>
<ul>
<li><b style="text-align: -webkit-center;"><b><b><b><b><b><b><a href="http://gtu.ac.in/GTU_Papers/MCA/NovDec11JanFeb12/640002.zip" rel="nofollow" style="font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif; font-size: 12px; font-weight: normal; text-align: left;" target="_blank">640002</a></b></b></b></b></b></b></b></li>
</ul>
<li><b style="text-align: -webkit-center;"><b><b><b><b><b><b><b>May-June-July 2011</b></b></b></b></b></b></b></b></li>
<ul>
<li><b style="text-align: -webkit-center;"><b><b><b><b><b><b><a href="http://gtu.ac.in/GTU_Papers/MCA/MAY_JULY_2011/640002.zip" rel="nofollow" style="font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif; font-size: 12px; font-weight: normal; text-align: left;" target="_blank">640002</a></b></b></b></b></b></b></b></li>
</ul>
</ul>
<div style="text-align: -webkit-center;">
<b><br /></b></div>
</div>
<div style="text-align: -webkit-center;">
<b><a href="http://www.bipinrupadiya.com/2014/05/gtu-wtad-important-questions-bank.html" rel="nofollow" target="_blank">UNIT / Chapter wise Important GTU Exam Question Bank</a></b></div>
</div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com0tag:blogger.com,1999:blog-5049897316123669366.post-26603096360009177072014-11-09T20:07:00.000-08:002015-08-16T21:05:40.723-07:00copy file from Assets to SDcard in Android Example<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<h3>
Definition : 16. Create an application to read file from asset folder and copy it in memory card.</h3>
<br />
<h3 style="text-align: center;">
<span style="color: red;">File Name : </span><span style="text-align: left;"><span style="color: red;">E16.java</span></span></h3>
<br />
<div class="codeview">
package bsr.exa;<br />
<br />
import java.io.DataInputStream;<br />
import java.io.File;<br />
import java.io.FileInputStream;<br />
import java.io.FileOutputStream;<br />
import java.io.IOException;<br />
import java.io.InputStream;<br />
import java.io.OutputStream;<br />
<br />
<a name='more'></a><br />
<br />
import android.app.Activity;<br />
import android.os.Bundle;<br />
import android.os.Environment;<br />
import android.widget.TextView;<br />
import android.widget.Toast;<br />
<br />
public class E16 extends Activity<br />
{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>/** @author Bipin S Rupadiya , www.bipinrupadiya.com<br />
*<br />
* 16. Create an application to read file from asset folder and copy it in memory card.<br />
* <br />
* */<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>FileOutputStream fos ;<br />
<br />
@Override<br />
public void onCreate(Bundle savedInstanceState)<br />
{<br />
super.onCreate(savedInstanceState);<br />
setContentView(R.layout.s1); <br />
<br />
try<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>String destPath = "/sdcard/bsr.txt";<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>File f = new File(destPath);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>if (!f.exists())<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>CopyDB( getBaseContext().getAssets().open("file.txt"),new FileOutputStream(destPath));<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>dispFile();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>catch (Exception e)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Toast.makeText(E16.this, " "+e.toString(), Toast.LENGTH_LONG).show();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
public void dispFile()<br />
{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>try<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>File fileDir = Environment.getExternalStorageDirectory();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>File directory = new File(fileDir.getAbsolutePath());<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>File file = new File(directory , "bsr.txt");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>FileInputStream fis = new FileInputStream(file);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>String str = null;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>StringBuffer sbuffer = new StringBuffer();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>DataInputStream dataio = new DataInputStream(fis);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>while((str = dataio.readLine()) != null)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>sbuffer.append(str + "\n");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>TextView txt=(TextView)findViewById(R.id.showTxt);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>txt.setText(sbuffer);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>catch (Exception e)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Toast.makeText(this, " "+e.toString(), Toast.LENGTH_LONG).show();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<br />
}<br />
public void CopyDB(InputStream inputStream,OutputStream outputStream)throws IOException<br />
{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>//---copy 1K bytes at a time---<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>byte[] buffer = new byte[1024];<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>int length;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>while ((length = inputStream.read(buffer)) > 0) //check the length of file<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>outputStream.write(buffer, 0, length);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>inputStream.close();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>outputStream.close();<br />
}<br />
}</div>
<br />
<h3 style="text-align: center;">
<span style="color: red;">File Name : screen1.java</span></h3>
<br />
<div class="codeview">
package bsr.exa;<br />
<br />
import java.io.DataInputStream;<br />
import java.io.File;<br />
import java.io.FileInputStream;<br />
<br />
import android.app.Activity;<br />
import android.os.Bundle;<br />
import android.os.Environment;<br />
import android.widget.TextView;<br />
import android.widget.Toast;<br />
<br />
public class screen1 extends Activity<br />
{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>/** @author Bipin S Rupadiya , www.bipinrupadiya.com<br />
*/<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>public void onCreate(Bundle b)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>super.onCreate(b);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>setContentView(R.layout.s1);<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>try<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>File fileDir = Environment.getExternalStorageDirectory();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>File directory = new File(fileDir.getAbsolutePath());<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>File file = new File(directory , "bsr.txt");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>FileInputStream fis = new FileInputStream(file);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>String str = null;<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>StringBuffer sbuffer = new StringBuffer();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>DataInputStream dataio = new DataInputStream(fis);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>while((str = dataio.readLine()) != null)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>sbuffer.append(str + "\n");<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>TextView txt=(TextView)findViewById(R.id.showTxt);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>txt.setText(sbuffer);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>catch (Exception e)<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>{<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>Toast.makeText(this, " "+e.toString(), Toast.LENGTH_LONG).show();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>}<br />
}<br />
<div>
<br /></div>
</div>
<br />
<h3 style="text-align: center;">
<span style="color: red;">File Name : </span><span style="text-align: left;"><span style="color: red;">AndroidManifest.xml</span></span></h3>
<br />
<div class="codeview">
<?xml version="1.0" encoding="utf-8"?><br />
<manifest xmlns:android="http://schemas.android.com/apk/res/android"<br />
android:versionCode="1"<br />
android:versionName="1.0" package="bsr.exa"><br />
<uses-sdk android:minSdkVersion="8" /><br />
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"></uses-permission><br />
<br />
<application android:icon="@drawable/icon" android:label="@string/app_name"><br />
<activity android:label="@string/app_name" android:name=".E16"><br />
<intent-filter><br />
<action android:name="android.intent.action.MAIN" /><br />
<category android:name="android.intent.category.LAUNCHER" /><br />
</intent-filter><br />
</activity><br />
<br />
</application><br />
</manifest><br />
<br />
<br />
<br /></div>
<br />
<br /></div>
Bipin Rupadiyahttp://www.blogger.com/profile/10129611409744432750noreply@blogger.com0