📄 ck_ziliao.jsp
字号:
<%@page language="java"%>
<%@page contentType="text/html;charset=8859_1"%>
<%@page import="java.sql.*"%>
<%@page import="DBCon"%>
<% DBCon DBConBean=new DBCon(); %>
<%@page import="IdSelect"%>
<% IdSelect IdSelectBean=new IdSelect(); %>
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/style.css" type="text/css">
</head>
<script src="data.js"></script>
<script>
function subb() {
if((document.form1.lm_id.value=="")&&(document.form1.zt_id.value=="")){
alert("请填写要查询的栏目名称或专题名称！！");
}
else{
document.form1.action="ck_brow.jsp"
form1.submit();
}
}
</script>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="">
<table width="90%" border="1" cellspacing="0" cellpadding="0" align="left" bordercolorlight="#000000" bordercolordark="#ffffff" class="zw" bgcolor="#e1e1e1">
<tr>
<td> </td>
<td>所属栏目：</td>
<td>
<select name="lm_id" style="width:100px">
<option value="">——————</option>
<%
String s_jb_id =(String)session.getValue("s_jb_id");
String s_user_lm_id =(String)session.getValue("s_user_lm_id");
IdSelectBean.setIdName("lm_del");
IdSelectBean.setStrTableName("lanmu");
if (s_user_lm_id.equals("1")){
IdSelectBean.setStrId("0 and s_jb_id="+s_jb_id+"");}
else{IdSelectBean.setStrId("0 and lm_id="+s_user_lm_id+"");}
try {
Connection conn = DBConBean.getConnection();
IdSelectBean.setConn(conn);
ResultSet result = IdSelectBean.getResultSet();
%>
<%
//利用while循环将数据表中的记录列出
while(result.next()) {
String lm_id= result.getString("lm_id");
String lm_name=result.getString("lm_name");%>
<option value="<%=lm_id%>"><%=lm_name%></option>
<%
}
result.close(); }
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}%>
</select>
</td>
<td>所属专题：</td>
<td>
<select name="zt_id" style="width:100px">
<option value="">——————</option>
<%
IdSelectBean.setIdName("zt_del");
IdSelectBean.setStrTableName("zhuanti");
if (s_user_lm_id.equals("1")){System.out.println("ok");
IdSelectBean.setStrId("0 and s_jb_id="+s_jb_id+"");}
else{IdSelectBean.setStrId("0 and lm_id="+s_user_lm_id+"");System.out.println("no");}
try {
Connection conn = DBConBean.getConnection();
IdSelectBean.setConn(conn);
ResultSet result = IdSelectBean.getResultSet();
%>
<%
//利用while循环将数据表中的记录列出
while(result.next()) {
String zt_id= result.getString("zt_id");
String zt_name=result.getString("zt_name");%>
<option value="<%=zt_id%>"><%=zt_name%></option>
<%
}
result.close(); }
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}DBConBean.closeAll();%>
</select>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>发布日期：</td>
<td>
<input type="text" name="first_data" style="width:100px" readonly>
<a href="javascript:show_calendar('form1.first_data');" onmouseover="window.status='Date Picker';return true;" onmouseout="window.status='';return true;"><img src="../img/FolderClosed.gif" border=0></a>
</td>
<td>至</td>
<td>
<input type="text" name="last_data" style="width:100px" readonly value="">
<a href="javascript:show_calendar('form1.last_data');" onmouseover="window.status='Date Picker';return true;" onmouseout="window.status='';return true;"><img src="../img/FolderClosed.gif" border=0></a>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>关键字：</td>
<td>
<input type="text" name="key_words" style="width:100px" value="">
</td>
<td>文章题目：</td>
<td>
<input type="text" name="key_name" style="width:100px" value="">
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>发布人：</td>
<td>
<input type="text" name="pubman" style="width:100px" value="">
</td>
<td>审核人：</td>
<td>
<input type="text" name="checkman" style="width:100px" value="">
</td>
<td> </td>
</tr>
<tr>
<td colspan="6">
<input type="button" name="Submit" value="按钮" onclick="subb()">
<input type="reset" name="Submit2" value="重置">
</td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -