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

Example 11 with Info

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

the class InfoDao method queryInfoSingle.

public Info queryInfoSingle(int id, int uid) {
    Info info = null;
    String sql = "select * from info where id=" + id + " and uid=" + uid;
    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 12 with Info

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

the class InfoDao method queryTimeInfo.

public List queryTimeInfo(int uid, String startdate, String enddate) {
    String sql = "";
    sql = "select * from info where uid='" + uid + "'" + "and to_days(date)>=to_days('" + startdate + "') and to_days(date)<=to_days('" + enddate + "') order by id desc";
    ArrayList list = null;
    Info info = null;
    ResultSet rs = this.connection.executeQuery(sql);
    if (rs != null) {
        list = new ArrayList();
        try {
            while (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));
                list.add(info);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    return list;
}

Example 13 with Info

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

the class TestJson method doPost.

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    InfoDao infodao = new InfoDao();
    int id = 1;
    List infoList = infodao.queryInfo(id);
    request.setAttribute("infoList", infoList);
    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("del", "<a href=\"InfoServlet?action=delete&id=" + single.getId() + "\">删除记录</a>");
        array.add(ob);
    }
    PrintWriter out = response.getWriter();
    out.print(array);
    System.out.println(array);
}