<dependency>
<groupId>com.enklib</groupId>
<artifactId>enklib-sql</artifactId>
<version>1.0.0</version>
</dependency>
properties
db.url=jdbc:mysql://localhost:3306/mydatabase
db.username=root
db.password=123456
import com.enklib.sql.SqlExecutor;
import com.enklib.sql.SqlRow;
public class DatabaseUtil {
private static final SqlExecutor sqlExecutor = new SqlExecutor();
public static void main(String[] args) {
String query = "SELECT * FROM users";
SqlRow[] rows = sqlExecutor.queryRows(query);
for (SqlRow row : rows) {
String name = row.getString("name");
int age = row.getInt("age");
System.out.println("Name: " + name + ", Age: " + age);
}
}
}
bash
javac DatabaseUtil.java
java DatabaseUtil