deletereader.jsp

来自「学习jsp时做的一个书馆」· JSP 代码 · 共 66 行

JSP

66 行

<%@ page contentType="text/html;charset=gb2312"%>    
<%@ page import="java.sql.*"%> 
<%
if(session.getAttribute("adlogin")!=null){
    String adlogin = (String)session.getAttribute("adlogin");
    if(!adlogin.endsWith("yes")){
        response.sendRedirect("../admin/login.jsp?errMsg=weidenglu" );
    }
}else{
	response.sendRedirect("../admin/login.jsp?errMsg=weidenglu" );
}
%>
<html>
<body>
<%
String id = request.getParameter("id");
 boolean delete = true;
 boolean delete1 = true;
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
String url ="jdbc:mysql://localhost/library?user=root&password=linux&useUnicode=true&characterEncoding=GB2312" ;
Connection conn= DriverManager.getConnection(url); 
Statement stmt=conn.createStatement();
String query ="select * from bookhavebr where readerid = '"+id+"'";
ResultSet rs = stmt.executeQuery(query);
if(rs.next()){
    delete = false;
}

query ="select sum(fakuan) from fakuan where readerid = '"+id+"'";
rs = stmt.executeQuery(query);
if(rs.next()){
	String s1=rs.getString("sum(fakuan)");
	double ss=0.0;
	if(s1!=null)
	    ss = Double.parseDouble(s1);
	if(ss>0){
		delete1 = false;
	}
}
String del="",del2="";

if(delete==true){
	del = "yes";
}else{
	del = "no";
}
if(delete1==true){
	del2 = "yes";
}else{
	del2 = "no";
}
%>
<br>
   <h1><blockquote>您是否确认删除<%=id %></blockquote></h1>
   <br><br>
<form name = deletereader action="../servlet/delReaderController" method="post"> 
  <input type = hidden name = "del" value = <%=del %> >
  <input type = hidden name = "del2" value = <%=del2 %> >
  <input type = hidden name = "id" value = <%=id %> >
  <input type = submit value="   确认删除    "  name = "de"> 
</form>
<a href = ./readerdetail.jsp?id=<%=id %>>返回</a>

</body>
</html>

deletereader.jsp - 源码说明

本页面展示了「学习jsp时做的一个书馆」中的 deletereader.jsp 源码文件，采用 JSP 编程语言编写，共 66 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与JSP相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?