offlogbean.java~3~

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

    DbADO dbAdo = new DbADO();
    try {

      dbAdo.connect();
      ResultSet rs = dbAdo.select(sql1);

      while (rs.next()) {
        id = rs.getInt("id");
        truename = rs.getString("truename");
        allAdmin.addElement(new Integer(id));
        allAdmin.addElement(truename);

        System.out.println("admin is: " + id + "   " + truename);
      }

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

      }
      rs = dbAdo.select(sql2);

      while (rs.next()) {
        viewContent.addElement(rs.getString("content"));
        viewContent.addElement(rs.getString("content2"));
        viewContent.addElement(rs.getString("title"));
        viewContent.addElement(rs.getString("hits"));
        viewContent.addElement(rs.getString("dateandtime"));
        viewContent.addElement(rs.getString("authorid"));
        viewContent.addElement(rs.getString("writer"));
        viewContent.addElement(rs.getString("writefrom"));
        viewContent.addElement(rs.getString("companyid"));

      }

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

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

    }
    return isadmin;

  }

  public boolean companyUpdate(HttpServletRequest req, HttpServletResponse resp,
                               String title, String content, String content2,
                               String writer, String writefrom) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }

    String companyid = req.getParameter("companyid");
    String authorid = req.getParameter("id");
    String sql = "update company set title='" + title + "',content='" + content +
        "',content2='" + content2 + "'";
    sql = sql + ",authorid=" + authorid + ",writer='" + writer +
        "',writefrom='" + writefrom +
        "',dateandtime=current Timestamp where companyid=" + companyid;
    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 companyDel(HttpServletRequest req, HttpServletResponse resp) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }

    String companyid = req.getParameter("companyid");
    String sql = "delete from company where companyid=" + companyid;
    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 ownAdd(HttpServletRequest req, HttpServletResponse resp) {
    HttpSession httpsession = req.getSession();
    String username = (String) httpsession.getAttribute("username");

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

    String partid = "";
    DbADO dbAdo = new DbADO();
    Vector ownUser = new Vector();

    try {

      dbAdo.connect();
      String sql = "select * from users where username='" + username + "'";
      ResultSet rs = dbAdo.select(sql);

      while (rs.next()) {
        ownUser.addElement(rs.getString("id"));
        ownUser.addElement(rs.getString("username"));
        ownUser.addElement(rs.getString("truename"));
        ownUser.addElement(rs.getString("flag"));
        partid = rs.getString("partid");
        ownUser.addElement(partid);
        System.out.println("partid=" + partid);

      }

      sql = "select * from part where partid=" + partid;
      rs = dbAdo.select(sql);
      while (rs.next()) {
        ownUser.addElement(rs.getString("partname"));

      }

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

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

    }
    return islogin;

  }

  public boolean ownSave(HttpServletRequest req, HttpServletResponse resp,
                         String sumcontent, String plancontent, String title,
                         String author, String user) {
    HttpSession httpsession = req.getSession();
    String username = (String) httpsession.getAttribute("username");

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

    System.out.println("title is: " + title);
    String partname = "";
    String partid = req.getParameter("partid");
    String flag = req.getParameter("flag");
    System.out.println("user is: " + user);
    String userid = req.getParameter("userid");
    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    String sql = "select * from part where partid=" + partid;
    ResultSet rs = dbAdo.select(sql);
    try {

      while (rs.next()) {
        partname = rs.getString("partname");
        System.out.println("partname is: " + partname);
      }

    }
    catch (Exception e) {
      e.printStackTrace();
    }

    sql = "insert into own (sumcontent,plancontent,reply1,reply2,title,partname,partid,flag,author,username,userid,dateandtime,state) values ";
    sql = sql + "('" + sumcontent + "','" + plancontent + "','无','无','" + title +
        "','" + partname + "'," + partid + "," + flag + ",'" + author + "','" +
        user + "'," + userid + ",current Timestamp,'no')";
    System.out.println("insert sql is: " + sql);

    dbAdo.update_insert(sql);
    dbAdo.close();
    String result = "添加个人总结成功!";
    req.setAttribute("result", result);

    return islogin;
  }

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

    Integer Flag = null;
    Flag = (Integer) httpsession.getAttribute("flag");
    int flag = Flag.intValue();

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

    String managerReply = req.getParameter("managerReply");
    if (managerReply == null) {
      managerReply = "0";
    }
    String path = "own_sum";
    String sql1 = "";
    String sql2 = "";
    String sql = "select partid from users where username='" + username + "'";

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    int partid = dbAdo.total(sql);
    System.out.println("partid is: " + partid);

    if (flag <= 2) {
      sql1 = "select * from own where state='yes' order by dateandtime";
      sql2 = "select count(ownid) from own where state='yes'";
      path = "company";
    }
    else if (flag >= 3) {
      sql1 = "select * from own where username='" + username +
          "' order by dateandtime";
      sql2 = "select count(ownid) from own where username='" + username + "'";
    }

    if (flag == 3 && managerReply.equals("1")) {
      sql1 = "select * from own where state='yes' and partid=" + partid +
          " order by dateandtime";
      sql2 = "select count(ownid) from own where state='yes' and partid=" +
          partid;
      path = "dept";
    }

    System.out.println("sql1 is: " + sql1);
    String state = "";
    Vector ownList = new Vector();

    String page = req.getParameter("page");
    if (page == null) {
      page = "1";
    }
    int pageRow = 8;

    int totalRow = 0;
    int thisPage = new Integer(page).intValue();
    int maxPage = 0;
    int startRow = 1;
    int endRow = pageRow;

    totalRow = dbAdo.total(sql2);

    if (totalRow % pageRow == 0) {
      maxPage = totalRow / pageRow;
    }
    else {
      maxPage = totalRow / pageRow + 1;
    }

    System.out.println("ownTotal() maxPage: " + maxPage);
    if (thisPage < 1) {
      thisPage = 1;
    }
    if (thisPage > maxPage) {
      thisPage = maxPage;

    }
    req.setAttribute("thisPage", new Integer(thisPage));

    thisPage = maxPage - thisPage + 1;

    if (thisPage > 1 && thisPage < maxPage) {
      startRow = (thisPage - 1) * pageRow + 1;
      endRow = thisPage * pageRow;
    }
    else if (thisPage >= maxPage) {
      startRow = (maxPage - 1) * pageRow + 1;
      endRow = totalRow;
    }

    System.out.println("ownTotal() startRow: " + startRow);
    System.out.println("ownTotal() endRow" + endRow);
    System.out.println("ownTotal() thisPage " + thisPage);

    System.out.println("ownTotal() totalRow: " + totalRow);

    ResultSet rs = dbAdo.select(sql1);
    try {
      if (startRow >= 1) {
        rs.absolute(startRow);
        int i = startRow;
        while (i <= endRow) {
          state = "";
          ownList.addElement(rs.getString("ownid"));
          ownList.addElement(rs.getString("reply1"));
          ownList.addElement(rs.getString("reply2"));
          ownList.addElement(rs.getString("title"));
          ownList.addElement(rs.getString("partid"));
          ownList.addElement(rs.getString("author"));
          ownList.addElement(rs.getString("userid"));
          ownList.addElement(rs.getString("dateandtime"));
          state = rs.getString("state").trim();
          if (state.equals("no")) {
            state = "未提交";
          }
          else if (state.equals("yes")) {
            state = "已提交";
          }
          ownList.addElement(state);

          i++;
          rs.next();
        }
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      dbAdo.close();
    }

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

    }
    req.setAttribute("managerReply", managerReply);
    req.setAttribute("path", path);

    req.setAttribute("maxPage", new Integer(maxPage));

    return islogin;
  }

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

    Integer Flag = null;
    Flag = (Integer) httpsession.getAttribute("flag");
    int flag = Flag.intValue();

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

    String managerReply = req.getParameter("managerReply");
    String path = req.getParameter("path");
    String sql1 = "";

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

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    int partid = dbAdo.total(sql);
    System.out.println("partid is: " + partid);

    if (flag <= 2) {
      sql1 = "select * from own where state='yes' and title like '%" + title +
          "%' order by dateandtime";

    }
    else if (flag >= 3) {
      sql1 = "select * from own where username='" + username +
          "' and title like '%" + title + "%' order by dateandtime";

    }

    if (flag == 3 && managerReply.equals("1")) {
      sql1 = "select * from own where state='yes' and partid=" + partid +
          " and title like '%" + title + "%' order by dateandtime";
    }

    System.out.println("sql1 is: " + sql1);
    String state = "";
    Vector ownList = new Vector();

    ResultSet rs = dbAdo.select(sql1);
    try {

      while (rs.next()) {
        state = "";
        ownList.addElement(rs.getString("ownid"));
        ownList.addElement(rs.getString("reply1"));
        ownList.addElement(rs.getString("reply2"));
        ownList.addElement(rs.getString("title"));
        ownList.addElement(rs.getString("partid"));
        ownList.addElement(rs.getString("author"));
        ownList.addElement(rs.getString("userid"));
        ownList.addElement(rs.getString("dateandtime"));
        state = rs.getString("state").trim();
        if (state.equals("no")) {
          state = "未提交";
        }
        else if (state.equals("yes")) {
          state = "已提交";
        }
        ownList.addElement(state);

      }

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

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

    }
    if (title != null) {
      req.setAttribute("searchTitle", title);

    }
    req.setAttribute("managerReply", managerReply);
    req.setAttribute("path", path);

    return islogin;
  }