📄 user_so.jsp

📁 java + sqlserver2000编写的一个网上购书系统,实现了一些基本的功能,但对于初学者来说这个系统已经足以起到帮助作用
💻 JSP
字号:
<%@ page language="java" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DBuser" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<head>
	<script language=javascript src="../function/admin.js"></script>
	<link rel="stylesheet" type="text/css" href="../css/admin.css">
</head>
<BODY leftMargin=0 topMargin=0 BGCOLOR="#FFCCCC">
<br>
<TABLE class=navi cellSpacing=1 align=center border=0>
  		<TBODY>
		  <TR>
		    <TH colSpan=2>当前位置:系统管理&gt;&gt;普通用户管理&gt;&gt;搜索用户</TH></TR>
		 <TR>
		   <td>搜索结果如下:</td>
		   <TD align=right>[<A href="user.jsp">所有用户</A>]&nbsp;&nbsp;[<A href="index.jsp">回首页</A>]</TD>
		 </TR>
		</TBODY>
</TABLE>
 <FORM name=checkform  method=post>
	<TABLE class=list cellSpacing=1 align=center border=0 width=760px;>
	<TBODY>
			<TR>
				 <TH>ID</TH>
				 <TH>用户名</TH>
				 <TH>真实名</TH>
				 <TH>密码</TH>
				 <TH>性别</TH>
				 <TH>电话</TH>
				 <TH>地址</TH>
				 <TH>邮编</TH>
				 <TH>E-mail</TH>
				 <TH>注册时间</TH>
				 <TH>文化程度</TH>
				 <TH>操作</TH>
			</TR>
<%
 try{   
  	  String name=request.getParameter("key");
  	  String lei=request.getParameter("souser");
  	  int slei=Integer.parseInt(lei);
  	  ResultSet rs2=null;
  	  //out.print("fdasdf"+lei);
  	  switch(slei){
  	  	case 0:
  	  	 {  
  	  	 	String str1="select * from userinfo where UserName='"+name+"'";
  	  	 	rs2=DBuser.executeQuery(str1);
  	  	 	//out.print(str1); 
  	  	 	break;	
  	  	 }
  	  	 
  	  	 case 1:
  	  	 {
  	  	 	String str2="select * from userinfo where Sex='"+name+"'";
  	  	 	rs2=DBuser.executeQuery(str2);
  	  	 	break;	
  	  	 }
  	  	 
  	  	 case 2:
  	  	 {
  	  	 	String str3="select * from userinfo where Address='"+name+"'";
  	  	 	rs2=DBuser.executeQuery(str3);
  	  	 	break;	
  	  	 }
  	  	 
  	  	 case 3:
  	  	 {
  	  	 	String str4="select * from userinfo where Educate='"+name+"'";
  	  	 	rs2=DBuser.executeQuery(str4);
  	  	 	break;	
  	  	 }
  	  	 
  	  	 case 4:
  	  	 {
  	  	 	String str5="select * from userinfo where Post='"+name+"'";
  	  	 	rs2=DBuser.executeQuery(str5);
  	  	 	break;	
  	  	 }
  	  } 
      //rs2=DBbookinfo.executeQuery();	
     // out.print(strSQL2);
      if(!rs2.next()){
      	out.print("<TR align=center><td colspan=14 >对不起没有搜索到该用户!</td></tr>");
      }
    else
    {
      rs2.beforeFirst();
      while(rs2.next()){
      int id=rs2.getInt("UserID");
     // out.print(id);
%>
    <TR align=center>
				 <TD><input type=text class=text1   name=bn  size=5  value=<%=id%>></TD>
				 <td><input type=text class=text1   name=idna size=5  value=<%=rs2.getString("UserName")%>></td>
				 <TD><input type=text class=text1   name=aut size=5 value=<%=rs2.getString("RealName")%>></TD>
				 <TD><input type=text class=text1   name=bc size=5  value=<%=rs2.getString("UserPass")%>></TD>
				 <TD><input type=text class=text1   name=pub size=5  value=<%=rs2.getString("Sex")%>></TD>
				 <TD><input type=text class=text1   name=pic  size=5 value=<%=rs2.getString("Telephone")%>></TD>
				 <TD><input type=text class=text1   name=pri size=4  value=<%=rs2.getString("Address")%>></TD>
				 <TD><input type=text class=text1   name=amo  size=4 value=<%=rs2.getString("Post")%>></TD>
				 <TD><input type=text class=text1   name=lno size=4  value=<%=rs2.getString("Email")%>></TD> 
				 <TD><input type=text class=text1   name=reg size=7  value=<%=rs2.getString("RegTime")%>></TD>
				 <TD><input type=text class=text1   name=sal size=5  value=<%=rs2.getString("Educate")%>></TD>
			<%  out.println("<td><input type=checkbox  name=check"+id+ " value=id  ></td> "); %>
			</TR>
<% } } }catch(Exception e){
  			out.println(e.toString());} %>	
	</TBODY>
    </TABLE>
  <TABLE align=center style="width:700px;">
    	    <tr><td >&nbsp;&nbsp;</td></tr>
    		<TR>
    		<td>&nbsp;&nbsp;</td>
    			<td align=center >   <input type="button" name="Submit" value="全选" onclick="check()" /> <input type="button" name="Submit" value="反选" onclick="check2()" /> 
    			&nbsp;&nbsp;&nbsp;&nbsp;<input type="button" name="delete" value="删除选中项" style="margin-top:0px" onClick="return dele();">
    			</td>
    		</TR>
    	</TABLE>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明

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