index.jsp
来自「邮件群发系统,为企业节省时间.用JSP+SQL+SERVLET+ SERVER 」· JSP 代码 · 共 59 行
JSP
59 行
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,java.io.*"%>
<%@ include file="include.inc"%>
<%
String addrres=request.getParameter("addrres");
String title=(String)request.getParameter("title");
String content=(String)request.getParameter("content");
try
{
Class.forName(CLASSFORNAME);
Connection con=DriverManager.getConnection(SERVER,USER,PWD);
Statement stmt=con.createStatement();
String isOK="select * from foremail where addrees='"+addrres+"'";
ResultSet rs=stmt.executeQuery(isOK);
}
catch(Exception e)
{
e.printStackTrace();
}
/*for(int i=1;i<addrres.length;i++)
{
String isOK="select * from foremail where addrees='"+addrres[i]+"'";
ResultSet rs=stmt.executeQuery(isOK);
}*/
if(!rs.next())
{
out.print("<html>");
out.print("<body>");
out.print("It is a wrong addrres!Please Chick it!");
out.print("<body>");
out.print("</html>");
con.close();
stmt.close();
rs.close();
}
else
{
session.setAttribute(title,"title");
session.setAttribute(content,"content");
try
{
stmt.executeQuery("update foremail set title='"+ title +"',content='"+content+"' where addrees='"+addrres+"'" );
}
catch(Exception e)
{
e.printStackTrace();
}
out.print("<html>");
out.print("<body>");
out.print("The email has been already sended!");
out.print("<body>");
out.print("</html>");
con.close();
stmt.close();
rs.close();
}
%>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?