mysurveydata.jsp
2.07 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="weaver.general.*,java.util.*"%>
<%@ page import="weaver.hrm.*,weaver.conn.*,org.json.*,java.math.*"%>
<jsp:useBean id="userinputrs" class="weaver.conn.RecordSet" scope="page" />
<%
User user_login_ = HrmUserVarify.getUser (request , response) ;
if(user_login_ == null) return ;
int sourceid = Util.getIntValue(request.getParameter("sourceid"));
User useritem = HrmUserVarify.getUser (request , response) ;
if(sourceid > 0){
useritem = new User(sourceid);
}
votingid= Util.null2String(request.getParameter("votingid"));
// votingid="34";
sql="select questiontype,isother,ismulti as type,questionid,value,remark from ( "+
" select questionid,optionid as value,'' as remark from VotingResource where votingid='"+votingid+"' and resourceid='"+useritem.getUID()+"' "+
" union all "+
" select questionid,'-100' as value,otherinput as remark from VotingResourceRemark where votingid='"+votingid+"' and resourceid='"+useritem.getUID()+"' "+
" )a inner join (select id,ismulti,isother,questiontype from VotingQuestion) b on a.questionid=b.id";
userinputrs.execute(sql);
List<Map<String,String>> userinputs=new ArrayList<Map<String,String>>();
Map<String,String> userinput;
String qtype;
String qother;
String qdtype;
String qid;
String qvalue;
String qremark;
while(userinputrs.next()){
userinput=new HashMap<String,String>();
qtype=userinputrs.getString("questiontype");
userinput.put("qtype",qtype);
qother=userinputrs.getString("isother");
userinput.put("qother",qother);
qdtype=userinputrs.getString("type");
userinput.put("qdtype",qdtype);
qid=userinputrs.getString("questionid");
userinput.put("qid",qid);
qvalue=userinputrs.getString("value");
userinput.put("qvalue",qvalue);
qremark = userinputrs.getString("remark");
userinput.put("qremark",qremark);
userinputs.add(userinput);
}
JSONArray userinutobj=new JSONArray(userinputs);
String userinputitems=userinutobj.toString();
%>