⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 index.jsp

📁 JSP和SQL2000
💻 JSP
字号:
<%@ 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 + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -