Java 投票（自动加一）

最新推荐文章于 2022-09-28 16:47:16 发布

stevenbill

最新推荐文章于 2022-09-28 16:47:16 发布

阅读量289

点赞数

分类专栏： JAVA 文章标签： Java Oracle JDBC JSP SQL

本文链接：https://blog.csdn.net/stevenbill/article/details/83874715

版权

JAVA 专栏收录该内容

332 篇文章 1 订阅

订阅专栏

数据库建立：


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>