?? 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 + -