代码如下:
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();
}
}