Question

我在jsp中用到了java处理sql语句，但在运行时MyEclipse时报出错误，找不到问题出在哪里，求各位的帮助！

报出的错误：
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select tid from xuanke where username= '1001' limit 0,3' at line 1 Query: select teacher.tphone from teacher where tid = select tid from xuanke where username= '1001' limit 0,3 Parameters: []

具体的sql语句是一个子查询：
String sql = "select teacher.tphone"
+ " from teacher"
+ " where tid = select tid from xuanke where username= '1001' ";

Answer 1

SQL语法有错。

可以改为下面:

String sql = "select teacher.tphone"
 + " from teacher"
 + " where tid in( select tid from xuanke where username= '1001' )";

追问

恩，已经解决了！谢谢

Answer 2

" where tid in ( select tid from xuanke where username= '1001' ");

嵌套子查询 要带括号 再把=号 改成in

Answer 3

String sql = "select teacher.tphone"
+ " from teacher"
+ " where tid = (select tid from xuanke where username= '1001' )";