manage.jsp

一个 网上答疑系统 与大家分享 jsp+sql

<%@ page contentType="text/html; charset=GB2312" 
		language="java"
		import = "java.util.*, java.text.*"
		import = "java.sql.*,MyBean.dbcon"
%>
	<table width="99%" border="1" align="center" cellpadding="2" bordercolor="#C0C0C0" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" bgcolor="#EEEEEE">
      <tr height=22>
	    <td width="15%" align=center>用户ID</td>
		<td width="15%" align=center>用户名</td>
        <td width="20%" align=center>用户email</td>
		<td width="10%" align=center>用户权限</td>
		
		<td width="10%" align=center>操作</td>
	  </tr>
	  <a href=addteacher.jsp>添加教师</a>
<%
   dbcon dbc =new dbcon();
   ResultSet rs=dbc.executeQuery("select * from userinfo");
   while(rs.next())
   {
   String userid=rs.getString("userid");
   %>
   
   <tr>
   <td align=center><%=userid%></td>
   <td align=center><%=rs.getString("username")%></td>
   <td align=center><%=rs.getString("useremail")%></td>
   <td align=center><%=rs.getString("userq")%></td>
   <%
   if(userid.equals((String)session.getAttribute("suserid")))
   {
   %>
   <td align=center>删除</td>
   <%
   }
   else
   {
   %>
   <td align=center><a href=deleuser.jsp?userid=<%=userid%>>删除</a></td>
   <%
   }
   %>
   </tr>
   
   <%
   }
%>
</table>