Examples with Info com.zyf.bean.Info used on opensource projects

Example 6 with Info

use of com.zyf.bean.Info in project HeartWatchdogJsp by Viczyf.

the class InfoDao method queryRelaInfoSingle.

public Info queryRelaInfoSingle(int id, int uid, int reid) {
    Info info = null;
    String sql = "select * from info where id=" + id + " and uid=" + reid + " and uid in (select reid from userrela where uid=" + uid + " and status=1) union select * from info where id=" + id + " and uid=" + reid + " and uid in (select uid from userrela where reid=" + uid + " and status=1)";
    ResultSet rs = this.connection.executeQuery(sql);
    try {
        if (rs.next()) {
            info = new Info();
            info.setId(rs.getInt(1));
            info.setUid(rs.getInt(2));
            info.setDate(rs.getString(3));
            info.setXinlv(rs.getInt(4));
            info.setXdgs(rs.getInt(5));
            info.setCon1(rs.getString(6));
            info.setSxxdgs(rs.getInt(7));
            info.setCon2(rs.getString(8));
            info.setXdgh(rs.getInt(9));
            info.setCon3(rs.getString(10));
            info.setFxyb(rs.getInt(11));
            info.setCon4(rs.getString(12));
            info.setSxyb(rs.getInt(13));
            info.setCon5(rs.getString(14));
            info.setXlbq(rs.getInt(15));
            info.setCon6(rs.getString(16));
            info.setSxzb(rs.getInt(17));
            info.setCon7(rs.getString(18));
            info.setFxzb(rs.getInt(19));
            info.setCon8(rs.getString(20));
            info.setJjxzb(rs.getInt(21));
            info.setCon9(rs.getString(22));
            info.setFc(rs.getInt(23));
            info.setCon10(rs.getString(24));
            info.setData(rs.getString(25));
            info.setPr(rs.getInt(26));
            info.setQrs(rs.getInt(27));
            info.setQt(rs.getInt(28));
            info.setQtc(rs.getInt(29));
            info.setP(rs.getInt(30));
            info.setPlist(rs.getString(31));
            info.setQlist(rs.getString(32));
            info.setRlist(rs.getString(33));
            info.setSlist(rs.getString(34));
            info.setTlist(rs.getString(35));
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return info;
}

Example 7 with Info

use of com.zyf.bean.Info in project HeartWatchdogJsp by Viczyf.

the class InfoServlet method singleInfo.

public void singleInfo(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    InfoDao infodao = new InfoDao();
    int id = MyTools.strToint(request.getParameter("id"));
    HttpSession session = request.getSession();
    // 获取用户对象
    User user = (User) session.getAttribute("user");
    int uid = user.getUid();
    Info infosingle = infodao.queryInfoSingle(id, uid);
    request.setAttribute("infosingle", infosingle);
    RequestDispatcher rd = request.getRequestDispatcher("infosingle.jsp");
    rd.forward(request, response);
}

Example 8 with Info

use of com.zyf.bean.Info in project HeartWatchdogJsp by Viczyf.

the class InfoServlet method select_time_info.

public void select_time_info(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    InfoDao infodao = new InfoDao();
    String startdate = request.getParameter("startdate");
    String enddate = request.getParameter("enddate");
    HttpSession session = request.getSession();
    // 获取用户对象
    User user = (User) session.getAttribute("user");
    int id = user.getUid();
    List infoList = infodao.queryTimeInfo(id, startdate, enddate);
    JsonArray array = new JsonArray();
    for (int i = 0; i < infoList.size(); i++) {
        Info single = (Info) infoList.get(i);
        JsonObject ob = new JsonObject();
        ob.addProperty("id", i + 1);
        ob.addProperty("date", single.getDate());
        ob.addProperty("read", "<a href=\"InfoServlet?action=single&id=" + single.getId() + " \"target=\"_blank\">查看记录</a>");
        ob.addProperty("read1", "<a href=\"InfoServlet?action=singlepot&id=" + single.getId() + " \"target=\"_blank\">查看记录</a>");
        ob.addProperty("del", "<a href=\"InfoServlet?action=delete&id=" + single.getId() + "\">删除记录</a>");
        array.add(ob);
    }
    PrintWriter out = response.getWriter();
    out.print(array);
    System.out.println(array);
}

Example 9 with Info

use of com.zyf.bean.Info in project HeartWatchdogJsp by Viczyf.

the class InfoServlet method deleteInfo.

public void deleteInfo(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    String message = "";
    String forward = "";
    String href = "";
    InfoDao infodao = new InfoDao();
    int id = MyTools.strToint(request.getParameter("id"));
    Info info = new Info();
    info.setId(id);
    HttpSession session = request.getSession();
    User user = (User) session.getAttribute("user");
    int uid = user.getUid();
    boolean mark = infodao.delInfo(info, uid);
    if (mark) {
        message = message + "<li>删除记录成功！</li>";
        forward = "tishi.jsp";
        href = href + "infotime.jsp";
    } else {
        message = message + "<li>删除记录失败！</li>";
        forward = "tishi.jsp";
        href = href + "infotime.jsp";
    }
    request.setAttribute("message", message);
    request.setAttribute("href", href);
    RequestDispatcher rd = request.getRequestDispatcher(forward);
    rd.forward(request, response);
}

Example 10 with Info

use of com.zyf.bean.Info in project HeartWatchdogJsp by Viczyf.

the class RelaServlet method relaInfoSingle.

public void relaInfoSingle(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    InfoDao infodao = new InfoDao();
    int id = MyTools.strToint(request.getParameter("para"));
    HttpSession session = request.getSession();
    // 获取用户对象
    User user = (User) session.getAttribute("user");
    int uid = user.getUid();
    int reid = MyTools.strToint(request.getParameter("para1"));
    Info infosingle = infodao.queryRelaInfoSingle(id, uid, reid);
    request.setAttribute("infosingle", infosingle);
    String relaid = String.valueOf(reid);
    request.setAttribute("reid", relaid);
    RequestDispatcher rd = request.getRequestDispatcher("relainfosingle.jsp");
    rd.forward(request, response);
}