????????Groovy????????

???????????? ???????[ 2014/9/22 10:53:19 ] ??????????????? ?????

???????????????????????
????1.???????
??????????????????SqlQuery
????import groovy.sql.*; abstract class SqlQuery { def sql; def query; def SqlQuery(sql??query){ this.sql=sql; this.query=query; } def execute(){ def rowList=sql.rows(query); def results=[]; def size=rowList.size(); 0.upto(size-1) { index-> results <<this.mapRow(rowList[index]); } return results; } def abstract mapRow(row); } 
???????????Account??????????account??????
????class Account { def id; def name; def url; @Override public String toString() { return "|$id|$name|$url|"; } } 
???????????AccountQuery????SqlQuery????????е??????rowMap
????import com.demo.db.SqlQuery; class AccountQuery extends SqlQuery { def AccountQuery(sql){ super(sql?? 'SELECT id?? name?? url FROM account'); } @Override public Object mapRow(Object row) { //????????? //def acc=new Account(id:row.getAt('id')??name:row.getAt('name')??url:row.getAt('url')); //def acc=new Account(id:row.getAt(0)??name:row.getAt(1)??url:row.getAt(2)); def acc=new Account( id:row.getProperty('id')?? name:row.getProperty('name')?? url:row.getProperty('url')); return acc; } } 
????AccountQuery???????rowMap??????????÷??????????????????????????????Table - Object?????Ч????
???????????????е??????????????????????д????
????2.???SqlQuery???????account???????
????//?????????? def accountQuery=new AccountQuery(sql); def accList=accountQuery.execute(); println 'Table <-> Object Query: '; accList.each { acc-> println acc.toString(); } 
????accList????Account???????????鼯???????????????????????????????
????????Spring?????????????
????1.???????
????Spring???????MappingSqlQuery???????????AccountQuery??и?????????е?rowMap??????????????????????
????import com.demo.db.Account; import org.springframework.jdbc.object.MappingSqlQuery class AccountQuery extends MappingSqlQuery { def AccountQuery(ds){ super(ds??'SELECT id?? name?? url FROM account'); this.compile(); } @Override protected Object mapRow(ResultSet rs?? int rowNumber) throws SQLException { def acc=new Account( id:rs.getInt('id')?? name:rs.getString('name')?? url:rs.getString('url')); return acc; } } 
???????????????Spring??MappingSqlQuery??????????????????????DataSource?????????SQL???
???????????Account???DAO??AccountDAO????????????????????????????????????????y?????ó??????????????????????????????ɡ???????????????塣
????class AccountDao { def ds; def getAccounts(){ def aq=new AccountQuery(ds); return aq.execute(); } } 
????AccountDao?????getAccounts??????????÷??????????????account?????м???????AccountQuery??Mapping???????????????????
????2.???AccountDao??????????
????//????Spring def ds=new DriverManagerDataSource(db.url?? db.user?? db.password); def accountDao=new AccountDao(ds:ds); accLists=accountDao.getAccounts(); println 'Spring MappingSqlObject Query: '; accList.each { acc-> println acc.toString(); } 
????????Groovy????????????????Groovy??Java???????????????????????????????????API?????????PHP??????????????????Groovy??Java???????????????????
??????????
????????????????????????????????Groovy???????????Python??PHP??Nodejs?????????????е?Java????????????????????"Java?????????"???????????????????μ??????????????????????????????￡?????????????·?????????????
??????????????SSH?? SSM??TSH??JSF???????Java??????????????????????????????????????????????????????????????????赸?????????????????ζ??????????????????????????????????????????????????????????????????
???????????Ч??????Ч???????????????????μ?Э?飬??????????????????????????????????????????????Щ???????????????????????????????????????

????1 2????

???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????