Java में MySQL टेबल से सूची बनाने का तरीका

समाधान

Java में ArrayList का उपयोग करके परिणाम सेट को सूची में बदलें।

सिंटैक्स

ArrayList> variable = new ArrayList>();

उदाहरण

टेबल बनाएं:

mysql> CREATE TABLE demo10 (
    -> id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    -> name VARCHAR(20)
    -> );
mysql> INSERT INTO demo10 (name) VALUES ('John'), ('Bob'), ('David');

Java कोड

import java.sql.*;
import java.util.ArrayList;
import com.mysql.jdbc.Statement;

public class ListInListDemo {
  public static void main(String[] args) {
    Connection con = null;
    Statement statement = null;
    try {
      ArrayList> outer = new ArrayList>();
      Class.forName("com.mysql.jdbc.Driver");
      con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sampledatabase", "root", "123456");
      statement = (Statement) con.createStatement();
      String sql = "SELECT * FROM demo10";
      ResultSet rs = statement.executeQuery(sql);
      while (rs.next()) {
        ArrayList inner = new ArrayList();
        inner.add(rs.getString("name"));
        outer.add(inner);
      }
      System.out.println("The names are as follows:");
      for (int i = 0; i < outer.size(); i++) {
        System.out.println(outer.get(i));
      }
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}

आउटपुट

The names are as follows:
[John]
[Bob]
[David]