<dependency>
<groupId>com.enklib</groupId>
<artifactId>enklib-sql</artifactId>
<version>1.0.0</version>
</dependency>
properties
db.url=jdbc:mysql://localhost:3306/mydb
db.username=root
db.password=secret
import com.enklib.sql.DataColumn;
import com.enklib.sql.DataRow;
import com.enklib.sql.DataTable;
import com.enklib.sql.SqlConnection;
import com.enklib.sql.SqlExecuter;
import java.sql.SQLException;
import java.util.List;
public class Person {
private int id;
private String name;
private int age;
public static void save(Person person) throws SQLException {
try (SqlConnection connection = new SqlConnection()) {
connection.openConnection();
SqlExecuter executer = new SqlExecuter(connection);
DataRow dataRow = new DataRow();
dataRow.addColumn(new DataColumn("name", person.getName()));
dataRow.addColumn(new DataColumn("age", person.getAge()));
executer.insert("person", dataRow);
}
}
public static List<Person> getAll() throws SQLException {
try (SqlConnection connection = new SqlConnection()) {
connection.openConnection();
SqlExecuter executer = new SqlExecuter(connection);
DataTable dataTable = executer.select("person");
List<DataRow> rows = dataTable.getRows();
List<Person> persons = new ArrayList<>();
for (DataRow row : rows) {
Person person = new Person();
person.setId(row.getInt("id"));
person.setName(row.getString("name"));
person.setAge(row.getInt("age"));
persons.add(person);
}
return persons;
}
}
}
