java sql hibernate and springsDAKSHAYINI 3BR19EE026.pptx

Java Sql Internship PPT

1. VISVESVARAYA TECHNOLOGICAL UNIVERSITY, BELAGAVI Ballari Institute of Technology and Management, Ballari Department of Electrical and Electronics Engineering A Internship on “JAVA, SQL, HYBERNATES AND SPRINGS” Presented by GOUSIA BEE 3BR20EE022 . Head of the Department Dr. Sharana Reddy Internship Coordinators Prof. Arathi P B Prof. Farzana Begum K

2. Contents Company Profile. About the Company. Introduction to Java. SQL Hybernates and Springs Conclusion

3. Company Profile QSpiders A Unit Of Test Yantra Software Solutions India Pvt Ltd “ Q Spiders is a place where businesses find talent and dreams take flight.”   Major Organization Milestones Established in 2007. Led by Industry Experts. Global Presence in 4 Countries. Spread Across 17 Centers in India. Presence in 8 States. Training Centers in 9 major Cities in India. Address: No.01, 3rd cross Basappa Layout, Gavipuram Extn, Kempegowda Nagar, Bengaluru, Karnataka 560019. Ph No: [phone] Website: http://www.qspiders.com Mail id: onlineenq@ qspiders .com

4. About QSpiders H eadquartered in India’s IT capital, Bangalore. Offers a wide range of courses in the area of software testing and are official partners of the ISTQB®. provides young job aspirants the perfect launch-pad to build a rewarding career in the growing IT sector. Has exponentially grown to be the world’s largest software testing training organization spread across countries. T raining is imparted by qualified f aculty, who are highly competent, skilled and dedicated in giving their best towards the professional development of the students. Besides training, provides placement assistance to the students. Building competency into over 5000 students a month, QSpiders is where talent meets opportunity and believe your search for the dream job or the dream professional ends here.

5. About QSpiders QSpiders has 17 centers across India; 4 different units working parallelly ; the total space used - 2,81,500Sqrft. Products and Services Specialized in Software testing & Automation Tools Training. Specialized in Software Development Training. Services offered are: Graduate Internships. Incubation – CSR Activity. Campus Recruitment Training. Corporate Training. Post Graduate Internship. Project Guidance. Placements.  

6. Introduction to Java Java is a high-level and general purpose object oriented programming language and platform developed by Sun Microsystems and released in 1995. Types of languages in java Low level : it is understand by machine only. Middle level : Nothing but assembly level it is understand by machine & human . High level : The language readable & writable which understandable by human .

7. FEATURES OF JAVA Features Simple Object-oriented concepts Portable Platform Independent Secure Robust Multithreading Distributed Applications

8. JAVA OOPS CONCEPT Class: A class is a user-defined blueprint or prototype from which the objects are been created. Object: An Object can be defined as an instance of a class. Any entity that has state and behavior is known as an object. Polymorphism: It is a concept by which we can perform a single action in different ways. Inheritance: : Inheritance is a mechanism in which one object acquires all the properties and behaviors of a parent/base object. Encapsulation: Encapsulation in Java is a process of wrapping code and data together in a single unit. Abstraction: It is a concept in Object oriented programming language where it shows all the eventual attributes and hides the unnecessary data.

9. Program to check the number is palindrome or not class Palindrome { public static void main(String args []) { int rem, rev=0,temp; int num =121; //It is the number variable to be checked for palindrome temp= num ; while( num >0) { rem=num%10; //getting remainder rev=(rev*10)+rem; num = num /10; }

10. if(temp==rev) System.out.println (“number is a palindrome "); else System.out.println (“number is not palindrome"); } } Output: Number is a palindrome

11. SQL (STRUCTURED QUERY LANGUAGE) SQL: SQL stands for Structured Query Language , and it is used to communicate with the Database. This is a standard language used to perform tasks such as retrieval, updating, insertion and deletion of data from a database. Some SQL Commands The SQL commands help in creating and managing the database. The most common SQL commands which are highly used are mentioned below: CREATE command UPDATE command DELETE command SELECT command DROP command INSERT command

12. CREATE Command This command helps in creating the new database, new table, table view, and other objects of the database. UPDATE Command This command helps in updating or changing the stored data in the database. DELETE Command This command helps in removing or erasing the saved records from the database tables. It erases single or multiple tuples from the tables of the database. SELECT Command This command helps in accessing the single or multiple rows from one or multiple tables of the database. We can also use this command with the WHERE clause. DROP Command This command helps in deleting the entire table, table view, and other objects from the database. INSERT Command This command helps in inserting the data or records into the database tables. We can easily insert the records in single as well as multiple rows of the table.

13. EXAMPLE : EMP TABLE EMP NUMBER EMP NAME SALARY DEPT NUMBER 1 A 1000 10 2 B 2000 20 3 C 3000 30 4 D 4000 40 Write a query to display name of the employees SELECT EMP NAME FROM EMP; OUTPUT : EMP NAME A B C D

14. HYBBERNATES AND SPRINGS HYBERNATES • Open Source light-weight ORM solution • Java Object/Relational Mapping, Maps JavaBeans (POJOs) to tables • Lets you avoid SQL • Works with (almost) all relational Databases, Easy migration from one vendor database to another • Support CRUD (Create, Read, Update and Delete) operations • Very well matured and adopted by a large developer community

15. SPRINGS • Core Lightweight Container(The heart of Spring) • Aspect-Oriented Programming (AOP) framework • Modularizes behavior that would otherwise be scattered through different methods • Decorates your POJOs with cross-cutting behavior in a transparent manner • Container instantiates objects and injects dependencies on collaborating objects and configuration properties through Java methods

16. Conclusion Through this internship we learnt the core concepts of both the frontend and backend programming course and to get familiar with the latest web development technologies, we learnt sql databases and complete web development process. We have enhanced our knowledge and skills. We had an opportunity to gain practical knowledge by applying the theoretical knowledge which we utilized. We have gained more knowledge Java and Sql.

17. THANK YOU