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

Example 6 with Urine

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

the class UrineServlet method select_time_urine.

public void select_time_urine(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    UrineDao urinedao = new UrineDao();
    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 urineList = urinedao.queryTimeUrine(id, startdate, enddate);
    JsonArray array = new JsonArray();
    for (int i = 0; i < urineList.size(); i++) {
        Urine single = (Urine) urineList.get(i);
        JsonObject ob = new JsonObject();
        ob.addProperty("id", i + 1);
        ob.addProperty("date", single.getDate());
        ob.addProperty("read", "<a href=\"UrineServlet?action=single&id=" + single.getId() + " \"target=\"_blank\">查看记录</a>");
        ob.addProperty("del", "<a href=\"UrineServlet?action=delete&id=" + single.getId() + "\">删除记录</a>");
        array.add(ob);
    }
    PrintWriter out = response.getWriter();
    out.print(array);
// System.out.println(array);
}

Example 7 with Urine

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

the class UrineDao method queryTimeUrine.

public List queryTimeUrine(int uid, String startdate, String enddate) {
    String sql = "";
    sql = "select * from urine where uid='" + uid + "'" + "and to_days(date)>=to_days('" + startdate + "') and to_days(date)<=to_days('" + enddate + "') order by id desc";
    ArrayList list = null;
    Urine urine = null;
    ResultSet rs = this.connection.executeQuery(sql);
    if (rs != null) {
        list = new ArrayList();
        try {
            while (rs.next()) {
                urine = new Urine();
                urine.setId(rs.getInt(1));
                urine.setUid(rs.getInt(2));
                urine.setDate(rs.getString(3));
                urine.setLeu(rs.getString(4));
                urine.setNit(rs.getString(5));
                urine.setUbg(rs.getString(6));
                urine.setPro(rs.getString(7));
                urine.setPh(MyTools.strTofloat(rs.getString(8)));
                urine.setSg(MyTools.strTofloat(rs.getString(9)));
                urine.setCa(rs.getString(10));
                urine.setBld(rs.getString(11));
                urine.setKet(rs.getString(12));
                urine.setBil(rs.getString(13));
                urine.setGlu(rs.getString(14));
                urine.setVc(rs.getString(15));
                urine.setMa(rs.getString(16));
                urine.setCr(rs.getString(17));
                list.add(urine);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    return list;
}