sweepstake/admin.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
<%@ page import= "java.sql.*" %>

<%
if ((request.getParameter("entrar")!=null)&& (request.getParameter("log")!=""))
{
	if ((request.getParameter("log")!="") != (request.getParameter("pas")!=""))
	{
	%>
	<p id="nota">login y password no deben estar vacíos</p>
	<%
	} else {

	  String JDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	  String connectDB="jdbc:odbc:porra";

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

	  String sql= "select idJug,nombre,login,password from usuarios where login='"+request.getParameter("log")+"' and password='"+request.getParameter("pas")+"'";

		stmt.execute(sql);
	 	ResultSet rs = stmt.getResultSet();
		if (rs.next())
		{
			session.setAttribute("idJ",rs.getString("idJug"));
			session.setAttribute("nombre",rs.getString("nombre"));
			session.setAttribute("login",rs.getString("login"));
			session.setAttribute("password",rs.getString("password"));
			response.sendRedirect("listado.jsp");
		}
		stmt.close();
	  con.close();
	}
}
%>


<html>
<head>
<title>PORRA MUNDIAL 2010</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
</head>


<body>

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

<div id="content">
<br/>
<br/>
</div>
</body>
</html>