Question

求高手帮帮忙，谢谢啦！我在做一个SSH框架的多表查询倒是总是报错 unexpected token: join near line 1, c

代码如下： List userInfos ;
try{
String sql = "from UserTab where root like '%"+root+"%' and flag like '%"+flag+"%' join TeatcherTab where root like '%"+root+"%' and flag like '%"+flag+"%'";
System.out.print("jurdfgvf");
sql+=" join TeatcherTab where TeatcherTab.root like '%"+root+"%' and TeatcherTab.flag like '%"+flag+"%'";
userInfos = this.getHibernateTemplate().find(sql);
}catch(DataAccessException t){
t.printStackTrace();
throw t;
}
return userInfos.size();

Answer 1

sql
不对吧
哎
写的太长
看不下去
自己再仔细看看吧