offlogbean.java~3~

Java数据库系统开发实例导航的例子

  public boolean workDel(HttpServletRequest req, HttpServletResponse resp) {
    HttpSession httpsession = req.getSession();
    String username = (String) httpsession.getAttribute("username");

    boolean islogin = isLogin(req, resp);
    if (!islogin) {
      return islogin;
    }

    String jobid = req.getParameter("jobid");
    String sql = "delete from job where jobid=" + jobid;
    System.out.println("update sql is: " + sql);

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    dbAdo.update_insert(sql);
    dbAdo.close();
    String result = "删除工作日志成功!";
    req.setAttribute("result", result);

    return islogin;
  }

  public boolean deptList(HttpServletRequest req, HttpServletResponse resp) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }

    String partid = "";
    String sql1 = "select * from part";
    String sql2 = "";
    ResultSet rs2 = null;

    Vector deptList = new Vector();
    Vector userList = new Vector();

    DbADO dbAdo = new DbADO();
    dbAdo.connect();

    ResultSet rs1 = dbAdo.select(sql1);

    try {

      while (rs1.next()) {
        userList = null;
        userList = new Vector();
        partid = rs1.getString("partid");
        System.out.println("partid=" + partid);
        userList.addElement(partid);
        userList.addElement(rs1.getString("partname"));

        sql2 = "select * from users where partid=" + partid;
        rs2 = dbAdo.select(sql2);

        while (rs2.next()) {
          userList.addElement(rs2.getString("id"));
          userList.addElement(rs2.getString("username"));
          userList.addElement(rs2.getString("truename"));
          System.out.println("truename=" + rs2.getString("truename"));
        }
        deptList.addElement(userList);

      }

    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      dbAdo.close();
    }

    if (deptList != null) {
      req.setAttribute("deptList", deptList);

    }
    return isadmin;
  }

  public boolean deptSave(HttpServletRequest req, HttpServletResponse resp,
                          String partname) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }

    System.out.println("partname is: " + partname);

    String sql = "insert into part (partname) values ('" + partname + "')";

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    dbAdo.update_insert(sql);
    dbAdo.close();
    String result = "添加部门成功!";
    req.setAttribute("result", result);
    return isadmin;
  }

  public boolean deptDel(HttpServletRequest req, HttpServletResponse resp) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }

    String partid = req.getParameter("partid");
    String sql = "delete from part where partid=" + partid;
    System.out.println("update sql is: " + sql);

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    dbAdo.update_insert(sql);
    dbAdo.close();
    String result = "删除部门成功!";
    req.setAttribute("result", result);

    return isadmin;
  }

  public boolean deptEdit(HttpServletRequest req, HttpServletResponse resp) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }

    String partid = req.getParameter("partid");
    Vector viewContent = new Vector();

    String sql = "select * from part where partid=" + partid;

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    ResultSet rs = dbAdo.select(sql);
    try {

      while (rs.next()) {
        viewContent.addElement(rs.getString("partid"));
        viewContent.addElement(rs.getString("partname"));
      }

    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      dbAdo.close();
    }

    if (viewContent != null) {
      req.setAttribute("viewContent", viewContent);

    }

    return isadmin;

  }

  public boolean deptUpdate(HttpServletRequest req, HttpServletResponse resp,
                            String partname) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }

    String partid = req.getParameter("partid");

    String sql = "update part set partname='" + partname + "' where partid=" +
        partid;
    System.out.println("update sql is: " + sql);

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    dbAdo.update_insert(sql);
    dbAdo.close();
    String result = "编辑部门成功!";
    req.setAttribute("result", result);

    return isadmin;
  }

  public boolean userNew(HttpServletRequest req, HttpServletResponse resp) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }

    String partid = req.getParameter("partid");
    String partname = "";
    String sql = "select * from part where partid=" + partid;

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    ResultSet rs = dbAdo.select(sql);
    try {

      while (rs.next()) {
        partname = rs.getString("partname");
      }

    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      dbAdo.close();
    }

    req.setAttribute("partid", partid);
    req.setAttribute("partname", partname);

    return isadmin;

  }

  public boolean userSave(HttpServletRequest req, HttpServletResponse resp,
                          String truename, String username) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }

    System.out.println("username is: " + username);

    String password = req.getParameter("password").trim();
    String userflag = req.getParameter("flag");
    String partid = req.getParameter("partid");
    String sql =
        "insert into users (username,password,truename,flag,partid) values ('" +
        username + "',";
    sql = sql + "'" + password + "','" + truename + "'," + userflag + "," +
        partid + ")";

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    dbAdo.update_insert(sql);
    dbAdo.close();
    String result = "添加用户成功!";
    req.setAttribute("result", result);

    return isadmin;
  }

  public boolean userEdit(HttpServletRequest req, HttpServletResponse resp) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }

    String id = req.getParameter("id");
    Vector viewContent = new Vector();

    String sql = "select * from users where id=" + id;

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    ResultSet rs = dbAdo.select(sql);
    try {

      while (rs.next()) {
        viewContent.addElement(rs.getString("id"));
        viewContent.addElement(rs.getString("username"));
        viewContent.addElement(rs.getString("password"));
        viewContent.addElement(rs.getString("truename"));
        viewContent.addElement(rs.getString("flag"));
      }

    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      dbAdo.close();
    }

    if (viewContent != null) {
      req.setAttribute("viewContent", viewContent);

    }
    return isadmin;

  }

  public boolean userUpdate(HttpServletRequest req, HttpServletResponse resp,
                            String truename, String username) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }

    String id = req.getParameter("id");
    String password = req.getParameter("password").trim();
    String flag = req.getParameter("flag");

    String sql = "update users set username='" + username + "',password='" +
        password + "',truename='" + truename + "'";
    sql = sql + ",flag=" + flag + " where id=" + id;
    System.out.println("update sql is: " + sql);

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    dbAdo.update_insert(sql);
    dbAdo.close();
    String result = "编辑用户信息成功!";
    req.setAttribute("result", result);

    return isadmin;
  }

  public boolean userDel(HttpServletRequest req, HttpServletResponse resp) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }

    String id = req.getParameter("id");
    String sql = "delete from users where id=" + id;
    System.out.println("update sql is: " + sql);

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    dbAdo.update_insert(sql);
    dbAdo.close();
    String result = "删除员工信息成功!";
    req.setAttribute("result", result);

    return isadmin;
  }

  public boolean passEdit(HttpServletRequest req, HttpServletResponse resp) {
    HttpSession httpsession = req.getSession();
    String username = (String) httpsession.getAttribute("username");

    boolean islogin = isLogin(req, resp);
    if (!islogin) {
      return islogin;
    }

    Vector viewContent = new Vector();

    String sql = "select * from users where username='" + username + "'";

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    ResultSet rs = dbAdo.select(sql);
    try {

      while (rs.next()) {
        viewContent.addElement(rs.getString("id"));
        viewContent.addElement(rs.getString("username"));
        viewContent.addElement(rs.getString("password"));
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      dbAdo.close();
    }

    if (viewContent != null) {
      req.setAttribute("viewContent", viewContent);

    }

    return islogin;

  }

  public boolean passUpdate(HttpServletRequest req, HttpServletResponse resp) {
    HttpSession httpsession = req.getSession();
    String username = (String) httpsession.getAttribute("username");

    boolean islogin = isLogin(req, resp);
    if (!islogin) {
      return islogin;
    }

    String password = req.getParameter("newpin").trim();
    String sql = "update users set password='" + password +
        "' where username='" + username + "'";
    System.out.println("update sql is: " + sql);

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    dbAdo.update_insert(sql);
    dbAdo.close();
    String result = "修改密码成功!";
    req.setAttribute("result", result);

    return islogin;
  }

  public boolean logOut(HttpServletRequest req, HttpServletResponse resp) {
    HttpSession httpsession = req.getSession();
    httpsession.setAttribute("truename", null);
    httpsession.setAttribute("flag", null);
    httpsession.setAttribute("username", null);

    return true;
  }

  public boolean isAdmin(HttpServletRequest req, HttpServletResponse resp) {
    boolean isadmin = true;

    HttpSession httpsession = req.getSession();
    String username = (String) httpsession.getAttribute("username");
    Integer Flag = null;
    Flag = (Integer) httpsession.getAttribute("flag");
    int flag = Flag.intValue();

    if (username == null || flag > 2) {
      isadmin = false;

    }
    return isadmin;
  }

  public boolean isLogin(HttpServletRequest req, HttpServletResponse resp) {
    boolean islogin = true;

    HttpSession httpsession = req.getSession();
    String username = (String) httpsession.getAttribute("username");

    if (username == null) {
      islogin = false;

    }
    return islogin;
  }
}