?? addlist.jsp
字號(hào):
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<% request.setCharacterEncoding("gb2312"); %>
<%@ page import="beans.Condb"%>
<%@ page import="beans.Strto" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.util.*"%>
<% Strto strto=new Strto();
Condb con=new Condb();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>目錄添加</title>
</head>
<link rel="stylesheet" href="../../Css/style.css">
<script language="javascript">
function check(){
var types=list.grade.value;
if(types=="二級(jí)目錄"){
list.father.disabled=false;
}
else{
list.father.disabled=true;
}
}
function back(url){
window.location.href="url";
opener.location.reload();
}
</script>
<body topmargin="0" leftmargin="0">
<p> </p>
<table width="558" height="110" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#bdcbd6">
<tr>
<td width="567" height="26" valign="bottom" background="../../Image/skintop2.gif"><div align="center"><font style="color:#FFFFFF; font-size:13px; ">視 頻 目 錄 名 稱 添 加</font> </div></td>
</tr>
<tr>
<td><table width="559" height="94" align="center" cellpadding="0" cellspacing="0" bordercolor="#9caab5">
<tr>
<td height="92"><table width="404" height="90" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#216184" class="wenbenkuang">
<tr>
<td width="402" valign="top"><table width="400" border="0" align="center" cellpadding="0" cellspacing="0">
<form name="list" method="post" action="">
<tr>
<td height="15" colspan="2"> </td>
</tr>
<tr>
<td width="150" height="40" background="../../Image/Audio/ListName.gif"><div align="right"></div> <div align="left"></div></td>
<td width="250" height="40"><input name="names" type="text" class="wenbenkuang3" id="name"></td>
</tr>
<tr>
<td height="40" background="../../Image/Audio/Grade.gif"> </td>
<td height="40"><select name="grade" class="wenbenkuangselect" OnChange="check()">
<option value="一級(jí)目錄" selected>一級(jí)目錄</option>
<option value="二級(jí)目錄">二級(jí)目錄</option>
</select></td>
</tr>
<tr>
<td height="40" background="../../Image/Audio/Father.gif"> </td>
<td height="40">
<select name="father" class="wenbenkuangselect" disabled>
<%
String sqladdlist="select * from tb_AudioList where Grade='一級(jí)目錄'";
ResultSet rsaddlist=con.executeQuery(sqladdlist);
while(rsaddlist.next())
{
%>
<option value="<%=rsaddlist.getString("Name")%>"><%=rsaddlist.getString("Name")%></option>
<% }
rsaddlist.close();
%>
</select></td>
</tr>
<tr>
<td height="30" colspan="2"><div align="center">
<input name="Submit" type="submit" class="go-wenbenkuang1" value=" 添 加 ">
<input name="Submit" type="button" class="go-wenbenkuang1" value=" 返 回 " onclick="javascript:window.location.href='../Manager.jsp?action=AudioList'">
</div></td>
</tr> </form>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<%
String sqladd="select * from tb_AudioList where Name='"+request.getParameter("names")+"'";
ResultSet rsadd=con.executeQuery(sqladd);
String father="";
if(rsadd.next()){
%>
<script language="javascript">
alert("相同名稱目錄已經(jīng)存在,請(qǐng)更換名稱!");
</script>
<%
}
else{
if(request.getParameter("father")==null){
father=request.getParameter("names");
}
else{
father=request.getParameter("father");
}
java.util.Date date=new java.util.Date();
String sqlin="insert into tb_AudioList Values('','"+request.getParameter("grade")+"','"+request.getParameter("names")+"','"+father+"','"+(String)session.getAttribute("check")+"','"+date.toLocaleString()+"')";
String names=strto.toChinese(request.getParameter("names"));
if(request.getParameter("grade")!=null&&names!=null){
int rsin=con.excuteUpdate(sqlin);
if(rsin>0){
%> <script language="javascript">
alert("添加成功!");
</script>
<% }
}
}
%>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -