//空全部查询 用in 查询多个
select * from student where 1=1 ${if(len(name)==0,"","and id in("+name+")")};
//模糊查询
select * from student where uname like '${"%"+name+"%"}';
//给单元格赋值
contentPane.curLGP.setCellValue(1, 2, "abc");
都从0 开始
第二竖,第三行 输入‘abc’