All pastes #177994 Raw Edit

Mine

public java v1 · immutable
#177994 ·published 2006-09-20 21:50 UTC
rendered paste body
import java.sql.Connectionimport java.sql.DriverManagerimport javax.sql.DataSourceimport groovy.sql.Sqlimport solid.jdbc.SolidDriverclass queryWCS {	static void main(args) {		Class.forName("solid.jdbc.SolidDriver");	    Connection conn = DriverManager.getConnection('jdbc:solid://wcs:1315/lala/lala');		Sql sql = new Sql(conn);	    		String sQuery = "SELECT lrad.lradname as name,lradif.channelnumber as channel,lradif.previouschannelnumber as prevchannel,lradif.powerlevel as power,lradif.lastchannelupdatetime as lastchannelupdatetime " +				" FROM LRADIF,lrad where lradif.macaddress=lrad.macaddress and lradif.iftype=2 " +				"order by lradif.lastchannelupdatetime";	     sql.eachRow(sQuery){ row |	        println row.name + " " + row.channel + " " + row.prevchannel	     }	}}