📄 editdepart.jsp

📁 该源码为JSP的开发案例集锦
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ include file="verify.jsp" %>
<%@ include file="../share/connection.jsp" %>
<%
String name = (String)session.getAttribute("adminname");
if(!name.equals("admin"))
{
	out.println("您没有此权限");
	return;
}
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../jscss/styles.css" rel="stylesheet" type="text/css">
</head>
<body>
<%
int flag=0;
String departid;
String departname;
String departlink;

String sqlList;
String sqlDepart;
String sqlSaveEdit;
ResultSet rsList;
ResultSet rsDepart;
String action=request.getParameter("action");
String actionArray[]={"list","edit","save"};
for(int i=0;i<actionArray.length;i++)
{
if (action.equalsIgnoreCase(actionArray[i]))
 {
   flag=i;
	break;
  }
}
switch(flag)
{
	case 0:
	%>
<TABLE width="80%" height=20 
      border=0 align="center" cellPadding=0 cellSpacing=0 background="../images/adminbg.gif" bgColor=#587dbc>
  <TBODY>
      <TR> 
        
      <TD><font color="#ffffff"> 
        <div align="center"><strong><font color="#000000">编辑部门</font></strong></div>
          </font></TD>
      </TR>
    </TBODY>
  </TABLE>
	    
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="20" style="border:1px solid #003366">
  <tr>  
    <td>
      <%	
sqlList="select * from cs_depart";
rsList=stm.executeQuery(sqlList);
while(rsList.next())
{%>
      <table width="100%" border="0" align="center">
        <tr>
          <td><%
  out.print(rsList.getString("depart_name"));
  %></td>
          <td width="100"><a href="editdepart.jsp?action=edit&departid=<%=rsList.getInt("depart_id")%>">编辑</a>
            |||<a href="deldepart.jsp?departid=<%=rsList.getInt("depart_id")%>">删除</a></td>
        </tr>
      </table><hr style="height:1px;color:#003366">
      <p> 
        <%

}
	break;
case 1:
	departid=request.getParameter("departid");
	sqlDepart="select * from cs_depart where depart_id="+departid;
	rsDepart=stm.executeQuery(sqlDepart);
	rsDepart.next();
	departname =rsDepart.getString("depart_name");
	departlink =rsDepart.getString("depart_link");
	%>
      </p></td>
  </tr>
</table>
<FORM name=frmDepartInfo action='editdepart.jsp?action=save' method=post >
  <TABLE width="80%" height=20 
      border=0 align="center" cellPadding=0 cellSpacing=0 background="../images/adminbg.gif" bgColor=#587dbc>
    <TBODY>
      <TR> 
        <TD><font color="#ffffff"> 
          <div align="center"><strong><font color="#000000">编辑部门</font></strong></div>
          </font></TD>
      </TR>
    </TBODY>
  </TABLE>
  <table width="80%" align=center cellpadding=3 cellspacing=20 style="border:1px solid #003366">
    <TBODY>

		<TD width=16% ><b>名称</b>：<BR> </TD>
		<TD width=84%  >
		 <INPUT maxLength=20 size=20 name=departname value='<%=departname%>'>
		 <INPUT  size=20 name=departlink value='<%=departlink%>'>
		 </TD>
	  </TR>
	  
    <TR align="center"> 
      <TD colspan="2" > 
        <input type="hidden"  name="departid" value="<%=departid%>"> 
		  <input type=submit value="提交" name=Submit> <input type=reset value="清 除" name=reset>
		  <input type="button" name="Cancel" value="返回" onClick="history.back()">
      </TD>
	  </TR>
  </table>

</form>
<%
break;
case 2:
departid=request.getParameter("departid");
departname=request.getParameter("departname");
departlink=request.getParameter("departlink");

sqlDepart="UPDATE cs_depart SET "
	+"depart_name="+"'"+departname+"',"
	+"depart_link="+"'"+departlink+"'"
	+" "+"where depart_id="+departid;

	if(stm.executeUpdate(sqlDepart)==1)
        {
          out.print("修改部门成功");
        }
}
%>
</body>
</html>
⌨️ 快捷键说明

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