How to retrive a single data from a database

Question Posted / mehtav singh

1 Answers
1322 Views
MCN Solutions, I also Faced
E-Mail Answers

How to retrive a single data from a database..

Answer / Ankit Chaturvedi

To retrieve a single row (or record) of data from a database, you typically execute a SQL SELECT statement that includes the WHERE clause to filter the results. Here's an example using Java and JDBC:

```java
import java.sql.*;

public class SingleDataQuery {
public static void main(String[] args) throws Exception {
String url = "jdbc:mysql://localhost/myDatabase";
String user = "username";
String password = "password";
String query = "SELECT * FROM myTable WHERE id = 123"; // Replace 'id' and '123' with the appropriate column name and value.

Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(query);

if (rs.next()) {
System.out.println("ID: " + rs.getInt("id"));
System.out.println("Name: " + rs.getString("name"));
// Print other columns as needed
} else {
System.out.println("No data found.");
}
}
}