📄 channelmanage.java
字号:
/*
*
*/
import java.io.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import java.util .Date ;
import javax.servlet.http.*;
import java.sql.*;
/**
*
*
* @author Zhu Ke Jun
*/
public class ChannelManage extends HttpServlet {
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
HtmlOut htmlOut = new HtmlOut (response);
Person p=new Person();
p.setName (CommonMethods.GetUserName(request));
String pass = CommonMethods.GetUserPass (request);
if( p.getName ()==null || (!p.checkPassword(pass))
||!p.IsSuperMan () )
{
htmlOut.setErrorID (htmlOut.SHOW_SIMPLE_MESSAGE ,"",
"请先登录！","/manage/");
htmlOut.outHtml();
return;
}
String queryString;
ResultSet rs;
String name,id,type,module,parent,nametemp="",idtemp="";
String content,temp;
temp="";
parent="";
content="";
int i,count,selectcount,j,orderid=1;
j=1;
selectcount=0;
i=0;
Enumeration e;
e = request.getParameterNames();
DBOperater DB = new DBOperater ("userchannel");
if(request.getParameter("selectpage")!=null)
{
try{
j=Integer.valueOf(request.getParameter("selectpage")).intValue();
}catch(Exception er){
j=1;}
}
htmlOut.addString ("<head>");
htmlOut.addString ("<style TYPE=text/css>");
htmlOut.addString ("a { color: #FF4040; text-decoration: none; vlink: maroon; alink: red }");
htmlOut.addString ("a:hover { color: #FF0000; background-color: #FFFFEF; text-decoration:underline }");
htmlOut.addString ("body,td { font-size: 9pt }");
htmlOut.addString ("</style>");
htmlOut.addString ("<base href="+CommonMethods.sHostNameCGI+">");
htmlOut.addString ("<link rel=\"stylesheet\" href=\"/img/style.css\">");
htmlOut.addString ("</head>");
htmlOut.addString ("<center><h1>频道管理</h1></center>");
htmlOut.addString ("<form method=get action=ChannelManage name=ChannelManage>");
//删除
if (request.getParameter("delete")!=null)
{
count=Integer.valueOf(request.getParameter("count")).intValue();
for(i=1;i<count+1;i++)
{
if(request.getParameter(i+"checkbox")!=null)
{
temp=request.getParameter(i+"checkbox");
byte[] gg=temp.getBytes("8859_1");
temp=new String(gg);
queryString = "delete from channel where channelid='"+ temp +"'";
DB.executeUpdate (queryString);
}
}
}
//新增
if (request.getParameter("add")!=null||request.getParameter ("add_accept")!=null)
{
htmlOut.addString ("<center>请输入新频道的信息<br>");
htmlOut.addString ("频道名称*:<INPUT type=text name=txt_name maxlength=25><br>");
htmlOut.addString ("频道代码*:<INPUT type=text name=txt_id maxlength=25><br>");
htmlOut.addString ("频道属性*:<INPUT type=text name=txt_type maxlength=1><br>");
htmlOut.addString ("频道模块*:<INPUT type=text name=txt_module maxlength=20><br>");
htmlOut.addString ("parent属性:<INPUT type=text name=txt_parent maxlength=25><br>");
htmlOut.addString ("带*号的项不可为空!<br>");
htmlOut.addString ("<input type=submit value=确定 name=add_accept></center>");
if(request.getParameter ("add_accept")!=null)
{
name = request.getParameter("txt_name");
id=request.getParameter("txt_id");
type = request.getParameter("txt_type");
module =request.getParameter("txt_module");
parent =request.getParameter("txt_parent");
byte[] a=name.getBytes("8859_1");
name=new String(a);
byte[] b=type.getBytes("8859_1");
type=new String(b);
byte[] c=module.getBytes("8859_1");
module=new String(c);
byte[] d=id.getBytes("8859_1");
id=new String(d);
byte[] ff=parent.getBytes("8859_1");
parent=new String(ff);
if(name.compareTo ("")!=0&&type.compareTo ("")!=0&&module.compareTo ("")!=0&&id.compareTo ("")!=0)
{
if(name.indexOf ("'",0)==-1&&type.indexOf ("'",0)==-1&&module.indexOf ("'",0)==-1&&id.indexOf ("'",0)==-1&&parent.indexOf ("'",0)==-1)
{
queryString="select channelname,channelid from channel where channelname='"+name+"' or channelid='"+id+"'";
rs=DB.executeQuery (queryString);
if(rs!=null)
{
try{
if(rs.next())
{
nametemp=rs.getString (1).trim ();
idtemp=rs.getString (2).trim ();
}
}catch(Exception er){
}
}
if(nametemp.compareTo("")==0&&idtemp.compareTo ("")==0)
{
queryString = "insert into channel(channelname,channelid,type,modulename,parent) values ('"+name+"','"+id+"','"+type+"','"+module+"','"+parent+"')";
DB.executeUpdate(queryString);
queryString="select max(orderid) from userchannel";
rs=DB.executeQuery (queryString);
if(rs!=null)
{
try{rs.next ();
orderid=rs.getInt (1)+1;
}catch (Exception er){
}
}
queryString="update userchannel set orderid="+orderid+",type='"+type+"' where channelid='"+id+"'";
DB.executeUpdate (queryString);
}
else
htmlOut.addString ("<center><font size=5>数据库中已有该条纪录!</font></center>");
}
else
htmlOut.addString ("<center><font size=5>所有项输入不能有单引号!</font></center>");
}
else
htmlOut.addString ("<center><font size=5>带*号的项输入不能为空!</font></center>");
}
}
//修改
if (request.getParameter ("modify")!=null||request.getParameter ("modify_accept")!=null)
{
count=Integer.valueOf(request.getParameter("count")).intValue();
for(i=1;i<count+1;i++)
{
if(request.getParameter(i+"checkbox")!=null)
{
if(selectcount==0)
{
temp=request.getParameter(i+"checkbox");
byte[] mm=temp.getBytes("8859_1");
temp=new String(mm);
}
selectcount=selectcount+1;
}
}
if(selectcount==0&&request.getParameter ("modify_accept")==null)
{
htmlOut.addString ("请选择选择一条信息进行修改");
}
else
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -