hibernate抓取DB(数据库)时间,jsp页面抓取DB(数据库)时间的方法.

記錄:

hibernate抓取DB(sql server)時間的方法:

	// 获取DB的当前时间
	public Timestamp getDbDate() {
		return (Timestamp) sessionFactory.getCurrentSession()
				.createSQLQuery("select getdate()").uniqueResult();
	}

jsp頁面抓取DB時間的方法:

<script language="JavaScript" type="text/javascript">

//从服务器上获取初始时间 
	var currentDate = new Date(<%=new java.util.Date().getTime()%>);

	function run() {
		currentDate.setSeconds(currentDate.getSeconds() + 1);
		var time = "";
		var year = currentDate.getFullYear();
		var month = currentDate.getMonth() + 1;
		var day = currentDate.getDate();
		var hour = currentDate.getHours();
		var minute = currentDate.getMinutes();
		var second = currentDate.getSeconds();
		if (hour < 10) {
			time += "0" + hour;
		} else {
			time += hour;
		}
		time += ":";
		if (minute < 10) {
			time += "0" + minute;
		} else {
			time += minute;
		}
		time += ":";
		if (second < 10) {
			time += "0" + second;
		} else {
			time += second;
		}
		document.getElementById("dt").innerHTML = year + "-" + month + "-"
				+ day + "  " + time;
	}
	window.setInterval("run();", 1000);

	setInterval("myrefresh()", 30000); //指定30秒刷新一次

</script>