mysql问题，执行查询语句的时候出错

错误信息：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 '=null where borrowBookName=null' at line 1
方法：public ResultSet checkBorrowBook(Connection con,Borrow borrow) throws Exception{
String sql= "select * from t_borrow borrowBookAutor=? where borrowBookName=? ";
PreparedStatement psmt=con.prepareStatement(sql);
psmt.setString(1,borrow.getBookName());
psmt.setString(2,borrow.getBorrowBookAutor());
return psmt.executeQuery();
}

select * from t_borrow where borrowBookName=? and borrowBookAutor=?

select * from t_borrow borrowBookAutor=? where borrowBookName=? 语法错了

String sql= "select * from t_borrow borrowBookAutor=? where borrowBookName=? ";条件位置写错了
String sql= "select * from t_borrow where borrowBookName=? and borrowBookAutor=? "; 这样写就对了

搂主是个小白吧，出现错误的时候就慌了不知道怎么检查和核对，其实只要仔细的看报错信息，信息是很明确的。You have an error in your SQL syntax;你的sql语句中有个错误。再回代码中看一下，一眼不就知道哪里不对了吗？

其实楼主没有其他办法 可以用这条语句去数据库查一下=-=我就是这样子干的