-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.jsp
116 lines (110 loc) · 6.16 KB
/
index.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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<!-- Bootstrap -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" crossorigin="anonymous">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap-theme.min.css" crossorigin="anonymous">
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js" crossorigin="anonymous"></script>
<link rel="stylesheet" href="crud.css">
<title>NBA Adrian Jimenez Montilla</title>
</head>
<body id="index">
<div class="container"> <!-- Contenedor -->
<br><br>
<div class="panel panel-warning">
<div class="panel-heading text-center"><h2>Jugadores y sus equipos de la NBA</h2></div>
<% //Acceso a la Base de Datos//
Class.forName("com.mysql.jdbc.Driver");
Connection conexion = DriverManager.getConnection("jdbc:mysql://localhost:3306/crudnba","root", "");
Statement s = conexion.createStatement();
//Ejecuta la consulta para guardarlo en listado
ResultSet listado = s.executeQuery ("SELECT * FROM jugadores INNER JOIN equipo ON jugadores.CodEqui = equipo.CodEqui");
%>
<!-- Tabla con formulario para agregar nuevos jugadores -->
<table class="table table-striped table table-condensed">
<form method="get" action="nuevoJugador.jsp">
<tr><td><input type="text" name="CodJug" size="2"></td>
<td><input type="text" name="NomJug" size="13"></td>
<td><input type="text" name="EdaJug" size="2"></td>
<td><input type="text" name="PosJug" size="13"></td>
<td><input type="text" name="AltJug" size="3"></td>
<td><input type="text" name="PesJug" size="2"></td>
<td><select name="CodEqui">
<option value="0"></option>
<option value="1">1-Los Angeles Lakers</option>
<option value="2">2-Golden State Warriors</option>
<option value="3">3-Boston Celtics</option>
<option value="4">4-Toronto Raptors</option>
<option value="5">5-Houston Rockets</option>
<option value="6">6-Oklahoma City Thunder</option>
<option value="7">7-Milwaukee Bucks</option>
<option value="8">8-San Antonio Spurs</option>
<option value="9">9-Philadelphia 76ers</option>
<option value="10">10-New York Knicks</option>
<option value="11">11-Chicago Bulls</option>
<option value="12">12-Miami Heat</option>
<option value="13">13-Cleveland Cavaliers</option>
<option value="14">14-Denver Nuggets</option>
<option value="15">15-Dallas Mavericks</option>
<option value="16">16-Sacramento Kings</option>
<option value="17">17-Los Angels Clippers</option>
<option value="18">18-Utah Jazz</option>
<option value="19">19-New Orleans Pelicans</option>
<option value="20">20-Portland Trail Blazers</option>
</select></td>
<td><button type="submit" value="Añadir" class="btn btn-success"><span class="glyphicon glyphicon-plus"></span> Añadir</button></td><td></td></tr>
<td><div> </div></td>
</form>
<tr><th>Código</th><th>Nombre</th><th>Edad</th><th>Posición</th><th>Altura</th><th>Peso</th><th>Código Equipo</th><th>Nombre Equipo</th><th>Año de fundación</th></tr>
<%//Extraemos los registros con bucle While
while (listado.next()) {
out.println("<tr><td>");
out.println(listado.getString("CodJug") + "</td>");
out.println("<td>" + listado.getString("NomJug") + "</td>");
out.println("<td>" + listado.getString("EdaJug") + "</td>");
out.println("<td>" + listado.getString("PosJug") + "</td>");
out.println("<td>" + listado.getString("AltJug") + "</td>");
out.println("<td>" + listado.getString("PesJug") + "</td>");
out.println("<td>" + listado.getString("CodEqui") + "</td>");
out.println("<td>" + listado.getString("NomEqui") + "</td>");
out.println("<td>" + listado.getString("FunEqui") + "</td>");
%>
<td>
<!-- Formulario que gestiona el boton editar -->
<form method="get" action="modificaJugador.jsp">
<input type="hidden" name="CodJug" value="<%=listado.getString("CodJug") %>">
<input type="hidden" name="NomJug" value="<%=listado.getString("NomJug") %>">
<input type="hidden" name="EdaJug" value="<%=listado.getString("EdaJug") %>">
<input type="hidden" name="PosJug" value="<%=listado.getString("PosJug") %>">
<input type="hidden" name="AltJug" value="<%=listado.getString("AltJug") %>">
<input type="hidden" name="PesJug" value="<%=listado.getString("PesJug") %>">
<input type="hidden" name="CodEqui" value="<%=listado.getString("CodEqui") %>">
<button type="submit" class="btn btn-warning"><span class="glyphicon glyphicon-pencil"></span></button>
</form>
</td>
<td>
<!-- Formulario que gestiona el boton borrar-->
<form method="get" action="borraJugador.jsp">
<input type="hidden" name="CodJug" value="<%=listado.getString("CodJug") %>"/>
<button type="submit" class="btn btn-danger"><span class="glyphicon glyphicon-remove"></span></button>
</form>
</td></tr>
<%
} //Termina While
conexion.close();
%>
</table>
</div>
<div class="text-center"><font color="red">© Adrian Jimenez Montilla</font></div>
</div>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>