Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@page import="java.sql.DriverManager"%>
- <%@page import="java.sql.ResultSet"%>
- <%@page import="java.sql.Statement"%>
- <%@page import="java.sql.Connection"%>
- <%
- String id = request.getParameter("userId");
- String driverName = "com.mysql.jdbc.Driver";
- String connectionUrl = "jdbc:mysql://localhost:3306/";
- String dbName = "mydb";
- String userId = "root";
- String password = "";
- try {
- Class.forName(driverName);
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- }
- Connection connection = null;
- Statement statement = null;
- ResultSet resultSet = null;
- %>
- <h2 align="center"><font><strong>Retrieve data from database in jsp</strong></font></h2>
- <table align="center" cellpadding="5" cellspacing="5" border="1">
- <tr>
- </tr>
- <tr bgcolor="#A52A2A">
- <td><b>id</b></td>
- <td><b>saldo</b></td>
- <td><b>porcentaje</b></td>
- <td><b>Interes</b></td>
- <td><b>Fecha ultimo cambio</b></td>
- </tr>
- <%
- try{
- connection = DriverManager.getConnection(connectionUrl+dbName, userId, password);
- statement=connection.createStatement();
- String sql ="SELECT * FROM saldo";
- resultSet = statement.executeQuery(sql);
- while(resultSet.next()){
- %>
- <tr bgcolor="#DEB887">
- <td><%=resultSet.getString("id") %></td>
- <td><%=resultSet.getString("saldo") %></td>
- <td><%=resultSet.getString("porcentaje") %></td>
- <td><%=resultSet.getString("interes_generado") %></td>
- <td><%=resultSet.getString("fecha_ultimo_cambio") %></td>
- </tr>
- <%
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- %>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement