📄 admin.jsp

📁 留学生信息管理系统我的工程实习的项目
💻 JSP
字号:
 <%@ page contentType="text/html; charset=GB2312"%>  
 <%@ page language="java" import="java.sql.*"%>
<jsp:directive.page import="news.sql_data"/>  

 <HTML>  
     <HEAD>  
         <TITLE>admin.jsp</TITLE>  

	
   	</HEAD>  
   	<SCRIPT LANGUAGE="JavaScript">  
     function btnClick(type){   
   	 var fm=document.form1   
 	  if(type=='add'){        
  		 fm.c.value=1;    
 		 return  true;   
   		}else if(type=='edt'){   
  				  fm.c.value=2;   
  				  return true;    
 				 }else if(type=='del'){   
    				fm.c.value=3;   
 					return true;     
	 			}   
	 }   
   
   function login(){
   	window.location="login.jsp"
   }
 		</SCRIPT>
   <jsp:useBean id="db" scope="session" class="news.sql_data"/>
     <BODY>      
     <%!
  	public String Bytes(String str)
  	{
  		try{
  			String str_1=str;
  			byte[] str_2=str_1.getBytes("ISO8859-1");
  			String bytes=new String(str_2);
  			return bytes;
  		}catch(Exception ex){
  			System.out.println("中文乱码解决问题出错"+ex.getMessage());
  			
  		}
  		return null;
  	}
   %>
         <%   try{
                 String parm = request.getParameter("c");   
                    
                 if(parm==null)   
                 {   
                 parm="";   
                    
                 }   
                 
               //  request.setCharacterEncoding("GBK");
                  	String  id=request.getParameter("id");   
                     String name=Bytes(request.getParameter("name")); 
                     String  password=request.getParameter("password");   
                     String roleid=Bytes(request.getParameter("roleid"));   
                     
               if (parm.equals("1")) {   
                        
                     String mysql = "insert into news values" + "(" + "'"
                      + name + "','" + password   
                     + "','" + roleid + "')"; 
                     db.executeUpdate(mysql);   
                   
                }else if (parm.equals("2")) {   
                     String mysql = "update news set name='"  
                     + name + "',password='" + password + "',roleid='"   
                     + roleid + "' where id='" + id + "'"; 
                     db.executeUpdate(mysql);   
   
                 } else if(parm.equals("3")){   
   
                     String mysql = "delete from news where id='"  
                     + id + "'";   
                     db.executeUpdate(mysql);   
                 }
                    
                             
                
                ResultSet rs=db.executeQuery("select news.id,news.name,news.password,role.role from news,role where news.roleid=role.id ");   
                
                %>
                	<%
                		if(session.getAttribute("name")==null){%>
                		<script language="JavaScript">
                			window.location="login.jsp"
                		</script>
                		<%}
                  		else
                			{%>
                			用户名：<%=session.getAttribute("name")%>
                			&nbsp;<input type="button" value="重新登录" onclick="login()">
                			<%}	
                	
                	 %>
           <table 	border="1" align="center" >
                	<tr><td align="center" colspan="5">成员列表</td></tr>
                	<tr bgcolor="d1d1ff">
  						<th>ID</th><th>姓  名</th><th>密 码</th><th>角 色</th><th>选择</th>
  					</tr>

                <%
                
                
              while(rs.next()){          
                  %> 
 		 <tr>
  			<td><%=rs.getString(1)%></td>
 			<td><%=rs.getString(2)%></td> 
 			<td><%=rs.getString(3)%></td> 
  			<td><%=rs.getString(4)%></td> 
  			<td><input type="checkbox" name="checkbox" value="checkbox"></td>
  		</tr>
			<%}
			
			rs.close();
		db.closeStmt();
		db.closeConn();
           }catch(Exception exc1){
				System.out.println("在执行数据库访问时发生了错误！");
				exc1.printStackTrace();
				}                           
             
         %>  
         </table>
         <center>  
             <form id="form1" name="form1" method="post"  action="admin.jsp">  
                 <br>  
               	&nbsp; I D:   
                 <input type="text" name="id" value="" >  
                 <br>  
                 名&nbsp;字:   
                 <input type="text" name="name" value="" >  
                 <br>  
                 密&nbsp;码:   
                 <input type="password" name="password" value="" >  
                 <br>  
                 角色ID:   
                 <input type="text" name="roleid" value="">  
   
                 <br>  
 <input type="hidden" name="c" id="c">  
 <input type="submit" name="add" value="新增" onclick="btnClick('add')" >  
 <input type="submit" name="edt" value="修改" onclick="btnClick('edt')">  
 <input type="Submit" name="del" value="删除" onclick="btnClick('del')">  
 <input type="button" name="ret" value="返回" onclick="history.go(-1)"> 
 <input type="button" onClick="window.opener = '';window.close();" value="关闭" > 
           </form>  
           		  
         </center>  
   
    </BODY>   
   </HTML>
⌨️ 快捷键说明

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