<dependency>
<groupId>org.tksfreamework</groupId>
<artifactId>tkscommons</artifactId>
<version>1.0.0</version>
</dependency>
# Database Configuration
db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/mydatabase
db.username=username
db.password=password
import org.tksframework.datastore.DataStore;
import org.tksframework.dataaccess.DataAccess;
import org.tksframework.dataaccess.param.Query;
import org.tksframework.dataaccess.param.Update;
public class DatabaseExample {
public static void main(String[] args) {
Query query = new Query()
.select("name", "age")
.from("users")
.where("age > 18")
.orderBy("age");
dataAccess.query(query)
.forEach(row -> {
String name = row.getString("name");
int age = row.getInt("age");
System.out.println("Name: " + name + ", Age: " + age);
});
Update update = new Update()
.table("users")
.set("age", 20)
.where("name = 'John'");
int updatedRows = dataAccess.update(update);
System.out.println("Updated rows: " + updatedRows);
}
}
