offlogbean.java~3~

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

package com.officelog;

/**
 * @author wsp
 *
 * To change this generated comment edit the template variable "typecomment":
 * Window>Preferences>Java>Templates.
 * To enable and disable the creation of type comments go to
 * Window>Preferences>Java>Code Generation.
 */

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import java.sql.*;
import java.util.*;

public class OffLogBean {

  /**
   * Constructor for ChkUser.
   */
  public OffLogBean() {}

  public boolean chkUser(HttpServletRequest req, HttpServletResponse resp) {
    String username = "";
    String password = "";

    String truename = "";
    int flag = 0;
    boolean isUser = false;

    username = req.getParameter("username").trim();
    password = req.getParameter("password");

    System.out.println("username=" + username + "__password=" + password);

    DbADO dbAdo = new DbADO();

    try {

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

      if (rs.next()) {
        truename = rs.getString("truename");
        flag = rs.getInt("flag");
        isUser = true;
        System.out.println("truname=" + truename + "___flag=" + flag);
      }

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

    HttpSession httpsession = req.getSession();
    httpsession.setAttribute("truename", truename);
    httpsession.setAttribute("flag", new Integer(flag));
    httpsession.setAttribute("username", username);

    Integer Flag = null;
    Flag = (Integer) httpsession.getAttribute("flag");
    flag = Flag.intValue();
    System.out.println("flag=" + flag);

    return isUser;
  }

  public boolean companyAdd(HttpServletRequest req, HttpServletResponse resp) {

    boolean isadmin = isAdmin(req, resp);

    if (!isadmin) {
      return isadmin;
    }

    DbADO dbAdo = new DbADO();
    Vector allAdmin = null;
    allAdmin = new Vector();
    int id = 0;
    String truename = "";

    try {

      dbAdo.connect();
      String sql = "select * from users where flag=1";
      ResultSet rs = dbAdo.select(sql);

      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);

      }

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

    return isadmin;

  }

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

    String authorid = req.getParameter("id");
    String sql = "insert into company (content,content2,title,hits,dateandtime,authorid,writer,writefrom,state) values ";
    sql = sql + "('" + content + "','" + content2 + "','" + title +
        "',0,current Timestamp," + authorid + ",'" + writer + "','" + writefrom +
        "','no')";
    System.out.println("insert 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 total(HttpServletRequest req, HttpServletResponse resp) {
    HttpSession httpsession = req.getSession();
    Integer Flag = null;
    Flag = (Integer) httpsession.getAttribute("flag");
    int flag = Flag.intValue();

    boolean islogin = isLogin(req, resp);

    if (!islogin) {
      return islogin;
    }

    String sql1 = "";
    String sql2 = "";

    if (flag <= 2) {
      sql1 = "select * from company order by dateandtime";
      sql2 = "select count(companyid) from company";
    }
    else if (flag > 2) {
      sql1 = "select * from company where state='yes' order by dateandtime";
      sql2 = "select count(companyid) from company where state='yes'";

    }

    System.out.println("sql1 is: " + sql1);
    String state = "";
    Vector sumList = 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;

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

    totalRow = dbAdo.total(sql2);

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

    System.out.println("toal() 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("total() startRow: " + startRow);
    System.out.println("total() endRow" + endRow);
    System.out.println("total() thisPage " + thisPage);

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

    ResultSet rs = dbAdo.select(sql1);
    try {
      if (startRow >= 1) {
        rs.absolute(startRow);
        int i = startRow;
        while (i <= endRow) {
          state = "";
          sumList.addElement(rs.getString("companyid"));
          sumList.addElement(rs.getString("title"));
          sumList.addElement(rs.getString("dateandtime"));
          sumList.addElement(rs.getString("writer"));
          state = rs.getString("state").trim();
          if (state.equals("no")) {
            state = "否";
          }
          else if (state.equals("yes")) {
            state = "是";
          }
          sumList.addElement(state);
          sumList.addElement(rs.getString("hits"));

          i++;
          rs.next();
        }
      }

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

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

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

    return islogin;
  }

  public boolean searchTotal(HttpServletRequest req, HttpServletResponse resp,
                             String title) {
    HttpSession httpsession = req.getSession();
    Integer Flag = null;
    Flag = (Integer) httpsession.getAttribute("flag");
    int flag = Flag.intValue();

    boolean islogin = isLogin(req, resp);

    if (!islogin) {
      return islogin;
    }

    String sql1 = "";

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

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

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

      while (rs.next()) {
        state = "";
        sumList.addElement(rs.getString("companyid"));
        sumList.addElement(rs.getString("title"));
        sumList.addElement(rs.getString("dateandtime"));
        sumList.addElement(rs.getString("writer"));
        state = rs.getString("state").trim();
        if (state.equals("no")) {
          state = "否";
        }
        else if (state.equals("yes")) {
          state = "是";
        }
        sumList.addElement(state);
        sumList.addElement(rs.getString("hits"));

      }

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

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

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

    }
    return islogin;
  }

  public boolean companyView(HttpServletRequest req, HttpServletResponse resp) {
    HttpSession httpsession = req.getSession();
    Integer Flag = null;
    Flag = (Integer) httpsession.getAttribute("flag");
    int flag = Flag.intValue();

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

    Vector viewContent = new Vector();
    String authorid = "";

    String companyid = req.getParameter("companyid");
    String sql1 = "update company set hits=hits+1 where companyid=" + companyid;
    String sql2 = "select * from company where companyid=" + companyid;

    DbADO dbAdo = new DbADO();
    dbAdo.connect();
    dbAdo.update_insert(sql1);
    ResultSet rs = dbAdo.select(sql2);
    try {

      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"));
        authorid = rs.getString("authorid");
        viewContent.addElement(authorid);
        viewContent.addElement(rs.getString("writefrom"));

      }
      sql2 = "select * from users where id=" + authorid;
      rs = dbAdo.select(sql2);
      while (rs.next()) {
        viewContent.addElement(rs.getString("truename"));

      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      dbAdo.close();
    }
    viewContent.addElement(companyid);
    if (viewContent != null) {
      req.setAttribute("viewContent", viewContent);

    }
    return islogin;
  }

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

    String companyid = req.getParameter("companyid");
    String sql = "update company set state='yes' where companyid=" + companyid;

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

    dbAdo.close();

    String result = "您已成功选用总结！";
    req.setAttribute("result", result);

    return isadmin;
  }

  public boolean companyEdit(HttpServletRequest req, HttpServletResponse resp) {
    boolean isadmin = isAdmin(req, resp);
    if (!isadmin) {
      return isadmin;
    }
    String companyid = req.getParameter("companyid");
    Vector allAdmin = null;
    allAdmin = new Vector();
    Vector viewContent = new Vector();
    int id = 0;
    String truename = "";
    String sql1 = "select * from users where flag=1";
    String sql2 = "select * from company where companyid=" + companyid;