-
Notifications
You must be signed in to change notification settings - Fork 0
/
voteaction.jsp
69 lines (55 loc) · 2.14 KB
/
voteaction.jsp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*"%>
<%
String gamecount = request.getParameter("gamecount");
String hidden1 = request.getParameter("hidden1");
String hidden2 = request.getParameter("hidden2");
String op1 = request.getParameter("op1");
String op2 = request.getParameter("op2");
int temp = 0;
Connection conn = null;
PreparedStatement pstmt = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/worldcup", "root", "1234");
String query1 = null;
String query2 = null;
String query3 = null;
String sql1 = null;
String sql2 = null;
sql1 = "update question set total=total+1 where num=" + op1;
sql2 = "update question set total=total+1 where num=" + op2;
if (hidden1.equals("1")) {
query1 = "update member set gamecount=gamecount+1 where id='" + session.getAttribute("id") + "'";
query2 = "update question set yes=yes+1 where num=" + op1;
temp = Integer.parseInt(op1);
pstmt = conn.prepareStatement(sql1);
pstmt.executeUpdate();
pstmt = conn.prepareStatement(sql2);
pstmt.executeUpdate();
pstmt.close();
} else if (hidden2.equals("1")) {
query1 = "update member set gamecount=gamecount+1 where id='" + session.getAttribute("id") + "'";
query2 = "update question set yes=yes+1 where num=" + op2;
temp = Integer.parseInt(op2);
pstmt = conn.prepareStatement(sql1);
pstmt.executeUpdate();
pstmt = conn.prepareStatement(sql2);
pstmt.executeUpdate();
pstmt.close();
}
pstmt = conn.prepareStatement(query1);
pstmt.executeUpdate();
pstmt = conn.prepareStatement(query2);
pstmt.executeUpdate();
query3 = "update member set g" + String.valueOf(Integer.parseInt(gamecount) + 1) + "="
+ String.valueOf(temp) + " where id='" + session.getAttribute("id") + "'";
pstmt = conn.prepareStatement(query3);
pstmt.executeUpdate();
response.sendRedirect("game.jsp");
} catch (Exception e) {
out.println(e);
//out.println("<script> alert('둘 중 하나를 반드시 선택해야 합니다.'); history.back(); </script>");
e.printStackTrace();
}
%>