jsp连接数据库问题

写在 SQL 里，“where id=2” ...

<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%> <%@page import="java.sql.*" %>  
 

           
        
 
     
       书号    
       书名    
       作者    
       出版社 
    
<%
String driverClass="com.mysql.jdbc.Driver"; 
String url="jdbc:mysql://localhost:3306/simple";//之前数据库名simple    
String user="root";//MySQ帐号    
String password="root";//MYSQL密码    
Connection conn; 
   try { 
    Class.forName(driverClass).newInstance(); 
    conn=DriverManager.getConnection(url,user,password);
    Statement stmt=conn.createStatement();    
    String sql="SELECT * FROM book where id = 2";//表名book     
    ResultSet rs=stmt.executeQuery(sql);     
    while(rs.next()){ 
    %>
 
   <%=rs.getString("bookid")%>       
   <%=rs.getString("bookname")%>    
   <%=rs.getString("writer")%>    
   <%=rs.getString("publish")%> 
   
  <% 
    } 
   }catch(Exception ex){      
       ex.printStackTrace();    
   } %>