<dependency>
<groupId>org.enklib</groupId>
<artifactId>enklib-sql</artifactId>
<version>1.0.0</version>
</dependency>
import org.enklib.sql.EnklibSqlConnection;
import org.enklib.sql.EnklibSqlException;
public class DatabaseConnector {
public static EnklibSqlConnection getConnection() throws EnklibSqlException {
String driver = "com.mysql.cj.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
return new EnklibSqlConnection(driver, url, username, password);
}
}
import org.enklib.sql.EnklibSqlException;
import org.enklib.sql.EnklibSqlQueryResult;
import org.enklib.sql.EnklibSqlStatement;
public class UserDao {
public List<User> getUsers() throws EnklibSqlException {
List<User> userList = new ArrayList<>();
EnklibSqlConnection connection = DatabaseConnector.getConnection();
try {
EnklibSqlStatement statement = connection.createStatement();
String queryString = "SELECT * FROM users";
EnklibSqlQueryResult result = statement.executeQuery(queryString);
while (result.next()) {
int id = result.getInt("id");
String name = result.getString("name");
User user = new User(id, name);
userList.add(user);
}
} finally {
connection.close();
}
return userList;
}
}
