vote投票系统说明.docxVIP

vote投票系统说明 系统说明：本系统由五个页面组成(三个显示页，两个处理页)，简单方便，美观大方，有一定的实用性，当然,此作品中还有许多要改进的地方,恳请老师多多指教! ODBC数据源名为firm add_total.jsp：用到了JavaBean数据库的链接，查找以及显示。 %@ page contentType=text/html; charset=gb2312 language=java import=java.sql.* errorPage= % !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN /TR/html4/loose.dtd jsp:useBean id=db scope=page class=firm.firm/ meta http-equiv=Content-Type content=text/html; charset=gb2312 % try { String test=request.getParameter(test); int id=Integer.parseInt(test); ResultSet rs = db.executeQuery(select all top 1 * from table_vote order by id desc); rs.next(); int total=rs.getInt(result+id)+1; db.executeUpdate(update table_vote set result+id+=+total); rs.close(); db.closeStmt(); db.closeConn(); } catch(Exception e) { out.print(e.toString()); } % % response.sendRedirect(show.jsp); % add_vote.htm：添加调查项目的投票选项，form表单，点击提交有判断，图片上有添加锚点跳转页面。 !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns=/1999/xhtml head meta http-equiv=Content-Type content=text/html; charset=gb2312 / link href=css/style.css rel=stylesheet type=text/css / title添加调查项目/title /head script language=javascript function check() { if(form1.context.value==) { alert(您没有写题目呢!); form1.context.focus(); return false; } if(form1.option1.value==) { alert(写一个好选啊!); form1.option1.focus(); return false; } if(form1.option2.value==) { alert(再来个更好选啊!); form1.option2.focus(); return false; } } /script body table width=200 border=0 align=center cellpadding=0 cellspacing=0 tr td colspan=2object classid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000 codebase=/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0 width=800 height=193 param name=movie value=images/top.swf / param name=quality value=high / embed src=images/top.swf quality=high pluginspage=/go/getflashplayer type=application/x-shockwave-flash width=800 height=193/embed /object/td /tr tr