reserve.java

vb+java实现的图书管理系统

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.text.SimpleDateFormat;
import java.util.Date;

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

import com.bean.util.DbConn;

public class Reserve extends HttpServlet {

	public Reserve() {
		super();
	}

	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("gbk");
		response.setContentType("text/html;charset=gbk");
		PrintWriter out = response.getWriter();
		HttpSession session=request.getSession(true);
		if(session.getAttribute("user")==null){
			response.sendRedirect("index.jsp?contr=myInfo");
		}
		else{
			String readerId=session.getAttribute("user").toString();
			String bookId=request.getParameter("bookId");
			String st = new String(new SimpleDateFormat("yyyy-MM-dd").format(new Date())); 
			System.out.print(st);
			String sql="insert into reserve(bookId,readerId,time) values('"+bookId+"','"+readerId+"','"+st+"')";
			String sql2="update bookInfo set Isreserve='Y' where bookId='"+bookId+"'";
			DbConn conn=new DbConn();
			int count=conn.update(sql);
			int count1=conn.update(sql2);
			if(count>0&&count1>0){
				out.println("<script type=text/javascript>alert('预约成功');</script>");
				out.println("<meta http-equiv=\"refresh\" content=\"0;url=index.jsp\">");
			}
			else{
				out.println("<script type=text/javascript>alert('预约失败');</script>");
				out.println("<meta http-equiv=\"refresh\" content=\"0;url=index.jsp\">");
			}
		}
		out.flush();
		out.close();
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

	}

	public void init() throws ServletException {
		// Put your code here
	}

}