sweepstake/generarjugador.jsp at master · megalucio/sweepstake · GitHub

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
70
71
72
73
74
75
76
77
78
79
80
81
82
<%@ page import= "java.sql.*" %>
<%@ page import = "java.util.Date,java.text.SimpleDateFormat,java.text.ParseException"%>


<%
if (request.getParameter("crear")!=null)
{
  String JDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
  String connectDB="jdbc:odbc:porra";

  Class.forName(JDriver);
  Connection con = DriverManager.getConnection(connectDB);
  Statement stmt = con.createStatement();

	String sql2= "select idJug from usuarios where nombre='"+request.getParameter("nombre")+"'";
	stmt.execute(sql2);
	ResultSet rs = stmt.getResultSet();
	if (rs.next())
	{
		%>
		<p>Player already exists</p>
		<%
	}
	else
	{
		String sql3= "insert into usuarios (nombre,puesto,login,password) values ('"+request.getParameter("nombre")+"','"+request.getParameter("puesto")+"','"+request.getParameter("login")+"','"+request.getParameter("password")+"')";
		stmt.executeUpdate(sql3);
		String sql= "select idJug from usuarios where nombre='"+request.getParameter("nombre")+"'";
		stmt.execute(sql);
		%><p>User created</p><%
		rs = stmt.getResultSet();
		if (rs.next())
		{
			String idJug=rs.getString("idJug");
		  for (int i=1;i<=64;i++)
		  {
		  	String sql5= "insert into apuestas (idJug,idpartido,r1,r2) values ("+idJug+","+i+",0,0)";
				stmt.execute(sql5);
			}
		}
	}
	stmt.close();
  con.close();

}
%>


<html>
<head>
<title>EUROCUP SWEEPSTAKE 2012</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
</head>


<body>


<%int opcion=1;%>
<%@ include file="header_admin.jsp"%>


<div id="content">

<form method="post" action="generarjugador.jsp">

<table>
<tr><td>Name:</td><td><input type="text" name="nombre" value="" style="width:100px;"></td></tr>
<tr><td>Position:</td><td><input type="text" name="puesto" value="" style="width:100px;"></td></tr>
<tr><td>Login:</td><td><input type="text" name="login" value="" style="width:100px;"></td></tr>
<tr><td>Password:</td><td><input type="text" name="password" value="" style="width:100px;"></td></tr>
<tr><td> </td><td><input type="submit" name="crear" value="crear"></td></tr>
</table>
</form>


<br/>
</div>

</body>
</html>