CompSciFlix

Design & Analysis of Algorithm

2024-02-14T21:33:00.000+05:30

Design & Analysis of Algorithm MCQs

Question 1: Which searching technique in the design and analysis of algorithms typically divides the search space into halves at each step?

A) Linear Search
B) Binary Search
C) Depth-First Search
D) Breadth-First Search

Answer: B) Binary Search

---

Question 2: Which of the following is NOT a characteristic of binary search?

A) It requires the array to be sorted.
B) It has a time complexity of O(log n).
C) It can search through unsorted arrays efficiently.
D) It divides the search space in half at each step.

Answer: C) It can search through unsorted arrays efficiently.

---

Question 3: In binary search, what is the term used to describe the process of narrowing down the search space to find the target element?

A) Halving
B) Conquering
C) Recursion
D) Partitioning

Answer: A) Halving

---

Question 4: Which data structure is commonly used to implement binary search?

A) Linked List
B) Stack
C) Queue
D) Array

Answer: D) Array

---

Question 5: What is the worst-case time complexity of binary search?

A) O(1)
B) O(log n)
C) O(n)
D) O(n^2)

Answer: B) O(log n)

Question 6: Which searching technique involves traversing the entire list or array sequentially until the target element is found?

A) Linear Search
B) Binary Search
C) Depth-First Search
D) Breadth-First Search

Answer: A) Linear Search

Question 7: In linear search, what is the best-case time complexity when the target element is found at the beginning of the list?

A) O(1)
B) O(log n)
C) O(n)
D) O(n^2)

Answer: A) O(1)

Question 8: Which searching technique is commonly used for searching in graphs or trees by exploring as far as possible along each branch before backtracking?

A) Linear Search
B) Binary Search
C) Depth-First Search
D) Breadth-First Search

Answer: C) Depth-First Search

Question 6: Which searching technique is suitable for unsorted arrays and sequentially checks each element until a match is found?

A) Linear Search
B) Binary Search
C) Interpolation Search
D) Depth-First Search

Answer: A) Linear Search

---

Question 7: What is the primary advantage of linear search over binary search?

A) It has a lower time complexity.
B) It does not require the array to be sorted.
C) It always finds the target element in fewer steps.
D) It consumes less memory.

Answer: B) It does not require the array to be sorted.

---

Question 8: Which searching technique is an enhancement of binary search, particularly effective when the elements are uniformly distributed?

A) Linear Search
B) Jump Search
C) Exponential Search
D) Interpolation Search

Answer: D) Interpolation Search

---

Question 9: In jump search, what is the role of the "jump" step?

A) It involves making large jumps in the array.
B) It determines the size of the next jump.
C) It decides whether to switch to binary search.
D) It is used to calculate the average jump length.

Answer: A) It involves making large jumps in the array.

---

Question 10: Which searching technique works best when the elements are uniformly distributed and the array is sorted?

A) Binary Search
B) Interpolation Search
C) Jump Search
D) Linear Search

Answer: C) Jump Search

---

Question 11: Which searching technique divides the array into blocks and performs a binary search on each block?

A) Block Search
B) Jump Search
C) Exponential Search
D) Interpolation Search

Answer: A) Block Search

---

Question 12: What is the primary disadvantage of linear search compared to binary search?

A) Higher time complexity
B) Requires sorted array
C) Requires more memory
D) Limited applicability

Answer: A) Higher time complexity

---

Question 13: In which scenario does linear search perform better than binary search?

A) When the array is very large
B) When the array is sorted in descending order
C) When the target element is located in the middle of the array
D) When the target element is located near the beginning of the array

Answer: D) When the target element is located near the beginning of the array

---

Question 14: Which searching technique involves recursively dividing the array into smaller subarrays until the target element is found or the array is empty?

A) Linear Search
B) Binary Search
C) Depth-First Search
D) Exponential Search

Answer: C) Depth-First Search

---

Question 15: In which situation does binary search perform poorly?

A) When the array is small
B) When the array is sorted in descending order
C) When the target element is located at the end of the array
D) When the array contains duplicate elements

Answer: B) When the array is sorted in descending order

Question 1: What is the average-case time complexity of linear search?

A) O(1)
B) O(log n)
C) O(n)
D) O(n^2)

Answer: C) O(n)

---

Question 2: What is the worst-case time complexity of binary search?

A) O(1)
B) O(log n)
C) O(n)
D) O(n^2)

Answer: B) O(log n)

---

Question 3: Which searching algorithm has a time complexity of O(log n) in both average and worst cases?

A) Linear Search
B) Binary Search
C) Interpolation Search
D) Exponential Search

Answer: B) Binary Search

---

Question 4: What is the worst-case time complexity of linear search?

A) O(1)
B) O(log n)
C) O(n)
D) O(n^2)

Answer: C) O(n)

---

Question 5: Which of the following searching algorithms has the best time complexity?

A) Linear Search
B) Binary Search
C) Jump Search
D) Interpolation Search

Answer: B) Binary Search

---

Question 6: What is the time complexity of binary search when the array is not sorted?

A) O(1)
B) O(log n)
C) O(n)
D) O(n^2)

Answer: B) O(log n)

---

Question 7: In the average case, which searching algorithm has a time complexity of O(log log n)?

A) Linear Search
B) Binary Search
C) Interpolation Search
D) Exponential Search

Answer: D) Exponential Search

---

Question 8: What is the time complexity of linear search when the target element is at the beginning of the array?

A) O(1)
B) O(log n)
C) O(n)
D) O(n^2)

Answer: A) O(1)

---

Question 9: Which searching algorithm has a time complexity of O(sqrt(n)) when the elements are uniformly distributed?

A) Linear Search
B) Binary Search
C) Jump Search
D) Interpolation Search

Answer: C) Jump Search

---

Question 10: What is the time complexity of binary search when implemented iteratively?

A) O(1)
B) O(log n)
C) O(n)
D) O(n^2)

Answer: B) O(log n)

Certainly! Here are some multiple-choice questions on the time complexity of sorting algorithms:

Question 1: What is the time complexity of the bubble sort algorithm?

A) O(n)
B) O(n log n)
C) O(n^2)
D) O(log n)

Answer: C) O(n^2)

---

Question 2: Which sorting algorithm has the best-case time complexity of O(n) when the elements are already sorted?

A) Insertion Sort
B) Merge Sort
C) Quick Sort
D) Bubble Sort

Answer: A) Insertion Sort

---

Question 3: What is the average-case time complexity of quick sort?

A) O(n)
B) O(n log n)
C) O(n^2)
D) O(log n)

Answer: B) O(n log n)

---

Question 4: Which sorting algorithm always performs in O(n log n) time complexity, regardless of the input data?

A) Quick Sort
B) Selection Sort
C) Merge Sort
D) Bubble Sort

Answer: C) Merge Sort

---

Question 5: Which sorting algorithm has the worst-case time complexity of O(n^2) but can be improved with certain optimizations?

A) Bubble Sort
B) Insertion Sort
C) Selection Sort
D) Quick Sort

Answer: D) Quick Sort

---

Question 6: What is the time complexity of merge sort in the worst-case scenario?

A) O(n)
B) O(n log n)
C) O(n^2)
D) O(log n)

Answer: B) O(n log n)

---

Question 7: Which sorting algorithm typically performs better for smaller datasets due to its simplicity?

A) Merge Sort
B) Quick Sort
C) Insertion Sort
D) Heap Sort

Answer: C) Insertion Sort

---

Question 8: In which case does heap sort exhibit a time complexity of O(n log n)?

A) Best-case scenario
B) Average-case scenario
C) Worst-case scenario
D) All cases

Answer: D) All cases

---

Question 9: Which sorting algorithm is not comparison-based and has a time complexity of O(n+k)?

A) Bucket Sort
B) Quick Sort
C) Radix Sort
D) Merge Sort

Answer: A) Bucket Sort

---

Question 10: Which sorting algorithm is inherently stable, meaning it preserves the relative order of equal elements?

A) Quick Sort
B) Merge Sort
C) Selection Sort
D) Bubble Sort

Answer: B) Merge Sort

---

Question 11: What is the time complexity of selection sort in all cases?

A) O(n)
B) O(n log n)
C) O(n^2)
D) O(log n)

Answer: C) O(n^2)

---

Question 12: Which sorting algorithm is known for its space efficiency and stability?

A) Quick Sort
B) Insertion Sort
C) Radix Sort
D) Heap Sort

Answer: B) Insertion Sort

---

Question 13: Which sorting algorithm has a time complexity of O(n log n) in the best-case scenario?

A) Merge Sort
B) Quick Sort
C) Heap Sort
D) Bubble Sort

Answer: A) Merge Sort

---

Question 14: Which sorting algorithm is not suitable for large datasets due to its quadratic time complexity?

A) Merge Sort
B) Quick Sort
C) Insertion Sort
D) Radix Sort

Answer: C) Insertion Sort

---

Question 15: Which sorting algorithm has a time complexity that can degrade to O(n^2) in the worst-case scenario but is widely used due to its average-case performance?

A) Merge Sort
B) Quick Sort
C) Heap Sort
D) Bucket Sort

Answer: B) Quick Sort

Question 16: Which sorting algorithm has a time complexity that remains O(n log n) even in the worst-case scenario?

A) Insertion Sort
B) Merge Sort
C) Quick Sort
D) Bubble Sort

Answer: B) Merge Sort

---

Question 17: What is the time complexity of shell sort in its worst-case scenario?

A) O(n)
B) O(n log n)
C) O(n^2)
D) O(log n)

Answer: C) O(n^2)

---

Question 18: Which sorting algorithm is most efficient for sorting linked lists due to its ability to perform well with minimal data movement?

A) Merge Sort
B) Quick Sort
C) Insertion Sort
D) Selection Sort

Answer: A) Merge Sort

---

Question 19: Which sorting algorithm is also known as partition-exchange sort?

A) Bubble Sort
B) Quick Sort
C) Heap Sort
D) Selection Sort

Answer: B) Quick Sort

---

Question 20: What is the time complexity of counting sort, assuming the range of elements is known and small?

A) O(n)
B) O(n log n)
C) O(n^2)
D) O(k)

Answer: A) O(n)

---

Question 21: Which sorting algorithm is based on the concept of divide and conquer?

A) Insertion Sort
B) Bubble Sort
C) Quick Sort
D) Selection Sort

Answer: C) Quick Sort

---

Question 22: What is the time complexity of radix sort?

A) O(n)
B) O(n log n)
C) O(n^2)
D) O(k)

Answer: A) O(n)

---

Question 23: Which sorting algorithm is not suitable for large datasets due to its memory requirements?

A) Quick Sort
B) Merge Sort
C) Radix Sort
D) Insertion Sort

Answer: C) Radix Sort

---

Question 24: Which sorting algorithm is commonly used for sorting small datasets due to its simplicity and low overhead?

A) Merge Sort
B) Quick Sort
C) Insertion Sort
D) Heap Sort

Answer: C) Insertion Sort

---

Question 25: What is the time complexity of bubble sort in its average-case scenario?

A) O(n)
B) O(n log n)
C) O(n^2)
D) O(log n)

Answer: C) O(n^2)

---

Question 26: Which sorting algorithm is most affected by the order of elements in the input array?

A) Quick Sort
B) Merge Sort
C) Bubble Sort
D) Insertion Sort

Answer: C) Bubble Sort

---

Question 27: Which sorting algorithm is stable, meaning it preserves the relative order of equal elements?

A) Quick Sort
B) Selection Sort
C) Radix Sort
D) Merge Sort

Answer: D) Merge Sort

---

Question 28: In which scenario does selection sort perform best?

A) When the dataset is nearly sorted
B) When the dataset is already sorted
C) When the dataset is randomly arranged
D) When the dataset is large

Answer: C) When the dataset is randomly arranged

---

Absolutely! Here are some multiple-choice questions about recursive functions:

Question 1: What is a recursive function?

A) A function that calls itself directly or indirectly.
B) A function that only accepts integer arguments.
C) A function that performs a linear search.
D) A function that sorts elements using a recursive approach.

Answer: A) A function that calls itself directly or indirectly.

---

Question 2: What is the base case in a recursive function?

A) The case where the function returns an error.
B) The case where the function calls itself infinitely.
C) The case where the function stops calling itself and returns a value.
D) The case where the function contains no conditional statements.

Answer: C) The case where the function stops calling itself and returns a value.

---

Question 3: Which of the following is true about recursion?

A) Recursion is always more efficient than iteration.
B) Recursion uses less memory than iteration.
C) Recursion can lead to infinite loops if not implemented correctly.
D) Recursion is limited to mathematical calculations.

Answer: C) Recursion can lead to infinite loops if not implemented correctly.

---

Question 4: In a recursive function, what is the role of the "recursive step"?

A) To perform the final computation.
B) To return the result.
C) To call the function itself with a smaller input.
D) To check if the base case has been reached.

Answer: C) To call the function itself with a smaller input.

---

Question 5: What is tail recursion?

A) A recursive function with no base case.
B) A recursive function where the recursive call is the last operation in the function.
C) A recursive function with multiple base cases.
D) A recursive function that uses a loop instead of recursion.

Answer: B) A recursive function where the recursive call is the last operation in the function.

---

Question 6: Which of the following is NOT a characteristic of recursive functions?

A) They can solve problems by breaking them down into smaller, similar subproblems.
B) They can be less intuitive to understand compared to iterative solutions.
C) They always result in better performance than iterative solutions.
D) They require a base case to terminate the recursion.

Answer: C) They always result in better performance than iterative solutions.

---

Question 7: What is the primary advantage of using recursion?

A) Recursion always results in faster execution time.
B) Recursion is easier to implement than iteration.
C) Recursion can solve problems that have a natural recursive structure more elegantly.
D) Recursion does not require a base case.

Answer: C) Recursion can solve problems that have a natural recursive structure more elegantly.

---

Question 8: What happens if a recursive function lacks a base case?

A) The function will return an error.
B) The function will go into an infinite loop.
C) The function will terminate immediately.
D) The function will output incorrect results.

Answer: B) The function will go into an infinite loop.

---

Question 9: Which programming languages typically support recursion?

A) Only functional programming languages.
B) Only object-oriented programming languages.
C) Both functional and procedural programming languages.
D) Recursion is not supported in any programming languages.

Answer: C) Both functional and procedural programming languages.

---

Question 10: When should you use recursion instead of iteration?

A) When performance is critical.
B) When the problem can be easily solved iteratively.
C) When the problem can be broken down into smaller, similar subproblems.
D) When the problem involves complex mathematical calculations.

Answer: C) When the problem can be broken down into smaller, similar subproblems.

Question 1:
```python
def factorial(n):
    if n == 0:
        return 1
    else:
        return n * factorial(n-1)

print(factorial(5))
```
What will be the output of the code?

A) 0
B) 1
C) 5
D) 120

Answer: D) 120

---

Question 2:
```python
def fibonacci(n):
    if n <= 1:
        return n
    else:
        return fibonacci(n-1) + fibonacci(n-2)

print(fibonacci(6))
```
What will be the output of the code?

A) 8
B) 13
C) 21
D) 34

Answer: B) 13

---

Question 3:
```python
def power(base, exponent):
    if exponent == 0:
        return 1
    else:
        return base * power(base, exponent-1)

print(power(2, 3))
```
What will be the output of the code?

A) 6
B) 8
C) 16
D) 64

Answer: C) 16

---

Question 4:
```python
def reverse_string(s):
    if len(s) == 0:
        return s
    else:
        return reverse_string(s[1:]) + s[0]

print(reverse_string("hello"))
```
What will be the output of the code?

A) "olleh"
B) "olleh"
C) "hello"
D) "eholl"

Answer: A) "olleh"

---

Question 5:
```python
def sum_of_digits(n):
    if n == 0:
        return 0
    else:
        return n % 10 + sum_of_digits(n // 10)

print(sum_of_digits(12345))
```
What will be the output of the code?

A) 15
B) 10
C) 14
D) 5

Answer: A) 15

---

Question 6:
```python
def print_odd_numbers(n):
    if n > 0:
        print_odd_numbers(n - 1)
        if n % 2 != 0:
            print(n)

print_odd_numbers(7)
```
What will be the output of the code?

A) 1 3 5 7
B) 7 5 3 1
C) 2 4 6
D) 1 2 3 4 5 6 7

Answer: B) 7 5 3 1

Question 7:
```python
def print_numbers(n):
    if n > 0:
        print_numbers(n - 1)
        print(n)

print_numbers(5)
```
What will be the output of the code?

A) 1 2 3 4 5
B) 5 4 3 2 1
C) 1 2 3 4
D) 5 4 3 2

Answer: B) 5 4 3 2 1

---

Question 8:
```python
def gcd(a, b):
    if b == 0:
        return a
    else:
        return gcd(b, a % b)

print(gcd(48, 18))
```
What will be the output of the code?

A) 6
B) 12
C) 18
D) 24

Answer: A) 6

---

Question 9:
```python
def print_triangle(n):
    if n > 0:
        print_triangle(n - 1)
        print('*' * n)

print_triangle(5)
```
What will be the output of the code?

A)
```
*
**
***
****
*****
```
B)
```
*****
****
***
**
*
```
C)
```
*****
****
  ***
   **
    *
```
D)
```
    *
   **
  ***
****
*****
```

Answer: D)
```
    *
   **
  ***
****
*****
```

---

Number of comparisons required to search an element X = 18 in the list A = [ 5, 44, 89, 22, 18, 9, 3, 15, 8 ] using linear search.
A. 2
B. 3
C. 4
D. 5

Which of the following algorithms use recursion for sorting an array of integers?
A. Bubble sort
B. Insertion sort
C. Merge sort
D. Selection sort

What is an external sorting algorithm?
a) Algorithm that uses tape or disk during the sort
b) Algorithm that uses main memory during the sort
c) Algorithm that involves swapping
d) Algorithm that are considered ‘in place’
Answer: a

What is an internal sorting algorithm?
a) Algorithm that uses tape or disk during the sort
b) Algorithm that uses main memory during the sort
c) Algorithm that involves swapping
d) Algorithm that are considered ‘in place’

Answer: b

The given array is arr = {1, 2, 4, 3}. Bubble sort is used to sort the array elements. How many iterations will be done to sort the array?
a) 4
b) 2
c) 1
d) 0

Answer: a

In the following scenarios, when will you use selection sort?
a) The input is already sorted
b) A large file has to be sorted
c) Large values need to be sorted with small keys
d) Small values need to be sorted with large keys
Answer: c

he given array is arr = {3,4,5,2,1}. The number of iterations in bubble sort and selection sort respectively are __________
a) 5 and 4
b) 4 and 5
c) 2 and 4
d) 2 and 5

Answer: a
Explanation: Since the input array is not sorted, bubble sort takes 5 ie n iterations and selection sort takes 4 ie(n-1) iterations

How many passes does an insertion sort algorithm consist of?
a) N
b) N-1
c) N+1
d) N2

Answer: b

What will be the number of passes to sort the elements using insertion sort?
14, 12,16, 6, 3, 10
a) 6
b) 5
c) 7
d) 1
Answer: b
Explanation: The number of passes is given by N-1. Here, N=6. Therefore,
6-1=5 passes.

For the following question, how will the array elements look like after second pass?
34, 8, 64, 51, 32, 21
a) 8, 21, 32, 34, 51, 64
b) 8, 32, 34, 51, 64, 21
c) 8, 34, 51, 64, 32, 21
d) 8, 34, 64, 51, 32, 21

Answer: d

Which of the following method is used for sorting in merge sort?
a) partitioning
b) merging
c) exchanging
d) selection
Answer: b

COMPUTER NETWORK MCQS

2024-02-10T22:58:00.001+05:30

COMPUTER NETWORK MCQS

1. Which layer of the OSI model is responsible for routing and addressing?

- A. Data Link

- B. Network

- C. Transport

- D. Physical

- **Answer: B. Network**

2. What is the primary function of ARP (Address Resolution Protocol)?

- A. To translate IP addresses to MAC addresses

- B. To translate domain names to IP addresses

- C. To establish a secure connection between two hosts

- D. To manage network traffic congestion

- **Answer: A. To translate IP addresses to MAC addresses**

3. What is the purpose of DNS (Domain Name System) in computer networks?

- A. To convert IP addresses to domain names

- B. To manage network security protocols

- C. To regulate data flow between devices

- D. To manage network hardware resources

- **Answer: A. To convert IP addresses to domain names**

4. Which protocol is used to securely transfer files over a network?

- A. FTP (File Transfer Protocol)

- B. HTTP (Hypertext Transfer Protocol)

- C. SMTP (Simple Mail Transfer Protocol)

- D. SNMP (Simple Network Management Protocol)

- **Answer: A. FTP (File Transfer Protocol)**

5. Which device forwards data packets between different networks?

- A. Hub

- B. Switch

- C. Router

- D. Repeater

- **Answer: C. Router**

6. What is the purpose of subnetting in networking?

- A. To reduce network traffic

- B. To create smaller, more manageable networks

- C. To increase network speed

- D. To secure network connections

- **Answer: B. To create smaller, more manageable networks**

7. Which protocol is used for sending and receiving emails?

- A. TCP (Transmission Control Protocol)

- B. UDP (User Datagram Protocol)

- C. SMTP (Simple Mail Transfer Protocol)

- D. HTTP (Hypertext Transfer Protocol)

- **Answer: C. SMTP (Simple Mail Transfer Protocol)**

8. What is the function of a firewall in a computer network?

- A. To prevent unauthorized access to the network

- B. To boost network speed

- C. To manage IP addresses

- D. To encrypt data transmission

- **Answer: A. To prevent unauthorized access to the network**

9. Which of the following is a reliable transport protocol in TCP/IP?

- A. TCP (Transmission Control Protocol)

- B. UDP (User Datagram Protocol)

- C. IP (Internet Protocol)

- D. ARP (Address Resolution Protocol)

- **Answer: A. TCP (Transmission Control Protocol)**

10. What is the purpose of NAT (Network Address Translation)?

- A. To map public IP addresses to private IP addresses

- B. To establish secure connections between networks

- C. To manage network traffic flow

- D. To encrypt data packets

- **Answer: A. To map public IP addresses to private IP addresses**

11. Which network topology connects all devices in a closed loop?

- A. Star

- B. Ring

- C. Bus

- D. Mesh

- **Answer: B. Ring**

12. What is the function of DHCP (Dynamic Host Configuration Protocol) in networking?

- A. To assign IP addresses to devices automatically

- B. To manage domain name registrations

- C. To encrypt data transmission

- D. To regulate network traffic

- **Answer: A. To assign IP addresses to devices automatically**

13. Which addressing scheme is used in IPv6?

- A. 32-bit

- B. 128-bit

- C. 64-bit

- D. 16-bit

- **Answer: B. 128-bit**

14. What is the purpose of ICMP (Internet Control Message Protocol) in networking?

- A. To send error messages and operational information

- B. To establish secure connections

- C. To manage network hardware resources

- D. To regulate network traffic flow

- **Answer: A. To send error messages and operational information**

15. Which network device operates at the Data Link layer of the OSI model?

- A. Hub

- B. Router

- C. Switch

- D. Bridge

- **Answer: C. Switch**

16. What is the role of SSL (Secure Sockets Layer) in network communication?

- A. To encrypt data transmission

- B. To manage network security policies

- C. To translate domain names to IP addresses

- D. To regulate network traffic flow

- **Answer: A. To encrypt data transmission**

17. Which protocol is used for secure remote login to a network device?

- A. FTP

- B. SSH (Secure Shell)

- C. Telnet

- D. SMTP

- **Answer: B. SSH (Secure Shell)**

18. What is the purpose of VLANs (Virtual Local Area Networks)?

- A. To connect geographically dispersed networks

- B. To divide a physical network into multiple logical networks

- C. To manage network hardware resources

- D. To encrypt data transmission

- **Answer: B. To divide a physical network into multiple logical networks**

19. Which protocol is used for real-time communication over the internet?

- A. HTTP

- B. FTP

- C. RTP (Real-time Transport Protocol)

- D. SNMP

- **Answer: C. RTP (Real-time Transport Protocol)**

20. What is the function of a proxy server in a computer network?

- A. To regulate network traffic flow

- B. To manage network security policies

- C. To translate domain names to IP addresses

- D. To act as an intermediary between clients and servers

- **Answer: D. To act as an intermediary between clients and servers**

21. Which protocol is used for web page retrieval?

- A. FTP

- B. HTTP

- C. SMTP

- D. SNMP

- **Answer: B. HTTP**

22. What is the purpose of QoS (Quality of Service) in networking?

- A. To increase network speed

- B. To manage network traffic priorities

- C. To encrypt data transmission

- D. To regulate network security policies

- **Answer: B. To manage network traffic priorities**

23. Which device connects multiple network segments and operates at the Data Link layer?

- A. Router

- B. Switch

- C. Hub

- D. Bridge

- **Answer: D. Bridge**

24. What is the role of a MAC address in networking?

- A. To uniquely identify a device on a network

- B. To translate domain names to IP addresses

- C. To manage network security policies

25. What is the function of ICMP (Internet Control Message Protocol) in networking?

- A. To send error messages and operational information

- B. To establish secure connections

- C. To manage network hardware resources

- D. To regulate network traffic flow

- **Answer: A. To send error messages and operational information**

26. Which protocol is used for secure remote login to a network device?

- A. FTP

- B. SSH (Secure Shell)

- C. Telnet

- D. SMTP

- **Answer: B. SSH (Secure Shell)**

27. What is the purpose of VLANs (Virtual Local Area Networks)?

- A. To connect geographically dispersed networks

- B. To divide a physical network into multiple logical networks

- C. To manage network hardware resources

- D. To encrypt data transmission

- **Answer: B. To divide a physical network into multiple logical networks**

28. Which protocol is used for real-time communication over the internet?

- A. HTTP

- B. FTP

- C. RTP (Real-time Transport Protocol)

- D. SNMP

- **Answer: C. RTP (Real-time Transport Protocol)**

29. What is the function of a proxy server in a computer network?

- A. To regulate network traffic flow

- B. To manage network security policies

- C. To translate domain names to IP addresses

- D. To act as an intermediary between clients and servers

- **Answer: D. To act as an intermediary between clients and servers**

30. Which protocol is used for web page retrieval?

- A. FTP

- B. HTTP

- C. SMTP

- D. SNMP

- **Answer: B. HTTP**

31. What is the purpose of QoS (Quality of Service) in networking?

- A. To increase network speed

- B. To manage network traffic priorities

- C. To encrypt data transmission

- D. To regulate network security policies

- **Answer: B. To manage network traffic priorities**

32. Which device connects multiple network segments and operates at the Data Link layer?

- A. Router

- B. Switch

- C. Hub

- D. Bridge

- **Answer: D. Bridge**

33. What is the role of a MAC address in networking?

- A. To uniquely identify a device on a network

- B. To translate domain names to IP addresses

- C. To manage network security policies

- D. To regulate network traffic flow

- **Answer: A. To uniquely identify a device on a network**

34. Which of the following is a characteristic of UDP (User Datagram Protocol)?

- A. Connection-oriented protocol

- B. Reliable data transmission

- C. Error checking and retransmission of lost packets

- D. Best-effort delivery

- **Answer: D. Best-effort delivery**

35. What is the purpose of NAT (Network Address Translation) in networking?

- A. To assign IP addresses to devices automatically

- B. To translate public IP addresses to private IP addresses

- C. To manage network security policies

- D. To regulate network traffic flow

- **Answer: B. To translate public IP addresses to private IP addresses**

36. Which protocol is responsible for converting domain names to IP addresses?

- A. DNS (Domain Name System)

- B. DHCP (Dynamic Host Configuration Protocol)

- C. ARP (Address Resolution Protocol)

- D. ICMP (Internet Control Message Protocol)

- **Answer: A. DNS (Domain Name System)**

37. What is the purpose of a MAC table in a switch?

- A. To store IP addresses of devices connected to the switch

- B. To manage routing tables

- C. To store MAC addresses and associated port numbers

- D. To encrypt data transmission

- **Answer: C. To store MAC addresses and associated port numbers**

38. Which network device operates at the Physical layer of the OSI model?

- A. Router

- B. Switch

- C. Hub

- D. Repeater

- **Answer: D. Repeater**

39. What is the primary function of a DNS server?

- A. To manage IP addresses

- B. To assign IP addresses to devices automatically

- C. To translate domain names to IP addresses

- D. To establish secure connections between networks

- **Answer: C. To translate domain names to IP addresses**

40. Which protocol is used for transferring files securely over a network?

- A. FTPS (File Transfer Protocol Secure)

- B. SMTP (Simple Mail Transfer Protocol)

- C. SNMP (Simple Network Management Protocol)

- D. POP3 (Post Office Protocol version 3)

- **Answer: A. FTPS (File Transfer Protocol Secure)**

41. What is the purpose of a subnet mask in IP addressing?

- A. To identify the network portion of an IP address

- B. To identify the host portion of an IP address

- C. To determine the default gateway

- D. To regulate network traffic flow

- **Answer: A. To identify the network portion of an IP address**

42. Which protocol is used for dynamically assigning IP addresses to devices on a network?

- A. TCP (Transmission Control Protocol)

- B. DNS (Domain Name System)

- C. DHCP (Dynamic Host Configuration Protocol)

- D. FTP (File Transfer Protocol)

- **Answer: C. DHCP (Dynamic Host Configuration Protocol)**

43. What is the role of a firewall in network security?

- A. To connect multiple networks together

- B. To regulate network traffic flow

- C. To manage IP addresses

- D. To translate domain names to IP addresses

- **Answer: B. To regulate network traffic flow**

44. Which network topology connects all devices to a central hub or switch?

- A. Ring

- B. Bus

- C. Star

- D. Mesh

- **Answer: C. Star**

45. What is the function of SSL/TLS in network communication?

- A. To establish secure connections

- B. To manage network hardware resources

- C. To translate domain names to IP addresses

- D. To regulate network traffic flow

- **Answer: A. To establish secure connections**

46. Which of the following is a characteristic of a hub?

- A. Operates at the Network layer of the OSI model

- B. Forwards data packets based on MAC addresses

- C. Provides collision detection and prevention

- D. Creates multiple collision domains

- **Answer: D. Creates multiple collision domains**

47. What is the purpose of a default gateway in networking?

- A. To manage IP addresses

- B. To connect multiple networks together

- C. To translate domain names to IP addresses

- D. To

Certainly, here are more unique multiple-choice questions related to computer networks:

48. Which protocol is commonly used for transferring files between a client and a server over a network?

- A. SSH

- B. FTP

- C. SNMP

- D. SMTP

- **Answer: B. FTP**

49. In which layer of the OSI model does the TCP protocol operate?

- A. Transport

- B. Network

- C. Data Link

- D. Application

- **Answer: A. Transport**

50. What does TCP stand for in TCP/IP?

- A. Transfer Control Protocol

- B. Transmission Control Protocol

- C. Transport Connection Protocol

- D. Terminal Control Protocol

- **Answer: B. Transmission Control Protocol**

51. Which device operates at the Data Link layer of the OSI model and can segment collision domains?

- A. Router

- B. Hub

- C. Bridge

- D. Switch

- **Answer: D. Switch**

52. What is the purpose of a subnet mask in IPv4 addressing?

- A. To identify the network portion of an IP address

- B. To identify the host portion of an IP address

- C. To determine the default gateway

- D. To identify the broadcast address

- **Answer: A. To identify the network portion of an IP address**

53. Which of the following is a characteristic of UDP (User Datagram Protocol)?

- A. Connection-oriented protocol

- B. Reliable data transmission

- C. Error checking and retransmission of lost packets

- D. Best-effort delivery

- **Answer: D. Best-effort delivery**

54. What is the role of a DNS server in a network?

- A. To assign IP addresses to devices automatically

- B. To translate IP addresses to domain names

- C. To manage network security policies

- D. To establish secure connections between networks

- **Answer: B. To translate IP addresses to domain names**

55. Which network device operates at the Physical layer of the OSI model and regenerates signals?

- A. Router

- B. Switch

- C. Repeater

- D. Bridge

- **Answer: C. Repeater**

56. What is the purpose of ICMP (Internet Control Message Protocol) echo request and echo reply messages?

- A. To manage IP addresses

- B. To establish secure connections

- C. To troubleshoot network connectivity issues

- D. To encrypt data transmission

- **Answer: C. To troubleshoot network connectivity issues**

57. In TCP/IP, which layer is responsible for addressing, routing, and fragmentation?

- A. Application

- B. Transport

- C. Internet

- D. Network Interface

- **Answer: C. Internet**

58. Which protocol is used for dynamically assigning IP addresses to network devices?

- A. DNS

- B. DHCP

- C. ARP

- D. ICMP

- **Answer: B. DHCP**

59. What is the function of a router in a computer network?

- A. To connect multiple networks together

- B. To provide centralized authentication services

- C. To forward data packets between devices within the same network

- D. To encrypt data transmission

- **Answer: A. To connect multiple networks together**

60. Which of the following is NOT a valid network topology?

- A. Mesh

- B. Star

- C. Circle

- D. Bus

- **Answer: C. Circle**

61. What is the purpose of ARP (Address Resolution Protocol) in a network?

- A. To convert IP addresses to MAC addresses

- B. To translate domain names to IP addresses

- C. To manage network security policies

- D. To regulate network traffic flow

- **Answer: A. To convert IP addresses to MAC addresses**

62. Which device operates at the Physical layer of the OSI model and connects multiple network segments?

- A. Hub

- B. Switch

- C. Router

- D. Bridge

- **Answer: A. Hub**

63. What is the primary function of NAT (Network Address Translation)?

- A. To assign IP addresses to devices automatically

- B. To translate public IP addresses to private IP addresses

- C. To manage network security policies

- D. To regulate network traffic flow

- **Answer: B. To translate public IP addresses to private IP addresses**

64. Which network device operates at the Application layer of the OSI model?

- A. Router

- B. Switch

- C. Firewall

- D. Proxy Server

- **Answer: D. Proxy Server**

65. What is the purpose of a VLAN (Virtual Local Area Network)?

- A. To connect multiple networks together

- B. To divide a single physical network into multiple logical networks

- C. To manage network hardware resources

- D. To regulate network traffic flow

- **Answer: B. To divide a single physical network into multiple logical networks**

66. Which protocol is used for securely accessing web pages over HTTPS?

- A. HTTP

- B. FTP

- C. SSL/TLS

- D. SNMP

- **Answer: C. SSL/TLS**

67. What is the role of a proxy server in a network?

- A. To regulate network traffic flow

- B. To manage network security policies

- C. To translate domain names to IP addresses

- D. To act as an intermediary between clients and servers

- **Answer: D. To act as an intermediary between clients and servers**

68. Which layer of the OSI model is responsible for error detection and correction?

- A. Transport

- B. Network

- C. Data Link

- D. Physical

- **Answer: A. Transport**

69. What is the purpose of DHCP (Dynamic Host Configuration Protocol) in networking?

- A. To assign IP addresses to devices automatically

- B. To manage domain name registrations

- C. To encrypt data transmission

- D. To regulate network traffic

- **Answer: A. To assign IP addresses to devices automatically**

70. Which protocol is used for transferring email messages between servers?

- A. SMTP

- B. POP3

- C. IMAP

- D. SNMP

- **Answer: A. SMTP**

71. What is the primary function of a firewall in network security?

- A. To connect multiple networks together

- B. To regulate network traffic flow

- C. To manage IP addresses

- D. To translate domain names to IP addresses

- **Answer: B. To regulate network traffic flow**

72. Which network topology connects devices in a linear fashion and uses terminators to prevent signal reflection?

- A. Star

- B. Ring

- C. Mesh

- D. Bus

- **

Answer: D. Bus**

73. What is the purpose of ARP (Address Resolution Protocol) in a network?

- A. To convert IP addresses to MAC addresses

- B. To translate domain names to IP addresses

- C. To manage network security policies

- D. To regulate network traffic flow

- **Answer: A. To convert IP addresses to MAC addresses**

74. Which device operates at the Physical layer of the OSI model and connects multiple network segments?

- A. Hub

- B. Switch

- C. Router

- D. Bridge

- **Answer: A. Hub**

75. What is the primary function of NAT (Network Address Translation)?

- A. To assign IP addresses to devices automatically

- B. To translate public IP addresses to private IP addresses

- C. To manage network security policies

- D. To regulate network traffic flow

- **Answer: B. To translate public IP addresses to private IP addresses**

76. Which network device operates at the Application layer of the OSI model?

- A. Router

- B. Switch

- C. Firewall

- D. Proxy Server

- **Answer: D. Proxy Server**

77. What is the purpose of a VLAN (Virtual Local Area Network)?

- A. To connect multiple networks together

- B. To divide a single physical network into multiple logical networks

- C. To manage network hardware resources

- D. To regulate network traffic flow

- **Answer: B. To divide a single physical network into multiple logical networks**

78. Which protocol is used for securely accessing web pages over HTTPS?

- A. HTTP

- B. FTP

- C. SSL/TLS

- D. SNMP

- **Answer: C. SSL/TLS**

79. What is the role of a proxy server in a network?

- A. To regulate network traffic flow

- B. To manage network security policies

- C. To translate domain names to IP addresses

- D. To act as an intermediary between clients and servers

- **Answer: D. To act as an intermediary between clients and servers**

80. Which layer of the OSI model is responsible for error detection and correction?

- A. Transport

- B. Network

- C. Data Link

- D. Physical

- **Answer: A. Transport**

81. What is the purpose of DHCP (Dynamic Host Configuration Protocol) in networking?

- A. To assign IP addresses to devices automatically

- B. To manage domain name registrations

- C. To encrypt data transmission

- D. To regulate network traffic

- **Answer: A. To assign IP addresses to devices automatically**

82. Which protocol is used for transferring email messages between servers?

- A. SMTP

- B. POP3

- C. IMAP

- D. SNMP

- **Answer: A. SMTP**

83. What is the primary function of a firewall in network security?

- A. To connect multiple networks together

- B. To regulate network traffic flow

- C. To manage IP addresses

- D. To translate domain names to IP addresses

- **Answer: B. To regulate network traffic flow**

84. Which network topology connects devices in a linear fashion and uses terminators to prevent signal reflection?

- A. Star

- B. Ring

- C. Mesh

- D. Bus

- **Answer: D. Bus**

85. What is the primary function of NAT (Network Address Translation)?

- A. To assign IP addresses to devices automatically

- B. To translate public IP addresses to private IP addresses

- C. To manage network security policies

- D. To regulate network traffic flow

- **Answer: B. To translate public IP addresses to private IP addresses**

86. Which network device operates at the Application layer of the OSI model?

- A. Router

- B. Switch

- C. Firewall

- D. Proxy Server

- **Answer: D. Proxy Server**

87. What is the purpose of a VLAN (Virtual Local Area Network)?

- A. To connect multiple networks together

- B. To divide a single physical network into multiple logical networks

- C. To manage network hardware resources

- D. To regulate network traffic flow

- **Answer: B. To divide a single physical network into multiple logical networks**

88. Which protocol is used for securely accessing web pages over HTTPS?

- A. HTTP

- B. FTP

- C. SSL/TLS

- D. SNMP

- **Answer: C. SSL/TLS**

89. What is the role of a proxy server in a network?

- A. To regulate network traffic flow

- B. To manage network security policies

- C. To translate domain names to IP addresses

- D. To act as an intermediary between clients and servers

- **Answer: D. To act as an intermediary between clients and servers**

90. Which layer of the OSI model is responsible for error detection and correction?

- A. Transport

- B. Network

- C. Data Link

- D. Physical

- **Answer: A. Transport**

91. What is the purpose of DHCP (Dynamic Host Configuration Protocol) in networking?

- A. To assign IP addresses to devices automatically

- B. To manage domain name registrations

- C. To encrypt data transmission

- D. To regulate network traffic

- **Answer: A. To assign IP addresses to devices automatically**

92. Which protocol is used for transferring email messages between servers?

- A. SMTP

- B. POP3

- C. IMAP

- D. SNMP

- **Answer: A. SMTP**

93. What is the primary function of a firewall in network security?

- A. To connect multiple networks together

- B. To regulate network traffic flow

- C. To manage IP addresses

- D. To translate domain names to IP addresses

- **Answer: B. To regulate network traffic flow**

94. Which network topology connects devices in a linear fashion and uses terminators to prevent signal reflection?

- A. Star

- B. Ring

- C. Mesh

- D. Bus

- **Answer: D. Bus**

95. What is the primary function of NAT (Network Address Translation)?

- A. To assign IP addresses to devices automatically

- B. To translate public IP addresses to private IP addresses

- C. To manage network security policies

- D. To regulate network traffic flow

- **Answer: B. To translate public IP addresses to private IP addresses**

96. Which network device operates at the Application layer of the OSI model?

- A. Router

- B. Switch

- C. Firewall

- D. Proxy Server

- **Answer: D. Proxy Server**

97. What is the purpose of a VLAN (Virtual Local Area Network)?

- A. To connect multiple networks together

B. To divide a single physical network into multiple logical networks

- C. To manage network hardware resources

- D. To regulate network traffic flow

- **Answer: B. To divide a single physical network into multiple logical networks**

98. Which protocol is used for securely accessing web pages over HTTPS?

- A. HTTP

- B. FTP

- C. SSL/TLS

- D. SNMP

- **Answer: C. SSL/TLS**

99. What is the role of a proxy server in a network?

- A. To regulate network traffic flow

- B. To manage network security policies

- C. To translate domain names to IP addresses

- D. To act as an intermediary between clients and servers

- **Answer: D. To act as an intermediary between clients and servers**

100. Which layer of the OSI model is responsible for error detection and correction?

- A. Transport

- B. Network

- C. Data Link

- D. Physical

- **Answer: A. Transport**

JDBC

2024-01-28T14:51:00.001+05:30

JDBC(Java Database Connectivity)

The JDBC API is a Java API that can access any kind of tabular data, especially data stored in a Relational Database. JDBC stands for Java Database Connectivity. JDBC works with Java on a variety of platforms, such as Windows, Mac OS, and the various versions of UNIX.

What is JDBC?

JDBC stands for Java Database Connectivity, which is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases. The JDBC library includes APIs for each of the tasks commonly associated with database usage:

Making a connection to a database
Creating SQL or MySQL statements
Executing that SQL or MySQL queries in the database
Viewing & Modifying the resulting records

Fundamentally, JDBC is a specification that provides a complete set of interfaces that allows for portable access to an underlying database. Java can be used to write different types of executables, such as:

Java Applications
Java Applets
Java Servlets
Java ServerPages (JSPs)
Enterprise JavaBeans (EJBs)

All of these different executables are able to use a JDBC driver to access a database and take advantage of the stored data. JDBC provides the same capabilities as ODBC, allowing Java programs to contain database-independent code.

JDBC Architecture:

The JDBC API supports both two-tier and three-tier processing models for database access but in general JDBC Architecture consists of two layers:

JDBC API: This provides the application-to-JDBC Manager connection.
JDBC Driver API: This supports the JDBC Manager-to-Driver Connection.

The JDBC API uses a driver manager and database-specific drivers to provide transparent connectivity to heterogeneous databases. The JDBC driver manager ensures that the correct driver is used to access each data source. The driver manager is capable of supporting multiple concurrent drivers connected to multiple heterogeneous databases.

Following is the architectural diagram, which shows the location of the driver manager with respect to the JDBC drivers and the Java application:

Common JDBC Components:

The JDBC API provides the following interfaces and classes:

DriverManager: This interface manages a list of database drivers. Matches connection requests from the java application with the proper database driver using communication subprotocol. The first driver that recognizes a certain subprotocol under JDBC will be used to establish a database Connection.
Driver: This interface handles the communications with the database server. You will interact directly with Driver objects very rarely. Instead, you use DriverManager objects, which manages objects of this type. It also abstracts the details associated with working with Driver objects
Connection : Interface with all methods for contacting a database. The connection object represents communication context, i.e., all communication with database is through connection object only.
Statement : You use objects created from this interface to submit the SQL statements to the database. Some derived interfaces accept parameters in addition to executing stored procedures.
ResultSet: These objects hold data retrieved from a database after you execute an SQL query using Statement objects. It acts as an iterator to allow you to move through its data.
SQLException: This class handles any errors that occur in a database application.

What is JDBC Driver?

JDBC drivers implement the defined interfaces in the JDBC API for interacting with your database server. For example, using JDBC drivers enable you to open database connections and to interact with it by sending SQL or database commands then receiving results with Java. The java.sql package that ships with JDK contains various classes with their behaviours defined and their actual implementaions are done in third-party drivers. Third party vendors implements the java.sql.Driver interface in their database driver.

JDBC Drivers Types:

JDBC driver implementations vary because of the wide variety of operating systems and hardware platforms in which Java operates. Sun has divided the implementation types into four categories known as:

JDBC-ODBC bridge plus ODBC driver, also called Type 1.
Native-API, partly Java driver, also called Type 2.
JDBC-Net, pure Java driver, also called Type 3.
Native-protocol, pure Java driver, also called Type 4.

Type 1 Driver- the JDBC-ODBC bridge

In a Type 1 driver, a JDBC bridge is used to access ODBC drivers installed on each client machine. Using ODBC requires configuring on your system a Data Source Name (DSN) that represents the target database. When Java first came out, this was a useful driver because most databases only supported ODBC access but now this type of driver is recommended only for experimental use or when no other alternative is available.

The JDBC type 1 driver, also known as the JDBC-ODBC bridge is a database driver implementation that employs the ODBC driver to connect to the database. The driver converts JDBC method calls into ODBC function calls. The bridge is usually used when there is no pure-Java driver available for a particular database.

The driver is implemented in the sun.jdbc.odbc.JdbcOdbcDriver class and comes with the Java 2 SDK, Standard Edition. The driver is platform-dependent as it makes use of ODBC which in turn depends on native libraries of the operating system.

Type 1 is the simplest of all but platform specific i.e only to Microsoft platform.

Type 1 drivers are "bridge" drivers. They use another technology such as Open Database Connectivity (ODBC) to communicate with a database. This is an advantage because ODBC drivers exist for many Relational Database Management System (RDBMS) platforms.

Functions:

Translates query obtained by JDBC into corresponding ODBC query, which is then handled by the ODBC driver.
Sun provides a JDBC-ODBC Bridge driver. sun.jdbc.odbc.JdbcOdbcDriver. This driver is native code and not Java, and is closed
source.
Client -> JDBC Driver -> ODBC Driver -> Database
There is some overhead associated with the translation work to go from JDBC to ODBC.

Advantages:

Almost any database for which ODBC driver is installed, can be accessed.

Disadvantages:

Performance overhead since the calls have to go through the JDBC overhead bridge to the ODBC driver, then to the native database connectivity interface.
The ODBC driver needs to be installed on the client machine.
Considering the client-side software needed, this might not be suitable for applets.

Type 2 Driver - the Native-API Driver

The JDBC type 2 driver, also known as the Native-API driver is a database driver implementation that uses the client-side libraries of the database. The driver converts JDBC method calls into native calls of the database API.

A native-API partly Java technology-enabled driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix, DB2, or other DBMS. Note that, like the bridge driver, this style of driver requires that some binary code be loaded on each client machine. It does not have the overhead of the additional ODBC function calls.

Functions:

This type of driver converts JDBC calls into calls to the client API for that database.
Client -> JDBC Driver -> Vendor Client DB Library -> Database

Advantage

Better performance than Type 1 since no jdbc to odbc translation is needed.

Disadvantages

The vendor client library needs to be installed on the client machine.
Cannot be used in internet due the client side software needed.
Not all databases give the client side library.

Type 3 driver - the Network-Protocol Driver

The JDBC type 3 driver, also known as the network-protocol driver is a database driver implementation which makes use of a middle-tier between the calling program and the database. The middle-tier (application server) converts JDBC calls directly or indirectly into the vendor-specific database protocol.

This differs from the type 4 driver in that the protocol conversion logic resides not at the client, but in the middle-tier. However, like type 4 drivers, the type 3 driver is written entirely in Java. These drivers use a networking protocol and middleware to communicate with a server. The server then translates the protocol to DBMS function calls specific to DBMS.

Functions:

Follows a three tier communication approach.
Can interface to multiple databases - Not vendor specific.
The JDBC Client driver written in java, communicates with a middleware-net-server using a database independent protocol, and then this net server translates this request into database commands for that database.
Thus the client driver to middleware communication is database independent.
Client -> JDBC Driver -> Middleware-Net Server -> Any Database

Advantages

Since the communication between client and the middleware server is database independent, there is no need for the vendor db library on the client machine. Also the client to middleware need'nt be changed for a new database.
The Middleware Server (Can be a full fledged J2EE Application server) can provide typical middleware services like caching (connections, query results, and so on), load balancing, logging, auditing etc..
eg. for the above include jdbc driver features in Weblogic.
Can be used in internet since there is no client side software needed.
At client side a single driver can handle any database.(It works provided the middlware supports that database!!)

Disadvantages

Requires database-specific coding to be done in the middle tier.
An extra layer added may result in a time-bottleneck. But typically this is overcome by providing efficient middleware
services described above.

Type 4 - the Native-Protocol Driver

The JDBC type 4 driver, also known as the native-protocol driver is a database driver implementation that converts JDBC calls directly into the vendor-specific database protocol.

The type 4 driver is written completely in Java and is hence platform independent. It is installed inside the Java Virtual Machine of the client. It provides better performance over the type 1 and 2 drivers as it does not have the overhead of conversion of calls into ODBC or database API calls. Unlike the type 1 and 2 drivers, it does not need associated software to work.

A native-protocol fully Java technology-enabled driver converts JDBC technology calls into the network protocol used by DBMSs directly. This allows a direct call from the client machine to the DBMS server and is a practical solution for Intranet access. Since many of these protocols are proprietary the database vendors themselves will be the primary source for this style of driver. Several database vendors have these in progress.

The IBM Toolbox for Java JDBC driver is a Type 4 JDBC driver, indicating that the API is a pure Java networking protocol driver.

Functions

Type 4 drivers are entirely written in Java that communicate directly with a vendor's database through socket connections. No translation or middleware layers, are required, improving performance.
The driver converts JDBC calls into the vendor-specific database protocol so that client applications can communicate directly with the database server.
Completely implemented in Java to achieve platform independence.
e.g include the widely used Oracle thin driver - oracle.jdbc.driver. OracleDriver which connect to jdbc:oracle:thin URL format.
Client Machine -> Native protocol JDBC Driver -> Database server

Advantages

These drivers don't translate the requests into db request to ODBC or pass it to client api for the db, nor do they need a middleware layer for request indirection. Thus the performance is considerably improved.

Disadvantage

At client side, a separate driver is needed for each database.

Which Driver should be used?

If you are accessing one type of database, such as Oracle, Sybase, or IBM, the preferred driver type is 4.

If your Java application is accessing multiple types of databases at the same time, type 3 is the preferred driver.

Type 2 drivers are useful in situations where a type 3 or type 4 driver is not available yet for your database.

The type 1 driver is not considered a deployment-level driver and is typically used for development and testing purposes only.

Following table lists down popular JDBC driver names and database URL.

RDBMS	JDBC driver name	URL format
MySQL	com.mysql.jdbc.Driver	jdbc:mysql://hostname/ databaseName
ORACLE	oracle.jdbc.driver.OracleDriver	jdbc:oracle:thin:@hostname:portnumber:databaseName
DB2	COM.ibm.db2.jdbc.net.DB2Driver	jdbc:db2:hostname:port Number/databaseName
Sybase	com.sybase.jdbc.SybDriver	jdbc:sybase:Tds:hostname: port Number/databaseName

Creating JDBC Application:

There are following six steps involved in building a JDBC application:

Import the packages . Requires that you include the packages containing the JDBC classes needed for database programming. Most often, using import java.sql.* will suffice.
Register the JDBC driver . Requires that you initialize a driver so you can open a communications channel with the database.
Open a connection . Requires using the DriverManager.getConnection() method to create a Connection object, which represents a physical connection with the database.
Execute a query . Requires using an object of type Statement for building and submitting an SQL statement to the database.
Extract data from result set . Requires that you use the appropriateResultSet.getXXX() method to retrieve the data from the result set.
Clean up the environment . Requires explicitly closing all database resources versus relying on the JVM's garbage collection.

Sample Code:

import java.sql.*;

class ExecuteCreate

{

public static void main(String[] args)

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:sydsn");

System.out.println("Connection Created");

Statement st = con.createStatement();

System.out.println("Statement Created");

String query="create table account(accno int,balance float,acctype varchar)";

boolean result = st.execute(query);

if(result!=true)

System.out.println("Table created");

else

System.out.println("Table not created");

st.close();

con.close();

}

catch(Exception ex)

{ System.out.println(ex);}

}

DriverManager class:

The DriverManager class acts as an interface between user and drivers. It keeps track of the drivers that are available and handles establishing a connection between a database and the appropriate driver. The DriverManager class maintains a list of Driver classes that have registered themselves by calling the method DriverManager.registerDriver().

Useful methods of DriverManager class

Method	Description
1) public static void registerDriver(Driver driver):	is used to register the given driver with DriverManager.
2) public static void deregisterDriver(Driver driver):	is used to deregister the given driver (drop the driver from the list) with DriverManager.
3) public static Connection getConnection(String url):	is used to establish the connection with the specified url.
4) public static Connection getConnection(String url,String userName,String password):	is used to establish the connection with the specified url, username and password.

Connection interface

A Connection is the session between java application and database. The Connection interface is a factory of Statement, PreparedStatement, and DatabaseMetaData i.e. object of Connection can be used to get the object of Statement and DatabaseMetaData. The Connection interface provide many methods for transaction management like commit(), rollback() etc.

Commonly used methods of Connection interface:

1) public Statement createStatement(): creates a statement object that can be used to execute SQL queries.

2) public Statement createStatement(int resultSetType,int resultSetConcurrency): Creates a Statement object that will generate ResultSet objects with the given type and concurrency.

3) public void setAutoCommit(boolean status): is used to set the commit status.By default it is true.

4) public void commit(): saves the changes made since the previous commit/rollback permanent.

5) public void rollback(): Drops all changes made since the previous commit/rollback.

6) public void close(): closes the connection and Releases a JDBC resources immediately.

Note: By default, connection commits the changes after executing queries.

Connecting to the MySql database in java

Step 1:

Two ways to load the jar file:

paste the mysqlconnector.jar file in jre/lib/ext folder
set classpath

1) paste the mysqlconnector.jar file in JRE/lib/ext folder:

Download the mysqlconnector.jar file. Go to jre/lib/ext folder and paste the jar file here.

2) set classpath:

There are two ways to set the classpath:

temporary: Type following command on command prompt

set classpath= C:\folder\mysql-connector.jar;.;

permanent

Go to environment variable then click on new tab. In variable name write classpath and in variable value paste the path to the mysqlconnector.jar file by appending mysqlconnector.jar;.; as C:\folder\mysql-connector.jar;.;

Step 2:

Create a table in the mysql database, but before creating table, we need to create database first.

Open MySql prompt and type following:

create database sydb;
use sydb;
create table student(rollno int(5),name varchar(40),marks int(3));

Program which connects to MySql database with database name=sydb id=root and password=msc2:

import java.sql.*;

class MysqlCon

{

public static void main(String args[])

{

try

{

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/sydb","root","msc2");

Statement stmt=con.createStatement();

ResultSet rs=stmt.executeQuery("select * from student");

while(rs.next())

System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));

con.close();

}

catch(Exception e)

{

System.out.println(e);

}

Note: If you are doing in Netbeans then download mysql-connector.jar and add to to project library.

Once a connection is obtained we can interact with the database. The JDBC Statement, CallableStatement, and PreparedStatement interfaces define the methods and properties that enable you to send SQL or PL/SQL commands and receive data from your database.

They also define methods that help bridge data type differences between Java and SQL data types used in a database.

Following table provides a summary of each interface's purpose to understand how do you decide which interface to use?

Interfaces	Recommended Use
Statement	Use for general-purpose access to your database. Useful when you are using static SQL statements at runtime. The Statement interface cannot accept parameters.
PreparedStatement	Use when you plan to use the SQL statements many times. The PreparedStatement interface accepts input parameters at runtime.
CallableStatement	Use when you want to access database stored procedures. The CallableStatement interface can also accept runtime input parameters.

The Statement Objects:

Creating Statement Object:

Before you can use a Statement object to execute a SQL statement, you need to create one using the Connection object's createStatement( ) method, as in the following example:

Statement stmt = null;

try {

stmt = conn.createStatement( );

. . .

}

catch (SQLException e) {

. . .

}

Once you've created a Statement object, you can then use it to execute a SQL statement with one of its three execute methods.

boolean execute(String SQL) : Returns a boolean value of true if a ResultSet object can be retrieved; otherwise, it returns false. Use this method to execute SQL DDL statements or when you need to use truly dynamic SQL.
int executeUpdate(String SQL) : Returns the numbers of rows affected by the execution of the SQL statement. Use this method to execute SQL statements for which you expect to get a number of rows affected - for example, an INSERT, UPDATE, or DELETE statement.
ResultSet executeQuery(String SQL) : Returns a ResultSet object. Use this method when you expect to get a result set, as you would with a SELECT statement.

The PreparedStatement Objects:

The PreparedStatement interface extends the Statement interface which gives you added functionality with a couple of advantages over a generic Statement object.

This statement gives you the flexibility of supplying arguments dynamically.

PreparedStatement pstmt = null;

try {

String SQL = "Update Employees SET age = ? WHERE id = ?";

pstmt = conn.prepareStatement(SQL);

. . .

}

catch (SQLException e) {

. . .

}

All parameters in JDBC are represented by the ? symbol, which is known as the parameter marker. You must supply values for every parameter before executing the SQL statement.

The setXXX() methods bind values to the parameters, where XXX represents the Java data type of the value you wish to bind to the input parameter. If you forget to supply the values, you will receive an SQLException.

Each parameter marker is referred to by its ordinal position. The first marker represents position 1, the next position 2, and so forth. This method differs from that of Java array indices, which start at 0.

All of the Statement object's methods for interacting with the database (a) execute(), (b) executeQuery(), and (c) executeUpdate() also work with the PreparedStatement object. However, the methods are modified to use SQL statements that can take input the parameters.

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

class FriendDatabase extends JFrame implements ActionListener

{

JLabel lblNo,lblBal,lblLoc;

JTextField txtBal,txtNo,txtType;

JButton cmdAdd,cmdExitl;

Container cn=getContentPane();

public FriendDatabase()

{

lblNo=new JLabel("account No.");

lblBal=new JLabel("account BALANCE");

lblLoc=new JLabel("account type");

txtBal=new JTextField(10);

txtNo=new JTextField(10);

txtType=new JTextField(10);

cmdAdd=new JButton("Add");

cmdAdd.addActionListener(this);

cmdExit=new JButton("Exit");

cmdExit.addActionListener(this);

cn.setLayout(new GridLayout(4,2));

cn.add(lblNo);

cn.add(txtNo);

cn.add(lblBal);

cn.add(txtBal);

cn.add(lblLoc);

cn.add(txtType);

cn.add(cmdAdd);

cn.add(cmdExit);

setTitle("Frndz DB");

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

setSize(300,300);

setVisible(true);

}

public void actionPerformed(ActionEvent ae)

{

Object obj=ae.getSource();

if(obj==cmdAdd)

{ Connection con;

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con = DriverManager.getConnection("jdbc:odbc:ty");

String query="insert into account values(?,?,?)";

PreparedStatement ps;

ps=con.prepareStatement(query);

ps.setInt(1,Integer.parseInt(txtNo.getText()));

ps.setString(2,txtBal.getText());

ps.setString(3,txtType.getText());

ps.executeUpdate();

JOptionPane.showMessageDialog(this,"Record Entered","FriendsDatabase",JOptionPane.ERROR_MESSAGE);

txtBal.setText("");

txtNo.setText("");

txtType.setText("");

ps.close();

con.close();

}

catch(Exception e)

{

System.out.println("Error:"+e.getMessage());

}

if(obj==cmdExit)

{

System.exit(0);

}

public static void main(String args[])throws SQLException

{

FriendDatabase b=new FriendDatabase();

}

The CallableStatement Objects:

Just as a Connection object creates the Statement and PreparedStatement objects, it also creates the CallableStatement object which would be used to execute a call to a database stored procedure.

The following code snippet shows how to employ the Connection.prepareCall() method to instantiate a CallableStatement object based on the preceding stored procedure:

CallableStatement cstmt = null;

try {

String SQL = "{call getEmpName (?, ?)}";

cstmt = conn.prepareCall (SQL);

. . .

}

catch (SQLException e) {

. . .

}

The String variable SQL represents the stored procedure, with parameter placeholders.

Using CallableStatement objects is much like using PreparedStatement objects. You must bind values to all parameters before executing the statement, or you will receive an SQLException. If you have IN parameters, just follow the same rules and techniques that apply to a PreparedStatement object; use the setXXX() method that corresponds to the Java data type you are binding. When you use OUT and INOUT parameters you must employ an additional CallableStatement method, registerOutParameter(). The registerOutParameter() method binds the JDBC data type to the data type the stored procedure is expected to return.

Once you call your stored procedure, you retrieve the value from the OUT parameter with the appropriate getXXX() method. This method casts the retrieved value of SQL type to a Java data type.

import java.sql.*;

class CallableJdbcEx

{

public static void main(String[] args)

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:sydsn","sa","");

Statement st=con.createStatement();

String query="create procedure proc2 as select * from account";

st.executeUpdate(query);

CallableStatement cs = con.prepareCall("{call proc2}");

ResultSet rs=cs.executeQuery();

while(rs.next())

{

System.out.println("No:"+rs.getString(1)+"\nBal:"+rs.getString(2));

}

con.close();

}

catch(Exception e)

{

System.out.println(e);

e.printStackTrace();

}

JDBC - Result Sets

he SQL statements that read data from a database query return the data in a result set. The SELECT statement is the standard way to select rows from a database and view them in a result set. The java.sql.ResultSet interface represents the result set of a database query.

A ResultSet object maintains a cursor that points to the current row in the result set. The term "result set" refers to the row and column data contained in a ResultSet object.

The methods of the ResultSet interface can be broken down into three categories:

Navigational methods: used to move the cursor around.
Get methods: used to view the data in the columns of the current row being pointed to by the cursor.
Update methods: used to update the data in the columns of the current row. The updates can then be updated in the underlying database as well.

The cursor is movable based on the properties of the ResultSet. These properties are designated when the corresponding Statement that generated the ResultSet is created.

JDBC provides following connection methods to create statements with desired ResultSet:

createStatement(int RSType, int RSConcurrency);
prepareStatement(String SQL, int RSType, int RSConcurrency);
prepareCall(String sql, int RSType, int RSConcurrency);

The first argument indicate the type of a ResultSet object and the second argument is one of two ResultSet constants for specifying whether a result set is read-only or updatable.

Type of ResultSet:

The possible RSType are given below, If you do not specify any ResultSet type, you will automatically get one that is TYPE_FORWARD_ONLY.

Type	Description
ResultSet.TYPE_FORWARD_ONLY	The cursor can only move forward in the result set.
ResultSet.TYPE_SCROLL_INSENSITIVE	The cursor can scroll forwards and backwards, and the result set is not sensitive to changes made by others to the database that occur after the result set was created.
ResultSet.TYPE_SCROLL_SENSITIVE.	The cursor can scroll forwards and backwards, and the result set is sensitive to changes made by others to the database that occur after the result set was created.

Concurrency of ResultSet:

The possible RSConcurrency are given below, If you do not specify any Concurrency type, you will automatically get one that is CONCUR_READ_ONLY.

Concurrency	Description
ResultSet.CONCUR_READ_ONLY	Creates a read-only result set. This is the default
ResultSet.CONCUR_UPDATABLE	Creates an updateable result set.

Our all the examples written so far can be written as follows which initializes a Statement object to create a forward-only, read only ResultSet object:

try {

Statement stmt = conn.createStatement(

ResultSet.TYPE_FORWARD_ONLY,

ResultSet.CONCUR_READ_ONLY);

}

catch(Exception ex) {

....

}

Navigating a Result Set:

There are several methods in the ResultSet interface that involve moving the cursor, including:

S.N.	Methods & Description
1	public void beforeFirst() throws SQLException Moves the cursor to just before the first row
2	public void afterLast() throws SQLException Moves the cursor to just after the last row
3	public boolean first() throws SQLException Moves the cursor to the first row
4	public void last() throws SQLException Moves the cursor to the last row.
5	public boolean absolute(int row) throws SQLException Moves the cursor to the specified row
6	public boolean relative(int row) throws SQLException Moves the cursor the given number of rows forward or backwards from where it currently is pointing.
7	public boolean previous() throws SQLException Moves the cursor to the previous row. This method returns false if the previous row is off the result set
8	public boolean next() throws SQLException Moves the cursor to the next row. This method returns false if there are no more rows in the result set
9	public int getRow() throws SQLException Returns the row number that the cursor is pointing to.
10	public void moveToInsertRow() throws SQLException Moves the cursor to a special row in the result set that can be used to insert a new row into the database. The current cursor location is remembered.
11	public void moveToCurrentRow() throws SQLException Moves the cursor back to the current row if the cursor is currently at the insert row; otherwise, this method does nothing

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import java.sql.*;

public class TabbedAndDatabaseDemo extends JFrame

{

JTabbedPane tabpane;

TabbedAndDatabaseDemo()

{

tabpane=new JTabbedPane();

getContentPane().add(tabpane);

tabpane.addTab("Entry of Data",new EntryData());

pack();

setTitle(" DB");

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

setSize(300,300);

setVisible(true);

}

public static void main(String[] a)

{

new TabbedAndDatabaseDemo();

}

class EntryData extends JPanel implements ActionListener

{

JLabel acc_no,acc_bal,acc_type;

JTextField textno, textbal,texttpe;

JTextArea textarea;

JButton search,button,exit,first,next,last,prev;

ResultSet rs;

Statement st;

Connection cn ;

EntryData()

{

setLayout(new GridLayout(6,1));

acc_no=new JLabel("No.");

acc_bal=new JLabel("Balance");

acc_type=new JLabel("Type");

textno=new JTextField();

textbal=new JTextField();

texttpe=new JTextField();

search = new JButton("search");

button = new JButton("submit");

exit = new JButton("exit");

first= new JButton("First");

next= new JButton("next");

last= new JButton("Last");

prev= new JButton("Prev");

button.addActionListener(this);

search.addActionListener(this);

exit.addActionListener(this);

first.addActionListener(this);

next.addActionListener(this);

last.addActionListener(this);

prev.addActionListener(this);

add(acc_no);

add(textno);

add(acc_bal);

add(textbal);

add(acc_type);

add(texttpe);

add(button);

add(exit);

add(first);

add(next);

add(last);

add(prev);

add(search);

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

cn = DriverManager.getConnection("jdbc:odbc:sydsn");

st = cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);

rs = st.executeQuery("SELECT * from account");

}

catch(Exception ex){System.out.println(ex);}

}

public void actionPerformed(ActionEvent ae)

{

String sql="SELECT * from account";

try

{

if(ae.getSource()==button)

{

st = cn.createStatement();

int m = st.executeUpdate("insert into account values("+Integer.parseInt(textno.getText())+","+textbal.getText()+",'"+texttpe.getText()+"');");

JOptionPane.showMessageDialog(this,"Record Entered","FriendsDatabase",JOptionPane.ERROR_MESSAGE);

textno.setText("");

textbal.setText("");

texttpe.setText("");

}

else if(ae.getSource()==search)

{

String ser=JOptionPane.showInputDialog(this,"Enter search account","Search",JOptionPane.INFORMATION_MESSAGE);

sql="SELECT * from account where accno="+ser;

st = cn.createStatement();

rs = st.executeQuery(sql);

if(rs.next())

{

JOptionPane.showMessageDialog(this,"Found","FriendsDatabase",JOptionPane.ERROR_MESSAGE);

prints(rs);

}

else

JOptionPane.showMessageDialog(this,"not Found","FriendsDatabase",JOptionPane.ERROR_MESSAGE);

}

else if(ae.getSource()==exit)

System.exit(0);

else if(ae.getSource()==first)

{

rs.first();

prints(rs);

}

else if(ae.getSource()==next)

{

rs.next();

}

else if(ae.getSource()==last)

{

rs.last();

prints(rs);

}

else if(ae.getSource()==prev)

{

rs.previous();

prints(rs);

}

}catch(Exception ex){System.out.println(ex);}

}

public void prints(ResultSet rs)

{

textno.setText(rs.getString("accno"));

textbal.setText(rs.getString("balance"));

texttpe.setText(rs.getString("acctype"));

}

Viewing a Result Set:

The ResultSet interface contains dozens of methods for getting the data of the current row. There is a get method for each of the possible data types, and each get method has two versions:

One that takes in a column name.
One that takes in a column index.

For example, if the column you are interested in viewing contains an int, you need to use one of the getInt() methods of ResultSet:

S.N.	Methods & Description
1	public int getInt(String columnName) throws SQLException Returns the int in the current row in the column named columnName
2	public int getInt(int columnIndex) throws SQLException Returns the int in the current row in the specified column index. The column index starts at 1, meaning the first column of a row is 1, the second column of a row is 2, and so on.

Similarly there are get methods in the ResultSet interface for each of the eight Java primitive types, as well as common types such as java.lang.String, java.lang.Object, and java.net.URL. There are also methods for getting SQL data types java.sql.Date, java.sql.Time, java.sql.TimeStamp, java.sql.Clob, and java.sql.Blob. Check the documentation for more information about using these SQL data types.

import java.sql.*;

public class NavigateExample

{

public static void main(String[] args)

{

Connection conn;

Statement stmt ;

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

conn = DriverManager.getConnection("jdbc:odbc:sydsn");

stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

String sql="SELECT * from account";

ResultSet rs = stmt.executeQuery(sql);

System.out.println("\nMoving cursor to the last...");

rs.last();

int no = rs.getInt("accno");

int bal = rs.getInt("balance");

String type = rs.getString("acctype");

System.out.print("No: " + no);

System.out.print(", Bal: " + bal);

System.out.print(", Type: " + type);

System.out.println("\nMoving cursor to the first row...");

rs.first();

no = rs.getInt("accno");

bal = rs.getInt("balance");

type = rs.getString("acctype");

System.out.print("No: " + no);

System.out.print(", Bal: " + bal);

System.out.print(", Type: " + type);

System.out.println("\nMoving cursor to the next row...");

rs.next();

no = rs.getInt("accno");

bal = rs.getInt("balance");

type = rs.getString("acctype");

System.out.print("No: " + no);

System.out.print(", Bal: " + bal);

System.out.print(", Type: " + type);

rs.close();

stmt.close();

conn.close();

}

catch(SQLException se)

{ se.printStackTrace();}

catch(Exception e)

{ e.printStackTrace();}

}}

Updating a Result Set:

The ResultSet interface contains a collection of update methods for updating the data of a result set. As with the get methods, there are two update methods for each data type:

One that takes in a column name.
One that takes in a column index.

For example, to update a String column of the current row of a result set, you would use one of the following updateString() methods:

S.N.	Methods & Description
1	public void updateString(int columnIndex, String s) throws SQLException Changes the String in the specified column to the value of s.
2	public void updateString(String columnName, String s) throws SQLException Similar to the previous method, except that the column is specified by its name instead of its index.

There are update methods for the eight primitive data types, as well as String, Object, URL, and the SQL data types in the java.sql package.

Updating a row in the result set changes the columns of the current row in the ResultSet object, but not in the underlying database. To update your changes to the row in the database, you need to invoke one of the following methods.

S.N.	Methods & Description
1	public void updateRow() Updates the current row by updating the corresponding row in the database.
2	public void deleteRow() Deletes the current row from the database
3	public void refreshRow() Refreshes the data in the result set to reflect any recent changes in the database.
4	public void cancelRowUpdates() Cancels any updates made on the current row.
5	public void insertRow() Inserts a row into the database. This method can only be invoked when the cursor is pointing to the insert row.

import java.sql.*;

public class InsertExample

{

public static void main(String[] args)

{

Connection conn;

Statement stmt ;

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

conn = DriverManager.getConnection("jdbc:odbc:sydsn");

stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="SELECT * from account";

ResultSet rs = stmt.executeQuery(sql);

printRs(rs);

int newBal;

rs.beforeFirst();

while(rs.next())

{

newBal = rs.getInt("balance") + 50;

rs.updateInt( "balance", newBal);

rs.updateRow();

}

System.out.println("List result set showing new ages...");

printRs(rs);

System.out.println("Inserting a new record...");

rs.moveToInsertRow();

rs.updateInt("accno",104);

rs.updateInt("balance",4000);

rs.updateString("acctype","saving");

//Commit row

rs.insertRow();

System.out.println("List result set showing new set...");

printRs(rs);

// Set position to second record first

rs.absolute( 2 );

rs.deleteRow();

System.out.println("List result set after deleting one records...");

printRs(rs);

rs.close();

stmt.close();

conn.close();

}

catch(SQLException se)

{ se.printStackTrace();}

catch(Exception e)

{ e.printStackTrace();}

}

public static void printRs(ResultSet rs) throws SQLException

{

rs.beforeFirst();

while(rs.next())

{

int no = rs.getInt("accno");

int bal = rs.getInt("balance");

String type = rs.getString("acctype");

System.out.print("No: " + no);

System.out.print(", Bal: " + bal);

System.out.print(", Type: " + type);

System.out.println();

}

JDBC - Data Types

The JDBC driver converts the Java data type to the appropriate JDBC type before sending it to the database. It uses a default mapping for most data types. For example, a Java int is converted to an SQL INTEGER. Default mappings were created to provide consistency between drivers.

The following table summarizes the default JDBC data type that the Java data type is converted to when you call the setXXX() method of the PreparedStatement or CallableStatement object or the ResultSet.updateXXX() method.

SQL	JDBC/Java	setXXX	updateXXX
VARCHAR	java.lang.String	setString	updateString
CHAR	java.lang.String	setString	updateString
LONGVARCHAR	java.lang.String	setString	updateString
BIT	boolean	setBoolean	updateBoolean
NUMERIC	java.math.BigDecimal	setBigDecimal	updateBigDecimal
TINYINT	byte	setByte	updateByte
SMALLINT	short	setShort	updateShort
INTEGER	int	setInt	updateInt
BIGINT	long	setLong	updateLong
REAL	float	setFloat	updateFloat
FLOAT	float	setFloat	updateFloat
DOUBLE	double	setDouble	updateDouble
VARBINARY	byte[ ]	setBytes	updateBytes
BINARY	byte[ ]	setBytes	updateBytes
DATE	java.sql.Date	setDate	updateDate
TIME	java.sql.Time	setTime	updateTime
TIMESTAMP	java.sql.Timestamp	setTimestamp	updateTimestamp
CLOB	java.sql.Clob	setClob	updateClob
BLOB	java.sql.Blob	setBlob	updateBlob

TRANSACTIONS:

There are times when you do not want one statement to take effect unless another one completes. For example, when the proprietor of The Coffee Break updates the amount of coffee sold each week, he will also want to update the total amount sold to date. However, he will not want to update one without updating the other; otherwise, the data will be inconsistent. The way to be sure that either both actions occur or neither action occurs is to use a transaction. A transaction is a set of one or more statements that are executed together as a unit, so either all of the statements are executed, or none of the statements is executed.

Disabling Auto-commit Mode:

When a connection is created, it is in auto-commit mode. This means that each individual SQL statement is treated as a transaction and is automatically committed right after it is executed.

The way to allow two or more statements to be grouped into a transaction is to disable auto-commit mode. This is demonstrated in the following line of code, where con is an active connection:

con.setAutoCommit(false);

Committing a Transaction:

Once auto-commit mode is disabled, no SQL statements are committed until you call the method commit explicitly. All statements executed after the previous call to the method commit are included in the current transaction and committed together as a unit. The following code, in which con is an active connection, illustrates a transaction:

con.setAutoCommit(false);

PreparedStatement updateSales = con.prepareStatement("UPDATE COFFEES SET SALES = ? WHERE COF_NAME LIKE ?");

updateSales.setInt(1, 50);

updateSales.setString(2, "Colombian");

updateSales.executeUpdate();

PreparedStatement updateTotal = con.prepareStatement("UPDATE COFFEES SET TOTAL = TOTAL + ? WHERE COF_NAME LIKE ?");

updateTotal.setInt(1, 50);

updateTotal.setString(2, "Colombian");

updateTotal.executeUpdate();

con.commit();

con.setAutoCommit(true);

In this example, auto-commit mode is disabled for the connection con, which means that the two prepared statements updateSales and updateTotal are committed together when the method commit is called. The final line of the previous example enables auto-commit mode, which means that each statement is once again committed automatically when it is completed. Then, you are back to the default state where you do not have to call the method commit yourself. It is advisable to disable auto-commit mode only while you want to be in transaction mode. This way, you avoid holding database locks for multiple statements, which increases the likelihood of conflicts with other users.

Using Transactions to Preserve Data Integrity:

In addition to grouping statements together for execution as a unit, transactions can help to preserve the integrity of the data in a table. For instance, suppose that an employee was supposed to enter new coffee prices in the table COFFEES but delayed doing it for a few days. In the meantime, prices rose, and today the owner is in the process of entering the higher prices. The employee finally gets around to entering the now outdated prices at the same time that the owner is trying to update the table. After inserting the outdated prices, the employee realizes that they are no longer valid and calls the Connection method rollback to undo their effects. (The method rollback aborts a transaction and restores values to what they were before the attempted update.) At the same time, the owner is executing a SELECT statement and printing out the new prices. In this situation, it is possible that the owner will print a price that was later rolled back to its previous value, making the printed

price incorrect.

This kind of situation can be avoided by using transactions, providing some level of protection against conflicts that arise when two users access data at the same time. To avoid conflicts during a transaction, a DBMS uses locks, mechanisms for blocking access

by others to the data that is being accessed by the transaction. Once a lock is set, it remains in force until the transaction is committed or rolled back. For example, a DBMS could lock a row of a table until updates to it have been committed. The effect of this

lock would be to prevent a user from getting a dirty read, that is reading a value before it is made permanent. (Accessing an updated value that has not been committed is considered a dirty read because it is possible for that value to be rolled back to its previous value. If you read a value that is later rolled back, you will have read an invalid value.)

How locks are set is determined by what is called a transaction isolation level, which can range from not supporting transactions at all to supporting transactions that enforce very strict access rules. One example of a transaction isolation level is TRANSACTION_READ_COMMITTED, which will not allow a value to be accessed until after it has been committed. In other words, if the transaction isolation level is set to TRANSACTION_READ_COMMITTED, the DBMS does not allow dirty reads to occur. The interface Connection includes five values which represent the transaction isolation levels you can use in JDBC. Normally, you do not need to do anything about the transaction isolation level; you can just use the default one for your DBMS. JDBC allows you to find out what transaction isolation level your DBMS is set to (using the Connection method

getTransactionIsolation) and also allows you to set it to another level (using the Connection method setTransactionIsolation). Keep in mind, however, that even though JDBC allows you to set a transaction isolation level, doing so has no effect unless the driver and DBMS you are using support it.

Example:

import java.sql.*;

import java.io.*;

class TransactionDemo

{

public static void main(String[] args)

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:sydsn","sa","");

System.out.println("Connection Created");

con.setAutoCommit(false);

Statement st = con.createStatement();

System.out.println("Statement Created");

String query;int no;

query="insert into account values(108,10000,'saving')";

no=st.executeUpdate(query);

System.out.println(no+"record inserted");

query="insert into account values(109,12000,'saving')";

no=st.executeUpdate(query);

System.out.println(no+"record inserted");

con.commit();

st.close();

con.close();

}

catch(Exception ex)

{

System.out.println(ex);

}

}}

Setting and Rolling Back to a Savepoint:

The JDBC 3.0 API adds the method Connection. Set Save point, which sets a savepoint within the current transaction. The Connection.rollback method has been overloaded to take a savepoint argument. The example below inserts a row into a table, sets the

savepoint svpt1, and then inserts a second row. When the transaction is later rolled back tosvpt1, the second insertion is undone, but the first insertion remains intact. In other words, when the transaction is committed, only the row containing ?FIRST? will be added to TAB1:

Statement stmt = conn.createStatement();

int rows = stmt.executeUpdate("INSERT INTO TAB1 (COL1) VALUES (‘FIRST’)");

// set savepoint

Savepoint svpt1 = conn.setSavepoint("SAVEPOINT_1");

rows = stmt.executeUpdate("INSERT INTO TAB1 (COL1) VALUES (‘SECOND’)");

...

conn.rollback(svpt1);

...

conn.commit();

Releasing a Savepoint:

The method Connection.rollback() release Savepoint takes a Savepoint object as a parameter and removes it from the current transaction. Once a savepoint has been released, attempting to reference it in a rollback operation causes an SQLException to be

thrown. Any savepoints that have been created in a transaction are automatically released and become invalid when the transaction is committed, or when the entire transaction is rolled back. Rolling a transaction back to a savepoint automatically releases and makes

invalid any other savepoints that were created after the savepoint in question.

When to Call the Method rollback:

As mentioned earlier, calling the method rollback aborts a transaction and returns any values that were modified to their previous values. If you are trying to execute one or more

statements in a transaction and get an SQLException, you should call the method rollback to abort the transaction and start the transaction all over again. That is the only way to be sure of what has been committed and what has not been committed. Catching an SQLException tells you that something is wrong, but it does not tell you what was or was not committed. Since you cannot count on the fact that nothing was committed, calling the method rollback is the only way to be sure.

Batch Updation:

Batch Processing allows you to group related SQL statements into a batch and submit them with one call to the database.

When you send several SQL statements to the database at once, you reduce the amount of communication overhead, thereby improving performance.

JDBC drivers are not required to support this feature. You should use the DatabaseMetaData.supportsBatchUpdates() method to determine if the target database supports batch update processing. The method returns true if your JDBC driver supports this feature.
The addBatch() method of Statement, PreparedStatement, and CallableStatement is used to add individual statements to the batch. The executeBatch() is used to start the execution of all the statements grouped together.
The executeBatch() returns an array of integers, and each element of the array represents the update count for the respective update statement.
Just as you can add statements to a batch for processing, you can remove them with the clearBatch() method. This method removes all the statements you added with the addBatch() method. However, you cannot selectively choose which statement to remove.

Batch Processing with Statement Object:

Here is a typical sequence of steps to use Batch Processing with Statement Object −

Create a Statement object using either createStatement() methods.
Set auto-commit to false using setAutoCommit().
Add as many as SQL statements you like into batch using addBatch()method on created statement object.
Execute all the SQL statements using executeBatch() method on created statement object.
Finally, commit all the changes using commit() method.

Example:

import java.sql.*;

public class BatchUpdate

{

public static void main(String[] args)

{ try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:sydsn");

Statement st = con.createStatement();

con.setAutoCommit(false);

String query="insert into account values(111,'King Khan',25500,'Saving')";

st.addBatch(query);

query = "insert into account values(112,'Hrithik',55500,'Saving')";

st.addBatch(query);

query ="update account set accname='Queen Khan',balance=60000 where accno=112";

st.addBatch(query);;

int[] count = st.executeBatch();

con.commit();

st.close();

con.close();

}

catch(Exception e)

{

e.printStackTrace();

}

System.out.println("Goodbye!");

}

Batch Processing with PrepareStatement

Here is a typical sequence of steps to use Batch Processing with PrepareStatement Object −

Create SQL statements with placeholders.
Create PrepareStatement object using either prepareStatement()methods.
Set auto-commit to false using setAutoCommit().
Add as many as SQL statements you like into batch using addBatch()method on created statement object.
Execute all the SQL statements using executeBatch() method on created statement object.
Finally, commit all the changes using commit() method.

Example:

import java.sql.*;

import java.util.*;

class PreparedStBatchUpdate

{

public static void main(String[] args)

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:sydsn");

String query="insert into account Values(?,?,?,?)";

PreparedStatement ps=con.prepareStatement(query);

con.setAutoCommit(false);

ps.setInt(1,198);

ps.setString(2,"John");

ps.setDouble (3,67890);

ps.setString(4,"saving");

ps.addBatch();

ps.setInt(1,199);

ps.setString(2,"Joyce");

ps.setDouble (3,56789);

ps.setString(4,"saving");

ps.addBatch();

int[] count = ps.executeBatch();

con.commit();

ps.close();

con.close();

System.out.println("Done!");

}

catch(Exception ex)

{

System.out.println(ex);

}

interface Blob:

An SQL BLOB is a built-in type that stores a Binary Large Object as a column value in a row of a database table. By default drivers implement Blob using an SQL locator(BLOB), which means that a Blob object contains a logical pointer to the SQL BLOB data rather than the data itself. A Blob object is valid for the duration of the transaction in which is was created.

Method Summary

Methods
Modifier and Type	Method and Description
InputStream	getBinaryStream() Retrieves the BLOB value designated by this Blob instance as a stream.
InputStream	getBinaryStream(long pos, long length) Returns an InputStream object that contains a partial Blob value, starting with the byte specified by pos, which is length bytes in length.
byte[]	getBytes(long pos, int length) Retrieves all or part of the BLOB value that this Blob object represents, as an array of bytes.
long	length() Returns the number of bytes in the BLOB value designated by this Blob object.
OutputStream	setBinaryStream(long pos) Retrieves a stream that can be used to write to the BLOB value that this Blob object represents.
int	setBytes(long pos, byte[] bytes) Writes the given array of bytes to the BLOB value that this Blob object represents, starting at position pos, and returns the number of bytes written.
int	setBytes(long pos, byte[] bytes, int offset, int len) Writes all or part of the given byte array to the BLOB value that this Blob object represents and returns the number of bytes written.

Program to insert image to table:

import java.sql.*;

import java.io.*;

class InsertImg

{

public static void main(String args[])

{

try

{

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/sydb","root","msc2");

File f= new File("kisi.jpg");

FileInputStream fis = new FileInputStream(f);

PreparedStatement ps=con.prepareStatement("insert into studinfo values(?,?,?)");

ps.setInt(1,201);

ps.setString(2,"trishna");

ps.setBinaryStream(3, fis, (int) f.length());

ps.executeUpdate();

fis.close();

ps.close();

con.close();

}

catch(Exception e)

{

System.out.println(e);

}

Program to read Images from table:

import java.sql.*;

import java.io.*;

import java.util.Scanner;

class ReadImgage

{

public static void main(String args[])

{

try

{

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/sydb","root","msc2");

Statement st=con.createStatement();

System.out.println("Enter rollno:");

Scanner sc=new Scanner(System.in);

int roll=sc.nextInt();

ResultSet rs=st.executeQuery("select photo from studinfo where rollno="+roll);

byte img[]=new byte[6500];

while(rs.next() )

{ img=rs.getBytes("photo");

}

FileOutputStream fos = new FileOutputStream("e://"+roll+".jpg");

fos.write(img);

}

catch(Exception e)

{

System.out.println(e);

} } }

Interface CLOB:

An SQL CLOB is a built-in type that stores a Character Large Object as a column value in a row of a database table. By default drivers implement a Clob object using an SQL locator(CLOB), which means that a Clob object contains a logical pointer to the SQL CLOB data rather than the data itself. A Clob object is valid for the duration of the transaction in which it was created.

Method Summary


Modifier and Type	Method and Description
InputStream	getAsciiStream() Retrieves the CLOB value designated by this Clob object as an ascii stream.
Reader	getCharacterStream() Retrieves the CLOB value designated by this Clob object as a java.io.Reader object (or as a stream of characters).
Reader	getCharacterStream(long pos, long length) Returns a Reader object that contains a partial Clob value, starting with the character specified by pos, which is length characters in length.
String	getSubString(long pos, int length) Retrieves a copy of the specified substring in the CLOB value designated by this Clob object.
long	length() Retrieves the number of characters in the CLOB value designated by this Clob object.
long	position(Clob searchstr, long start) Retrieves the character position at which the specified Clob object searchstr appears in this Clob object.
long	position(String searchstr, long start) Retrieves the character position at which the specified substring searchstr appears in the SQL CLOB value represented by thisClob object.
OutputStream	setAsciiStream(long pos) Retrieves a stream to be used to write Ascii characters to the CLOB value that this Clob object represents, starting at position pos.
Writer	setCharacterStream(long pos) Retrieves a stream to be used to write a stream of Unicode characters to the CLOB value that this Clob object represents, at positionpos.
int	setString(long pos, String str) Writes the given Java String to the CLOB value that this Clob object designates at the position pos.
int	setString(long pos, String str, int offset, int len) Writes len characters of str, starting at character offset, to the CLOB value that this Clob represents.

Java Servlet

2024-01-28T14:46:00.001+05:30

Java Servlets

Why server-side programming?

Though it is technically feasible to implement almost any business logic using client-side programs, logically or functionally it carries no ground when it comes to enterprise applications (e.g. banking, air ticketing, e-shopping, etc.). To further explain, going by the client-side programming logic; a bank having 10,000 customers would mean that each customer should have a copy of the program(s) in his or her PC which translates to 10,000 programs! In addition, there are issues like security, resource pooling, concurrent access, and manipulations to the database which simply cannot be handled by client-side programs. The answer to most of the issues cited above is – “Server Side Programming”. Figure 1 illustrates Server-side architecture in the simplest terms.

Advantages of Server Side Programs

The list below highlights some of the important advantages of Server Side programs.

All programs reside in one machine called the Server. Any number of remote machines (called clients) can access the server program.
New functionalities to existing programs can be added at the server side which the clients’ can advantage without having to change anything from their side.
Migrating to newer versions, architectures, design patterns, adding patches, switching to new databases can be done at the server side without having to bother about clients’ hardware or software capabilities.
Issues relating to enterprise applications like resource management, concurrency, session management, security and performance are managed by service side applications.
They are portable and possess the capability to generate dynamic and user-based content (e.g. displaying transaction information of credit card or debit card depending on user’s choice).

Types of Server Side Programs

Active Server Pages (ASP)
Java Servlets
Java Server Pages (JSPs)
Enterprise Java Beans (EJBs)
PHP

To summarize, the objective of server side programs is to centrally manage all programs relating to a particular application (e.g. Banking, Insurance, e-shopping, etc). Clients with bare minimum requirement (e.g. Pentium II, Windows XP Professional, MS Internet Explorer and an internet connection) can experience the power and performance of a Server (e.g. IBM Mainframe, Unix Server, etc) from a remote location without having to compromise on security or speed. More importantly, server programs are not only portable but also possess the capability to generate dynamic responses based on user’s request.

Servlet

Servlet technology is used to create web application (resides at server side and generates dynamic web page).

Servet technology is robust and scalable as it uses the java language. Before Servlet, CGI (Common Gateway Interface) scripting language was used as a server-side programming language. But there were many disadvantages of this technology. We have discussed these disadvantages below.

There are many interfaces and classes in the servlet API such as Servlet, GenericServlet, HttpServlet, ServletRequest, ServletResponse etc.

What is a Servlet?

Servlet can be described in many ways, depending on the context.

Servlet is a technology i.e. used to create web application.
Servlet is an API that provides many interfaces and classes including documentations.
Servlet is an interface that must be implemented for creating any servlet.
Servlet is a class that extend the capabilities of the servers and respond to the incoming request. It can respond to any type of requests.
Servlet is a web component that is deployed on the server to create dynamic web page.

What is web application?

A web application is an application accessible from the web. A web application is composed of web components like Servlet, JSP, Filter etc. and other components such as HTML. The web components typically execute in Web Server and respond to HTTP request.

CGI(Commmon Gateway Interface)

CGI technology enables the web server to call an external program and pass HTTP request information to the external program to process the request. For each request, it starts a new process.

Disadvantages of CGI

There are many problems in CGI technology:

If number of clients increases, it takes more time for sending response.
For each request, it starts a process and Web server is limited to start processes.
It uses platform dependent language e.g. C, C++, perl.

Advantage of Servlet

There are many advantages of Servlet over CGI. The web container creates threads for handling the multiple requests to the servlet. Threads have a lot of benefits over the Processes such as they share a common memory area, lighweight, cost of communication between the threads are low. The basic benefits of servlet are as follows:

better performance: because it creates a thread for each request not process.
Portability: because it uses java language.
Robust: Servlets are managed by JVM so no need to worry about momory leak, garbage collection etc.
Secure: because it uses java language.

The basic terminology used in servlet are given below:

HTTP
HTTP Request Types
Difference between Get and Post method
Container
Server and Difference between web server and application server
Content Type
Introduction of XML
Deployment

HTTP (Hyper Text Transfer Protocol)

Http is the protocol that allows web servers and browsers to exchange data over the web.
It is a request response protocol.
Http uses reliable TCP connections bydefault on TCP port 80.
It is stateless means each request is considered as the new request. In other words, server doesn't recognize the user bydefault.

Http Request Methods

Every request has a header that tells the status of the client. There are many request methods. Get and Post requests are mostly used. The http request methods are:

GET
POST
HEAD
PUT
DELETE
OPTIONS
TRACE

HTTP Request	Description
GET	Asks to get the resource at the requested URL.
POST	Asks the server to accept the body info attached. It is like GET request with extra info sent with the request.
HEAD	Asks for only the header part of whatever a GET would return. Just like GET but with no body.
TRACE	Asks for the loopback of the request message, for testing or troubleshooting.
PUT	Says to put the enclosed info (the body) at the requested URL.
DELETE	Says to delete the resource at the requested URL.
OPTIONS	Asks for a list of the HTTP methods to which the thing at the request URL can respond

What is the difference between Get and Post?

There are many differences between the Get and Post request. Let's see these differences:

GET	POST
1) In case of Get request, only limited amount of datacan be sent because data is sent in header.	In case of post request, large amount of data can be sent because data is sent in body.
2) Get request is not secured because data is exposed in URL bar.	Post request is secured because data is not exposed in URL bar.
3) Get request can be bookmarked	Post request cannot be bookmarked
4) Get request is idempotent. It means second request will be ignored until response of first request is delivered.	Post request is non-idempotent
5) Get request is more efficient and used more than Post	Post request is less efficient and used less than get.

Anatomy of Get Request

As we know that data is sent in request header in case of get request. It is the default request type. Let's see what informations are sent to the server.

Anatomy of Post Request

As we know, in case of post request original data is sent in message body. Let's see how informations are passed to the server in case of post request.

Container

It provides runtime environment for JavaEE (j2ee) applications.It performs many operations that are given below:

Life Cycle Management
Multithreaded support
Object Pooling
Security etc.

Server

It is a running program or software that provides services.There are two types of servers:

Web Server
Application Server

Web Server

Web server contains only web or servlet container. It can be used for servlet, jsp, struts, jsf etc. It can't be used for EJB. Example of Web Servers are: Apache Tomcat and Resin.

Application Server

Application server contains Web and EJB containers. It can be used for servlet, jsp, struts, jsf, ejb etc.

Example of Application Servers are:

JBoss Open-source server from JBoss community.
Glassfish provided by Sun Microsystem. Now acquired by Oracle.
Weblogic provided by Oracle. It more secured.
Websphere provided by IBM.

Content Type

Content Type is also known as MIME (Multipurpose internet Mail Extension) Type. It is a HTTP header that provides the description about what are you sending to the browser.

There are many content types:

text/html
text/plain
application/msword
application/vnd.ms-excel
application/jar
application/pdf
application/octet-stream
application/x-zip
images/jpeg
video/quicktime etc.

Servlet API

The javax.servlet and javax.servlet.http packages represent interfaces and classes for servlet api.

The javax.servlet package contains many interfaces and classes that are used by the servlet or web container. These are not specific to any protocol.

The javax.servlet.http package contains interfaces and classes that are responsible for http requests only.

Interfaces in javax.servlet package

There are many interfaces in javax.servlet package. They are as follows:

Servlet
ServletRequest
ServletResponse
RequestDispatcher
ServletConfig
ServletContext
SingleThreadModel
Filter
FilterConfig
FilterChain
ServletRequestListener
ServletRequestAttributeListener
ServletContextListener
ServletContextAttributeListener

Classes in javax.servlet package

There are many classes in javax.servlet package. They are as follows:

GenericServlet
ServletInputStream
ServletOutputStream
ServletRequestWrapper
ServletResponseWrapper
ServletRequestEvent
ServletContextEvent
ServletRequestAttributeEvent
ServletContextAttributeEvent
ServletException
UnavailableException

Interfaces in javax.servlet.http package

There are many interfaces in javax.servlet.http package. They are as follows:

HttpServletRequest
HttpServletResponse
HttpSession
HttpSessionListener
HttpSessionAttributeListener
HttpSessionBindingListener
HttpSessionActivationListener
HttpSessionContext (deprecated now)

Classes in javax.servlet.http package

There are many classes in javax.servlet.http package. They are as follows:

HttpServlet
Cookie
HttpServletRequestWrapper
HttpServletResponseWrapper
HttpSessionEvent
HttpSessionBindingEvent
HttpUtils (deprecated now)

Servlet Interface

Servlet interface provides common behaviour to all the servlets.

Servlet interface needs to be implemented for creating any servlet (either directly or indirectly). It provides 3 life cycle methods that are used to initialize the servlet, to service the requests, and to destroy the servlet and 2 non-life cycle methods.

Methods of Servlet interface

There are 5 methods in Servlet interface. The init, service and destroy are the life cycle methods of servlet. These are invoked by the web container.

Method	Description
public void init(ServletConfig config)	initializes the servlet. It is the life cycle method of servlet and invoked by the web container only once.
public void service(ServletRequest request,ServletResponse response)	provides response for the incoming request. It is invoked at each request by the web container.
public void destroy()	is invoked only once and indicates that servlet is being destroyed.
public ServletConfig getServletConfig()	returns the object of ServletConfig.
public String getServletInfo()	returns information about servlet such as writer, copyright, version etc.

Servlet Example by implementing Servlet interface

File: First.java

import java.io.*;

import javax.servlet.*;

public class First implements Servlet{

ServletConfig config=null;

public void init(ServletConfig config){

this.config=config;

System.out.println("servlet is initialized");

}

public void service(ServletRequest req,ServletResponse res)

throws IOException,ServletException{

res.setContentType("text/html");

PrintWriter out=res.getWriter();

out.print("<html><body>");

out.print("<b>hello simple servlet</b>");

out.print("</body></html>");

}

public void destroy(){System.out.println("servlet is destroyed");}

public ServletConfig getServletConfig(){return config;}

}

GenericServlet class

GenericServlet class implements Servlet,ServletConfig and Serializable interfaces. It provides the implementaion of all the methods of these interfaces except the service method.

GenericServlet class can handle any type of request so it is protocol-independent.

You may create a generic servlet by inheriting the GenericServlet class and providing the implementation of the service method.

Methods of GenericServlet class

There are many methods in GenericServlet class. They are as follows:

public void init(ServletConfig config) is used to initialize the servlet.
public abstract void service(ServletRequest request, ServletResponse response) provides service for the incoming request. It is invoked at each time when user requests for a servlet.
public void destroy() is invoked only once throughout the life cycle and indicates that servlet is being destroyed.
public ServletConfig getServletConfig() returns the object of ServletConfig.
public String getServletInfo() returns information about servlet such as writer, copyright, version etc.
public void init() it is a convenient method for the servlet programmers, now there is no need to call super.init(config)
public ServletContext getServletContext() returns the object of ServletContext.
public String getInitParameter(String name) returns the parameter value for the given parameter name.
public Enumeration getInitParameterNames() returns all the parameters defined in the web.xml file.
public String getServletName() returns the name of the servlet object.
public void log(String msg) writes the given message in the servlet log file.
public void log(String msg,Throwable t) writes the explanatory message in the servlet log file and a stack trace.

Servlet Example by inheriting the GenericServlet class

File: First.java

import java.io.*;

import javax.servlet.*;

public class First extends GenericServlet{

public void service(ServletRequest req,ServletResponse res)

throws IOException,ServletException{

res.setContentType("text/html");

PrintWriter out=res.getWriter();

out.print("<html><body>");

out.print("<b>hello generic servlet</b>");

out.print("</body></html>");

} }

HttpServlet class

The HttpServlet class extends the GenericServlet class and implements Serializable interface. It provides http specific methods such as doGet, doPost, doHead, doTrace etc.

Methods of HttpServlet class

There are many methods in HttpServlet class. They are as follows:

public void service(ServletRequest req,ServletResponse res) dispatches the request to the protected service method by converting the request and response object into http type.
protected void service(HttpServletRequest req, HttpServletResponse res) receives the request from the service method, and dispatches the request to the doXXX() method depending on the incoming http request type.
protected void doGet(HttpServletRequest req, HttpServletResponse res) handles the GET request. It is invoked by the web container.
protected void doPost(HttpServletRequest req, HttpServletResponse res) handles the POST request. It is invoked by the web container.
protected void doHead(HttpServletRequest req, HttpServletResponse res) handles the HEAD request. It is invoked by the web container.
protected void doOptions(HttpServletRequest req, HttpServletResponse res) handles the OPTIONS request. It is invoked by the web container.
protected void doPut(HttpServletRequest req, HttpServletResponse res) handles the PUT request. It is invoked by the web container.
protected void doTrace(HttpServletRequest req, HttpServletResponse res) handles the TRACE request. It is invoked by the web container.
protected void doDelete(HttpServletRequest req, HttpServletResponse res) handles the DELETE request. It is invoked by the web container.
protected long getLastModified(HttpServletRequest req) returns the time when HttpServletRequest was last modified since midnight January 1, 1970 GMT.

DemoServlet.java

import javax.servlet.http.*;

import javax.servlet.*;

import java.io.*;

public class DemoServlet extends HttpServlet{

public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException

{

res.setContentType("text/html");//setting the content type

PrintWriter pw=res.getWriter();//get the stream to write the data

pw.println("<html><body>");

pw.println("Welcome to servlet");

pw.println("</body></html>");

pw.close();

}}

Life Cycle of a Servlet (Servlet Life Cycle)

The web container maintains the life cycle of a servlet instance. Let's see the life cycle of the servlet:

Servlet class is loaded.
Servlet instance is created.
init method is invoked.
service method is invoked.
destroy method is invoked.

As displayed in the above diagram, there are three states of a servlet: new, ready and end. The servlet is in new state if servlet instance is created. After invoking the init() method, Servlet comes in the ready state. In the ready state, servlet performs all the tasks. When the web container invokes the destroy() method, it shifts to the end state.

1) Servlet class is loaded

The classloader is responsible to load the servlet class. The servlet class is loaded when the first request for the servlet is received by the web container.

2) Servlet instance is created

The web container creates the instance of a servlet after loading the servlet class. The servlet instance is created only once in the servlet life cycle.

3) init method is invoked

The web container calls the init method only once after creating the servlet instance. The init method is used to initialize the servlet. It is the life cycle method of the javax.servlet.Servlet interface. Syntax of the init method is given below:

public void init(ServletConfig config) throws ServletException

4) service method is invoked

The web container calls the service method each time when request for the servlet is received. If servlet is not initialized, it follows the first three steps as described above then calls the service method. If servlet is initialized, it calls the service method. Notice that servlet is initialized only once. The syntax of the service method of the Servlet interface is given below:

public void service(ServletRequest req, ServletResponse res)throws ServletException,IOException

5) destroy method is invoked

The web container calls the destroy method before removing the servlet instance from the service. It gives the servlet an opportunity to clean up any resource for example memory, thread etc. The syntax of the destroy method of the Servlet interface is given below:

public void destroy()

How Servlet works?

It is important to learn how servlet works for understanding the servlet well. Here, we are going to get the internal detail about the first servlet program.

The server checks if the servlet is requested for the first time.

If yes, web container does the following tasks:

loads the servlet class.
instantiates the servlet class.
calls the init method passing the ServletConfig object

else

calls the service method passing request and response objects

The web container calls the destroy method when it needs to remove the servlet such as at time of stopping server or undeploying the project.

How web container handles the servlet request?

The web container is responsible to handle the request. Let's see how it handles the request.

maps the request with the servlet in the web.xml file.
creates request and response objects for this request
calls the service method on the thread
The public service method internally calls the protected service method
The protected service method calls the doGet method depending on the type of request.
The doGet method generates the response and it is passed to the client.
After sending the response, the web container deletes the request and response objects. The thread is contained in the thread pool or deleted depends on the server implementation.

ServletRequest Interface

An object of ServletRequest is used to provide the client request information to a servlet such as content type, content length, parameter names and values, header informations, attributes etc.

Methods of ServletRequest interface

There are many methods defined in the ServletRequest interface. Some of them are as follows:

Method	Description
public String getParameter(String name)	is used to obtain the value of a parameter by name.
public String[] getParameterValues(String name)	returns an array of String containing all values of given parameter name. It is mainly used to obtain values of a Multi select list box.
java.util.Enumeration getParameterNames()	returns an enumeration of all of the request parameter names.
public int getContentLength()	Returns the size of the request entity data, or -1 if not known.
public String getCharacterEncoding()	Returns the character set encoding for the input of this request.
public String getContentType()	Returns the Internet Media Type of the request entity data, or null if not known.
public ServletInputStream getInputStream() throws IOException	Returns an input stream for reading binary data in the request body.
public abstract String getServerName()	Returns the host name of the server that received the request.
public int getServerPort()	Returns the port number on which this request was received.

Example of ServletRequest to display the name of the user

In this example, we are displaying the name of the user in the servlet. For this purpose, we have used the getParameter method that returns the value for the given request parameter name.

index.html

Enter your name<input type="text" name="name"><br>

</form>
DemoServ.java

import javax.servlet.http.*;

import javax.servlet.*;

import java.io.*;

public class DemoServ extends HttpServlet{

public void doGet(HttpServletRequest req,HttpServletResponse res)

throws ServletException,IOException

{

res.setContentType("text/html");

PrintWriter pw=res.getWriter();

String name=req.getParameter("name");//will return value

pw.println("Welcome "+name);

pw.close();

}}

READING FORM DATA FROM SERVLETS

Reading Single Values: getParameter

To read a request (form) parameter, you simply call the getParameter method of HttpServletRequest, supplying the casesensitive parameter name as an argument. You supply the parameter name exactly as it appeared in the HTML source code, and you get the result exactly as the end user entered it; any

necessary URL-decoding is done automatically. An empty String is returned if the parameter exists but has no value (i.e., the user left the corresponding textfield empty when submitting the form), and

null is returned if there was no such parameter. Parameter names are case sensitive so, for example, request. Get Parameter ("Param1") and request. get Parameter ("param1") are not interchangeable.

Reading Multiple Values: getParameterValues

If the same parameter name might appear in the form data more than once, you should call getParameterValues (which returns an array of strings) instead of getParameter (which returns

a single string corresponding to the first occurrence of the parameter). The return value of getParameterValues is null for nonexistent parameter names and is a one element array when the

parameter has only a single value. Now, if you are the author of the HTML form, it is usually best to ensure that each textfield, checkbox, or other user interface element has a unique name. That way, you can just stick with the simpler getParameter method and avoid getParameterValues altogether. Besides, multiselectable list boxes repeat the parameter name for each selected element in the list. So, you cannot always avoid multiple values.

Looking Up Parameter Names: getParameterNames

Use getParameterNames to get this list in the form of an Enumeration, each entry of which can be cast to a String and used in a getParameter or getParameterValues call. If there are no parameters in the current request, getParameterNames returns an empty Enumeration (not null). Note that Enumeration is an interface that merely guarantees that the actual class will have hasMoreElements and nextElement methods: there is no guarantee that any particular underlying data structure will be used. And, since

some common data structures (hash tables, in particular) scramble the order of the elements, you should not count on getParameterNames returning the parameters in the order in which they appeared in the HTML form.

RequestDispatcher Interface

The RequestDispacher interface provides the facility of dispatching the request to another resource it may be html, servlet or jsp.This interface can also be used to include the content of antoher resource also. It is one of the way of servlet collaboration.There are two methods defined in the RequestDispatcher interface.

Methods of RequestDispatcher interface

The RequestDispatcher interface provides two methods. They are:

public void forward(ServletRequest request,ServletResponse response)throws ServletException,java.io.IOException:Forwards a request from a servlet to another resource (servlet, JSP file, or HTML file) on the server.
public void include(ServletRequest request,ServletResponse response)throws ServletException,java.io.IOException:Includes the content of a resource (servlet, JSP page, or HTML file) in the response.

As you see in the above figure, response of second servlet is sent to the client. Response of the first servlet is not displayed to the user.

As you can see in the above figure, response of second servlet is included in the response of the first servlet that is being sent to the client.

How to get the object of RequestDispatcher

The getRequestDispatcher() method of ServletRequest interface returns the object of RequestDispatcher. Syntax:

public RequestDispatcher getRequestDispatcher(String resource);

Example of RequestDispatcher interface

In this example, we are validating the password entered by the user. If password is servlet, it will forward the request to the WelcomeServlet, otherwise will show an error message: sorry username or password error!. In this program, we are cheking for hardcoded information. But you can check it to the database also that we will see in the development chapter. In this example, we have created following files:

index.html file: for getting input from the user.
Login.java file: a servlet class for processing the response. If password is secret, it will forward the request to the welcome servlet.
WelcomeServlet.java file: a servlet class for displaying the welcome message.
web.xml file: a deployment descriptor file that contains the information about the servlet.

index.html

Name:<input type="text" name="userName"/><br/>

Password:<input type="password" name="userPass"/><br/>

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class Login extends HttpServlet {

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html");

PrintWriter out = response.getWriter();

String n=request.getParameter("userName");

String p=request.getParameter("userPass");

if(p.equals("secret"){

RequestDispatcher rd=request.getRequestDispatcher("WelcomeServlet");

rd.forward(request, response);

}

else{

out.print("Sorry UserName or Password Error!");

RequestDispatcher rd=request.getRequestDispatcher("/index.html");

rd.include(request, response);

}

WelcomeServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class WelcomeServlet extends HttpServlet {

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html");

PrintWriter out = response.getWriter();

String n=request.getParameter("userName");

out.print("Welcome "+n);

} }

SendRedirect in servlet

The sendRedirect() method ofHttpServletResponse interface can be used to redirect response to another resource, it may be servlet, jsp or html file.It accepts relative as well as absolute URL.

It works at client side because it uses the url bar of the browser to make another request. So, it can work inside and outside the server.

Difference between forward() and sendRedirect() method

There are many differences between the forward() method of RequestDispatcher and sendRedirect() method of HttpServletResponse interface. They are given below:

forward() method	sendRedirect() method
The forward() method works at server side.	The sendRedirect() method works at client side.
It sends the same request and response objects to another servlet.	It always sends a new request.
It can work within the server only.	It can be used within and outside the server.
Example: request.getRequestDispacher("servlet2").forward(request,response);	Example: response.sendRedirect("servlet2");

Syntax of sendRedirect() method

public void sendRedirect(String URL)throws IOException;

Example:

In this example, we are redirecting the request to the google server. Notice that sendRedirect method works at client side, that is why we can our request to anywhere. We can send our request within and outside the server.

DemoServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class DemoServlet extends HttpServlet{

public void doGet(HttpServletRequest req,HttpServletResponse res)

throws ServletException,IOException

{

res.setContentType("text/html");

PrintWriter pw=res.getWriter();

response.sendRedirect("http://www.google.com");

pw.close();

}}

Creating custom google search using sendRedirect

In this example, we are using sendRedirect method to send request to google server with the request data.

index.html

<title>sendRedirect example</title>

</head><body>

</form></body></html>

MySearcher.java

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class MySearcher extends HttpServlet {

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String name=request.getParameter("name");

response.sendRedirect("https://www.google.co.in/#q="+name);

}

ServletConfig Interface

An object of ServletConfig is created by the web container for each servlet. This object can be used to get configuration information from web.xml file.

If the configuration information is modified from the web.xml file, we don't need to change the servlet. So it is easier to manage the web application if any specific content is modified from time to time.

Advantage of ServletConfig

The core advantage of ServletConfig is that you don't need to edit the servlet file if information is modified from the web.xml file.

Methods of ServletConfig interface

public String getInitParameter(String name):Returns the parameter value for the specified parameter name.
public Enumeration getInitParameterNames():Returns an enumeration of all the initialization parameter names.
public String getServletName():Returns the name of the servlet.
public ServletContext getServletContext():Returns an object of ServletContext.

Syntax:

public ServletConfig getServletConfig();

Syntax to provide the initialization parameter for a servlet

The init-param sub-element of servlet is used to specify the initialization parameter for a servlet.

<web-app>

......

<init-param>

<param-name>parametername</param-name>

<param-value>parametervalue</param-value>

</init-param>

......

</servlet>

</web-app>

Example of ServletConfig to get initialization parameter

In this example, we are getting the one initialization parameter from the web.xml file and printing this information in the servlet.

DemoServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class DemoServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html");

PrintWriter out = response.getWriter();

ServletConfig config=getServletConfig();

String driver=config.getInitParameter("driver");

out.print("Driver is: "+driver);

out.close(); } }

web.xml

<web-app>

<servlet-name>DemoServlet</servlet-name>

<servlet-class>DemoServlet</servlet-class>

<init-param>

<param-name>driver</param-name>

<param-value>sun.jdbc.odbc.JdbcOdbcDriver</param-value>

</init-param>

</servlet>

<servlet-mapping>

<servlet-name>DemoServlet</servlet-name>

<url-pattern>/servlet1</url-pattern>

</servlet-mapping>

</web-app>

Example of ServletConfig to get all the initialization parameters

In this example, we are getting all the initialization parameter from the web.xml file and printing this information in the servlet.

DemoServlet.java

import java.io.IOException;

import java.io.PrintWriter;

import java.util.Enumeration;

import javax.servlet.ServletConfig;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class DemoServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html");

PrintWriter out = response.getWriter();

ServletConfig config=getServletConfig();

Enumeration<string> e=config.getInitParameterNames();

String str="";

while(e.hasMoreElements()){

str=e.nextElement();

out.print("<br>Name: "+str);

out.print(" value: "+config.getInitParameter(str));

}

out.close();

} }

web.xml

<web-app>

<servlet-name>DemoServlet</servlet-name>

<servlet-class>DemoServlet</servlet-class>

<init-param>

<param-name>username</param-name>

<param-value>system</param-value>

</init-param>

<init-param>

<param-name>password</param-name>

<param-value>oracle</param-value>

</init-param>

</servlet>

<servlet-mapping>

<servlet-name>DemoServlet</servlet-name>

<url-pattern>/servlet1</url-pattern>

</servlet-mapping>

</web-app>

ServletContext Interface

An object of ServletContext is created by the web container at time of deploying the project. This object can be used to get configuration information from web.xml file. There is only one ServletContext object per web application.If any information is shared to many servlet, it is better to provide it from the web.xml file using the<context-param> element.

Advantage of ServletContext

Easy to maintain if any information is shared to all the servlet, it is better to make it available for all the servlet. We provide this information from the web.xml file, so if the information is changed, we don't need to modify the servlet. Thus it removes maintenance problem.

Usage of ServletContext Interface

There can be a lot of usage of ServletContext object. Some of them are as follows:

The object of ServletContext provides an interface between the container and servlet.
The ServletContext object can be used to get configuration information from the web.xml file.
The ServletContext object can be used to set, get or remove attribute from the web.xml file.
The ServletContext object can be used to provide inter-application communication.

Commonly used methods of ServletContext interface

There is given some commonly used methods of ServletContext interface.

public String getInitParameter(String name):Returns the parameter value for the specified parameter name.
public Enumeration getInitParameterNames():Returns the names of the context's initialization parameters.
public void setAttribute(String name,Object object):sets the given object in the application scope.
public Object getAttribute(String name):Returns the attribute for the specified name.
public Enumeration getInitParameterNames():Returns the names of the context's initialization parameters as an Enumeration of String objects.
public void removeAttribute(String name):Removes the attribute with the given name from the servlet context.

How to get the object of ServletContext interface

getServletContext() method of ServletConfig interface returns the object of ServletContext.
getServletContext() method of GenericServlet class returns the object of ServletContext.

Syntax:

public ServletContext getServletContext()

Syntax to provide the initialization parameter in Context scope

The context-param element, subelement of web-app, is used to define the initialization parameter in the application scope. The param-name and param-value are the sub-elements of the context-param. The param-name element defines parameter name and and param-value defines its value.

<web-app>

......

<context-param>

<param-name>parametername</param-name>

<param-value>parametervalue</param-value>

</context-param>

......

</web-app>

Example of ServletContext to get the initialization parameter

In this example, we are getting the initialization parameter from the web.xml file and printing the value of the initialization parameter. Notice that the object of ServletContext represents the application scope. So if we change the value of the parameter from the web.xml file, all the servlet classes will get the changed value. So we don't need to modify the servlet. So it is better to have the common information for most of the servlets in the web.xml file by context-param element. Let's see the simple example:

DemoServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class DemoServlet extends HttpServlet{

public void doGet(HttpServletRequest req,HttpServletResponse res)

throws ServletException,IOException

{

res.setContentType("text/html");

PrintWriter pw=res.getWriter();

//creating ServletContext object

ServletContext context=getServletContext();

//Getting the value of the initialization parameter and printing it

String driverName=context.getInitParameter("dname");

pw.println("driver name is="+driverName);

pw.close();

}}

web.xml

<web-app>

<servlet-name>servlet1</servlet-name>

<servlet-class>DemoServlet</servlet-class>

</servlet>

<context-param>

<param-name>dname</param-name>

<param-value>sun.jdbc.odbc.JdbcOdbcDriver</param-value>

</context-param>

<servlet-mapping>

<servlet-name>servlet1</servlet-name>

<url-pattern>/context</url-pattern>

</servlet-mapping>

</web-app>

Example of ServletContext to get all the initialization parameters

In this example, we are getting all the initialization parameter from the web.xml file. For getting all the parameters, we have used the getInitParameterNames() method in the servlet class.

DemoServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class DemoServlet extends HttpServlet{

public void doGet(HttpServletRequest req,HttpServletResponse res)

throws ServletException,IOException

{

res.setContentType("text/html");

PrintWriter out=res.getWriter();

ServletContext context=getServletContext();

Enumeration<string> e=context.getInitParameterNames();

String str="";

while(e.hasMoreElements()){

str=e.nextElement();

out.print("<br> "+context.getInitParameter(str));

} }}

web.xml

<web-app>

<servlet-name>servlet1</servlet-name>

<servlet-class>DemoServlet</servlet-class>

</servlet>

<context-param>

<param-name>dname</param-name>

<param-value>sun.jdbc.odbc.JdbcOdbcDriver</param-value>

</context-param>

<context-param>

<param-name>username</param-name>

<param-value>system</param-value>

</context-param>

<context-param>

<param-name>password</param-name>

<param-value>oracle</param-value>

</context-param>

<servlet-mapping>

<servlet-name> servlet1</servlet-name>

<url-pattern>/context</url-pattern>

</servlet-mapping>

</web-app>

Attribute in Servlet

An attribute is an object that can be set, get or removed from one of the following scopes:

request scope
session scope
application scope

The servlet programmer can pass informations from one servlet to another using attributes. It is just like passing object from one class to another so that we can reuse the same object again and again.

Attribute specific methods of ServletRequest, HttpSession and ServletContext interface

There are following 4 attribute specific methods. They are as follows:

public void setAttribute(String name,Object object):sets the given object in the application scope.
public Object getAttribute(String name):Returns the attribute for the specified name.
public Enumeration getInitParameterNames():Returns the names of the context's initialization parameters as an Enumeration of String objects.
public void removeAttribute(String name):Removes the attribute with the given name from the servlet context.

Example of ServletContext to set and get attribute

In this example, we are setting the attribute in the application scope and getting that value from another servlet.

DemoServlet1.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class DemoServlet1 extends HttpServlet{

public void doGet(HttpServletRequest req,HttpServletResponse res)

{

try{

res.setContentType("text/html");

PrintWriter out=res.getWriter();

ServletContext context=getServletContext();

context.setAttribute("company","IBM");

out.println("Welcome to first servlet");

out.println("<a href='servlet2'>visit</a>");

out.close();

}catch(Exception e){out.println(e);}

}}

DemoServlet2.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class DemoServlet2 extends HttpServlet{

public void doGet(HttpServletRequest req,HttpServletResponse res)

{

try{

res.setContentType("text/html");

PrintWriter out=res.getWriter();

ServletContext context=getServletContext();

String n=(String)context.getAttribute("company");

out.println("Welcome to "+n);

out.close();

}catch(Exception e){out.println(e);}

}}

web.xml

<web-app>

<servlet-name>s1</servlet-name>

<servlet-class>DemoServlet1</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>s1</servlet-name>

<url-pattern>/servlet1</url-pattern>

</servlet-mapping>

<servlet-name>s2</servlet-name>

<servlet-class>DemoServlet2</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>s2</servlet-name>

<url-pattern>/servlet2</url-pattern>

</servlet-mapping>

</web-app>

Difference between ServletConfig and ServletContext:

ServletConfig

ServletConfig available in javax.servlet.*; package
ServletConfig object is one per servlet class
Object of ServletConfig will be created during initialization process of the servlet
This Config object is public to a particular servlet only
Scope: As long as a servlet is executing, ServletConfig object will be available, it will be destroyed once the servlet execution is completed.
We should give request explicitly, in order to create ServletConfig object for the first time
In web.xml – <init-param> tag will be appear under <servlet-class> tag

ServletContext

ServletContext available in javax.servlet.*; package
ServletContext object is global to entire web application
Object of ServletContext will be created at the time of web application deployment
Scope: As long as web application is executing, ServletContext object will be available, and it will be destroyed once the application is removed from the server.
ServletContext object will be available even before giving the first request
In web.xml – <context-param> tag will be appear under <web-app> tag

So finally…….

No. of web applications = That many number of ServletContext objects [ 1 per web application ]
No. of servlet classes = That many number of ServletConfig objects

Cookies in Session Tracking

Cookie is a mechanism to maintain the state of an user. Before cookie, let's see what is sesion tracking and what are ways to perform session tracking.

Session Tracking

Session simply means a particular interval of time.

Session Tracking is a way to maintain state of an user. Http protocol is a stateless protocol. Each time user requests to the server, server treats the request as the new request. So we need to maintain the state of an user to recognize to particular user.

Why use Session Tracking?

To recognize the user.

Session Tracking Techniques

There are four techniques used in Session tracking:

Cookies
Hidden Form Field
URL Rewriting
HttpSession

1) Cookies

A cookie is a small piece of information that is persisted between the multiple client requests.A cookie has a name, a single value, and optional attributes such as a comment, path and domain qualifiers, a maximum age, and a version number.

javax.servlet.http.Cookie class provides the functionality of using cookies.

Constructor of Cookie class

Cookie(String name, String value): Constructs a cookie with a specified name and value.

Commonly used methods of Cookie class

There are given some commonly used methods of the Cookie class.

public void setMaxAge(int expiry):Sets the maximum age of the cookie in seconds.
public String getName():Returns the name of the cookie. The name cannot be changed after creation.
public String getValue():Returns the value of the cookie.
public void addCookie(Cookie ck):method of HttpServletResponse interface is used to add cookie in response object.
public Cookie[] getCookies():method of HttpServletRequest interface is used to return all the cookies from the browser.

Advantage of Cookies

Simplest technique of maintaining the state.
Cookies are maintained at client side.

Disadvantage of Cookies

It will not work if cookie is disabled from the browser.
Only textual information can be set in Cookie object.

Example of using Cookies

In this example, we are storing the name of the user in the cookie object and accessing it in another servlet. As we know well that session corresponds to the particular user. So if you access it from too many browsers with different values, you will get the different value.

index.html

Name:<input type="text" name="userName"/><br/>

FirstServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class FirstServlet extends HttpServlet {

public void doPost(HttpServletRequest request, HttpServletResponse response){

try{

response.setContentType("text/html");

PrintWriter out = response.getWriter();

String n=request.getParameter("userName");

out.print("Welcome "+n);

Cookie ck=new Cookie("uname",n);//creating cookie object

response.addCookie(ck);//adding cookie in the response

//creating submit button

out.print("<form action=' SecondServlet'>");

out.print("<input type='submit' value='go'>");

out.print("</form>");

out.close();

}catch(Exception e){System.out.println(e);}

} }

SecondServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class SecondServlet extends HttpServlet {

public void doPost(HttpServletRequest request, HttpServletResponse response){

try{

response.setContentType("text/html");

PrintWriter out = response.getWriter();

Cookie ck[]=request.getCookies();

out.print("Hello "+ck[0].getValue());

out.close();

}catch(Exception e){System.out.println(e);}

} }

2)Hidden Form Field

In case of Hidden Form Field an invisible textfield is used for maintaing the state of an user. In such case, we store the information in the hidden field and get it from another servlet. This approach is better if we have to submit form in all the pages and we don't want to depend on the browser.

Advantage of Hidden Form Field

It will always work whether cookie is disabled or not.

Disadvantage of Hidden Form Field:

It is maintained at server side.
Extra form submission is required on each pages.
Only textual information can be used.

Example of using Hidden Form Field

In this example, we are storing the name of the user in a hidden textfield and getting that value from another servlet.

index.html

Name:<input type="text" name="userName"/><br/>

FirstServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class FirstServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response){

try{

response.setContentType("text/html");

PrintWriter out = response.getWriter();

String n=request.getParameter("userName");

out.print("Welcome "+n);

//creating form that have invisible textfield

out.print("<form action='SecondServlet'>");

out.print("<input type='hidden' name="uname" value='"+n+"'>");

out.print("<input type='submit' value='go'>");

out.print("</form>");

out.close();

}catch(Exception e){System.out.println(e);}

} }

SecondServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class SecondServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

try{

response.setContentType("text/html");

PrintWriter out = response.getWriter();

//Getting the value from the hidden field

String n=request.getParameter("uname");

out.print("Hello "+n);

out.close();

}catch(Exception e){System.out.println(e);}

}

3)URL Rewriting

In URL rewriting, we append a token or identifier to the URL of the next Servlet or the next resource. We can send parameter name/value pairs using the following format:

url?name1=value1&name2=value2&??

A name and a value is separated using an equal = sign, a parameter name/value pair is separated from another parameter using the ampersand(&). When the user clicks the hyperlink, the parameter name/value pairs will be passed to the server. From a Servlet, we can use getParameter() method to obtain a parameter value.

Advantage of URL Rewriting

It will always work whether cookie is disabled or not (browser independent).
Extra form submission is not required on each pages.

Disadvantage of URL Rewriting

It will work only with links.
It can send Only textual information.

Example of using URL Rewriting

In this example, we are maintaning the state of the user using link. For this purpose, we are appending the name of the user in the query string and getting the value from the query string in another page.

index.html

<form action="FirsrServlet">

Name:<input type="text" name="userName"/><br/>

<input type="submit" value="go"/></form>

FirstServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class FirstServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response){

try{

response.setContentType("text/html");

PrintWriter out = response.getWriter();

String n=request.getParameter("userName");

out.print("Welcome "+n);

//appending the username in the query string

out.print("<a href='SecondServlet?uname="+n+"'>visit</a>");

out.close();

}catch(Exception e){System.out.println(e);}

} }

SecondServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class SecondServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

try{

response.setContentType("text/html");

PrintWriter out = response.getWriter();

//getting value from the query string

String n=request.getParameter("uname");

out.print("Hello "+n);

out.close();

}catch(Exception e){System.out.println(e);}

} }

4) HttpSession interface

In such case, container creates a session id for each user.The container uses this id to identify the particular user.An object of HttpSession can be used to perform two tasks:

bind objects
view and manipulate information about a session, such as the session identifier, creation time, and last accessed time.

How to get the HttpSession object ?

The HttpServletRequest interface provides two methods to get the object of HttpSession:

public HttpSession getSession():Returns the current session associated with this request, or if the request does not have a session, creates one.
public HttpSession getSession(boolean create):Returns the current HttpSession associated with this request or, if there is no current session and create is true, returns a new session.

Commonly used methods of HttpSession interface

public String getId():Returns a string containing the unique identifier value.
public long getCreationTime():Returns the time when this session was created, measured in milliseconds since midnight January 1, 1970 GMT.
public long getLastAccessedTime():Returns the last time the client sent a request associated with this session, as the number of milliseconds since midnight January 1, 1970 GMT.
public void invalidate():Invalidates this session then unbinds any objects bound to it.

Example of using HttpSession

In this example, we are setting the attribute in the session scope in one servlet and getting that value from the session scope in another servlet. To set the attribute in the session scope, we have used the setAttribute() method of HttpSession interface and to get the attribute, we have used the getAttribute method.

index.html

Name:<input type="text" name="userName"/><br/>

</form>

FirstServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class FirstServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response){

try{

response.setContentType("text/html");

PrintWriter out = response.getWriter();

String n=request.getParameter("userName");

out.print("Welcome "+n);

HttpSession session=request.getSession();

session.setAttribute("uname",n);

out.print("<a href='SecondServlet'>visit</a>");

out.close();

}catch(Exception e){System.out.println(e);}

} }

SecondServlet.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class SecondServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

try{

response.setContentType("text/html");

PrintWriter out = response.getWriter();

HttpSession session=request.getSession(false);

String n=(String)session.getAttribute("uname");

out.print("Hello "+n);

out.close();

}catch(Exception e){System.out.println(e);}

} }

Queue Data Structure

2023-04-14T21:28:00.003+05:30

Queue

A Queue is a linear data structure that follows a First-In-First-Out (FIFO) principle. In a queue, the first element inserted is the first element to be removed. It works like a real-life queue of people waiting to do something.

The two primary operations that can be performed on a queue are enqueue and dequeue.

enqueue: This operation adds an element to the end of the queue.

dequeue: This operation removes the element from the front of the queue.

Other operations that are often provided by a queue data structure include:

peek: This operation returns the element at the front of the queue without removing it.

isEmpty: This operation returns true if the queue is empty, and false otherwise.

size: This operation returns the number of elements currently in the queue.

Queues can be implemented using arrays, linked lists, or other data structures.

Application of Queue:

The queue data structure has many practical applications, some of which are:

Job scheduling: Queues can be used in operating systems to manage the order in which tasks are executed. Each task is added to a queue, and the operating system schedules tasks for execution in the order they were added.
Print spooling: Queues are often used to manage print jobs in computer systems. Each print job is added to a queue, and the printer processes them in the order they were added.
Call center routing: In a call center, queues are used to manage incoming calls. Calls are added to a queue, and agents take calls from the front of the queue in a first-come, first-served manner.
Breadth-first search: In graph theory, breadth-first search algorithms use queues to explore all the vertices in a graph in order of their distance from a starting vertex.
Resource sharing: Queues can be used to manage shared resources, such as network connections. Requests for the resource are added to a queue, and the resource is granted in the order the requests were received.
CPU scheduling: In computer operating systems, queues are used to schedule CPU time for processes. Each process is added to a queue, and the operating system allocates CPU time to processes in the order they were added.
Buffering: In networking and telecommunications, queues are used to buffer packets of data as they are transmitted between devices. The packets are added to a queue, and the receiving device processes them in the order they were received.

These are just a few examples of the many practical applications of the queue data structure.

Implementation of Queue in Python:

class Queue:

def __init__(self):

self.items = []

def enqueue(self, item):

self.items.append(item)

def dequeue(self):

if not self.is_empty():

return self.items.pop(0)

def peek(self):

if not self.is_empty():

return self.items[0]

def is_empty(self):

return len(self.items) == 0

def size(self):

return len(self.items)

q= Queue()

n= int(input("How many elements youn want?"))

for i in range(n):

elt=input("Enter element:")

q.enqueue(elt)

print(q.is_empty())

print(q.dequeue())

print(q.size())

print(q.peek())

In this implementation, the Queue class has a list instance variable called items to store the elements of the queue.

The enqueue() method adds an element to the end of the list using the append() method.

The dequeue() method removes and returns the first element from the list using the pop() method with an index of 0.

The peek() method returns the first element of the list without removing it.

The is_empty() method returns True if the list is empty, and False otherwise.

The size() method returns the number of elements in the list using the built-in len() function.

Arrays

2023-04-09T20:58:00.002+05:30

What is Arrays Data Structure?

An array is a data structure that stores a collection of elements of the same data type in a contiguous block of memory. Each element in the array is identified by its index or position within the array, starting from 0.

Arrays can be one-dimensional, two-dimensional, or multi-dimensional, depending on the number of indices required to access each element. One-dimensional arrays are commonly used to store a list of items, while two-dimensional arrays are used to represent a matrix or a table.

The main advantage of arrays is that they provide fast access to individual elements, as elements can be accessed in constant time using their index. This makes arrays a popular choice for storing large amounts of data that need to be accessed quickly.

Some common operations that can be performed on arrays include:

Accessing an element: An element in the array can be accessed by its index.

Inserting an element: An element can be inserted at a specific index in the array.

Deleting an element: An element can be deleted from a specific index in the array.

Searching for an element: The array can be searched for a specific element.

Arrays have a fixed size, which means that once an array is created, its size cannot be changed. If additional elements need to be added to the array, a new array must be created with a larger size and the existing elements copied over.

Applications of Arrays:

Arrays have a wide range of applications in computer programming. Here are some common applications of arrays:

Storing and accessing collections of data: One of the most common applications of arrays is to store and access collections of data. Arrays provide a fast and efficient way to access individual elements in the collection.

Sorting and searching: Arrays are frequently used in sorting and searching algorithms. For example, many sorting algorithms such as quicksort, mergesort, and heapsort use arrays as the underlying data structure.

Matrices and tables: Two-dimensional arrays are often used to represent matrices and tables. This is particularly useful in scientific and engineering applications, where matrices are commonly used to represent systems of linear equations.

Image processing: Arrays are also used in image processing applications. Images can be represented as arrays of pixels, with each pixel represented by a value that corresponds to its color.

Dynamic programming: Dynamic programming algorithms often use arrays to store intermediate results. This is particularly useful in problems where subproblems must be solved and their results combined to solve the overall problem.

Audio processing: Arrays can be used to represent audio signals. The elements of the array correspond to the values of the audio signal at each point in time.

Graphs and networks: Arrays are used to represent graphs and networks. Each element of the array corresponds to a node in the graph, and the values in the array indicate the connections between nodes.

These are just a few examples of the many applications of arrays in computer programming. Arrays are a fundamental data structure that is used in many different types of algorithms and applications.

PYTHON PROGRAM TO IMPLEMENT INSERTION AND DELETION OPERATIONS ON ARRAY

Insertion Code:

arr=[]

n=int (input("how many elements you want?"))

for i in range(n):

elt=int(input("Enter element:"))

arr.append(elt)

print("------intitial arrays-------")

for i in range(n):

print("array[",i,"]",arr[i])

pos=int(input("Enter position u want to add:"))

val=int(input("Enter element to be added:"))

j=n

arr.append(0)

n=n+1

while(j>pos):

arr[j]=arr[j-1]

j=j-1

arr[pos]=val

print("-------arrays after insertion------")

for i in range(n):

print("array[",i,"]",arr[i])

OUTPUT:

Deletion Code:

arr=[]

n=int (input("how many elements you want?"))

for i in range(n):

elt=int(input("Enter element:"))

arr.append(elt)

print("------intitial arrays-------")

for i in range(n):

print("array[",i,"]",arr[i])

pos=int(input("Enter position u want to delete:"))

j=pos

while(j<pos):

arr[j-1]=arr[j]

j=j-1

n=n-1

print("-------arrays after deletion------")

for i in range(n):

print("array[",i,"]",arr[i])

OUTPUT:

Stack

2023-04-09T20:48:00.002+05:30

What is Stack Data Structure?

In computer science, a stack is a linear data structure that allows data to be added and removed in a specific order. It is based on the principle of Last-In-First-Out (LIFO), which means that the last element added to the stack is the first one to be removed.

A stack can be visualized as a collection of items that are piled up on top of each other. The item that is added last is placed on top of the stack, while the item that is added first is at the bottom of the stack.

The main operations that can be performed on a stack are:

Push: Adds an item to the top of the stack.

Pop: Removes the item from the top of the stack.

Peek: Returns the item at the top of the stack without removing it.

IsEmpty: Returns true if the stack is empty, false otherwise.

Stacks are commonly used in programming for various applications, such as managing function calls, expression evaluation, undo/redo functionality, and more.

Implementation of Stack in Python:

CODE:

class Stack:

def __init__(self):

self.items=[]

def isEmpty(self):

return self.items==[]

def push(self,item):

self.items.append(item)

def pop(self):

return self.items.pop()

def peek(self):

return self.items[len(self.items)-1]

def size(self):

return self.items

def getelements(self):

return self.items

s= Stack()

n= int(input("How many elements youn want?"))

for i in range(n):

elt=input("Enter element:")

s.push(elt)

print(s.getelements())

print(s.isEmpty())

print(s.pop())

print(s.size())

print(s.peek())

OUTPUT:

Binary Search

2023-04-08T21:02:00.001+05:30

What is Binary Search?

Binary search is a search algorithm used to find the position of a target value within a sorted array. The algorithm works by repeatedly dividing the array in half and eliminating the half of the array that cannot contain the target element until the target element is found or the search ends with an empty subarray.

Here are the steps of the binary search algorithm:

Define the search range: Initialize two pointers, low and high, to the start and end of the array, respectively.

Find the middle element: Calculate the middle index of the array as the average of the low and high pointers.

Compare the target element with the middle element: If the target element matches the middle element, return the index of the middle element. If the target element is less than the middle element, discard the upper half of the array and repeat the search on the lower half. If the target element is greater than the middle element, discard the lower half of the array and repeat the search on the upper half.

Repeat steps 2-3 until the target element is found or the search range is empty.

Here is an example of the binary search algorithm in action:

Suppose we have the following sorted array:

[2, 5, 7, 8, 12, 16, 21, 23, 27, 31]

We want to find the position of the element 16.

Define the search range: low=0, high=9.

Find the middle element: middle=4 (integer division of (low+high)/2).

Compare the target element with the middle element: 16>12, discard the lower half of the array [2, 5, 7, 8, 12].

Define the new search range: low=middle+1=5, high=9.

Find the middle element: middle=7.

Compare the target element with the middle element: 16>23, discard the upper half of the array [21, 23, 27, 31].

Define the new search range: low=5, high=6.

Find the middle element: middle=5.

Compare the target element with the middle element: 16=16, return the index 5.

The binary search algorithm has a time complexity of O(log n) since the search range is divided in half at each step. This makes it a very efficient algorithm for large arrays compared to linear search, which has a time complexity of O(n). However, binary search requires a sorted array as input, which can be an additional cost if the array is not already sorted.

Binary Search implementation in python

Here's an implementation of binary search in Python:

def binary_search(arr, target):

low = 0

high = len(arr) - 1

while low <= high:

mid = (low + high) // 2

if arr[mid] == target:

return mid

elif arr[mid] < target:

low = mid + 1

else:

high = mid - 1

return -1 # Target not found

arr = [2, 5, 7, 8, 12, 16, 21, 23, 27, 31]

target = 16

print(binary_search(arr, target)) # Output: 5

Searching Techniques

2023-04-08T20:56:00.001+05:30

Searching Techniques

Searching is a fundamental operation in data structures and algorithms. It involves finding the location of a particular element in a data structure, such as an array, a linked list, a tree, or a hash table. Different data structures may require different searching techniques, depending on the structure of the data and the requirements of the problem.

Here are some commonly used searching techniques in data structures:

1. Linear search: Also known as sequential search, this technique involves examining each element of the data structure one by one until the target element is found. It is a simple and easy-to-implement algorithm, but it can be slow for large datasets.

2. Binary search: This technique is used for sorted arrays and requires dividing the array into two halves repeatedly until the target element is found. It has a time complexity of O(log n), which is much faster than linear search.

3. Hashing: This technique involves using a hash function to map the key of the element to a specific index in a hash table. The element can then be searched for in constant time, O(1), on average. However, collisions can occur if two or more elements map to the same index, which requires resolving the collision.

4. Depth-first search (DFS): This technique is used for searching through a graph or a tree data structure. It involves traversing each branch of the structure as far as possible before backtracking and trying the next branch. It can be implemented recursively or iteratively.

5. Breadth-first search (BFS): This technique is also used for searching through a graph or a tree data structure. It involves visiting all the nodes at the same level before moving on to the next level. It can also be implemented recursively or iteratively.

6. Interpolation search: This technique is used for uniformly distributed sorted arrays. It involves using an interpolation formula to estimate the position of the target element based on its value and the values of the endpoints of the array. It has a time complexity of O(log log n) in the best case and O(n) in the worst case.

7. Exponential search: This technique is used for unbounded or unknown size arrays. It involves finding a range that the target element might be in, doubling the range size until the target element is within that range, and then performing a binary search within the range. It has a time complexity of O(log n).

These are some of the most commonly used searching techniques in data structures. Choosing the right technique depends on the structure of the data and the requirements of the problem.

EMOTION DETECTION USING TEXT & FACE

2023-04-08T20:44:00.004+05:30

EMOTION DETECTION USING TEXT & FACE

Emotional Detection as a process of identifying human emotion from any form of written text.

Due to the advanced use of NLP, machine learning, and computational linguistics for extracting emotion and satisfaction relevance in text analysis, this tool has become a prevalent topic for research studies.

While Sentiment Analysis (link) seeks to obtain a polarity from the text, that is, to gauge if a sentiment expressed is positive, negative, or neutral, Emotion Analysis takes it a step further.

It provides us an insight into the underlying reasons for the sentiment output: happy, sad, angry, confusion, curiosity, and so on.

For example, here are three sentences:

● I want to return this product, maybe order a replacement.

● This is not a friendly product.

● I hate this product; not useful at all.

Although all three sentences deliver us with the same sentiment, which is negative, when we examine the emotion behind each sentence, it is quite different.

According to this, the approach to customer service would also be very different and should be handled by marketers and client support teams in distinct ways.

What is the significance of using Emotion Analysis?

During interactions over digital media, emotions become a significant component in the communication between people of different cultural languages.

Generally, we can divide emotions into six types which are:

joy, surprise, love, anger, sadness, and fear.

In the context of written text, emotions may be expressed by a single word, for example,

- Great.

- Nope.

- Recommend.

Or it can be a group of words,

- This is great!

- Nope, won’t buy again!

- Definitely recommend this product!

Thus, phrase- and sentence-level emotion analysis methods play a vital role in tracking emotions or questing the indications for recognizing emotions.

A document always consists of sentences that have words or phrases.

The detection of emotions from word level, phrase level, and document level is very complex.

But at the same time, it is highly crucial for an accurate simulation of customer behavior.

The fast-flowing internet services have facilitated increased online communication and written content over the websites.

That has led to the flow of large amounts of online content rich in user opinions and varies across digital platforms.

The exchange of emotions through plain text, messages, tweet posts, comments, etc.,

Emotion Detection will play a promising role in the field of Artificial Intelligence, especially in the case of Human-Machine Interface development.

For Emotion Detection from an artificial intelligence, different parameters should be taken into consideration.

Various types of techniques are used to detect emotions from a human being like facial expressions, body movements, blood pressure, heart beat and textual information.

This paper focuses on the emotion detection from textual information There are four basic methods to detect emotions from text:

1) Keyword based detection,

2) Learning-based detection,

3) Lexical affinity method,

4) Hybrid detection.

Each and every method contains some strong and weak points while detecting emotions from text.

Hybrid Method is the most likely method to get a high accuracy result, as it includes the combined strength of two or more methods.

The main difficulty is to find the most effective combination.

Tools we need :-

Anaconda :

Packages of multiple libraries and IDEs IDEs

Jupyter notebook VSCode

Install these libraries (we need to install after anaconda being installed)

1)Package NRCLex (lexicon-based methods) NRC = National Research Canada

Pip install NRCLex

2)DeepFace (for deep learning models implementation) - Pre-trained models

Pip install deepface 3)Opencv

Pip install opencv-python

Examples or Applications

There are four basic methods to detect emotions fromtext:

1)Keyword- based detection,

2)learning-based detection,

3)lexical affinity method,hybrid detection.

Each and every method contains some strong and weak points while detecting emotions from text.

It uses facial expressions to identify parts of an image or video to determine age, gender and emotions.

This technology can be applied to fields like security, biometrics, law enforcement, etc., for tracking and surveillance purposes.

NLP Project Ideas

2023-04-08T20:14:00.007+05:30

NLP Project Ideas

NLP stands for Natural Language Processing. It is a subfield of artificial intelligence (AI) and linguistics that focuses on the interaction between computers and human language.

In other words, NLP involves teaching computers to understand, interpret, and generate human language. This includes tasks such as text classification, sentiment analysis, machine translation, speech recognition, and more.

NLP algorithms use a combination of machine learning, deep learning, and statistical techniques to analyze and understand natural language data. The goal of NLP is to enable computers to understand human language in a way that allows them to perform tasks such as responding to spoken commands, generating text, or translating between languages.

NLP has a wide range of applications, from chatbots and virtual assistants to sentiment analysis for customer feedback and automated translation for international communication.

Full Video Playlist for NLP Projects :

NLP Projects

Here are some NLP project ideas:

1. Sentiment analysis of customer reviews:

Build a model that can analyze customer reviews of a product or service and determine the sentiment expressed in the text. This could be used by companies to monitor their reputation and make improvements based on customer feedback.

Twitter Hashtag Sentiment Analysis

2023-04-08T20:00:00.005+05:30

Twitter Hashtag Sentiment Analysis

Twitter is what's happening and what people are talking about right now. It is a global platform for public self-expression and conversation in real-time. It provides a network that connects users to people, information, ideas, opinions, and news.

This project provides different functions to analyze tweets and segregate them on the basis of the sentiment of each tweet. We can search for any Twitter hashtag and any number of tweets. Using this we can get an overview of people’s reactions to many topics and events. It can also help Data Analysts for getting information out of a particular hashtag.

The language used for creating this project in Python.

Introduction:

Sentiment analysis is a natural language processing technique that involves the use of algorithms and machine learning models to identify, extract, and classify subjective information from text, such as opinions, attitudes, emotions, and feelings. It is used to analyze the sentiment or tone of a piece of text, typically by categorizing it as positive, negative, or neutral.

Sentiment analysis is commonly used in various applications, including customer feedback analysis, brand reputation management, social media monitoring, political analysis and market research.

Overall, sentiment analysis is a valuable tool for businesses, researchers, and individuals who want to gain insights into how people feel and think about a particular topic or brand.

On Twitter, a hashtag is a word or phrase preceded by the hash symbol (#) that is used to identify a specific topic or theme. When a user includes a hashtag in their tweet, it makes it easier for others to discover and join in on the conversation about that topic. Users can click on a hashtag to view all tweets that include that specific hashtag, even if they don't follow the user who tweeted it.

Hashtags can also be used to participate in or follow specific events, campaigns, or social movements on Twitter. They can help to increase the reach and visibility of a tweet and make it more likely to be seen by a larger audience.

Libraries Used:

nltk: The Natural Language Toolkit (NLTK) is a platform used for building Python programs that work with human language data for applying in statistical natural language processing (NLP). It contains text processing libraries for tokenization, parsing, classification, stemming, tagging and semantic reasoning.

snscrape: Snscrape is a scraper for social networking services (SNS). It scrapes things like user profiles, hashtags, or searches and returns the discovered items.

googletrans: Googletrans is a free and unlimited python library that implemented Google Translate API. This uses the Google Translate Ajax API to make calls to such methods as detect and translate.

string: String module contains some constants, utility function, and classes for string manipulation.

re: A Regular Expressions (RegEx) is a special sequence of characters that uses a search pattern to find a string or set of strings.

wordcloud: Word Cloud is a data visualization technique used for representing text data in which the size of each word indicates its frequency or importance.

matplotib: Matplotlib is a comprehensive library for creating static, animated, and interactive visualizations in Python.

tkinter: Tkinter is the standard GUI library for Python. Python when combined with Tkinter provides a fast and easy way to create GUI applications.

Code(sentimentAnalysis.py):

import snscrape.modules.twitter as sntwitter

from googletrans import Translator

import string

import re

from wordcloud import WordCloud

import matplotlib.pyplot as plt

from nltk.corpus import stopwords

from nltk.tokenize import word_tokenize

from nltk.sentiment.vader import SentimentIntensityAnalyzer

def stop_word_removal(sent):

stop_words = set(stopwords.words("english"))

word_tokens = word_tokenize(sent)

swr = [word for word in word_tokens if word.lower() not in stop_words]

clear = ' '.join(swr)

return clear

# Extracting Tweets and translating them in English

def orig_tweets(hashtag, num):

tweets = []

translator = Translator()

for tweet in sntwitter.TwitterSearchScraper(hashtag).get_items():

if len(tweets) == num:

break

else:

translated = translator.translate(tweet.rawContent, dest="en")

tweets.append(translated.text)

return tweets

# Cleaning the extracted tweets

def clean_tweets(tweets):

cleared = []

for i in range(len(tweets)):

sent = tweets[i]

lower_case = sent.lower()

lower_case = stop_word_removal(lower_case)

cleaning = lower_case.translate(str.maketrans('', '', string.punctuation))

cleaning = re.sub(r'@[A-Za-z0-9]+', '', cleaning)

cleaning = re.sub(r'#', '', cleaning)

cleaning = re.sub(r'RT[\s]+', '', cleaning)

cleaning = re.sub(r'https?:\/\/\S+', '', cleaning)

cleared.append(cleaning)

return cleared

# Performing sentiment analysis on the cleaned Tweets

def senti(ctweets):

sent_analyzer = SentimentIntensityAnalyzer()

sentimentsList = []

for text in ctweets:

analysis = sent_analyzer.polarity_scores(text)

sentiment = analysis["compound"]

sentimentsList.append(sentiment)

return sentimentsList

# Segregating tweets into Positive, Negative and Neutral

def segregate_tweets(sen, tweets):

positive = []

posiPol = []

negative = []

negPol = []

neutral = []

neutPol = []

for i in range(len(sen)):

if sen[i] >= 0.5:

posiPol.append(sen[i])

positive.append(tweets[i])

elif sen[i] <= -0.5:

negPol.append(sen[i])

negative.append(tweets[i])

else:

neutPol.append(sen[i])

neutral.append(tweets[i])

return positive, posiPol, negative, negPol, neutral, neutPol

# For plotting a bar graph

def bar_graph(p, ne, n, h):

values = [p, ne, n]

attributes = ["Positive", "Neutral", "Negative"]

plt.figure(figsize=(10, 5))

plt.bar(attributes, values, color='maroon', width=0.4)

plt.title("Bar Graph of #" + h)

plt.xlabel("Emotions")

plt.ylabel("Number of Tweets")

plt.show()

# For plotting a pie chart

def pie_chart(p, ne, n, h):

values = [p, ne, n]

attributes = ["Positive", "Neutral", "Negative"]

plt.title("Pie distribution of #" + h)

plt.pie(values, labels=attributes, autopct='%2.1f%%')

plt.show()

# For creating a word cloud

def word_cloud(text):

wordcloud = WordCloud(width=800, height=400, random_state=21, max_font_size=110).generate(text)

plt.figure(figsize=(10, 5))

plt.imshow(wordcloud, interpolation="bilinear")

plt.axis('off')

plt.show()

Code(analysisWindow.py)

from tkinter import *

from tkinter import messagebox

import sentimentAnalysis as sa

window = Tk()

window.title("Twitter Sentiment Analysis")

window.geometry('530x250')

positive_tweets = []

negative_tweets = []

neutral_tweets = []

all_words = ""

hashtag_label = Label(window, text="Enter a Twitter Hashtag", fg="blue", font=("Arial", 16))

hashtag_label.grid(row=0, column=0, padx=10, pady=10)

hashtag = Entry(window, background="white", fg="black", font=("Arial", 16))

hashtag.grid(row=0, column=1, padx=10, pady=10)

num_label = Label(window, text="Number of Tweets", fg="blue", font=("Arial", 16))

num_label.grid(row=1, column=0, padx=10, pady=10)

tweet_num = Entry(window, background="white", fg="black", font=("Arial", 16))

tweet_num.grid(row=1, column=1, padx=10, pady=10)

def analyzing():

try:

global all_words, positive_tweets, neutral_tweets, negative_tweets

hash_text = hashtag.get()

num = int(tweet_num.get())

tweets = sa.orig_tweets(hash_text, num)

cleaned_tweets = sa.clean_tweets(tweets)

all_words = ' '.join(cleaned_tweets)

polarity = sa.senti(cleaned_tweets)

positive_tweets, positive_polarity, negative_tweets, negative_polarity, neutral_tweets, neutral_polarity = sa.segregate_tweets(polarity, tweets)

sa.bar_graph(len(positive_tweets), len(neutral_tweets), len(negative_tweets), hash_text)

sa.pie_chart(len(positive_tweets), len(neutral_tweets), len(negative_tweets), hash_text)

except:

messagebox.showerror("Error", "Wrong Input")

analyze = Button(window, text="Analyze", fg="red", background="yellow", font=("Arial", 16), command=analyzing)

analyze.grid(row=3, column=1, padx=10, pady=10)

def show_tweets():

win = Tk()

win.title("Tweets")

win.geometry('1000x650')

main_frame = Frame(win)

main_frame.pack(fill=BOTH, expand=1)

canvas = Canvas(main_frame)

canvas.pack(side=LEFT, fill=BOTH, expand=1)

scbar = Scrollbar(main_frame, orient=VERTICAL, command=canvas.yview)

scbar.pack(side=RIGHT, fill=Y)

canvas.configure(yscrollcommand=scbar.set)

canvas.bind('<Configure>', lambda e: canvas.configure(scrollregion=canvas.bbox("all")))

second_frame = Frame(canvas)

canvas.create_window((0, 0), window=second_frame, anchor="nw")

l1 = "Positive Tweets(" + str(len(positive_tweets)) + ")"

l2 = "Negative Tweets(" + str(len(negative_tweets)) + ")"

l3 = "Neutral Tweets(" + str(len(neutral_tweets)) + ")"

posi_list = "Tweet--> " + '\nTweet--> '.join(positive_tweets)

neg_list = "Tweet--> " + '\nTweet--> '.join(negative_tweets)

neu_list = "Tweet--> " + '\nTweet--> '.join(neutral_tweets)

p_label = Label(second_frame, text=l1, fg="green", font=("Arial", 18), background="yellow")

p_label.grid(row=0, column=0, padx=10, pady=10)

p_tweets = Text(second_frame, fg="black", font=("Arial", 16), background="white")

p_tweets.grid(row=1, column=0, padx=10, pady=10)

p_tweets.insert("1.0", posi_list)

n_label = Label(second_frame, text=l2, fg="red", font=("Arial", 18), background="black")

n_label.grid(row=2, column=0, padx=10, pady=10)

n_tweets = Text(second_frame, fg="black", font=("Arial", 16), background="white")

n_tweets.grid(row=3, column=0, padx=10, pady=10)

n_tweets.insert("1.0", neg_list)

nu_label = Label(second_frame, text=l3, fg="blue", font=("Arial", 18), background="lightblue")

nu_label.grid(row=4, column=0, padx=10, pady=10)

nu_tweets = Text(second_frame, fg="black", font=("Arial", 16), background="white")

nu_tweets.grid(row=5, column=0, padx=10, pady=10)

nu_tweets.insert("1.0", neu_list)

see_tweets = Button(window, text="Show Tweets", fg="black", background="green", font=("Arial", 16), command=show_tweets)

see_tweets.grid(row=4, column=0, padx=10, pady=10)

def show_word_cloud():

if len(all_words) > 0:

sa.word_cloud(all_words)

else:

messagebox.showwarning("Warning", "Analyze a hashtag first")

wordCloud = Button(window, text="Word Cloud", fg="black", background="lightblue", font=("Arial", 16), command=show_word_cloud)

wordCloud.grid(row=4, column=1, padx=10, pady=10)

window.mainloop()

Output:

After entering the hashtag and the number press analyze.

Right after the analyzing process is finished the bar graph and pie chart is presented.

For viewing all the tweets press Show Tweets button.

And for a wordcloud of the data press Wordcloud button.

Conclusion:

The code performs well and deliver the desired output. If the data is large the speed of process will be slow. Overall, it is fit for conducting sentiment analysis at a small level.