📄 ordercheck.jsp
字号:
<%@page contentType="text/html"%><%@page pageEncoding="GB2312"%><%@page import = "java.sql.*" %><html><head><title>订阅电子报</title></head><body><%request.setCharacterEncoding("GB2312") ; String cancelValue ="" ; if(request.getParameter("cancel")!=null) cancelValue = request.getParameter("cancel") ; String nameorder = request.getParameter("nameorder") ; String mailorder = request.getParameter("mailorder") ; String checkMail = "SELECT * FROM list WHERE mail='" + mailorder + "'" ; int updateCount=0 ; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection con = DriverManager.getConnection("jdbc:odbc:paper");Statement smt =con.createStatement (ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);ResultSet chkResult = smt.executeQuery(checkMail) ; if(cancelValue.equals("yes")){ if(chkResult.next() == true){ String newOrder = "DELETE FROM list WHERE mail='"+mailorder+"'" ; updateCount=smt.executeUpdate(newOrder) ; if(updateCount==1) out.println("邮件地址"+mailorder+"已取消订阅 !!" ); }else out.println("邮件地址"+mailorder+"无任何订阅记录 !!" );}else{ if(chkResult.next() != true){ String newOrder = "INSERT INTO list(mail,name)VALUES('"+mailorder+"','"+nameorder+"')" ; updateCount=smt.executeUpdate(newOrder) ; if(updateCount==1){ out.println("尊敬的"+nameorder+"会员您好：<br>" ); out.println("您已经成功订阅 JSP 电子报，电子报收件地址如下：<br>" ); out.println("<b>" + mailorder+"</b>" ); } }else out.println("邮件地址"+mailorder+"已订阅 !!" ); } %></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -