ps = connection.prepareStatement("select * from atm_information WHERE id limit"+" "+(pageNo-1)*pageSize+","+pageSize);
limit后面有空格 一定要注意 不然一直sql执行错误
ps = connection.prepareStatement("select * from atm_information WHERE id limit"+" "+(pageNo-1)*pageSize+","+pageSize);
limit后面有空格 一定要注意 不然一直sql执行错误