SqlTemplate

SqlTemplateEngin sqlTemplateEngin = new SqlTemplateEngin();
	String sqlTpl = "select * from user_info <where><if test=' username != null' > and  username = #{username} </if><if test=' email != null' > and  email = #{email} </if></where> ";
	//从字符串读取sql模板内容,还可以从单独的文件读取  
	SqlTemplate sqlTemplate = sqlTemplateEngin.getSqlTemplate(sqlTpl) ;
	
	Bindings bind = new Bindings().bind("email", "wenzuojing@gmail.com");
	
	SqlMeta sqlMeta = sqlTemplate.process(bind) ; //可传map对象或javabean对象
	
	//System.out.println(sqlMeta.getSql());
	
	Assert.assertEquals("select * from user_info  WHERE  email = ?   ", sqlMeta.getSql());
	List<Object> parameter = sqlMeta.getParameter(); //取出参数
	Assert.assertEquals(1, parameter.size());
	
	
	
	bind.bind("username", "wenzuojing") ;
	sqlMeta = sqlTemplate.process(bind) ;
	Assert.assertEquals("select * from user_info  WHERE  username = ?   and  email = ?   ", sqlMeta.getSql());
	List<Object> parameter2 = sqlMeta.getParameter();//取出参数
	Assert.assertEquals( 2  ,parameter2.size() );

	Map<String ,Object > userInfo = new HashMap<String,Object>() ;
	
	userInfo.put("id", "123456") ;
	userInfo.put("email", "wenzuojing@126.com") ;
	
	String sqlTpl =" update userinfo <set> <if test ='email != null '> email = #{email} </if>, <if test='age'> age = #{age} </if> </set> where id = #{id}" ;
	
	SqlTemplate sqlTemplate = sqlTemplateEngin.getSqlTemplate(sqlTpl) ;
	
	SqlMeta sqlMeta = sqlTemplate.process(userInfo) ;
	
	Assert.assertEquals(" update userinfo  SET email = ?    where id = ? ", sqlMeta.getSql());
	
	List<Object> parameter = sqlMeta.getParameter(); //取出参数
	Assert.assertEquals(2, parameter.size());