代码为
String sql = "select * from lottery , userandlottery , users where lottery.Lotteryid=userandlottery.Lotteryid and userandlottery.nickname = users.nickname and users.nickname = " ;
java.sql.Statement statement = conn.createStatement();
java.sql.ResultSet rsResultset = statement.executeQuery(sql + name ) ;
其中name表示要查询的关键字名字,如果这样写而且name设置为tom会报错如下所示:
数据库访问有问题 java.sql.SQLSyntaxErrorException: Unknown column 'tom' in 'where clause'
各位们!!感谢