<%@ page import="java.sql.*"%> <% try { Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/emp_db", "root","sanjeev"); Statement stmt=con.createStatement(); String query="SELECT * FROM EMPLOYEE"; ResultSet rs=stmt.executeQuery(query); while(rs.next()) { %> <% } rs.close(); stmt.close(); con.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch( SQLException e) { e.printStackTrace(); } %>

<%= rs.getString("MEMID")%>

<%= rs.getString("MEMFNAME")%>

<%= rs.getString("MEMLNAME")%>

<%= rs.getString("MEMEMAIL")%>

<%= rs.getString("MEMPASSWORD")%>

<%= rs.getString("MEMADDR") %>

EDIT

DELETE