📄 mail.jsp
字号:
<%@page language="java" import="java.io.*,java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title></title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<script language="javascript">
function chk()
{
var v;
v=confirm("Are U Sure Of Deletion");
if(v==true)
f1.action="delrec.jsp";
}
</script>
</head>
<body>
<%
int r=1;
String mail=" ";
try
{
String q;
q=request.getParameter("s");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:wsm");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from registration " );
%>
<form name="f1" method="get" action="mailpage1.jsp">
<TABLE id="Table1" style="BORDER-RIGHT: #009999 thin solid; BORDER-TOP: #009999 thin solid; FONT-WEIGHT: bold; BORDER-LEFT: #009999 thin solid; COLOR: #009999; BORDER-BOTTOM: #009999 thin solid; POSITION: absolute; TOP: 100px; BORDER-COLLAPSE: collapse"
cellSpacing="0" cellPadding="0" width="100%" border="0">
<TR>
<TD style="FONT-WEIGHT: bold; COLOR: #99ffcc; BACKGROUND-COLOR: #00cc99; TEXT-ALIGN: center"
colSpan="11">Mail List Details</TD>
</TR>
<TR bgcolor=red>
<TD>Name</TD>
<TD>RegNo</TD>
</TR>
<%
while((rs.next()) && (r<4))
{
String n=rs.getString(1);
mail=mail +"-" +rs.getString(7);
String pwd=rs.getString(11);
%>
<TR>
<TD><%=n%></TD> <TD><%=pwd%></TD>
<input type=hidden name =h<%=r%> value=<%=pwd%> >
</TR>
<%
r++;
}
rs.close();
con.close();
}catch(Exception e)
{
out.println(""+e);
}
%>
<tr><td colspan=2><input type=submit value=send></tr>
</table>
<input type=hidden name="mail"value=<%=mail%> >
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -