在同一调查表中同时有多选与单选,数据库只需要将选项的数目增加,请问提交后处理的JSP代码与导入数据库的代码应如何写,我只会做单选的?表单生成的代码只有单选!!要求单选与多选都有!
while(rs.next())
{
i++;
question = rs.getString(1);
questionid= rs.getInt(2);
out.print("<TABLE borderColor=#999999 cellSpacing=0 cellPadding=0 width=100% border=0><tr bgcolor=#999999><td>"+" "+i+"."+" "+question+"</td></tr>");
_sql = "SELECT Item,ItemID From Items Where QuestionID ="+questionid;
_rs = _smt.executeQuery(_sql);
j = 0;
while(_rs.next())
{
j++;
item = _rs.getString(1);
itemid = _rs.getInt(2);
//out.print("<tr>"+item);%>
<td > <%=j%><input type=radio value="<%=itemid%>" name="<%=questionid%>" <%if(j<2) {out.print(" checked "+j);}%>><%=item%></td></tr>
<% //out.print("<td > "+j+"<input type=radio value="+itemid+" name="+questionid+" checked>"+item+"</td>");
//out.print("</tr>");
}
单选表单处理,希望也能同时处理多选
while(rs.next())
{
questionid = rs.getInt(1);
itemid = Integer.parseInt(request.getParameter(String.valueOf(questionid)));
_sql = "update Items set ItemCount = ItemCount + 1 Where ItemID ="+itemid;
_smt.executeUpdate(_sql);
}
String _sql_;
_sql_= "update list set Count = Count + 1 Where ListID ="+listid;
_smt.executeUpdate(_sql_);
%>再就想请教投票后不允许重复投票的代码!!!限IP的,限时间的,限用户名的.
while(rs.next())
{
i++;
question = rs.getString(1);
questionid= rs.getInt(2);
out.print("<TABLE borderColor=#999999 cellSpacing=0 cellPadding=0 width=100% border=0><tr bgcolor=#999999><td>"+" "+i+"."+" "+question+"</td></tr>");
_sql = "SELECT Item,ItemID From Items Where QuestionID ="+questionid;
_rs = _smt.executeQuery(_sql);
j = 0;
while(_rs.next())
{
j++;
item = _rs.getString(1);
itemid = _rs.getInt(2);
//out.print("<tr>"+item);%>
<td > <%=j%><input type=radio value="<%=itemid%>" name="<%=questionid%>" <%if(j<2) {out.print(" checked "+j);}%>><%=item%></td></tr>
<% //out.print("<td > "+j+"<input type=radio value="+itemid+" name="+questionid+" checked>"+item+"</td>");
//out.print("</tr>");
}
单选表单处理,希望也能同时处理多选
while(rs.next())
{
questionid = rs.getInt(1);
itemid = Integer.parseInt(request.getParameter(String.valueOf(questionid)));
_sql = "update Items set ItemCount = ItemCount + 1 Where ItemID ="+itemid;
_smt.executeUpdate(_sql);
}
String _sql_;
_sql_= "update list set Count = Count + 1 Where ListID ="+listid;
_smt.executeUpdate(_sql_);
%>再就想请教投票后不允许重复投票的代码!!!限IP的,限时间的,限用户名的.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货