- WAP to exchange values of 2 variables by calling a function exchange
- WAP to find length of a string by calling a function lenght
- WAP to copy contents of one string into another by calling a function copy.
- WAP to reverse contents of a string
- WAP to find sum of 10 int values by calling a function sum (passing array as an argument)
- WAP to find mean of 10 in values by calling a function MEAN (passing array as an argument)
- WAP to dynamically read n values and find their sum
- WAP to read information about n students and display them
- WAP to find area and circumference of a circle by calling a single function circle
- WAP to call functions area and circumference of circle by using function pointer
- WAP to count total number of words in a string by calling a function wcount
- WAP to read a String and coutn total vowels in that string
- WAP to read a string and count total no of digits in that string
- WAP to read a string and copy it into another array
- WAP to rad a string and reverse that string
Category: C Programming
Hibernate Native SQL
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package corehibernatedemo;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import model.Person;
import model.Student;
import model.Users;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
/**
*
* @author Shailesh Sonare
*/
public class CoreHibernateDemo {
/**
* @param args the command line arguments
*/
public static void main(String[] args) throws ParseException {
// TODO code application logic here
/*
Configuration cfg = new Configuration();
cfg.configure("hibernate.cfg.xml");
StandardServiceRegistryBuilder ssrb = new StandardServiceRegistryBuilder().applySettings(cfg.getProperties());
SessionFactory factory = cfg.buildSessionFactory(ssrb.build());
Session session = factory.openSession();
Transaction t = session.beginTransaction();
List users = session.createQuery("from Users").list();
System.out.println("done...");
for (Iterator iterator = users.iterator(); iterator.hasNext();) {
Users e = (Users) iterator.next();
System.out.println(e.getFirstName());
}
Date bdate = new SimpleDateFormat("yyyy-MM-dd").parse("1992-11-15");
Users usr = new Users("Sunita", "Sonare", bdate);
String hql = "UPDATE Users SET dob = :dob WHERE id = :id";
Query query = session.createQuery(hql);
query.setParameter("dob", bdate);
query.setParameter("id", 4);
query.executeUpdate();
//session.save(usr);
t.commit();
session.close();
System.out.println("DOne....");
*/
//Student s = new Student();
Configuration cfg = new Configuration().configure("hibernate.cfg.xml");
StandardServiceRegistryBuilder ssrb = new StandardServiceRegistryBuilder().applySettings(cfg.getProperties());
SessionFactory factory = cfg.buildSessionFactory(ssrb.build());
Session session = factory.openSession();
// String hql = "FROM Users";
// List<Users> list = session.createQuery(hql).list();
String sql = "SELECT first_name, last_name, dob FROM users";
SQLQuery query = session.createSQLQuery(sql);
query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP); // important when you are using alias <key><value> pair
// List<Object[]> rows = query.list();
//
// for(Object[] row : rows){
//
// Users u = new Users(row[0].toString(), row[1].toString(), new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(row[2].toString()));
// System.out.println(u);
// System.out.println("--------------");
// }
List list = query.list();
for(Object obj : list){
Map map = (Map)obj;
System.out.println("" + map.get("first_name"));
System.out.println("" + map.get("last_name"));
System.out.println("" + map.get("dob"));
System.out.println("-------------------------");
}
}
}
Users.java
package model;
// Generated 30 May, 2017 5:20:27 PM by Hibernate Tools 4.3.1
import java.util.Date;
/**
* Users generated by hbm2java
*/
public class Users implements java.io.Serializable {
private Integer id;
private String firstName;
private String lastName;
private Date dob;
public Users() {
}
public Users(String firstName, String lastName, Date dob) {
this.firstName = firstName;
this.lastName = lastName;
this.dob = dob;
}
public Integer getId() {
return this.id;
}
public void setId(Integer id) {
this.id = id;
}
public String getFirstName() {
return this.firstName;
}
public void setFirstName(String firstName) {
this.firstName = firstName;
}
public String getLastName() {
return this.lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
public Date getDob() {
return this.dob;
}
public void setDob(Date dob) {
this.dob = dob;
}
@Override
public String toString() {
return "Users{" + "id=" + id + ", firstName=" + firstName + ", lastName=" + lastName + ", dob=" + dob + '}';
}
}
Structure
- WAP to read Information about Student and Display it.
(Information: Roll Number, Name, Age, Sex) - WAP to read Information about an Employee and Display it.
(Information: EmpNo, Name, Job, Sal) - WAP to read Information about a Worker and Print Payment
(Information: Name, Wages, WorkingDays) - WAP to read information about 10 workers and print their Payment.
Print Average Payment
(Information: Name, Wages, WorkingDays) - WAP to read co-ordinates of end point of a line and find its slope by using the structure
struct Line{
int x1, y1, x2, y2;
} - WAP to read information about student
(Roll No. Name, Birth Date, Admission Date) by using following structure
struct date {
int D, M, Y;
}
struct Student {
int RollNo;
char name[20];
struct date bdate;
struct date admsndate;
}
Arrays Programs (Multi Dimensional)
- WAP to read a matrix of size 3 X 5 and find their SUM
- WAP to read a matrix of size 3 X 5 and find sum of each ROW
- WAP to read a matrix of size 3 X 3 and check if it is NULL or NOT
- WAP to read a matrix of size 3 X 5 and count all EVEN and ODD numbers
- WAP to read matrix of size 3 X 3 and check if it is UNIT Matrix or NOT
- WAP to read 2 matrix of size 3 X 3 and find their Addition
- WAP to read 2 matrix of size 3 X 3 and find their Product
- WAP to read matrix of size 3 X 3 and find its Transpose
- WAP to read matrix of size 3 X 3 and find its Transpose without using second matrix
- WAP to read matrix of size 3 X 3 and find its Upper Triangular Matrix
- WAP to read matrix of size 3 X 3 and find its Lower Triangular Matrix
- WAP to read matrix of size 3 X 3 and check if sum of its diagonal is same or not
- WAP to read matrix of size 3 X 3 and check if sum of its middle row is same as sum of its middle column
- WAP to create TIC-TAC-TOE by showing number and take 9 inputs from 2 users.
[box title=”” bg_color=”#dbdbdb” align=”left”]1 2 3
4 5 6
7 8 9
[/box]
[box title=”” bg_color=”#dbdbdb” align=”left”]X O X
O X O
O O X
[/box]
PLAYER 1 WIN
[box title=”” bg_color=”#dbdbdb” align=”left”]O X O
X O X
O X O
[/box]
PLAYER 2 WIN
Arrays Programs (One Dimensional)
- WAP to read an array of 10 numbers and find their sum
- WAP to read temperature days of Week and find their Mean
- WAP to read an array of 10 numbers and find greatest of them
- WAP to read an array of 10 numbers and count all EVEN and ODD numbers
- WAP to rad an array of 10 numbers and find sum, mean, min, max
- WAP to read an array of 10 numbers and search a number in it
- WAP to read an array of 10 numbers and sort it in ascending order
- WAP to read an array of 10 numbers and sort it in descending order
- WAP to insert a number at given position in an array (optional)
- WAP to remove a number from given position from an array (optional)
- WAP to arrange all even numbers at top and all odd numbers at bottom of an array (optional)
FUNCTIONS
- WAF repeat to display a char specified no of times.
- WAF intrest to calculate simple intrest.
- WAF to return Volume of Sphere
- WAF to return mean of 3 numbers
- WAF to return greatest of 2 numbers
- WAF to return Factorial of given Number
- WAF to return Sum of Given Number.
- WAF to return Greatest of 3 numbers.
- WAF to print all numbers from 1 to given numbers
- WAF to repeat a given char given number of timest.
e.g. repeat(‘#’, 25) - Design a recursive function factorial to return factorial of given number.
- Design a recursive function intrest to return compound intrest.
- Design a recursive function SOD to return sum of digit of given number.
-
WAF to return sum of number which is passed in a Array.
-
WAF to return Mean of numbers which is passed in a Array.
-
WAF to return Greatest number which is passed in a Array.
SWITCH Statement
- WAP to read a single digit number and print that number in words.
- WAP to read month in digits print it in words.
- WAP to read a single number and print all numbers from 1 to that number in words.
- WAP to read a color code (char value) and print appropriate color.
(e.g. R – Red, G- Green, B-Blue and other char – Black) - WAP to read 2 numbers and a Operator sign and perform the operation according to operator.
(e.g.
i/p:
5
7
+
5+7=12
)
- WAP to count total number of vowels in a string by using a switch statement
- WAP to count total number of vowels of each type
Loops Programs
EXACT OUTPUT IS OPTIONAL FOR PYTHON AND JAVASCRIPT
WAP to read a number and print all numbers from 1 to that number
Input: Enter a number: 5
Output:
1
2
3
4
5
WAP to read number and print all even numbers from 1 to that number
Input: Enter a number: 5
Output:
2
4
WAP to print all numbers from 1 to 10 using while, for, and do-while loop
WAP to read a number and find sum of all numbers from 1 to that number
Input: Enter a number: 5
Output: 1 + 2 + 3 + 4 + 5 = 15
WAP to read a number and find factorial of that number
Input: Enter a number: 5
Output: 1 * 2 * 3 * 4 * 5 = 120
WAP to read a number and check if it is a prime number or not
Input: Enter a number: 5
Output: 5 is a prime number
WAP to print all prime numbers in range from 1 to 100
Output:
2, 3, 5, 7, 11, 13, 17, 19, 23, 29,
31, 37, 41, 43, 47, 53, 59, 61, 67,
71, 73, 79, 83, 89, 97
WAP to print first 10 Fibonacci numbers
Output: 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55
WAP to print table of number in following format using 1 for loop
Input: Enter a number: 5
Output:
5 * 1 = 5 5 * 10 = 50
5 * 2 = 10 5 * 9 = 45
5 * 3 = 15 5 * 8 = 40
5 * 4 = 20 5 * 7 = 35
5 * 5 = 25 5 * 6 = 30
5 * 6 = 30 5 * 5 = 25
5 * 7 = 35 5 * 4 = 20
5 * 8 = 40 5 * 3 = 15
5 * 9 = 45 5 * 2 = 10
5 * 10 = 50 5 * 1 = 5
WAP to create random jackpot number and take input from user to guess the number
-
Based on level, the attempt to guess the number should change:
-
Easy – 20 attempts
-
Medium – 10 attempts
-
Difficult – 5 attempts
-
WAP to execute Fizz Buzz Problem / Print number 1 to 100
-
If number is divisible by 3 then print Fizz
-
If number is divisible by 5 then print Buzz
-
If number is divisible by both 3 and 5 then print Fizz Buzz
Programs on If Statement
Basic WAP (Write A Program) Questions
- Check if a number is even or odd
Input:
Enter a number: 5
Output:
Number 5 is odd
- Check if the last digits of two numbers are the same
Input:
Enter number 1: 55
Enter number 2: 45
Output:
Last digits of 55 and 45 are same
- Check if a triangle can be formed from 3 angles
Input:
Enter value for angle a: 50
Enter value for angle b: 60
Enter value for angle c: 70
Output:
Triangle can be formed
- Check if a triangle is equilateral
Input:
Enter value for angle a: 60
Enter value for angle b: 60
Enter value for angle c: 60
Output:
Triangle is equilateral triangle
- Check if student is passed based on marks of 5 subjects
Input:
Enter marks for maths: 50
Enter marks for science: 50
Enter marks for history: 50
Enter marks for english: 50
Enter marks for marathi: 50
Output:
Total Marks: 250
Percentage: 50%
Student is passed
- Find the greatest of two numbers
Input:
Enter number 1: 50
Enter number 2: 60
Output:
60 is greater than 50
- Find the greatest of three numbers
Input:
Enter number 1: 50
Enter number 2: 60
Enter number 3: 70
Output:
70 is greater than 50 and 60
- Check if the sum of cube of digits equals the number (Armstrong number)
Input:
Enter a 3 digit number: 153
Output:
Success: Sum of cube of 153 is 153
- Check if last digits of three numbers are the same
Input:
Enter number 1: 50
Enter number 2: 60
Enter number 3: 70
Output:
Last digits of 50, 60 and 70 are same
- Check if a number is a palindrome
Input:
Enter a number: 121
Output:
121 is palindrome number
- Print total, percentage and result (pass/fail) from 5 subject marks
Input:
Enter marks for maths: 50
Enter marks for science: 50
Enter marks for history: 50
Enter marks for english: 50
Enter marks for marathi: 50
Output:
Total Marks: 250
Percentage: 50%
Student is passed
- Check type of triangle based on angles
Input:
Enter value for angle a: 45
Enter value for angle b: 45
Enter value for angle c: 90
Output:
Triangle can be formed
The triangle is right angled triangle
- Check marriage eligibility based on age and gender
Input:
Enter gender M or F: M
Enter your age: 30
Output:
30 ka ho gaya ab to shadi kar le
- Check if a year is a leap year
Input:
Enter year: 2004
Output:
Year 2004 is a leap year
- Calculate commission based on salary
Salary Commission
<10000 10%
10000-20000 12%
>20000 15%
Input:
Enter Salary: 10000
Output:
Your commission is 1000 Rupees
- Print division based on percentage
Percentage Division
>=75 1st class with distinction
60-75 1st class
50-60 2nd class
40-50 3rd class
<40 Fail
Input:
Enter marks for maths: 75
Enter marks for science: 75
Enter marks for history: 75
Enter marks for english: 75
Enter marks for marathi: 75
Output:
Total Marks: 375
Percentage: 75%
Student passed with 1st class Distinction
Basic Programs
1. WAP to read radius of circle and calculate Area and Circumference
Input:
Enter radius: 5
Output:
Area of circle is 78.5
Circumference of circle is 31.5
2. WAP to read 3 numbers and find their mean
Input:
Enter number 1: 5
Enter number 2: 6
Enter number 3: 7
Output:
Mean of 5, 6 and 7 is 6
3. WAP to read 2 numbers and find Sum of their last digit
Input:
Enter number 1: 52
Enter number 2: 65
Output:
2 + 5 = 7
4. WAP to read 4-digit number and sum of its digits
Input:
Enter a number: 1234
Output:
1 + 2 + 3 + 4 = 10
5. WAP to read radius of Sphere and find its Volume
Input:
Enter radius: 5
Output:
Volume of sphere having radius 5 is 523.6
6. WAP to read 3-digit number and sum of its digits
Input:
Enter a number: 123
Output:
1 + 2 + 3 = 6
7. WAP to read 4-digit number and find reverse of that number
Input:
Enter a number: 1234
Output:
Reverse of 1234 is 4321
8. WAP to read temperature in Celsius and convert it into Fahrenheit
Input:
Enter temperature in Celsius: 38
Output:
Temperature in Fahrenheit is 100.4
9. WAP to read value in inches and print it in feet and inches
Input:
Enter length in inches: 20
Output:
20 inches is equal to 1 foot and 8 inches
10. WAP to read marks of 5 subjects and print total and percentage
Input:
Enter marks for Maths: 50
Enter marks for Science: 50
Enter marks for History: 50
Enter marks for English: 50
Enter marks for Marathi: 50
Output:
Total Marks: 250
Percentage: 50%
11. WAP to read 2 numbers and exchange their values using third variable
Input:
Enter value for x: 5
Enter value for y: 6
Output:
After swapping value of x is 6 and value of y is 5
12. WAP to read 2 numbers and exchange their values without using third variable
Input:
Enter value for x: 5
Enter value for y: 6
Output:
After swapping value of x is 6 and value of y is 5
13. WAP to read Length, Breadth and Height and find its volume and surface area
Input:
Enter length: 5
Enter breadth: 6
Enter height: 7
Output:
Volume of box is 210
Surface area of box is 214