📄 toupiao2.jsp.bak
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@page import="java.sql.*"%>
<%
String sql="";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce){
out.println(ce.getMessage()+"!");
}
try{
conn=DriverManager.getConnection("jdbc:odbc:toupiao");
stmt=conn.createStatement();
rs=stmt.executeQuery("Select * from tp_title");
}
catch(SQLException e){
System.out.println(e.getMessage()+"?");
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>在线投票系统</title>
</head>
<BODY BGCOLOR="BEIGE">
<H2>投票结果
<br>
<%
while (rs.next())
{
String tihao = rs.getString("id");
//String temp=request.getParameter("No" + tihao);out.print("temp"+temp);
for(int k=1;k<5;k++){
if(request.getParameter(tihao+"No" +k )!=null){
String sqlup="update tp_title set 得票"+k+"=得票"+k+"+1" +" where id="+tihao;
//out.print("<br>"+sqlup);
stmt=conn.createStatement();
stmt.executeUpdate(sqlup);
}
}
}
ResultSet rs1=stmt.executeQuery("Select * from tp_title");
while(rs1.next()){
out.print(rs1.getString("title")+"<br>");
for(int i=1;i<5;i++)
{
out.print(rs1.getString("选项"+i)+rs1.getInt("得票"+i)+"<br>");
}
}
//stmt.close();
//conn.close();
//update V_vote set vcount=vcount+1 where id=cint('"&v&"')
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -