📄 deletereader.jsp

📁 学习jsp时做的一个书馆

💻 JSP

字号:

<%@ 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>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -