📄 show.java
字号:
/*
* Show.java
*
* Created on 2007年11月22日, 下午2:25
*/
package pageShow;
import java.io.*;
import java.net.*;
import dbpack.dbConnect;
import java.sql.SQLException;
import javax.servlet.*;
import javax.servlet.http.*;
import org.omg.PortableServer.REQUEST_PROCESSING_POLICY_ID;
import java.util.*;
/**
*
* @author weiyunbo
* @version
*/
public class Show extends HttpServlet {
/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String id;
String type;
request.setCharacterEncoding("UTF-8");
id=request.getParameter("id");
type=request.getParameter("type");
if(id==null){
response.sendRedirect("index.jsp");
}
/* TODO output your page here
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet Show</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>Servlet Show at " + request.getContextPath () + "</h1>");
out.println("</body>");
out.println("</html>");
*/
foodInfo fi=new foodInfo();
roomShow rms=new roomShow();
HttpSession session=request.getSession(true);
try {
dbConnect db=new dbConnect();
if(type.equals("food")){
db.rs=db.sat.executeQuery("select * from food where foodid="+id);
while(db.rs.next()){
fi.setFoodboss(db.rs.getString("foodboss"));
fi.setFoodcooker(db.rs.getString("foodcooker"));
fi.setFooddescription(db.rs.getString("fooddescription"));
fi.setFoodid(db.rs.getString("foodid"));
fi.setFoodname(db.rs.getString("foodname"));
fi.setFoodprice(db.rs.getString("foodprice"));
fi.setFoodroom(db.rs.getString("foodroom"));
fi.setRoom(db.rs.getString("room"));
}
session.setAttribute("foodinfo",fi);
session.setAttribute("roomInfo",null);
}else{
db.rs=db.sat.executeQuery("select * from room where roomid="+id);
while(db.rs.next()){
rms.setRoomadd(db.rs.getString("roomadd"));
rms.setRoomid(db.rs.getString("roomid"));
rms.setRoomname(db.rs.getString("roomname"));
rms.setRoompicture(db.rs.getString("roompicture"));
rms.setRoomtel(db.rs.getString("roomtel"));
}
session.setAttribute("roomInfo",rms);
session.setAttribute("foodinfo",null);
}
db.doClose();
response.sendRedirect("show.jsp?type="+type);
} catch (SQLException ex) {
ex.printStackTrace();
}
out.close();
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/** Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -