SampleList.jsp
Dosyayı İndir
<%--
Document : SampleList
Created on : May 21, 2013, 7:29:55 PM
Author : onder
--%>
<%@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 Listeleme</h1>
<table border="1">
<tr>
<td>ÖRNEK NO</td>
<td>ÖRNEK ADI</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 