虽然我不大懂,但我根据错误提示断定你的sql语句组合有问题:没有正常结束。确认
rs=stmt.executeQuery("select COUNT(id) from chatuser where state='\"'online'\"'");
确认这句话里的select count(id) from chatuser where state='state='\"'online'\"'"
能正确生成,否则用一个固定的语句先测试
比如:
private
ssql : String;
ssql = 'select count(id) idnum from chatuser where state='Noyork' ';
再试验一下
rs=stmt.executeQuery("select COUNT(id) from chatuser where state='\"'online'\"'");
确认这句话里的select count(id) from chatuser where state='state='\"'online'\"'"
能正确生成,否则用一个固定的语句先测试
比如:
private
ssql : String;
ssql = 'select count(id) idnum from chatuser where state='Noyork' ';
再试验一下
你仔细看一下,我怎么看都看不明白的意思