ایجاد کلاسی که اطلاعات رو از دیتابیس بخونه و اطلاعات خوانده شده رو داخل یک یا چند jsp بشه خروجی گرفت.
در واقع روش MVC انجام بشه توش.
یک کد رو خودم نوشتم مشکلش کجاست.
package panel;
import java.sql.*;
import java.util.ArrayList;
/**
*
* @author JOKER
*/
public class DBHandler {
private Connection cn;
public DBHandler() throws SQLException {
try {
Class.forName("com.mysql.jdbc.Driver");
cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/siwa", "root", "");
}
catch (Exception ex){
throw new SQLException("data source has not found", ex);
}
}
public void koko() throws ClassNotFoundException, SQLException {
ArrayList retAry = new ArrayList();
String getQuery = "SELECT * FROM pagenew";
try (PreparedStatement ps = cn.prepareStatement(getQuery)) {
ResultSet result = ps.executeQuery();
while (result.next()) {
String title = result.getString("title");
String content = result.getString("content");
String time = result.getString("time");
Ites it = new Ites(title,content,time);
retAry.add(it);
}
result.close();
}
catch (SQLException ex) {
System.out.println("ERoor");
}
}
}
-----------------------------------------------------------------------------------
<%—
Document : pages-table
Created on : Apr 18, 2017, 5:00:16 PM
Author : JOKER
—%>
<%@page import="panel.DBHandler"%>
<%@taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%
DBHandler handler = new DBHandler();
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Siwa Dashboard</title>
<meta name="description" content="" />
<meta name="keywords" content="" />
<meta name="robots" content="" />
<meta name="viewport" content="width=device-width, minimum-scale=1.0, maximum-scale=1.0">
<link rel="stylesheet" href="css/style.css" media="all" />
<!--[if IE]><link rel="stylesheet" href="css/ie.css" media="all" /><![endif]-->
</head>
<body>
<h2><% handler.koko(); %></h2>
</body>
</html>