String queStringrynewmoviefilmreview = "select * from filmreview where filmreview.fname NOT IN (select movie.fname from movie where ontime <"+(total-500)+")";
这个跟Java没关系吧,你先拿到数据库客户端上执行一下,没错了再说啊
没看错的话 少半拉括号