<%@ page contentType="text/html; charset=euc-kr" %>
<%@ page import = "java.io.*, java.sql.*, java.util.*, java.net.*" %>
<% request.setCharacterEncoding("utf-8"); %>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0, user-scalable=no, target-densitydpi=medium-dpi" />
</head>
<body style="margin:0;">
<%
String strReq = request.getParameter("number");
if(strReq == null)
{
out.print("잘못된 접근입니다");
}
else
{
String subject = null;
String content = null;
String filename = null;
String srtname = null;
int isvbns = 0;
String memberid = null;
int number = Integer.valueOf(strReq);
String url="jdbc:mysql://localhost/vbns";
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection(url,"root","kwcvbns");
Statement stmt=conn.createStatement();
String SQL = "SELECT subject, content, filename, isvbns, memberid FROM board WHERE number = " + number + ";";
ResultSet rs = stmt.executeQuery(SQL);
while(rs.next())
{
subject = rs.getString(1);
content = rs.getString(2);
filename = rs.getString(3);
isvbns = rs.getInt(4);
memberid = rs.getString(5);
}
rs.close();
stmt.close();
conn.close();
if(filename == null)
out.print("조회할 데이터가 없습니다");
else
{
String imagename = filename.substring(0, filename.lastIndexOf("."))+ ".jpg";
if(isvbns==1)
{
srtname = filename.substring(0, filename.lastIndexOf("."))+ ".srt";
srtname = "/files/srt/" + srtname;
}
else
srtname = "";
filename = "/files/movie/" + filename;
imagename = "/files/screen/" + imagename;
%>
<table width="100%" align="center" cellpadding=0 cellspacing=0>
<tr height=10 bgcolor="black">
<td></td>
</tr>
<tr height=50 align="center" bgcolor="f0f0f0">
<td><font size=5><b>V.B.N.S</b></font></td>
</tr>
<tr height=1 bgcolor="gray">
<td></td>
</tr>
<tr height=15>
<td>
</td>
</tr>
<tr height=1 bgcolor="gray">
<td></td>
</tr>
<tr height=30>
<td>
<table width="95%" align="center"><tr><td><font size=4><b><%=subject%></b></font></td></tr></table>
</td>
</tr>
<tr height=20>
<td>
<table width="80%" align="center"><tr><td><font size=1><%=memberid%></font></td></tr></table>
</td>
</tr>
<tr height=1 bgcolor="gray">
<td></td>
</tr>
<tr height=15>
<td>
</td>
</tr>
<tr>
<td>
<table width="95%" align="center">
<tr>
<td>
<video poster="<%=imagename%>" width="100%" height="200" controls preload="false" onclick="this.play();">
<source src="<%=filename%>" >
<caption srt="<%=srtname %>" ></caption>
<p>비디오 태그를 지원하지 않습니다</p></video>
</td>
</tr>
</table>
</td>
</tr>
<tr height=20>
<td>
</td>
</tr>
<tr height=150 valign="top">
<td>
<table width="95%" align="center"><tr><td><font size=3><%=content%></font></td></tr></table>
</td>
</tr>
</table>
<%
}
}
%>
</body>
</html>
jwplayer를 이용해서 해당 동영상 및 자막을 플레이어에서 재생하려 합니다.
그런데 동영상 재생이랑 소리는 잘 들리는데 자막파일이 안나오네요.
제가 초보라 그런가 ctrl c ,v로 여기까지 만들기는 했는데 도저히 모르겠습니다.
movie = ROOT\files\movie\해당 파일.mp4
image = ROOT\files\screen\해당파일.img
둘다 잘 나옵니다!
저학년이라 배워가는 단계입니다.
안드로이드 개발로 이것저것 만들고 있어서 아예 초보이니
자세하게 설명해주시면 감사하겠습니다.!!
