Skip to main content

What are JDBC and ODBC? Write a java program using JDBC to extract name of those students who live in Morang district, assuming that student table has four attributes (ID, name, district, and age).

 JDBC (Java Database Connectivity) and ODBC (Open Database Connectivity) are application programming interfaces (APIs) that allow Java and other programming languages to interact with databases.

Here's an example Java program that uses JDBC to extract the names of students who live in Morang district, assuming that the student table has four attributes (ID, name, district, and age):

import java.sql.*;

public class StudentList {
    public static void main(String[] args) {
        try {
            // load the JDBC driver
            Class.forName("com.mysql.jdbc.Driver");

            // create a connection to the database
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "username", "password");

            // create a statement object
            Statement stmt = conn.createStatement();

            // execute the SQL query
            ResultSet rs = stmt.executeQuery("SELECT name FROM student WHERE district='Morang'");

            // iterate through the result set and print the names of the students
            while (rs.next()) {
                String name = rs.getString("name");
                System.out.println(name);
            }

            // close the resources
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception e) {
            System.err.println("Exception: " + e.getMessage());
        }
    }
}

This program loads the JDBC driver, creates a connection to the database, creates a statement object, and executes an SQL query to select the names of the students who live in Morang district. The program then iterates through the result set and prints the names of the students. Finally, the program closes the resources (result set, statement, and connection).

Note that you will need to replace the jdbc:mysql://localhost:3306/mydb URL with the URL of your own database, and replace the username and password with your own database credentials. Also, you will need to include the JDBC driver JAR file in your classpath.

Comments

Popular posts from this blog

Write a program using the algorithm count() to count how many elements in a container have a specified value.

 Here's an example program using the count() algorithm to count the number of occurrences of a specific value in a vector container: #include <iostream> #include <vector> #include <algorithm> using namespace std; int main() {     vector<int> numbers = { 2, 5, 3, 7, 8, 5, 1, 5, 4 };          // count the number of occurrences of the value 5 in the vector     int count = count(numbers.begin(), numbers.end(), 5);          cout << "The number of occurrences of 5 in the vector is: " << count << endl;          return 0; } Output: The number of occurrences of 5 in the vector is: 3 Explanation: The program starts by creating a vector named numbers that contains several integer values. The count() algorithm is used to count the number of occurrences of the value 5 in the numbers vector. The function takes three arguments: the beginning and end iterators of...

What are Stub and Skeleton in Distributed Application? Explain its function with block diagram.

 Stub and Skeleton are two important components of distributed applications. A distributed application is a software system that runs on multiple computers connected through a network. It allows users to access resources and services on different computers as if they were on a local computer. In a distributed application, a client program on one computer sends a request to a server program on another computer. The server program processes the request and sends a response back to the client program. Stub and Skeleton help to facilitate this communication between the client and server programs. A Stub is a client-side proxy that represents the remote object on the client machine. It acts as a gateway for the client to communicate with the server. When a client invokes a method on the Stub, it marshals the arguments and sends them to the server over the network. The Stub then waits for the server to send a response. When the response is received, the Stub unmarshals the data and retur...

Explain the lifecycle of Servlet with block diagram.

 The lifecycle of a Servlet can be divided into several stages. Here's a block diagram that illustrates the different stages: Servlet API: The Servlet API provides a standard set of interfaces and classes for creating and interacting with Servlets. It is typically included in the web application's classpath as a JAR file. Servlet Container: The Servlet Container is a web server or application server that implements the Servlet API. It provides a runtime environment for executing Servlets and manages their lifecycle. Servlet Class: The Servlet Class is the Java class that implements the javax.servlet.Servlet interface. It contains the logic for processing HTTP requests and generating HTTP responses. init(): The init() method is called once when the Servlet is first loaded by the Servlet Container. It is used for initialization tasks, such as setting up database connections, loading configuration settings, or initializing other resources that will be used by the Servlet. service(...