jsp页面获取参数 执行sql查询数据库

<%@ page import="tidemedia.cms.system.*,
tidemedia.cms.base.*,
tidemedia.cms.util.*,
tidemedia.cms.user.*,
java.util.*,
java.sql.*"%>
<%@ page contentType="text/html;charset=GBK" %>
<%@ include file="../config.jsp"%>
<%


String  items = getParameter(request,"itemids");
int action = getIntParameter(request,"action");


out.println("items="+items+",action="+action);


int isvr=0;
if(action==2){
isvr =1;
}
TableUtil tu = new TableUtil();
String sql ="update channel_s3_a_b set IsVr="+isvr+" where id in ("+items+")";

tu.executeUpdate(sql);

%>