📄 lendbook.java
字号:
package mypackage;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.PrintWriter;
import java.io.IOException;
import java.sql.*;
import javax.sql.DataSource;
public class LendBook extends HttpServlet
{
private static final String CONTENT_TYPE = "text/html; charset=GBK";
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
response.setContentType(CONTENT_TYPE);
request.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
String readerID = request.getParameter("readerID");
String bookID = request.getParameter("bookID");
String lenddate = new FormatDate().nowDate();
String returndate = new FormatDate().returnDate();
int isreturn = 1;
int success = 0;
DataSource ds = null;
Connection conn = null;
PreparedStatement pstm = null;
try{
ds = (DataSource)request.getSession().getServletContext().getAttribute("DataSrc");
conn = ds.getConnection();
pstm = conn.prepareStatement("insert into lendinfo(id1,id2,lenddate,returndate,isreturn) values(?,?,?,?,?)");
pstm.setString(1,bookID);
pstm.setString(2,readerID);
pstm.setString(3,lenddate);
pstm.setString(4,returndate);
pstm.setInt(5,isreturn);
success = pstm.executeUpdate();
pstm.close();
conn.close();
}
catch(Exception e){
System.out.println(e.getMessage());
}
out.println("<html>");
out.println("<head><title>LendBook</title></head>");
out.println("<body>");
if(success > 0)
request.getSession().getServletContext().getNamedDispatcher("LendInfo").forward(request, response);
else
out.println("此书已借出！请检查图书编号！");
out.println("</body></html>");
out.close();
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -