commonGroupClickStatictics.jsp
1.06 KB
<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<%@ page import="weaver.general.Util,java.sql.Timestamp"%>
<%@ page import="weaver.hrm.HrmUserVarify"%>
<%@ page import="weaver.hrm.User"%>
<%
User user = HrmUserVarify.getUser (request , response) ;
if(user == null) return ;
String groupid = Util.null2String(request.getParameter("groupid"));
weaver.conn.RecordSet sltRs = new weaver.conn.RecordSet();
weaver.conn.RecordSet rs = new weaver.conn.RecordSet();
long clickCnt = 0;
if (!"".equals(groupid)) {
sltRs.executeSql("SELECT id, clickCnt FROM HrmUserGroupStatictics WHERE userid=" + user.getUID() + " and groupid=" + groupid);
if (sltRs.next()) {
clickCnt = Long.parseLong(sltRs.getString("clickCnt"));
clickCnt++;
rs.executeSql("UPDATE HrmUserGroupStatictics SET clickCnt=" + clickCnt + " WHERE userid=" + user.getUID() + " and groupid=" + groupid);
} else {
rs.executeSql("INSERT INTO HrmUserGroupStatictics(userid, groupid, clickCnt) VALUES(" + user.getUID() + " , " + groupid + ", 1)");
}
out.print("0");
} else {
out.print("-1");
}
%>