themeColorListJson.jsp
1.22 KB
<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="weaver.hrm.HrmUserVarify"%>
<%@ page import="weaver.hrm.User"%>
<%@ page import="weaver.general.Util"%>
<%@ page import="java.text.*"%>
<%@ page import="weaver.conn.RecordSet"%>
<%@ page import="org.json.JSONArray"%>
<%@ page import="org.json.JSONObject"%>
<%
/*用户验证*/
User user = HrmUserVarify.getUser(request, response);
String userid = "" + user.getUID();
Map map = new HashMap();
if(userid!=null&&userid!=""){
RecordSet rs = new RecordSet();
String sql = "select a.logo,b.logocolor,b.hrmcolor,b.leftcolor,b.topcolor from hrmusersetting c inner join (select * from systemtemplate where templatetype='ecology8') a on c.templateid=a.id inner join ecology8theme b on a.skin=b.id where c.resourceid="+userid;
rs.executeSql(sql);
int index=0;
while (rs.next()) {
map.put("logo", rs.getString("logo"));
map.put("logocolor", rs.getString("logocolor"));
map.put("hrmcolor", rs.getString("hrmcolor"));
map.put("leftcolor", rs.getString("leftcolor"));
map.put("topcolor", rs.getString("topcolor"));
}
}
JSONObject obj = new JSONObject(map);
out.println(obj.toString());
%>