package command;
 
import java.util.Collections;
import java.util.List;
import java.sql.*;
 
public class InfoPage implements Module {
	private String menuName;
	private int contentID;
	private Connection conn;
 
	public InfoPage(String menuName, int contentID, Connection conn) {
		super();
		this.menuName = menuName;
		this.contentID = contentID;
		this.conn = conn;
	}
 
	public List<String> GetMenu() {
		return Collections.singletonList(menuName);
	}
 
	public void Run() {
		String pageText = "";
		try {
			PreparedStatement stmt = conn.prepareStatement("SELECT txt FROM contents WHERE id = ?");
			stmt.setInt(1, contentID);
			ResultSet rs = stmt.executeQuery();
			rs.next();
			pageText = rs.getString("txt");
 
		} catch (SQLException e) {
			System.out.println("ошибочка...!");
		}
 
		//...
	}
 
}