<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="javax.naming.Context" %>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.sql.*"%>
<!--加载数据连接池-->
<!--jsp:useBean id="db" class="DBConnection.DbPool" scope="application"/-->
<jsp:useBean id="limit_control" class="DBConnection.limit_control" scope="application"/>
<%! String limit;%><%! Connection conn=null;%>
<%! Statement stmt;%>
<%! Statement stmt1;%>
<%! String str_sql;%>
<%! ResultSet rs;%>
<%! ResultSet rs1;%>
<%! DataSource ds = null;%>
<html>
<head>
<title>left</title>
<style type="text/css">
<!--
.pic { vertical-align: bottom; border-style: none}
-->
</style>
<link rel="stylesheet" href="menu_css.css" type="text/css">
</head><body background="images/lan2.jpg">
<table width="268" border="0" cellpadding="0" cellspacing="0" align="right">
<tr width=267>
<td>
<script language="JavaScript1.2">
NS4 = (document.layers) ? 1 : 0;
IE4 = (document.all) ? 1 : 0;
ver4 = (NS4 || IE4) ? 1 : 0;if (ver4) {
with (document) {
write("<STYLE TYPE='text/css'>");
/* if (NS4) {
write(".parent {position:absolute; visibility:visible}");
write(".child {position:absolute; visibility:visible}");
write(".regular {position:absolute; visibility:visible}")
}
else {
write(".child {display:none}")
}
*/
write("</STYLE>");
}
}function getIndex(el) {
ind = null;
for (i=0; i<document.layers.length; i++) {
whichEl = document.layers[i];
if (whichEl.id == el) {
ind = i;
break;
}
}
return ind;
}function arrange() {
nextY = document.layers[firstInd].pageY +document.layers[firstInd].document.height;
for (i=firstInd+1; i<document.layers.length; i++) {
whichEl = document.layers[i];
if (whichEl.visibility != "hide") {
whichEl.pageY = nextY;
nextY += whichEl.document.height;
}
}
}function initIt(){
if (!ver4) return;
if (NS4) {
for (i=0; i<document.layers.length; i++) {
whichEl = document.layers[i];
if (whichEl.id.indexOf("Child") != -1) whichEl.visibility = "hide";
}
arrange();
}
else {
divColl = document.all.tags("DIV");
for (i=0; i<divColl.length; i++) {
whichEl = divColl(i);
if (whichEl.className == "child") whichEl.style.display = "none";
}
}
}function expandIt(el) {
if (!ver4) return;
if (IE4) {
whichEl = eval(el + "Child");
if (whichEl.style.display == "none") {
whichEl.style.display = "block";
}
else {
whichEl.style.display = "none";
}
}
else {
whichEl = eval("document." + el + "Child");
if (whichEl.visibility == "hide") {
whichEl.visibility = "show";
}
else {
whichEl.visibility = "hide";
}
arrange();
}
}
</script><div id="KB1Parent" class="parent"> <a href="#" onClick="expandIt('KB1'); return false">
<img src="images/nav_enter.gif" class="pic">福州海事局船舶动态</a></div>
<%
//建立与数据库的连接,调用连接池
try{
//调用数据连接池的方法,此方法判断数据连接池是否存在,若不存在调用createpool()方法新建数据连接池。
/*if(db.getUrl() == null)
{
db.createpool(); //新创建一个连接池
//System.out.println("DB config");
}
conn = db.getCon(); //获取连接字符串
*/
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (DataSource)envCtx.lookup("jdbc/dtbg"); conn = ds.getConnection();
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); //创建记录集
stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); //创建记录集
int i=2;
String str_error;
String menu_frm;
str_sql="select menu_name,menu_id,menu_sort from r_menu where menu_parent=0 order by menu_sort";
rs=stmt.executeQuery(str_sql);
str_error="系统出现错误,请与系统管理员联系!";
while (rs.next())
{
if (i==2) {
%>
<div id="KB1Child" class="child">
<a href="#" onClick="expandIt('KB<%=i%>'); return false">
<img src="images/icon_4.gif" class="pic"><%=rs.getString("menu_name")%></a>
<%
} else {
%>
<div id="KB<%=i%>Parent" class="parent">
<a href="#" onClick="expandIt('KB<%=i%>'); return false">
<img src="images/icon_4.gif" class="pic"><%=rs.getString("menu_name")%></a>
</div><%
}
str_sql="select menu_frm,menu_name,menu_sort from r_menu where menu_parent="+rs.getInt("menu_id")+" order by menu_sort";
//System.out.println(str_sql);
rs1=stmt1.executeQuery(str_sql);
rs1.last();
int rscount=rs1.getRow();
//System.out.println(rscount);
rs1.first();
if (rscount>0)
{
%>
<div id="KB<%=i%>Child">
<%
do
{ //System.out.println(rs1.getString("menu_frm"));
if (rs1.getString("menu_frm")!=null)
{
menu_frm=rs1.getString("menu_frm").trim();
limit_control.set_limit_menu(rs1.getString("menu_name"),session.getAttribute("UserName").toString());
limit=limit_control.get_limit_menu();
if(limit.equals("1"))
{
%>
<img src="images/over.gif" class="pic"><a href=
<%
out.println(menu_frm+" target=mainFrame>"+rs1.getString("menu_name").trim()+"</a><br>");
}
}
} while (rs1.next());
out.println("</div>"); }
if(rs1!=null)
rs1.close();
i=i+1;
}
if(rs!=null)
rs.close();
out.print("</div>");
//关闭数据连接
}
catch(Exception e)
{
System.out.println("basetree.jsp "+e.toString());
}
finally
{
/* rs.close();
stmt.close();
db.freeCon(conn);*/
if(stmt!=null)
stmt.close();
if(stmt1!=null)
stmt1.close();
if(conn!=null)
conn.close();
if(ds!=null)
ds=null;
}
%>
</td>
</tr>
</table>
</body>
</html>
<%@ page import="javax.naming.Context" %>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.sql.*"%>
<!--加载数据连接池-->
<!--jsp:useBean id="db" class="DBConnection.DbPool" scope="application"/-->
<jsp:useBean id="limit_control" class="DBConnection.limit_control" scope="application"/>
<%! String limit;%><%! Connection conn=null;%>
<%! Statement stmt;%>
<%! Statement stmt1;%>
<%! String str_sql;%>
<%! ResultSet rs;%>
<%! ResultSet rs1;%>
<%! DataSource ds = null;%>
<html>
<head>
<title>left</title>
<style type="text/css">
<!--
.pic { vertical-align: bottom; border-style: none}
-->
</style>
<link rel="stylesheet" href="menu_css.css" type="text/css">
</head><body background="images/lan2.jpg">
<table width="268" border="0" cellpadding="0" cellspacing="0" align="right">
<tr width=267>
<td>
<script language="JavaScript1.2">
NS4 = (document.layers) ? 1 : 0;
IE4 = (document.all) ? 1 : 0;
ver4 = (NS4 || IE4) ? 1 : 0;if (ver4) {
with (document) {
write("<STYLE TYPE='text/css'>");
/* if (NS4) {
write(".parent {position:absolute; visibility:visible}");
write(".child {position:absolute; visibility:visible}");
write(".regular {position:absolute; visibility:visible}")
}
else {
write(".child {display:none}")
}
*/
write("</STYLE>");
}
}function getIndex(el) {
ind = null;
for (i=0; i<document.layers.length; i++) {
whichEl = document.layers[i];
if (whichEl.id == el) {
ind = i;
break;
}
}
return ind;
}function arrange() {
nextY = document.layers[firstInd].pageY +document.layers[firstInd].document.height;
for (i=firstInd+1; i<document.layers.length; i++) {
whichEl = document.layers[i];
if (whichEl.visibility != "hide") {
whichEl.pageY = nextY;
nextY += whichEl.document.height;
}
}
}function initIt(){
if (!ver4) return;
if (NS4) {
for (i=0; i<document.layers.length; i++) {
whichEl = document.layers[i];
if (whichEl.id.indexOf("Child") != -1) whichEl.visibility = "hide";
}
arrange();
}
else {
divColl = document.all.tags("DIV");
for (i=0; i<divColl.length; i++) {
whichEl = divColl(i);
if (whichEl.className == "child") whichEl.style.display = "none";
}
}
}function expandIt(el) {
if (!ver4) return;
if (IE4) {
whichEl = eval(el + "Child");
if (whichEl.style.display == "none") {
whichEl.style.display = "block";
}
else {
whichEl.style.display = "none";
}
}
else {
whichEl = eval("document." + el + "Child");
if (whichEl.visibility == "hide") {
whichEl.visibility = "show";
}
else {
whichEl.visibility = "hide";
}
arrange();
}
}
</script><div id="KB1Parent" class="parent"> <a href="#" onClick="expandIt('KB1'); return false">
<img src="images/nav_enter.gif" class="pic">福州海事局船舶动态</a></div>
<%
//建立与数据库的连接,调用连接池
try{
//调用数据连接池的方法,此方法判断数据连接池是否存在,若不存在调用createpool()方法新建数据连接池。
/*if(db.getUrl() == null)
{
db.createpool(); //新创建一个连接池
//System.out.println("DB config");
}
conn = db.getCon(); //获取连接字符串
*/
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (DataSource)envCtx.lookup("jdbc/dtbg"); conn = ds.getConnection();
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); //创建记录集
stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); //创建记录集
int i=2;
String str_error;
String menu_frm;
str_sql="select menu_name,menu_id,menu_sort from r_menu where menu_parent=0 order by menu_sort";
rs=stmt.executeQuery(str_sql);
str_error="系统出现错误,请与系统管理员联系!";
while (rs.next())
{
if (i==2) {
%>
<div id="KB1Child" class="child">
<a href="#" onClick="expandIt('KB<%=i%>'); return false">
<img src="images/icon_4.gif" class="pic"><%=rs.getString("menu_name")%></a>
<%
} else {
%>
<div id="KB<%=i%>Parent" class="parent">
<a href="#" onClick="expandIt('KB<%=i%>'); return false">
<img src="images/icon_4.gif" class="pic"><%=rs.getString("menu_name")%></a>
</div><%
}
str_sql="select menu_frm,menu_name,menu_sort from r_menu where menu_parent="+rs.getInt("menu_id")+" order by menu_sort";
//System.out.println(str_sql);
rs1=stmt1.executeQuery(str_sql);
rs1.last();
int rscount=rs1.getRow();
//System.out.println(rscount);
rs1.first();
if (rscount>0)
{
%>
<div id="KB<%=i%>Child">
<%
do
{ //System.out.println(rs1.getString("menu_frm"));
if (rs1.getString("menu_frm")!=null)
{
menu_frm=rs1.getString("menu_frm").trim();
limit_control.set_limit_menu(rs1.getString("menu_name"),session.getAttribute("UserName").toString());
limit=limit_control.get_limit_menu();
if(limit.equals("1"))
{
%>
<img src="images/over.gif" class="pic"><a href=
<%
out.println(menu_frm+" target=mainFrame>"+rs1.getString("menu_name").trim()+"</a><br>");
}
}
} while (rs1.next());
out.println("</div>"); }
if(rs1!=null)
rs1.close();
i=i+1;
}
if(rs!=null)
rs.close();
out.print("</div>");
//关闭数据连接
}
catch(Exception e)
{
System.out.println("basetree.jsp "+e.toString());
}
finally
{
/* rs.close();
stmt.close();
db.freeCon(conn);*/
if(stmt!=null)
stmt.close();
if(stmt1!=null)
stmt1.close();
if(conn!=null)
conn.close();
if(ds!=null)
ds=null;
}
%>
</td>
</tr>
</table>
</body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货