📄 updaterights.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*, java.text.SimpleDateFormat, java.util.*,
java.util.Date" import="com.saas.biz.mysite.*" errorPage=""%>
<!--------------------------------------------------------------------
当前页面JavaScript函数部分
---------------------------------------------------------------------->
<html>
<script language="javascript" src="Calendar.js"></script>
<!--选择授权人员操作-->
<script language="JavaScript">
<!-- 分配权限操作 -->
function moveToRight(){
var flag=false;
var selectName,selectIdx,index,count,addName="";
index=document.grantRights.rightsList.selectedIndex;
count=document.grantRights.leftList.options.length;
if(index<0){
alert("请选择要分配的权限项!");
}else{
selectName=document.grantRights.rightsList.options[index].text;
selectIdx=document.grantRights.rightsList.value;
<!--向分配权限列表中加入一项-->
if(count>0){
for(var i=0;i<count;i++){
addName=document.grantRights.leftList.options[i].text;
addName=addName.replace(/(^\s+)|\s+$/g,"") ;
selectName=selectName.replace(/(^\s+)|\s+$/g,"") ;
if(addName==selectName){
flag=false;
}else{
flag=true;
}
}
if(flag){
document.grantRights.leftList.options.add(new Option(selectName,selectIdx));
}
}else{
document.grantRights.leftList.options.add(new Option(selectName,selectIdx));
}
<!--将分配过的权限项从已有权限列表中删除-->
document.grantRights.rightsList.options.remove(index);
}
}
<!--取消权限操作-->
function moveToLeft(){
var selectName,selectIdx,index,count,addName="";
var flag=false;
index=document.grantRights.leftList.selectedIndex;
count=document.grantRights.rightsList.options.length;
if(index<0){
alert("请选择要回收的权限项!");
}else{
selectName=document.grantRights.leftList.options[index].text;
selectIdx=document.grantRights.leftList.value;
<!--向已有权限列表中加入在分配权限项中删除的那一项-->
if(count>0){
for(var i=0;i<count;i++){
addName=document.grantRights.rightsList.options[i].text;
addName=addName.replace(/(^\s+)|\s+$/g,"") ;
selectName=selectName.replace(/(^\s+)|\s+$/g,"") ;
if(addName==selectName){
flag=false;
}else{
flag=true;
}
}
if(flag){
document.grantRights.rightsList.options.add(new Option(selectName,selectIdx));
}
}else{
document.grantRights.rightsList.options.add(new Option(selectName,selectIdx));
}
<!--将分配过的权限项从分配权限列表中删除-->
document.grantRights.leftList.options.remove(index);
}
}
<!--保存权限信息-->
function saveRightsInfo(){
var count,elemName,elemValue,acceptName,optionStr="";
var bgtime,ovtime,aa,bb;
aa=document.grantRights.startTime.value;
bb=document.grantRights.endTime.value;
bgtime=aa.split("-")[0]+aa.split("-")[1]+aa.split("-")[2];
ovtime=bb.split("-")[0]+bb.split("-")[1]+bb.split("-")[2];
acceptName=document.grantRights.acceptMenName.value;
count=document.grantRights.leftList.options.length;
<!-- 判断开始时间是否小于结束时间-->
if(bgtime>ovtime){
alert("开始时间："+aa+" 不能大于结束时间："+bb);
return false;
}
if(count>0){
if(acceptName==null || acceptName.length<1){
alert("请选择接受权限分配的人员!");
return false;
}else{
for (var i=0;i<count;i++){
optionStr+=document.grantRights.leftList.options[i].value+";";
}
document.grantRights.options.value=optionStr;
return true;
}
}else{
return true;
}
}
<!--返回主页-->
function returnRightsInfo(){
document.grantRights.action="default.jsp";
}
<!--取消权限信息-->
function cancelRightsInfo(){
window.location.reload();
}
</script>
<script language="javascript">
var cdr = new Calendar("cdr");
document.write(cdr);
cdr.showMoreDay = true;
</script>
<body>
<div>
<%
String curr_UserName,end,start,acceptMan,sql,acceptId;
Calendar date_Time = Calendar.getInstance();
date_Time.set(Calendar.MONTH,date_Time.get(Calendar.MONTH)+3 );
HttpSession tempsession = request.getSession();
curr_UserName=(String)tempsession.getAttribute("SESSION_USER_NAME");
acceptMan=request.getParameter("acceptMenName");
acceptId=request.getParameter("acceptMenId");
start =new SimpleDateFormat("yyyy-MM-dd").format(new Date()).toString();
end =new SimpleDateFormat("yyyy-MM-dd").format(date_Time.getTime()).toString();
%>
<%
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@192.168.10.202:1521:saas";
String user = "dev";
String password = "111111";
Connection conn = DriverManager.getConnection(url, user,password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql = "select t.menu_name,t.menu_id from menuinfo t where t.menu_id in( select f.menu_id from rightinfo f where f.end_date>=sysdate and f.staff_id= '"+curr_UserName+"')";
ResultSet rs = stmt.executeQuery(sql);
%>
<form action="saveOrUpdateRights.jsp" method="get" name="grantRights">
<table width="100" bgcolor="#9999CC">
<tr>
<td nowrap align="center">权限管理</td>
<td nowrap align="center">权限操作</td>
<td nowrap align="center">已有权限</td>
<td nowrap align="center">授权人</td>
</tr>
<tr align="center">
<td>
<select name="rightsList" size="15" multiple>
<% while (rs.next()) {%>
<option value=<%=rs.getString(2) %>><%=rs.getString(1)%></option>
<%
}
%>
</select></td>
<td align="center">
<input name="moveToR" type="button" value=" >> "align="middle" onClick="moveToRight()">
<p>
<br>
<input name="moveToL" type="button" value=" << "align="middle" onClick="moveToLeft()">
</td>
<td width="25" align="left">
<%
sql="select t.menu_id,t.menu_name from menuinfo t where t.menu_id in(select f.menu_id from rightinfo f where f.end_date >= sysdate and f.staff_id='"+acceptMan+"')";
ResultSet rst = stmt.executeQuery(sql);%>
<select name="leftList" size="15">
<%
while(rst.next()){
%>
<option value=<%=rst.getString(1)%>><%=rst.getString(2)%></option>
<%}%>
</select>
</td>
<td align="left">姓名
<input name="acceptMenName" type="text" value="<%=acceptMan%>">
UserId
<input name="acceptMenId" type="text" value="<%=acceptId%>" >
<input name="options" type="hidden">
<br>
开始时间
<input name="startTime" type="text" value="<%=start %>">
<br>
结束时间
<input name="endTime" type="text" value="<%=end %>">
</td>
</tr>
<tr align="center">
<td align="center"><input name="saveRights" type="submit" value=" 保存 " onClick="return saveRightsInfo()"></td>
<td align="center"><input name="resetRights" type="button" value=" 取消 " onClick="cancelRightsInfo()"></td>
</tr>
</table>
</form>
<%
rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
%>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -