<%@page import="java.sql.*"%>
<%
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/webdb";
String user = "root";
String password = "godoro";
Connection connection = DriverManager.getConnection(url, user, password);
String sql = "select * from Sample";
PreparedStatement statement = connection.prepareStatement(sql);
ResultSet resultSet = statement.executeQuery();
%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<h1>Örnek Dizelgeleme</h1>
<table border="1">
<tr style="font-weight: bold">
<td>Örnek Kimliği</td>
<td>Örnek Ad</td>
<td>Örnek Değer</td>
</tr>
<% while (resultSet.next()) {%>
<tr>
<td><%=resultSet.getLong("sampleId")%></td>
<td><%=resultSet.getString("sampleName")%></td>
<td><%=resultSet.getDouble("sampleValue")%></td>
</tr>
<% }%>
</table>
</body>
</html>
<%
connection.close();
%>
Dosyayı İndir