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

📄 admin_del_user.jsp

📁 《J2EE专业项目实例开发》源代码
💻 JSP
字号:
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<title>Delete User Page</title>
</head>

<body bgcolor="#C0C0C0" topmargin="0" background="http:\\localhost:8000\music\Background.bmp" >

<table border="0" width="100%">
  <tr>
    <td width="100%">
      <table border="0" width="97%" height="19">
        <tr>
          <td width="18%" height="13" valign="middle" align="right">
      <font face="Arial" size="5" color="#800000"><b><i>eMusicWorld-----&gt; The World of Music</i></b></font>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>


<table border="0" width="100%">
    <tr>
    <td width="100%"><table border="0" width="100%" height="19">
        <tr>
          <td width="9%" height="13" valign="middle" align="center"><font face="Arial" size="2" color="#800000"><b><a HREF="welcome_page.htm">Home</a></b></font></td>
          <td width="10%" height="13" valign="middle" align="center"></td>
          <td width="19%" height="13" valign="middle" align="center"></td>
          <td width="13%" height="13" valign="middle" align="center"></td>
          <td width="13%" height="13" valign="middle" align="center"></td>
        	<td width="11%" height="13" valign="middle" align="center"></td>
 			<td width="10%" height="13" valign="middle" align="center"></td>
          <td width="9%" height="13" valign="middle" align="center"><font face="Arial" size="2" color="#800000"><b><a HREF="home_page.htm">Logout</b></font></td>
          <td width="9%" height="13" valign="middle" align="center"><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/admin_home_page_old.htm">Help</a></b></font></td>
        </tr>
      </table>
    </td>
  </tr>
</table>

<table border="1" width="100%" height="353">
  <tr>
   <td width="15%" height="347" valign="top">
    
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/admin_del_user.jsp">Delete User</a></b></font></p>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/ItemContext/ItemAlias">Add Item</a></b></font></p>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/admin_mod_item.jsp">Modify Item</a></b></font></p>
<p><font face="Arial" size="2" color="#800000"><b>Sales Reports<br>---<a HREF="http://localhost:8000/music/daily_sales_report.jsp">Choose a Date</a><br>---<a HREF="http://localhost:8000/music/weekly_sales_report.jsp">Previous
Week</a><br>---<a HREF="http://localhost:8000/music/monthly_sales_report.jsp">Previous Month</a></b></font></p>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/admin_wishlist.jsp">View Wishlist</a></b></font></p>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/admin_messages.jsp">View Messages</a></b></font></p>
   

	</td>
  
    <td width="85%" height="347" valign="top">
<p align="center" style="margin-top: 1; margin-bottom: 1"><b><u><font color="#800000" face="Arial" size="2">Delete
User</font></u></b>
<p align="center" style="margin-top: 1; margin-bottom: 1">
<form method="get" action="http://localhost:8000/music/admin_del.jsp">
  
  <p align="left" style="margin-left: -2; margin-right: -2; margin-top: 1; margin-bottom: 1"><font face="Arial" size="2" color="#800000">Select
  the Username to be Deleted:</font> <select size="1" name="delUserName">

	<%@ page import="java.util.*" %>
	<%@ page import="java.sql.*" %>
	<%@ page import="java.text.*" %>
	<%@ page import="java.sql.Date" %>

	<%@ page language = "java" %> 
	<%
	try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection connect;

	connect=DriverManager.getConnection("jdbc:odbc:RegisterDataSource","wasiqr","bhalbabatu");
	Statement state;
	state = connect.createStatement();
	String strQuery1 = "select User_name from User_Info order by User_name asc" ;
	ResultSet result1 = state.executeQuery(strQuery1);
	int ctr1=0;
   while(result1.next())				
	{										
	%>	
	<option><%=result1.getString("User_name")%></option>
		
<%	}
	connect.close();
	}
	catch(Exception e)
	{
		out.println("Exception: "+e);
	}
%>
</select></p>
  </select></p>
  <p align="left" style="margin-left: -2; margin-right: -2; margin-top: 3; margin-bottom: 10">&nbsp;&nbsp;&nbsp;<font face="Arial" size="2" color="#800000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></p>
  <table border="0" width="100%">
    <tr>
      <td width="50%" valign="middle" align="right"><font face="Arial" size="2" color="#800000">&nbsp;
  &nbsp;&nbsp;</font><input type="submit" value="Delete" name="B1"><input type="button" value="Cancel" name="B2"></td>
      <td width="50%" valign="middle" align="right"><font face="Arial" size="2" color="#800000">&nbsp;&nbsp;</font></td>
    </tr>
  </table>
</form>

   
  
    </td>
  </tr>
</table>

</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -