📄 toupiao2.jsp

📁 一个用java制作的在线投票网站

💻 JSP

字号:

<%@ 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">
投票结果
<br>
 <%
	while (rs.next())
	{	
		String tihao = rs.getString("id");
		String leixing= rs.getString("types");
		if (leixing.equals("多选"))
	   {
	      for(int k=1;k<5;k++){
			if(request.getParameter(tihao+"No" +k )!=null){
				String sqlm="update tp_title set 得票"+k+"=得票"+k+"+1" +" where id="+tihao;
				//out.print("<br>"+sqlm);
				stmt=conn.createStatement();
				stmt.executeUpdate(sqlm);
			  }
		    }
	     }
		else
		{
			String Sel = request.getParameter(tihao);
			String Ans[] = {"1","2","3","4"};
			for(int i=1;i<5;i++){
			if (Ans[i-1].equals(Sel))
			{
				String sqlup="update tp_title set 得票"+i+"=得票"+i+"+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.getInt("id")+"."+rs1.getString("title")+"<br>");
		for(int i=1;i<5;i++)
		{
			
		out.print(rs1.getString("选项"+i)+"    "+rs1.getInt("得票"+i)+"<br>");
		}
	
	}
  //stmt.close();
  //conn.close();

%>

</BODY>

</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -