无参数调用存储过程

 代码如下:

package com.test;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.*;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class dealbook extends HttpServlet {

 /**
  * The doGet method of the servlet. <br>
  *
  * This method is called when a form has its tag value method equals to get.
  *
  * @param request the request send by the client to the server
  * @param response the response send by the server to the client
  * @throws ServletException if an error occurred
  * @throws IOException if an error occurred
  */
 public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {

  doPost(request,response);
 }

 /**
  * The doPost method of the servlet. <br>
  *
  * This method is called when a form has its tag value method equals to post.
  *
  * @param request the request send by the client to the server
  * @param response the response send by the server to the client
  * @throws ServletException if an error occurred
  * @throws IOException if an error occurred
  */
 public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {

  response.setContentType("text/html");
  PrintWriter out = response.getWriter();
  String name = request.getParameter("name");
  Connection con=null;
  ResultSet rst=null;
  try{
   con = DbConnection.getConnection();
   CallableStatement cs = con.prepareCall("{call getAllBooks}");//调用无参数的存储过程
   cs.execute();
   rst = cs.getResultSet();
   out.println("bookid/t");
            out.println("bookname/t");
            out.println("bookauthor/t");
            out.println("bookprice/t");
            out.println("bookdata/t");
            out.println("bookleft/t");
            out.println("<br/>");
         while(rst.next()){
                out.println(rst.getString("bookid"));
                out.println(rst.getString("bookname"));
                out.println(rst.getString("bookprice"));
                out.println(rst.getString("bookdata"));
                out.println(rst.getString("bookauthor"));
                out.println(rst.getString("bookleft"));
                out.println("<br/>");
                out.flush();
             }
         rst.close();
   cs.close();
   con.close();
  }catch(Exception e){
   System.err.println(e.getStackTrace());
  }
  
  out.flush();
  out.close();
 }

}