<%--
Document : essential_details.jsp
Created on : Jan 6, 2023, 10:00:04 PM
Author : AbdulRasool
--%>
<%@page import = "java.sql.*" contentType="text/html" pageEncoding="UTF-8"%>
Kind Heart Charity - News Detail
<%
Class.forName("com.mysql.cj.jdbc.Driver");
String url = "jdbc:mysql://localhost:3307/feedindia";
String user = "root";
String pass = "root";
Connection con = DriverManager.getConnection(url,user,pass);
String query = "SELECT * FROM DONATE_DETAILS;";
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(query);
%>
| Name |
Contact |
Receive |
Amount |
From |
Essentials |
Credits |
<%
while(rs.next()){
String column1 = rs.getString(1);
String column2 = rs.getString(2);
String column3 = rs.getString(3);
String column4 = rs.getString(4);
String column5 = rs.getString(5);
String column6 = rs.getString(6);
int column7 = rs.getInt(7);
%>
| <%= column1%> |
<%= column2%> |
<%= column3%> |
<%= column4%> |
<%= column5%> |
<%= column6%> |
<%= column7%> |
<%
}
%>