📄 lm_up.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 language="javascript">
function subb() {
if(document.form1.lm_name.value==""){
alert("请填写要增加的栏目名称！！");
}
else
if(document.form1.lm_admin_mail.value==""){
alert("请填写要增加的管理员信箱！！");
}else{
document.form1.action="lm_up2.jsp"
form1.submit();
}
}
</script>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="">
<table width="75%" border="1" cellspacing="0" cellpadding="0" align="left" bordercolorlight="#000000" bordercolordark="#ffffff" class="zw" bgcolor="#e1e1e1">
<%
String s_jb_id =(String)session.getValue("s_jb_id");
String lm_id = request.getParameter("lm_id");
String lm_type="";String lm_moban_id="";String lm_tx="";
String lm_win="";String lm_vist_power="";String lm_info="";
IdSelectBean.setIdName("lm_id");
IdSelectBean.setStrTableName("lanmu");
IdSelectBean.setStrId(lm_id+" and lm_del=0");
try {
Connection conn = DBConBean.getConnection();
IdSelectBean.setConn(conn);
ResultSet result = IdSelectBean.getResultSet();
//利用while循环将数据表中的记录列出
while(result.next()) {
String lm_name= result.getString("lm_name");
lm_type=result.getString("lm_type");
lm_info=result.getString("lm_info");
lm_tx=result.getString("lm_tx");
String lm_line=result.getString("lm_line");
lm_win=result.getString("lm_win");
String lm_admin_mail=result.getString("lm_admin_mail");
lm_moban_id=result.getString("lm_moban_id");
String lm_xh=result.getString("lm_xh");
lm_vist_power=result.getString("lm_vist_power");
%>
<tr>
<td rowspan="12" height="240"> </td>
<td height="30">栏目名称：</td>
<td height="30">
<input type="text" name="lm_name" style="width:140px" value="<%=lm_name%>"><input type="hidden" name="lm_id" style="width:140px" value="<%=lm_id%>">
</td>
<td rowspan="12" height="240"> </td>
</tr>
<tr>
<td height="30">每页显示文章数：</td>
<td height="30">
<input type="text" name="lm_line" style="width:140px" value="<%=lm_line%>">
</td>
</tr>
<tr>
<td height="30">管理员信箱：</td>
<td height="30">
<input type="text" name="lm_admin_mail" style="width:140px" value="<%=lm_admin_mail%>">
</td>
</tr>
<tr>
<td height="30">栏目排列序号</td>
<td height="30">
<input type="text" name="lm_xh" style="width:140px" value="<%=lm_xh%>">
</td>
</tr>
<tr>
<td height="30">栏目级别：<%=lm_type%></td>
<td height="30">
<select name="lm_type" style="width:140px">
<option value="0">初级栏目</option>
<% IdSelectBean.setIdName("1");
IdSelectBean.setStrTableName("lanmu");
IdSelectBean.setStrId("1 and lm_del=0 and lm_type=0 and s_jb_id="+s_jb_id+"");
try {
ResultSet result1 = IdSelectBean.getResultSet();
//利用while循环将数据表中的记录列出
while(result1.next()) {
String lm_id_new=result1.getString("lm_id");
String lm_name_new=result1.getString("lm_name");
if (lm_id_new.equals(lm_type)){
out.println("<option value='"+lm_id_new+"' selected>"+lm_name_new+"</option>");}else
{out.println("<option value='"+lm_id_new+"'>"+lm_name_new+"</option>");}
}
}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}
%>
</select>
</td>
</tr>
<tr>
<td height="30">栏目的模板名称：</td>
<td height="30">
<select name="lm_moban_id" style="width:140px">
<%
IdSelectBean.setIdName("jm_del");
IdSelectBean.setStrTableName("jiemian");
IdSelectBean.setStrId("0 and s_jb_id="+s_jb_id+"");
try {
ResultSet result1 = IdSelectBean.getResultSet();
//利用while循环将数据表中的记录列出
while(result1.next()) {
String jm_id_new=result1.getString("jm_id");
String jm_bei=result1.getString("jm_bei");
if (jm_id_new.equals(lm_moban_id)){
out.println("<option value='"+jm_id_new+"' selected>"+jm_bei+"</option>");}else
{out.println("<option value='"+jm_id_new+"'>"+jm_bei+"</option>");}
}
}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}%>
</select>
</td>
</tr>
<tr>
<td height="30">栏目间隔符号：</td>
<td height="30">
<select name="lm_tx" style="width:140px">
<option value="<%=lm_tx%>"><%=lm_tx%></option>
<option value="〗〖">〗〖</option>
<option value="】【">】【</option>
<option value="‖">‖</option>
<option value="|">|</option>
<option value="┃">┃</option>
<option value="│">│</option>
<option value="↓">↓</option>
<option value="↑">↑</option>
</select>
</td>
</tr>
<tr>
<td height="30">窗口打开方式：</td>
<td height="30">
<select name="lm_win" style="width:140px">
<% if (lm_win.equals("_blank")){
out.println("<option value='_blank' selected>新窗口</option>");}else
{out.println("<option value='_self'>本窗口</option>");}
%>
<option value="_blank">新窗口</option>
<option value="_self">本窗口</option>
<option value="_top">最上层框架</option>
</select>
</td>
</tr>
<tr>
<td height="30">栏目的访问权限： </td>
<td height="30">
<select name="lm_vist_power" style="width:140px">
<% if (lm_vist_power.equals("1")){
out.println("<option value='1' selected>公众</option>");}else
{out.println("<option value='0'>用户</option>");}
%>
<option value="1">公众</option>
<option value="0">用户</option>
</select>
</td>
</tr>
<tr>
<td height="30" colspan="2">栏目简介：</td>
</tr>
<tr>
<td height="30" colspan="2">
<textarea name="lm_info" style="width:300px"><%=lm_info%></textarea>
</td>
</tr>
<tr>
<td height="30" colspan="2">
<input type="button" name="Submit" value="按钮" onClick="subb()">
<input type="button" name="Submit3" value="返回" onclick="window.history.back()">
<input type="reset" name="Submit2" value="重置">
</td>
</tr>
<%
}
}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
} DBConBean.closeAll();
%>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -