📄 insertaccount.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统
💻 JSP
字号:
<jsp:useBean id="account" class="src.wuyang.Account" scope="page"/>
<jsp:useBean id="role" class="src.com.RoleRight" scope="page"/>
<jsp:useBean id="global" class="src.com.MyGlobal" scope="session"/>

<% if (global.isLogined == false) {
%>
<jsp:forward page="../pub/DBErr.jsp" > 
	<jsp:param name="rtcode" value="-4" />
</jsp:forward>
<%	}
%>

<HTML>
<HEAD>
<TITLE>InsertDepartment</TITLE>
<script language ="javascript" src='../pub/pub.js' type=text/javascript></script>
<link rel="stylesheet" href="css.css" type="text/css">
</HEAD>
<script language="JavaScript">
function VerifyInput(e){
	if(isEmpty(e.accountId.value)){    
			alert("请输入帐号");
			e.accountId.focus();  
			return false;
		} 
	
	if(isEmpty(e.employeeId.value)){    
			alert("请输入职员编号");
			e.employeeId.focus();  
			return false;
		}
	
	if(isEmpty(e.password.value))
		{    
			alert("请选择密码");
			e.password.focus();  
			return false;
		}
}	
</script>
<%! String mode;%>
<%
	mode = request.getParameter("mode");
	if (request.getParameter("insert")!=null && mode.equals("insert") ){ 
	account.setGlobal(global);	
%>
<jsp:setProperty name="account" property="*" />
<%
	int rtcode = account.insert();

	if(rtcode >= 0) {
%>
<jsp:forward page="InsertAccount.jsp"> 
	<jsp:param name="mode" value="ok" />
</jsp:forward>
<% 	
	}else {  
%>
<jsp:forward page="../pub/DBErr.jsp" > 
	<jsp:param name="rtcode" value="<%= rtcode %>" />
</jsp:forward>

<%  
	}  
}

	if (mode!= null && mode.equals("ok")){
%>
<span class="title">记录插入成功!!</span> 
<%
	}
%><BODY bgcolor=#949b93>
<table width="100%" border="1" height="90%" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" cellpadding="0" cellspacing="0">
  <tr> 
    <td valign="top">
      <blockquote><br>
        <br><FORM METHOD="post"  onsubmit="return VerifyInput(this)">
<input type="hidden" name="mode" value="insert"/>
          <table width="45%" border="0">
            <tr> 
              <td width="22%" class="textb"><b>帐号 </b></td>
              <td width="78%"> 
                <input type="text" name="accountId" />
              </td>
            </tr>
            <tr> 
              <td width="22%" class="textb"><b>人员编号</b></td>
              <td width="78%"> 
                <input type="text" name="employeeId" />
              </td>
            </tr>
            <tr> 
              <td width="22%" class="textb"><b>密码</b></td>
              <td width="78%"> 
                <input type="password" name="password" />
              </td>
            </tr>
            <tr> 
              <td width="22%" class="textb"><b>角色号</b></td>
              <td width="78%"> 
                <select name="roleId">
                  <%
	role.query("","roleId");
	while(role.next()>0){
%>
                  <option value="<%=role.getRoleId()%>"><%=role.getRoleName()%></option>
                  <%
	}
%>
                </select>
              </td>
            </tr>
            <tr> 
              <td colspan="2"> 
                <div align="center"> <br>
                  <input type="submit" name="insert" value="新增" />
                  <input type="reset" value="重置" name="reset" />
                </div>
              </td>
            </tr>
          </table>
          <br>
          <br>
          <br>
          <p>&nbsp; 
        </FORM>
      </blockquote>
    </td>
  </tr>
</table>
</BODY>
</HTML>
⌨️ 快捷键说明

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