<dependency>
<groupId>org.enklib</groupId>
<artifactId>enklib-sql</artifactId>
<version>1.0.0</version>
</dependency>
import org.enklib.sql.*;
import org.enklib.sql.entity.*;
import org.enklib.sql.mapper.*;
public class Main {
public static void main(String[] args) {
SQLSessionFactory factory = new SQLSessionFactory();
factory.setDriverClassName("com.mysql.jdbc.Driver");
factory.setUrl("jdbc:mysql://localhost:3306/mydatabase");
factory.setUsername("root");
factory.setPassword("password");
SQLSession session = factory.openSession();
SQLMapper<ExampleEntity> mapper = new SQLMapper<>(ExampleEntity.class);
SQLBuilder builder = new SQLBuilder();
builder.select()
.from("example_table")
.where("id = ?")
.orderBy("name ASC")
.limit(10);
SQLQueryResult<ExampleEntity> result = session.execute(builder, mapper);
List<ExampleEntity> entities = result.getEntities();
for (ExampleEntity entity : entities) {
System.out.println(entity.getId() + " " + entity.getName());
}
session.close();
}
}
