做 jsp 连接mysql 连接报错500 ,谢谢帮我看看

Question

<%@ page contentType="text/html; charset=GB2312"%>
<%@ page import="java.util.*,java.sql.*"%>
<%
request.setCharacterEncoding("GB2312");
//链接数据库程序
Class.forName("org.gjt.mm.mysql.Driver");
//Connection conn = DriverManager.getConnection( -------SQL桥
// "jdbc:odbc:bookshoplk", "sa", "");
Connection connect = DriverManager
.getConnection("jdbc:mysql://localhost:3306/bookshop?user=root&password=root&useUnicode=true&characterEncoding=GBK");
//Statement stmt = conn.createStatement( ---------- SQL的连接
// ResultSet.TYPE_SCROLL_INSENSITIVE,
// ResultSet.CONCUR_READ_ONLY);
Statement stmt = connect.createStatement();
ResultSet rs = null;
//rs结果集
String s_where = (String) session.getAttribute("s_where");
String s_bookid = "";
String s_bookname = "";
String s_author = "";
String s_publisher = "";
String s_price = "";
int i_totalnum = 0;//书籍数量
rs = stmt //String sql=“SELECT * FROM `show`”
.executeQuery("select count(distinct bookid) from'book left join publisher on book.publisherid=publisher.publisherid where bookid is not null "
+ s_where);
rs.next();
i_totalnum = rs.getInt(1);
%>

Answer 1

异常中已经说明了，SQL语句有语法错误：
You have an error in your SQL syntax;

从错误页面上可以看到，from 关键字上多了一对引号，是误输入吧：
select count(distinct bookid) 'from' ...

追问

引号去掉了还是这块报错,我连的mysql 这个是查询 sql的语句,是不是查询语句不正确啊,能不能帮我改改,我都快愁死了

追答

select部分看起来是正确的，请查看一下完整的SQL语句是什么，特别是s_where那部分，有可能是那里出错了，是否漏了 AND ?