<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<html>
<body>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://185.44.192.164/book";
Connection con = DriverManager.getConnection(url, "root", "godoro");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from Users");
%><ol><%
//ResultSet’teki tüm bilgi liste olarak gösteriliyor
while(rs.next()){
String name=rs.getString("Name");
int age=rs.getInt("Age");
%><li><%=name+"("+age+")"%></li><%
}
%></ol><%
}catch(Exception e){
e.printStackTrace();
}
%>
</body>
</html>
Dosyayı İndir