Pre neko vreme sam pisao o novoj specifikaciji za C# koju MS tek treba da se realizuje. Ali zato u javi postoji Open source projekat već više od godinu dana kojm je realizovano to što C# 3.0 predviđa. Naravno u javi to nije ugrađeno u sam jezik već u biblioteku koju može da koristi svako kome treba. Takva pristup mi je prirodniji od onog koji tera MS: nabij sve što možeš u sam jezik, neće da se baci
.gif ":)")
Evo primera:
Kod:
// Build a SQL statement to Person objects that are over a certain age and order
// the results by last name
String sql = "SELECT * FROM com.javasrc.josql.Person WHERE age >= :age ORDER BY lastName";
// Build a Query object and ask it to parse the SQL
Query query = new Query();
query.parse( sql );
// Set our bind variables: the person's age
query.setVariable( "age", new Integer( 18 ) );
// Execute the query and extract the results
QueryResults res = query.execute( this.people );
List sortedPeopleThatCanVote = req.getResults();
// the results by last name
String sql = "SELECT * FROM com.javasrc.josql.Person WHERE age >= :age ORDER BY lastName";
// Build a Query object and ask it to parse the SQL
Query query = new Query();
query.parse( sql );
// Set our bind variables: the person's age
query.setVariable( "age", new Integer( 18 ) );
// Execute the query and extract the results
QueryResults res = query.execute( this.people );
List sortedPeopleThatCanVote = req.getResults();
A evo i linka na projekat SQL for Java Object (JoSQL)