目录
0、效果展示
1、概述
通过问卷调查信息化平台,可以实现信息化的网络化管理,形成一个及时更新的数据中心和信息管理平台,全面、实时、准确提供问卷调查的有关信息,为用户提供辅助支持,为管理人员开展工作提供极大的便利。该系统主要实现了发布人:问卷添加、问卷管理、问卷统计、信息修改、注册、登录、留言板;浏览答题者:浏览问卷、回答问卷、公告查看;后台管理员:修改密码、管理员管理、订单管理、问卷管理、问卷分类管理、发布人管理、公告管理、留言管理。
2、搭建环境
本文以实现一个问卷投票调查网站为目标,从环境搭建到编码实现全过程讲述
我们使用javaweb、J2EE来构建问卷投票调查网站,环境使用最新版jdk和tomcat,配合mysql数据库
开发工具使用idea(也可以使用eclipse),数据库管理工具使用Navicat Premium
开发框架使用JavaBean Servlet MVC结构;
没有使用SSH(Struts+Spring+Hibernate)或SSM(Spring+SpringMVC+MyBatis),这两个框架我们在别的项目中再介绍开发过程
在项目中会引入My97DatePicker作为前端日期时间选择工具,使用fckeditor作为富媒体编辑器(也可以使用百度的ueditor)
3、数据表结构
7 t_timu题目表
字段名称 | 自动增长 | 字段类型 | 说明 |
id | - | int | 编号 |
name | - | text | 名称 |
xuanxianga | - | text | 选项 |
xuanxiangb | - | text | 选项 |
xuanxiangc | - | text | 选项 |
xuanxiangd | - | text | 选项 |
daan | - | text | 答案 |
fenshu | - | int | 分数 |
del | - | varchar | 是否删除 |
type | - | text | 分类 |
userid | - | int | 用户ID |
8 t_wenjuan 问卷
字段名称 | 自动增长 | 字段类型 | 说明 |
id | - | int | 编号 |
title | - | text | 标题 |
shijian | - | text | 日期 |
type | - | text | 类型 |
content | - | text | 内容 |
del | - | text | 是否删除 |
userid | - | text | 用户ID |
4、后端代码示例
package com.action;
import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.dao.DB;
import com.orm.Tputuser;
import com.orm.Ttimu;
import com.orm.Twenjuan;
import com.service.liuService;
public class wenjuan_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("wenjuanAdd"))
{
wenjuanAdd(req, res);
}
if(type.endsWith("wenjuanMana"))
{
wenjuanMana(req, res);
}
if(type.endsWith("wenjuanDel"))
{
wenjuanDel(req, res);
}
if(type.endsWith("wenjuanDelByUser"))
{
wenjuanDelByUser(req, res);
}
if(type.endsWith("wenjuanDetail"))
{
wenjuanDetail(req, res);
}
if(type.endsWith("wenjuanAll"))
{
wenjuanAll(req, res);
}
if(type.endsWith("wenjuanDetailQian"))
{
wenjuanDetailQian(req, res);
}
if(type.endsWith("wenjuanTotal"))
{
wenjuanTotal(req, res);
}
if(type.endsWith("wenjuanTotalJs"))
{
wenjuanTotalJs(req, res);
}
if(type.endsWith("wenjuanByUser"))
{
wenjuanByUser(req, res);
}
}
public void wenjuanAdd(HttpServletRequest req,HttpServletResponse res)
{
String id=String.valueOf(new Date().getTime());
String title=req.getParameter("title");
String type_id=req.getParameter("fenlei_id");
String content=req.getParameter("content");
String userid=req.getParameter("userid");
String shijian=req.getParameter("shijian");
String gqdate=req.getParameter("gqdate");
String del="no";
String sql="insert into t_wenjuan values(?,?,?,?,?,?,?,?)";
Object[] params={null,title,shijian,type_id,content,del,userid,gqdate};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "wenjuan?type=wenjuanByUser&userid="+userid);
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void wenjuanDelByUser(HttpServletRequest req,HttpServletResponse res)
{
int id=Integer.parseInt(req.getParameter("id"));
String sql="delete from t_wenjuan where id=?";
Object[] params={id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
HttpSession session=req.getSession();
Tputuser putuser=(Tputuser)session.getAttribute("putuser");
req.setAttribute("message", "操作成功");
req.setAttribute("path", "wenjuan?type=wenjuanByUser&userid="+putuser.getId());
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void wenjuanDel(HttpServletRequest req,HttpServletResponse res)
{
String id=req.getParameter("id");
String sql="delete from t_wenjuan where id=?";
Object[] params={id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "wenjuan?type=wenjuanMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void wenjuanDetail(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String id=req.getParameter("id");
Twenjuan wenjuan=new Twenjuan();
String sql="select * from t_wenjuan where id=?";
Object[] params={id};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
rs.next();
wenjuan.setId(rs.getString("id"));
wenjuan.setTitle(rs.getString("title"));
wenjuan.setContent(rs.getString("content"));
wenjuan.setUser_id(rs.getInt("userid"));
wenjuan.setUser_name(liuService.getPutuserName(rs.getInt("userid")));
wenjuan.setShijian(rs.getString("shijian"));
wenjuan.setType_id(rs.getInt("type"));
wenjuan.setType_name(liuService.getTypeName(rs.getInt("type")));
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("wenjuan", wenjuan);
req.getRequestDispatcher("admin/wenjuan/wenjuanDetail.jsp").forward(req, res);
}
public void wenjuanTotalJs(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String id=req.getParameter("id");
Twenjuan wenjuan=new Twenjuan();
String sql="select * from t_wenjuan where id=?";
Object[] params={id};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
rs.next();
wenjuan.setId(rs.getString("id"));
wenjuan.setTitle(rs.getString("title"));
wenjuan.setContent(rs.getString("content"));
wenjuan.setShijian(rs.getString("shijian"));
wenjuan.setType_id(rs.getInt("type"));
wenjuan.setType_name(liuService.getTypeName(rs.getInt("type")));
wenjuan.setUser_id(rs.getInt("userid"));
wenjuan.setUser_name(liuService.getPutuserName(rs.getInt("userid")));
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
String wenjuanid=req.getParameter("id");
List timuList=new ArrayList();
String sql1="select * from t_timu_wenjuan where wenjuan_id=? ";
Object[] params1={wenjuanid};
DB mydb1=new DB();
try
{
mydb1.doPstm(sql1, params1);
ResultSet rs=mydb1.getRs();
while(rs.next())
{
String sql11="select count(*) as gs,IFNULL(daan,'未回答') as daan from t_timu_user where timu_id="+rs.getInt("timu_id")+" and wenjuan_id="+wenjuanid+" GROUP BY daan";
Object[] params11={};
DB mydb11=new DB();
mydb11.doPstm(sql11, params11);
ResultSet rs1=mydb11.getRs();
while(rs1.next())
{
Ttimu timu=new Ttimu();
timu.setName(liuService.getTimuName(rs.getInt("timu_id")));
timu.setDaan(rs1.getString("daan"));
timu.setFenshu(rs1.getInt("gs"));
System.out.println(timu.getName());
timuList.add(timu);
}
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("timuList", timuList);
req.setAttribute("wenjuan", wenjuan);
req.getRequestDispatcher("qiantai/wenjuan/wenjuanTotalJs.jsp").forward(req, res);
}
public void wenjuanDetailQian(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String id=req.getParameter("id");
Twenjuan wenjuan=new Twenjuan();
String sql="select * from t_wenjuan where id=?";
Object[] params={id};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
rs.next();
wenjuan.setId(rs.getString("id"));
wenjuan.setTitle(rs.getString("title"));
wenjuan.setContent(rs.getString("content"));
wenjuan.setShijian(rs.getString("shijian"));
wenjuan.setType_id(rs.getInt("type"));
wenjuan.setType_name(liuService.getTypeName(rs.getInt("type")));
wenjuan.setUser_id(rs.getInt("userid"));
wenjuan.setUser_name(liuService.getPutuserName(rs.getInt("userid")));
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
String wenjuanid=req.getParameter("id");
List timuList=new ArrayList();
String sql1="select * from t_timu_wenjuan where wenjuan_id=? ";
Object[] params1={wenjuanid};
DB mydb1=new DB();
try
{
mydb1.doPstm(sql1, params1);
ResultSet rs=mydb1.getRs();
while(rs.next())
{
timuList.add(liuService.getTimuById(rs.getInt("timu_id")));
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("timuList", timuList);
req.setAttribute("wenjuan", wenjuan);
req.getRequestDispatcher("qiantai/wenjuan/wenjuanDetailQian.jsp").forward(req, res);
}
public void wenjuanMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String page1=req.getParameter("page");
if(page1==null){
page1="1";
}
//分页设置
int EVERYPAGENUM=20;//每页条数
int page=Integer.parseInt(page1); //传递过来的当前页
int cou = 1;//得到信息总数
int pagecount=1; //总页数
String sql1="select count(*) as cou from t_wenjuan where del='no'";
if(req.getParameter("name")!=null)sql1+=" and title like '%"+req.getParameter("name").trim()+"%'";
Object[] params1={};
DB mydb1=new DB();
try
{
mydb1.doPstm(sql1, params1);
ResultSet rs=mydb1.getRs();
while(rs.next())
{
cou= rs.getInt("cou");
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb1.closed();
if (cou % EVERYPAGENUM == 0) {
pagecount= cou / EVERYPAGENUM;
} else {
pagecount=cou / EVERYPAGENUM + 1;
}
req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);
req.setAttribute("page", page);
req.setAttribute("cou", cou);
req.setAttribute("pagecount", pagecount);
List wenjuanList=new ArrayList();
String sql="select * from t_wenjuan where del='no'";
if(req.getParameter("name")!=null)sql+=" and title like '%"+req.getParameter("name").trim()+"%'";
sql+=" order by id desc";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
rs.next();
}
for (int t = 0; t < EVERYPAGENUM; t++) {
if (rs.next()) {
Twenjuan wenjuan=new Twenjuan();
wenjuan.setId(rs.getString("id"));
wenjuan.setTitle(rs.getString("title"));
wenjuan.setType_id(rs.getInt("type"));
wenjuan.setType_name(liuService.getTypeName(rs.getInt("type")));
wenjuan.setContent(rs.getString("content"));
wenjuan.setShijian(rs.getString("shijian"));
wenjuan.setUser_id(rs.getInt("userid"));
wenjuan.setUser_name(liuService.getPutuserName(rs.getInt("userid")));
wenjuanList.add(wenjuan);
} else {
break; //减少空循环的时间
}
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("wenjuanList", wenjuanList);
req.getRequestDispatcher("admin/wenjuan/wenjuanMana.jsp").forward(req, res);
}
//前台按用户
public void wenjuanByUser(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String userid=req.getParameter("userid");
String page1=req.getParameter("page");
if(page1==null){
page1="1";
}
//分页设置
int EVERYPAGENUM=20;//每页条数
int page=Integer.parseInt(page1); //传递过来的当前页
int cou = 1;//得到信息总数
int pagecount=1; //总页数
String sql1="select count(*) as cou from t_wenjuan where del='no' and userid="+userid+"";
if(req.getParameter("name")!=null)sql1+=" and title like '%"+req.getParameter("name").trim()+"%'";
Object[] params1={};
DB mydb1=new DB();
try
{
mydb1.doPstm(sql1, params1);
ResultSet rs=mydb1.getRs();
while(rs.next())
{
cou= rs.getInt("cou");
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb1.closed();
if (cou % EVERYPAGENUM == 0) {
pagecount= cou / EVERYPAGENUM;
} else {
pagecount=cou / EVERYPAGENUM + 1;
}
req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);
req.setAttribute("page", page);
req.setAttribute("cou", cou);
req.setAttribute("pagecount", pagecount);
List wenjuanList=new ArrayList();
String sql="select * from t_wenjuan where del='no' and userid="+userid+"";
if(req.getParameter("name")!=null)sql+=" and title like '%"+req.getParameter("name").trim()+"%'";
sql+=" order by id desc";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
rs.next();
}
for (int t = 0; t < EVERYPAGENUM; t++) {
if (rs.next()) {
Twenjuan wenjuan=new Twenjuan();
wenjuan.setId(rs.getString("id"));
wenjuan.setTitle(rs.getString("title"));
wenjuan.setContent(rs.getString("content"));
wenjuan.setShijian(rs.getString("shijian"));
wenjuan.setType_id(rs.getInt("type"));
wenjuan.setType_name(liuService.getTypeName(rs.getInt("type")));
wenjuan.setUser_id(rs.getInt("userid"));
wenjuan.setUser_name(liuService.getPutuserName(rs.getInt("userid")));
wenjuan.setGqdate(rs.getString("gqdate"));
wenjuanList.add(wenjuan);
} else {
break; //减少空循环的时间
}
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("userid", userid);
req.setAttribute("wenjuanList", wenjuanList);
req.getRequestDispatcher("qiantai/wenjuan/wenjuanByUser.jsp").forward(req, res);
}
//前台按用户统计
public void wenjuanTotal(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String userid=req.getParameter("userid");
String page1=req.getParameter("page");
if(page1==null){
page1="1";
}
//分页设置
int EVERYPAGENUM=20;//每页条数
int page=Integer.parseInt(page1); //传递过来的当前页
int cou = 1;//得到信息总数
int pagecount=1; //总页数
String sql1="select count(*) as cou from t_wenjuan where del='no' and userid="+userid+"";
if(req.getParameter("name")!=null)sql1+=" and title like '%"+req.getParameter("name").trim()+"%'";
Object[] params1={};
DB mydb1=new DB();
try
{
mydb1.doPstm(sql1, params1);
ResultSet rs=mydb1.getRs();
while(rs.next())
{
cou= rs.getInt("cou");
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb1.closed();
if (cou % EVERYPAGENUM == 0) {
pagecount= cou / EVERYPAGENUM;
} else {
pagecount=cou / EVERYPAGENUM + 1;
}
req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);
req.setAttribute("page", page);
req.setAttribute("cou", cou);
req.setAttribute("pagecount", pagecount);
List wenjuanList=new ArrayList();
String sql="select * from t_wenjuan where del='no' and userid="+userid+"";
if(req.getParameter("name")!=null)sql+=" and title like '%"+req.getParameter("name").trim()+"%'";
sql+=" order by id desc";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
rs.next();
}
for (int t = 0; t < EVERYPAGENUM; t++) {
if (rs.next()) {
Twenjuan wenjuan=new Twenjuan();
wenjuan.setId(rs.getString("id"));
wenjuan.setTitle(rs.getString("title"));
wenjuan.setContent(rs.getString("content"));
wenjuan.setShijian(rs.getString("shijian"));
wenjuan.setType_id(rs.getInt("type"));
wenjuan.setType_name(liuService.getTypeName(rs.getInt("type")));
wenjuan.setUser_id(rs.getInt("userid"));
wenjuan.setUser_name(liuService.getPutuserName(rs.getInt("userid")));
wenjuanList.add(wenjuan);
} else {
break; //减少空循环的时间
}
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("userid", userid);
req.setAttribute("wenjuanList", wenjuanList);
req.getRequestDispatcher("qiantai/wenjuan/wenjuanTotal.jsp").forward(req, res);
}
//前台按分类显示
public void wenjuanAll(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String fenleiid=req.getParameter("fenleiid");
String page1=req.getParameter("page");
if(page1==null){
page1="1";
}
//分页设置
int EVERYPAGENUM=20;//每页条数
int page=Integer.parseInt(page1); //传递过来的当前页
int cou = 1;//得到信息总数
int pagecount=1; //总页数
String sql1="select count(*) as cou from t_wenjuan where del='no' and type="+fenleiid+" and UNIX_TIMESTAMP(gqdate)>UNIX_TIMESTAMP()";
if(req.getParameter("name")!=null)sql1+=" and title like '%"+req.getParameter("name").trim()+"%'";
Object[] params1={};
DB mydb1=new DB();
try
{
mydb1.doPstm(sql1, params1);
ResultSet rs=mydb1.getRs();
while(rs.next())
{
cou= rs.getInt("cou");
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb1.closed();
if (cou % EVERYPAGENUM == 0) {
pagecount= cou / EVERYPAGENUM;
} else {
pagecount=cou / EVERYPAGENUM + 1;
}
req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);
req.setAttribute("page", page);
req.setAttribute("cou", cou);
req.setAttribute("pagecount", pagecount);
List wenjuanList=new ArrayList();
//String sql="select * from t_wenjuan where del='no' and type="+fenleiid+" and UNIX_TIMESTAMP(gqdate)>UNIX_TIMESTAMP() ";
String sql="select * from t_wenjuan where del='no' and type="+fenleiid+" ";
if(req.getParameter("name")!=null)sql+=" and title like '%"+req.getParameter("name").trim()+"%'";
sql+=" order by id desc";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
rs.next();
}
for (int t = 0; t < EVERYPAGENUM; t++) {
if (rs.next()) {
Twenjuan wenjuan=new Twenjuan();
wenjuan.setId(rs.getString("id"));
wenjuan.setTitle(rs.getString("title"));
wenjuan.setContent(rs.getString("content"));
wenjuan.setShijian(rs.getString("shijian"));
wenjuan.setType_id(rs.getInt("type"));
wenjuan.setType_name(liuService.getTypeName(rs.getInt("type")));
wenjuan.setUser_id(rs.getInt("userid"));
wenjuan.setUser_name(liuService.getPutuserName(rs.getInt("userid")));
wenjuanList.add(wenjuan);
} else {
break; //减少空循环的时间
}
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("fenleiid", fenleiid);
req.setAttribute("wenjuanList", wenjuanList);
req.getRequestDispatcher("qiantai/wenjuan/wenjuanAll.jsp").forward(req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}
5、前端代码示例
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@ page isELIgnored="false" %>
<%
String path = request.getContextPath();
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />
<meta http-equiv="expires" content="0" />
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3" />
<meta http-equiv="description" content="This is my page" />
<link rel="stylesheet" type="text/css" href="<%=path %>/css/base.css" />
<script type="text/javascript" src="<%=path %>/js/popup.js"></script>
<script language="javascript">
function timuAll(userid,wenjuanid)
{
var url="<%=path %>/timu?type=timuAll&userid="+userid+"&wenjuanid="+wenjuanid;
var pop=new Popup({ contentType:1,isReloadOnClose:false,width:500,height:300});
pop.setContent("contentUrl",url);
pop.setContent("title","题目选择");
pop.build();
pop.show();
}
function timuByWenjuan(wenjuanid)
{
var url="<%=path %>/timu?type=timuByWenjuan&wenjuanid="+wenjuanid;
var pop=new Popup({ contentType:1,isReloadOnClose:false,width:500,height:300});
pop.setContent("contentUrl",url);
pop.setContent("title","题目明细");
pop.build();
pop.show();
}
</script>
<script language="JavaScript" src="<%=path %>/js/public.js" type="text/javascript"></script>
<script language="javascript">
function wenjuanAdd()
{
var url="<%=path %>/admin/wenjuan/wenjuanAdd.jsp";
window.location.href=url;
}
function wenjuanDetail(id)
{
var url="<%=path %>/wenjuan?type=wenjuanDetail&id="+id;
var n="";
var w="500px";
var h="400px";
var s="resizable:no;help:no;status:no;scroll:yes";
window.location.href=url;
}
function down1(fujianPath,fujianYuashiMing)
{
var url="<%=path %>/updown/updown.jsp?fujianPath="+fujianPath+"&fujianYuashiMing="+fujianYuashiMing;
url=encodeURI(url);
url=encodeURI(url);
window.open(url,"_self");
}
</script>
</head>
<body leftmargin="2" topmargin="2" >
<table width='98%' border='0' align="center">
<tr>
<td ><form action="<%=path %>/wenjuan?type=wenjuanMana" name="formAdd" method="post">
<input type="text" name="name" size="20" value="<%if(request.getParameter("name")!=null){out.print(request.getParameter("name"));} %>"/>
<input type="submit" value="搜索" />
</form></td>
</tr>
</table>
<table width="98%" border="0" cellpadding="2" cellspacing="1" bgcolor="#D1DDAA" align="center" style="margin-top:8px">
<tr bgcolor="#E7E7E7">
<td height="14" colspan="7" background="<%=path %>/images/wbg.gif">问卷管理</td>
</tr>
<tr align="center" bgcolor="#FAFAF1" height="22">
<td>名称</td>
<td>内容</td>
<td>类型</td>
<td>发布人</td>
<td>发布时间</td>
<td>问卷明细</td>
<td>操作</td>
</tr>
<c:forEach items="${requestScope.wenjuanList}" var="wenjuan">
<tr align='center' bgcolor="#FFFFFF" onMouseMove="javascript:this.bgColor='red';" onMouseOut="javascript:this.bgColor='#FFFFFF';" height="22">
<td bgcolor="#FFFFFF" align="center">
${wenjuan.title}
</td>
<td bgcolor="#FFFFFF" align="center">
<a href="#" onclick="wenjuanDetail(${wenjuan.id})" class="pn-loperator">查看内容</a>
</td>
<td bgcolor="#FFFFFF" align="center">
${wenjuan.type_name}
</td>
<td bgcolor="#FFFFFF" align="center">
${wenjuan.user_name}
</td>
<td bgcolor="#FFFFFF" align="center">
${wenjuan.shijian}
</td>
<td bgcolor="#FFFFFF" align="center">
<a href="#" style="color: red" onclick="timuByWenjuan(${wenjuan.id})" class="pn-loperator">查看问卷题目</a>
<a href="#" style="color: red" onclick="timuAll(${wenjuan.user_id},${wenjuan.id})" class="pn-loperator">题目添加</a>
</td>
<td bgcolor="#FFFFFF" align="center">
<a class="pn-loperator" href="<%=path %>/wenjuan?type=wenjuanDel&id=${wenjuan.id}">删除</a>
</td>
</tr>
</c:forEach>
</table>
<table width='98%' border='0'style="margin-top:8px;margin-left: 5px;">
<TR align="right">
<TD ><form action="" method="post" name="formpage">
<input type="hidden" name="pageCount" value="${requestScope.pagecount}" />
<!--//用于给上面javascript传值-->
<input type="hidden" name="page" value="${requestScope.page}" />
<!--//用于给上面javascript传值-->
<input type="hidden" name="jumpurl" value="<%=path%>/wenjuan?type=wenjuanMana&" />
<!--//用于给上面javascript传值-->
<a href="#" onClick="PageTop()"><strong>首页</strong></a>
<a href="#" onClick='PagePre()'><strong>上一页</strong></a>
共${requestScope.cou}条记录,
共计${requestScope.pagecount}页,
当前第${requestScope.page}页
<a href="#" onClick="PageNext()"><strong>下一页</strong></a>
<a href="#" onClick="PageLast()"><strong>尾页</strong></a> 第
<input name="busjump" type="text" size="3" value="${requestScope.page}" style=" width:15px"/>
页<a href="#" onClick="bjump()"><strong>跳转</strong></a>
</form>
<script type="text/javascript" src="<%=path%>/js/page.js"></script></TD>
</TR>
</table>
</body>
</html>