fjenett / sql-library-processing

SQLibrary – a SQL database library for Processing incl. MySQL, SQLite and PostgreSQL
http://fjenett.github.com/sql-library-processing/
37 stars 24 forks source link

Simplify and improve querying #2

Open fjenett opened 11 years ago

fjenett commented 11 years ago

Smarter queries:

db.query( String )
db.query( String, Object ... args ) {
db.query( String.format( String, args ) )
}

or just use a [PreparedStatement](http://docs.oracle.com/javase/6/docs/api/java/sql/PreparedStatement.html PreparedStatement) which seems to bring in

select("table_name").all()
select("table_name").where("name",Object).groupBy("foo")
fjenett commented 11 years ago

Have a look at ActiveRecord and other ORMs