?? rightoperate.java
字號:
package com.ICT.AFC.user.beans;
import com.ICT.AFC.DB.DB;
import java.sql.ResultSet;
import java.util.ArrayList;
/**
* <p>Title:權限類相關操作 </p>
* <p>Description:權限類相關操作,包括部門插入、修改、刪除。 </p>
* <p>Copyright: Copyright (c) 2006</p>
* <p>Company: 電子所AFC事業部</p>
* @author 梅曉峰
* @version 1.0
*/
public class RightOperate {
public RightOperate() {
}
/**
* 添加新權限信息方法
* @param db DB
* @param department Department
* @throws Exception
* @return boolean
*/
public static boolean AddRight(DB db, Right right) throws
Exception {
ResultSet rs;
int rightid = right.getRightId();
String rightremark = right.getRightRemark();
String rightdesc = right.getRightDesc();
String sqlstr =
"insert into M_RIGHT(RIGHTID,RIGHTNAME,RIGHTREMARK) values("
+ rightid + ",'"
+ rightdesc + "','"
+ rightremark + "')";
if (db.ExecSql(sqlstr) == 0) {
return false;
}
else {
return true;
}
}
/**
* 查找權限信息方法
* @param db DB
* @param department Department
* @throws Exception
* @return boolean
*/
public static ArrayList SearchRight(DB db) throws
Exception {
ResultSet rs;
ArrayList RightList = new ArrayList();
String sqlstr = "select * from M_RIGHT order by RIGHTID";
rs = db.OpenSql(sqlstr);
while (rs.next()) {
Right right = new Right();
right.setRightId(rs.getInt("RIGHTID"));
right.setRightDesc(rs.getString("RIGHTNAME"));
right.setRightRemark(rs.getString("RIGHTREMARK"));
RightList.add(right);
}
return RightList;
}
/**
* 刪除權限信息方法
* @param db DB
* @param department Department
* @throws Exception
* @return boolean
*/
public static boolean deleteRight(DB db, int rightID) throws Exception {
String strSql = null;
strSql = "delete M_Right where RIGHTID=" + rightID;
if (db.ExecSql(strSql) == 0) {
System.out.println("order false");
return false;
}
else {
System.out.println("order true");
return true;
}
}
/**
* 修改權限信息方法
* @param db DB
* @param department Department
* @throws Exception
* @return boolean
*/
public static boolean updateRight(DB db, Right right) throws Exception {
String strSql = null;
String rightname = right.getRightDesc();
String rightremark = right.getRightRemark();
int rightid = right.getRightId();
strSql = "update M_Right set RIGHTNAME=" + rightname +
",RIGHTREMARK=" + "'" + rightremark + "'" +
" where RIGHTID=" + rightid;
if (db.ExecSql(strSql) == 0) {
System.out.println("order false");
return false;
}
else {
System.out.println("order true");
return true;
}
}
/**
* 權限編號加1方法
* @param db DB
* @param department Department
* @throws Exception
* @return boolean
*/
public static int SearchRightID(DB db) throws Exception {
int no;
ResultSet rs;
String strSql = null;
strSql = "select Max(RIGHTID) from M_RIGHT";
rs = db.OpenSql(strSql);
if (rs.next()) {
no = rs.getInt(1) + 1;
}
else {
no = 1;
}
return no;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -