Question

Develop a program to display the name and roll_no of student from "student table" having percentage >70.

Answer 1

Explanation:

A Database Management System (DBMS) provides mechanisms for storing, organizing, retrieving and modifying data from a database. Today, most databases are relational databases. Some popular relational database systems are Microsoft SQL Server, Oracle, Sybase, Mysql etc.

A language called Structured Query Language (SQL) pronounced “sequel” is the standard language used with relational databases to execute queries and to manipulate data. Several applications store their data in a database. Hence, a java program has to communicate with the database to access and manipulate the data. This is possible using the JDBC API. The JDBC API is a Java API that can access any kind of tabular data, especially data stored in a relational database.

JDBC API

The Java Database Connectivity Application Programming Interface is a set of specifications and specifies the process how a Java program can communicate with the database. This API contains set of classes and Interfaces to enable programmers to communicate with a database using java.

To be more specific, it defines how an application opens a connection, communicates with the database, executes SQL statements and retrieves the results. Using JDBC, an application can access virtually any data source in a platform-independent manner.

What does the JDBC API do?

The JDBC API makes it possible to do three things:

Establish a connection with a data source.

Send queries and update statements to the data source.

Process the result.

NOTE: To use JDBC, you need to install a database that is compatible with JDBC. Several databases are available which you can install. For example: postgreSQL, Oracle,MySQL etc.

For each database, the appropriate driver should be installed. The installation procedure and the settings vary from vendor to vendor. Please consult the documentation for this purpose.

Read more: http://mrbool.com/jdbc-basics-how-to-deal-with-databases-in-java/28087#ixzz610tW05nc