
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class JDBCSelectAsListExample {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String url ="jdbc:mysql://localhost:3306/my_uat";
String userName="root";
String password ="root123";
String selectQuery ="Select data from my_table";
Connection connection = DriverManager.getConnection(url,userName,password);
PreparedStatement preparedStatement = connection.prepareStatement(selectQuery);
List<String> dataList = new ArrayList<>();
ResultSet resultSet = preparedStatement.executeQuery();
//Converting resultSet to ArrayList
while(resultSet.next()) {
dataList.add(resultSet.getString(1));
}
//Print ArrayList
System.out.println(dataList);
}
}
Output:
[Europe, Asia, America]
Provide Feedback For This Article
We take your feedback seriously and use it to improve our content. Thank you for helping us serve you better!
😊 Thanks for your time, your feedback has been registered!
Comments & Discussion
Facing issues? Have questions? Post them here! We're happy to help!