第二次冲刺 07

今日对于广告实现最终的实现。

对于广告的投放以及对于广告的播放进行了进一步实现。

<div class="div1">
<div class="bigcontent">
            <!-- muted:视频内容静音 -->
            <%
            
            List<String> s = new ArrayList<>();
            Connection c=Tool.getConnection();
            PreparedStatement pre = null;
            ResultSet res = null;
            String sql = "SELECT * FROM advert where user_name= ? ";
            try {
                pre = c.prepareStatement(sql);
                pre.setString(1,"111");
                //pre.setString(2,tel);
                res = pre.executeQuery();
                while (res.next()) {
                    String s1 = res.getString("advert_name");
                    s.add(s1);
                    
                }
            } catch (SQLException e) {

                e.printStackTrace();
            } finally {
                Tool.release(c, pre, res);
            }
            System.out.println(s.get(0));
            if(s.get(0).equals("拼多多官方推广")){%>
                <video onmouseover="play_v1(this)"  controls loop  muted src="video/se.mp4"></video>
            <%}else{%>
                <video onmouseover="play_v1(this)"  controls loop  muted src="http://101.43.157.183:8233/FileServer/ss.mp4"></video>
            <%}
            %>
            <img alt="" src="images/gg.webp" width='500' height='300' id="im1"/>
            <img alt="" src="images/gge.jpg" width='500' height='190'/>
        </div>
        </div>
        <div class="aside" id="aside">
        <span id="s">10</span>
        <span>秒后关闭</span>
        &nbsp;&nbsp;
<!--          <img alt="" src="images/mn.jpg" width='300' height='300'/> -->
        <a onclick="del()">关闭</a>
        </div>

</body>
</html>
<script type="text/javascript" src="index.js"></script>