<dependency>
<groupId>com.enklib</groupId>
<artifactId>enklib-sql</artifactId>
<version>1.0.0</version>
</dependency>
groovy
implementation 'com.enklib:enklib-sql:1.0.0'
import com.enklib.sql.DbConnection;
public class Example {
public static void main(String[] args) {
DbConnection connection = new DbConnection();
connection.setUrl("jdbc:mysql://localhost:3306/example");
connection.setUsername("username");
connection.setPassword("password");
connection.connect();
}
}
import com.enklib.sql.DbConnection;
import com.enklib.sql.DbResult;
public class Example {
public static void main(String[] args) {
DbConnection connection = new DbConnection();
String sql = "SELECT * FROM customers";
DbResult result = connection.executeQuery(sql);
while (result.next()) {
int id = result.getInt("id");
String name = result.getString("name");
String email = result.getString("email");
System.out.println("ID: " + id);
System.out.println("Name: " + name);
System.out.println("Email: " + email);
}
result.close();
connection.close();
}
}
