@Override
  public boolean addRole(Role role) {
    boolean flag = false;
    String newRoleName = role.getName();
    int newRolePrivilege = role.getRole_privilege();
    String sql =
        "insert into role_cl "
            + "values(myrole.nextval, "
            + "'"
            + newRoleName
            + "'"
            + ","
            + newRolePrivilege
            + ")";
    Connection conn = null;
    Statement stmt = null;
    try {
      conn = ConnectUtils.getConnection();
      stmt = conn.createStatement();
      int n = stmt.executeUpdate(sql);
      if (n == 1) {
        flag = true;
      }
    } catch (Exception e) {

    }
    return flag;
  }
  @Override
  public boolean updateRole(Role role) {
    boolean flag = false;
    String RoleName = role.getName();
    int RolePrivilege = role.getRole_privilege();
    System.out.println(RoleName);
    String sql =
        "update role_cl set role_privilege = "
            + RolePrivilege
            + " where role_name = "
            + "'"
            + RoleName
            + "'";
    Connection conn = null;
    Statement stmt = null;
    try {
      conn = ConnectUtils.getConnection();
      stmt = conn.createStatement();
      int n = stmt.executeUpdate(sql);
      if (n == 1) {
        flag = true;
      }
    } catch (Exception e) {

    }
    return flag;
  }
 @Override
 public List<Role> searchAllRole() {
   String sql = "select * from role_cl";
   List<Role> list = new ArrayList<Role>();
   int role_id = 0;
   String role_name = null;
   int role_privilege = 0;
   Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;
   try {
     conn = ConnectUtils.getConnection();
     stmt = conn.createStatement();
     rs = stmt.executeQuery(sql);
     while (rs.next()) {
       Role getRole = new Role();
       role_id = rs.getInt("role_id");
       role_name = rs.getString("role_name");
       role_privilege = rs.getInt("role_privilege");
       getRole.setId(role_id);
       getRole.setName(role_name);
       getRole.setRole_privilege(role_privilege);
       list.add(getRole);
     }
   } catch (Exception e) {
     e.printStackTrace();
   } finally {
     ConnectUtils.close(rs);
     ConnectUtils.close(stmt);
     ConnectUtils.close(conn);
   }
   return list;
 }