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...

write a program in C++ to overload '-' operator to find difference of two complex object.

write a program to overload '-' operator to find difference of two complex object /* program in C++ to overload '-' operator to find difference of two complex object */ #include<iostream> using namespace std; class Complex{     public:     float a, b;     complex(): a(0), b(0) {}     complex(float x, float y): a(x), b(y){}     void display(){          cout<<this->a<<"+"<<this->b<<"i"<<endl;     }     friend Complex operator-(const Complex&, const Complex&); }; complex operator-(const Complex& com, const Complex& comp){     float x= com.a - comp.a;     foat y= com.b - comp.b;     return Complex(x,y); } int main(){     Complex a(1,7), b(6,9);     cout<<"A = ";a.display();      cout<<"B = ";b.display();      cout<<"A - B = ";(a-b).display(); ...

what is static data member and static member function? how can we overload a function?

what is static data member and static member function? how can we overload a function? A static data member in C++ is a class variable that is shared among all objects of a class and is defined using the 'static' keyword. It has a single instance for the entire class, and its value is shared by all objects of that class. Unlike non-static class members, a static data member can be accessed without creating an instance of the class. A static member function in C++ is a member function of a class that can be called without creating an instance of the class. Like static data members, a static member function operates on the class as a whole rather than on individual objects. A static member function can only access static data members on other static member functions of the same class. To overload a function in C++, you create multiple functions with the same name but different parameter lists. The correct function to call is determined at compile-time based on the number and type...