Java 投票(自动添一)
Java 投票(自动加一)
数据库建立:
//index.jsp
//turn.jsp
数据库建立:
SQL> create table vote( 2 id number, 3 name varchar(200), 4 num number 5 );
//index.jsp
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@ page import="java.sql.*" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>投票</title> </head> <body> <% Connection conn1 = null; Statement stmt1 = null; ResultSet rs1 = null; try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); conn1 = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:orcl", "zhang", "zhang"); stmt1 = conn1.createStatement(); String url = "select * from vote order by id desc"; rs1 = stmt1.executeQuery(url); while (rs1.next()) { out.print(rs1.getString("name")+":"); %> <a href="../service/turn.jsp?id=<%=rs1.getString("id")%>" >支持<%=rs1.getString("num") %></a> <% out.print("<br/>"); } } catch (Exception e) { e.printStackTrace(); } finally { try { if (rs1 != null) { rs1.close(); } if (stmt1 != null) { stmt1.close(); } if (conn1 != null) { conn1.close(); } } catch (Exception e) { e.printStackTrace(); } } %> </body> </html>
//turn.jsp
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@ page import="java.sql.*" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>turn</title> </head> <body> <% //int add = 1; Connection conn = null; Statement stmt = null; ResultSet rs = null; String myid = request.getParameter("id"); // if ("".equals(myid) || myid == null) { // out.println("您如果对感兴趣的话,请填写!"); // out.print("<br/>"); // } else { Boolean flag = false; try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:orcl", "zhang", "zhang"); stmt = conn.createStatement(); int addl = Integer.valueOf(myid); //++addl; //String lid=addl+""; String url = "update vote set num=num+1 where id=" + myid + ""; //String url = "update adder set num=num+1 where id=" + myid + ""; // out.print("url"+url); stmt.execute(url); out.print("5555555555"); response.sendRedirect("../service/index.jsp"); return; //String urll = "select * from adder"; // rs = stmt.executeQuery(urll); //while (rs.next()) { // flag = true; // } } catch (Exception e) { e.printStackTrace(); } // } %> </body> </html>