Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
- "http://www.w3.org/TR/html4/loose.dtd">
- <%@ page import="java.sql.*" %>
- <%@ page import="java.io.*" %>
- <html>
- <head>
- <title>Connection avec mysql</title>
- </head>
- <body>
- <%
- String URL = "jdbc:mysql://localhost:3306/gapp";
- Class.forName("com.mysql.jdbc.Driver");
- Connection connection = DriverManager.getConnection(URL, "root" , "");
- %>
- <%
- Statement stmt = connection.createStatement();
- ResultSet rs = stmt.executeQuery("select * from user");
- while (rs.next()) {
- String id = rs.getString("id_user");
- String nom = rs.getString("user_nom");
- String prenom = rs.getString("user_prenom");
- String mail = rs.getString("user_mail");
- out.println("<li>"+id+" "+nom+" "+prenom+" "+mail+"</li>");
- }
- %>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement