代码拉取完成,页面将自动刷新
测试代码:
String sqlTemplate = " select top 10 firstname,keyid from sys_users where 1=1 and keyid=#text(xxx)# and keyid=#xxx,typeofnvarchar# ";
SQLScript sqlScript = sqlManager.getSqlScript(sqlTemplate);
System.out.println((new Date()).toString() + ":获取SQL:"
SQLResult sqlResult = sqlScript.run();// 获取参数等信息
//也支持 #use("cols_ext")#
System.out.println("SQL:" + sqlResult.jdbcSql + "");
List params = sqlResult.jdbcPara;// 传入变量
for (SQLParameter param : params) {
Class classType = (Class) JavaType.jdbcJavaTypes.get(Integer
.valueOf(param.jdbcType));
System.out.println("-----参数名称:" + param.expression + ",值类型:"