📄 book_borrow.java
字号:
/*
* book_borrow.java
*
* Created on April 13, 2007, 3:03 AM
*/
package inc;
import java.io.*;
import java.net.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author mamat-dev
* @version
*/
public class book_borrow 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();
/* TODO output your page here
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet book_borrow</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>Servlet book_borrow at " + request.getContextPath () + "</h1>");
out.println("</body>");
out.println("</html>");
*/
//cek anggota
String memberId = request.getParameter("memberId");
Anggota anggota = new Anggota();
ResultSet rsAnggota = anggota.selectAnggota("select member_status_id from member where member_id ="+memberId);
String status = null;
int i =0;
try {
while(rsAnggota.next()){
status = rsAnggota.getString(1);
i++;
}
if(i<1){
response.sendRedirect("pinjam.jsp?error_null");
} else {
if (status.equals("2")){
response.sendRedirect("pinjam.jsp?error_anggota_sudah_pinjam&"+status);
} else if(status.equals("1")) {
//response.sendRedirect("pinjam.jsp?error_anggota_belum_pinjam&"+status);
String bookId = request.getParameter("bookId");
Buku buku = new Buku();
ResultSet rs = buku.selectBuku("select book_status_id from book where book_id = "+bookId);
try {
int j = 0;
String status_buku = null;
while (rs.next()){
status_buku = rs.getString(1);
j++;
}
if(j<1){
response.sendRedirect("pinjam.jsp?error_book_null");
} else if(status_buku.equals("2")){
response.sendRedirect("pinjam.jsp?error_book_sudah_dipinjam");
} else{
Pinjam pinjam = new Pinjam();
pinjam.setPinjam(bookId,memberId);
response.sendRedirect("pinjam.jsp?ok");
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
} catch (SQLException ex) {
//response.sendRedirect("pinjam.jsp?error_null");
ex.printStackTrace();
} catch (IOException ex) {
//response.sendRedirect("pinjam.jsp?error_null");
ex.printStackTrace();
}
/*
//cek buku
String bookId = request.getParameter("bookId");
Buku buku = new Buku();
ResultSet rs = buku.selectBuku("select book_status_id from book where book_id = "+bookId);
try {
while (rs.next()){
try {
if(rs.getString(1).equals("1")){
Pinjam pinjam = new Pinjam();
pinjam.setPinjam(bookId);
response.sendRedirect("pinjam.jsp");
} else {
response.sendRedirect("pinjam.jsp?error_buku");
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
response.sendRedirect("pinjam.jsp?error_buku");
} 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 + -