主题:问题(2)
接问题(1)
<table width="700" border="1" align="center">
<tr>
<th width="20" scope="col"> </th>
<th width="105" scope="col">用户名</th>
<th width="167" scope="col">密码</th>
<th width="40" scope="col">性别</th>
<th width="145" scope="col">身份证号</th>
<th width="130" scope="col">角色</th>
<th width="47" scope="col">删除</th>
</tr>
<%
Object[] a = null;
Editusers obj = new Editusers();
List list = obj.select("select t.id,t.name,t.pwd,t.sex,t.idcode,t.part from Users as t");
Iterator it = list.iterator();
while (it.hasNext())
{
a=(Object[])it.next();
out.print("<tr>");
out.print("<td> <input type=radio name=rad value="+ a[0] +"></td>");
out.print("<td>"+a[1]+"</td>");
out.print("<td>"+a[2]+"</td>");
out.print("<td>"+a[3]+"</td>");
out.print("<td>"+a[4]+"</td>");
if (a[5]!=null)
{
if(a[5].equals("1"))
a[5]="管理员";
if(a[5].equals("2"))
a[5]="教师";
if(a[5].equals("3"))
a[5]="财务";
if(a[5].equals("4"))
a[5]="校长";
if(a[5].equals("5"))
a[5]="市场人员";
if(a[5].equals("6"))
a[5]="市场部经理";
if(a[5].equals("7"))
a[5]="教务";
}
out.print("<td>"+a[5]+"</td>");
out.print("<td><a href=delete1.jsp?name="+a[0].toString()+">del</a></td>");
out.print("<tr>");
}
%>
</table>
<p> </p>
</form>
<table width="700" border="1" align="center">
<tr>
<th width="20" scope="col"> </th>
<th width="105" scope="col">用户名</th>
<th width="167" scope="col">密码</th>
<th width="40" scope="col">性别</th>
<th width="145" scope="col">身份证号</th>
<th width="130" scope="col">角色</th>
<th width="47" scope="col">删除</th>
</tr>
<%
Object[] a = null;
Editusers obj = new Editusers();
List list = obj.select("select t.id,t.name,t.pwd,t.sex,t.idcode,t.part from Users as t");
Iterator it = list.iterator();
while (it.hasNext())
{
a=(Object[])it.next();
out.print("<tr>");
out.print("<td> <input type=radio name=rad value="+ a[0] +"></td>");
out.print("<td>"+a[1]+"</td>");
out.print("<td>"+a[2]+"</td>");
out.print("<td>"+a[3]+"</td>");
out.print("<td>"+a[4]+"</td>");
if (a[5]!=null)
{
if(a[5].equals("1"))
a[5]="管理员";
if(a[5].equals("2"))
a[5]="教师";
if(a[5].equals("3"))
a[5]="财务";
if(a[5].equals("4"))
a[5]="校长";
if(a[5].equals("5"))
a[5]="市场人员";
if(a[5].equals("6"))
a[5]="市场部经理";
if(a[5].equals("7"))
a[5]="教务";
}
out.print("<td>"+a[5]+"</td>");
out.print("<td><a href=delete1.jsp?name="+a[0].toString()+">del</a></td>");
out.print("<tr>");
}
%>
</table>
<p> </p>
</form>