<%@ page import="java.sql.*" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title></title>
<!-- Bootstrap -->
<link href="../css/bootstrap.min.css" rel="stylesheet">
<!-- jQuery (Bootstrap 的所有 JavaScript 插件都依赖 jQuery，所以必须放在前边) -->
<script src="../js/jquery.min.js"></script>
<script src="../js/bootstrap.min.js"></script>
<style>
	body{
		font-family:YouYuan;
	}
</style>
</head>
<body>
 <div style="background: lightblue;height: 30px;;color:#fff;border-radius: 8px;width: 90%;margin:auto auto;">
<marquee style="font-size:20px;font-family:YouYuan;" behavior="scroll" direction="left"  hspace="0.1%" vspace="0.1%" loop="-1" scrollamount="20" scrolldelay="100" onMouseOut="this.start()" onMouseOver="this.stop()">
    ❤图书馆公告栏，记得查收公告呀！❤
</marquee> 
</div>
<script>
$(function () { 
	$("[data-toggle='popover']").popover();
});
</script>
<div class="a" align="center">
	
		<h2>近期公告</h2>

<jsp:useBean id="check" scope="session" class="javabean.JDBCBean"></jsp:useBean>
<%
		String sql="select*from announcement";
		ResultSet rs = check.executeQuery(sql);
		while (rs.next()) {

	if(Integer.parseInt(rs.getString("ID")) % 2== 1){
%>
	<button type="button" class="btn " title="<%=rs.getString("title")%>"  
			data-container="body" data-trigger="focus" data-toggle="popover" data-placement="left" 
			data-content="<%=rs.getString("detail")%>" style="width:40%;">
			
			<%=rs.getString("title")%><br>
			发布时间：<%=rs.getString("publish_date")%>
		
	</button><br><br>
<%
		}else{
			%>
			<button type="button" class="btn " title="<%=rs.getString("title")%>"  
					data-container="body" data-trigger="focus" data-toggle="popover" data-placement="right" 
					data-content="<%=rs.getString("detail")%>" style="width:40%;">
					
					<%=rs.getString("title")%><br>
					发布时间：<%=rs.getString("publish_date")%>
				
			</button><br><br>
<%
		}
		}
 %>

</div>
</body>
</html>