Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
- <%@page contentType="text/html" pageEncoding="UTF-8"%>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
- <title>Insertar Cuotas</title>
- </head>
- <body>
- <form action="EjecutarInsertar" method="POST" >
- <table>
- <tr>
- <td>
- <label for="cuota1">Cuota 1:</label>
- </td>
- <td>
- <input name="cuota1" type="number" min="1" step="0.01"/>
- </td>
- </tr>
- <tr>
- <td>
- <label for="cuota2">Cuota 2:</label>
- </td>
- <td>
- <input name="cuota2" type="number" min="1" step="0.01"/>
- </td>
- </tr>
- <tr>
- <td>
- <label for="cuota3">Cuota 3:</label>
- </td>
- <td>
- <input name="cuota3" type="number" min="1" step="0.01"/>
- </td>
- </tr>
- <tr>
- <td>
- <label for="cuota4">Cuota 4:</label>
- </td>
- <td>
- <input name="cuota4" type="number" min="1" step="0.01"/>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <button type="submit">Insertar</button><br/>
- <button type="reset">Limpiar</button><br/>
- <button type="button"> <sql:query var="cuota1" dataSource="ds">
- SELECT (cuota1*cuota2*cuota3*cuota4) AS resultado FROM cuotas WHERE ID='5';
- </sql:query>
- </td>
- </tr>
- </table>
- </form>
- </body>
- </html>
- @Bean
- public DriverManagerDataSource dataSource(){
- DriverManagerDataSource ds=new DriverManagerDataSource();
- ds.setDriverClassName("com.mysql.jdbc.Driver");
- ds.setUrl("jdbc:mysql://localhost:3306/apuestas");
- ds.setUsername("root");
- ds.setPassword("root");
- return ds;
- }
Add Comment
Please, Sign In to add comment