📄 sysuserinfo.jsp

📁 JSP软件工程案例精解书中的webStore例子源码
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@page import="java.util.*"%>
<%@page import="java.io.*"%>
<%@page import="java.sql.*,java.lang.Double.*"%>
<%@include file="comm.jsp"%>

<html>

<SCRIPT language=javascript>
<!--
function datacheck()
{

	if(frmUpdate.password.value=="" || frmUpdate.password.value!=frmUpdate.repassword.value)
	{
		window.alert("请设置两次密码一致");
		document.frmUpdate.elements(1).focus();
		return;
	}

	frmUpdate.submit();
}
-->
</SCRIPT>

<body link="#000000" vlink="#000080" alink="#000080">
<div>
  <table>
     <tr>
	
<%
String SysuserID=(String)session.getValue("sysuser");
String SysuserType=(String)session.getValue("sysuserType");
String tempID=SysuserID;
action=request.getParameter("action");

if(SysuserID==null)
{%>
	<jsp:forward page="CustomerLogin.htm"/>
<%}

if(SysuserType.compareTo("系统管理员")==0)
{ %>
	<td width="236" align=center valign=top> <br>
		
		<p ><font color="#000080"><a href=SysuserInfo.jsp?action=mine>我的资料</a></font></p>
		<p> <a href=SysuserInfo.jsp?action=list>用户列表</a></p>
		<p> <a href=SysuserRegist.htm>添加用户</a></p>	
	</td>
<%}
else if(SysuserType.equals("商品管理员"))
{%>
	<td width="236" align=center valign=top> <br>
		<p ><font color="#000080"><a href=SysuserInfo.jsp?action=mine>我的资料</a></font></p>
		<p><a href="GoodsInfo.jsp?action=view&type=1">商品管理</a></p>
	</td>
<%}
else if(SysuserType.equals("财务管理员"))
{%>
	<td width="236" align=center valign=top> <br>
		<p ><font color="#000080"><a href=SysuserInfo.jsp?action=mine>我的资料</a></font></p>
		<p><a href="BillInfo.jsp?action=view&type=2">帐单管理</a></p>
	</td>
<%}

if(action.compareTo("list")==0)
{ %>
	<td align=center >
	欢迎您：<%=SysuserID%> (<%=SysuserType%>)</p>
	<table>
	  <tr bgcolor=#E9E9D1>
		<td width=129>系统ID</td>
		<td width=129>姓名</td>
		<td width=229>用户类型</td>
		<td width=50></td>
	 </tr>
<%
	strSql="{call dbo.sp_GetAllSysuser()}";
	cstmt=conn.prepareCall(strSql);
	
	rs=cstmt.executeQuery();
	while(rs.next())
	{ %>
	  <tr bgcolor="#EAFfFff">
		<td><a href=SysuserInfo.jsp?action=view&SysID=<%=rs.getString(1)%>>
		    <%=new String(rs.getString(1).getBytes("8859_1"),"gb2312")%></td>
		<td><%=new String(rs.getString(2).getBytes("8859_1"),"gb2312")%></td>
		<td><%=new String(rs.getString(4).getBytes("8859_1"),"gb2312")%></td>
		<td><a href=SysuserInfo.jsp?action=del&SysID=<%=rs.getString(1)%>>删除</a></td>
	  </tr>
	<%}%>
	</table>
	</td> <%	
}

if(action.compareTo("update")==0)
{ 
	String sysID=request.getParameter("SysID");
	String sysName=request.getParameter("SysuserName");
	String pwd=request.getParameter("password");

	strSql="{call dbo.sp_UpdateSysuser(?,?,?)}";
	cstmt=conn.prepareCall(strSql);
	cstmt.setString(1,sysID);
	cstmt.setString(2,sysName);
	cstmt.setString(3,pwd);
	cstmt.executeUpdate();

	tempID=sysID;
}

if(action.compareTo("insert")==0)
{
	String sysID=request.getParameter("SysID");
	String sysName=request.getParameter("SysuserName");
	String pwd=request.getParameter("password");
	String sysType=request.getParameter("SysuserType");

	strSql="{call dbo.sp_InsertSysuser(?,?,?,?)}";
	cstmt=conn.prepareCall(strSql);
	cstmt.setString(1,sysID);
	cstmt.setString(2,sysName);
	cstmt.setString(3,pwd);
	cstmt.setString(4,sysType);

	cstmt.executeUpdate();
	
	tempID=sysID;

	out.print("<p align=center>添加"+sysID+"成功</p>");
}
	
if(action.compareTo("del")==0)
{
	String sysID=request.getParameter("SysuserID");
	
	strSql="{call dbo.sp_DelSysuser(?)}";
	cstmt=conn.prepareCall(strSql);
	cstmt.setString(1,sysID);
	cstmt.executeUpdate();

	out.print("<p align=center>删除"+sysID+"成功</p>");

}

if(action.compareTo("view")==0)
{
	tempID=request.getParameter("SysID");
}

strSql="{call dbo.sp_GetSysuser(?)}";
cstmt=conn.prepareCall(strSql);
cstmt.setString(1,tempID);

rs=cstmt.executeQuery();
if(!rs.next())
	out.println("<p align=center>错误的用户，无权使用！</p>");
else if(action.compareTo("list")==0||action.compareTo("del")==0)
	out.println("");
else
{	
			
%>

	<td>
	<p align=center>欢迎您：<%=SysuserID%> (<%=SysuserType%>)</p>
	<form method="POST" action="SysuserInfo.jsp?action=update&SysID=<%=tempID%>" name="frmUpdate">
	<table align=center>
        	<tr bgcolor="#E9E9D1">
        		<td align=center width="89"> 　</td>
        		<td align=center width="337"> <p align="left">　 </td>
        	</tr>
       		<tr>          
			<td width="89">ID:&nbsp;&nbsp;&nbsp;  </td>   
			<td width="337"><%=rs.getString(1)%>  </td>        
		</tr>
		<tr bgcolor="#EAFfFff">    
			<td width="89">姓名： </td>    
			<td width="337"><input type="text" name="SysuserName" size="17" 
				value=<%=new String(rs.getString(2).getBytes("8859_1"),"gb2312")%>>  * </td>         
		</tr>
		<tr>	
			<td width="89">密码： </td>  
			<td width="337"><input type="password"  name="password" size="13" >* </td>  
		</tr>
		<tr bgcolor="#EAFfFff">	
			<td width="89">修改密码： </td>
			<td width="337"><input type="password"  name="repassword" size="13" >* </td>
		</tr>
		<tr >    
			<td width="89">用户类型：</td>  
			<td width="337"> 
				<%=new String(rs.getString(4).getBytes("8859_1"),"gb2312")%>
			</td>
			 
		</tr>
	</table>
	<table align=center><br>
        	<p><button type="none" class="button" onclick="datacheck()">修改提交</button>
		<input type="reset" value="全部重写" name="B2"></p>
        </table>
      	</form>
 	</td>

<%
}
rs.close();
cstmt.close();
conn.close();	

%>
   </tr>
 </table>
 </div>
</body>

</html>
💿 文件大小 141 K
👤 上传用户 a1a1J0
📂 所属分类书籍源码
🏷️ 相关标签

#webStore #JSP #软件工程 #案例
⌨️ 快捷键说明

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