📄 delete1.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="Delrec1.jsp";
}
</script>
</head>
<body Background=g1.bmp>
<%
int r=1;
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">
<TABLE id="Table1" style="BORDER-RIGHT: #ffffcc thin solid; BORDER-TOP: #ffffcc thin solid; FONT-WEIGHT: bold; BORDER-LEFT: #ffffcc thin solid; COLOR: #009999; BORDER-BOTTOM: #ffffcc thin solid; POSITION: absolute; TOP: 100px; BORDER-COLLAPSE: collapse"
cellSpacing="0" cellPadding="0" width="100%" border="0">
<TR>
<TD style="FONT-WEIGHT: bold; COLOR: #ffffcc; BACKGROUND-COLOR: g1.bmp; TEXT-ALIGN: center"
colSpan="11">Deletion List Details</TD>
</TR>
<TR bgcolor=#ffffcc>
<TD>Name</TD>
<TD>Regno</TD>
</TR>
<%
while((rs.next()) && (r<4))
{
String n=rs.getString(1);
String pwd=rs.getString(11);
%>
<TR>
<TD><%=n%></TD> <TD><%=pwd%></TD> </TR>
<input type=text name =h<%=r%> value=<%=pwd%> >
<%
r++;
}
rs.close();
con.close();
}catch(Exception e)
{
out.println(""+e);
}
%>
<TR>
<TD style="FONT-WEIGHT: bold; COLOR: #99ffcc; BACKGROUND-COLOR: g1.bmp; TEXT-ALIGN: center"
colSpan="11"><input type=submit onClick="chk()" value=Delete></TD>
</TR>
<TR>
<TD style="WIDTH: 197px" align="right"><a href="adm1.jsp" ><FONT color="#ffffcc">Back</FONT></a></TD>
</TR>
</TABLE>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -