📄 channelmanage.java
字号:
if(selectcount>1)
{
htmlOut.addString ("您不能选择多于一条的信息进行修改");
}
else
{
if(temp.compareTo ("")!=0)
{
queryString="select channelname,channelid,type,modulename,parent from channel where channelid='"+temp+"'";
rs=DB.executeQuery (queryString);
if(rs!=null){
try{rs.next ();
name = rs.getString(1).trim();
id = rs.getString(2).trim();
type = rs.getString(3).trim();
module = rs.getString(4).trim();
try{
parent = rs.getString(5);
}
catch(Exception er){
parent=null;
}
htmlOut.addString ("<center>请修改频道的信息<br>");
htmlOut.addString ("频道名称*:<INPUT type=text name=txt_name maxlength=25 value='"+name+"'><br>");
htmlOut.addString ("频道代码*:<INPUT type=text name=txt_id maxlength=25 value='"+id+"'><br>");
htmlOut.addString ("频道属性*:<INPUT type=text name=txt_type maxlength=1 value='"+type+"'><br>");
htmlOut.addString ("频道模块*:<INPUT type=text name=txt_module maxlength=20 value='"+module+"'><br>");
if(parent==null)
htmlOut.addString ("parent属性:<INPUT type=text name=txt_parent maxlength=25><br>");
else
htmlOut.addString ("parent属性:<INPUT type=text name=txt_parent maxlength=25 value='"+parent+"'><br>");
htmlOut.addString ("带*号的项不可为空!<br>");
htmlOut.addString ("<INPUT type=hidden name=txt_temp value='"+temp+"'>");
htmlOut.addString ("<input type=submit value=确定 name=modify_accept></center>");
}catch (Exception er){
}
}
}
if(request.getParameter ("modify_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[] aa=name.getBytes("8859_1");
name=new String(aa);
byte[] bb=type.getBytes("8859_1");
type=new String(bb);
byte[] cc=module.getBytes("8859_1");
module=new String(cc);
byte[] dd=id.getBytes("8859_1");
id=new String(dd);
byte[] ee=parent.getBytes("8859_1");
parent=new String(ee);
temp=request.getParameter("txt_temp");
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{rs.next();
nametemp=rs.getString (1).trim ();
idtemp=rs.getString (2).trim ();
}catch(Exception er){
}
}
if(nametemp.compareTo ("")==0&&idtemp.compareTo ("")==0)
{
queryString = "update channel set channelname='"+name+"',channelid='"+id+"',type='"+type+"',modulename='"+module+"',parent='"+parent+"' where channelid='"+temp+"'";
htmlOut.addString ("<center><font size=3>修改成功!</font></center>");
/*}
if(nametemp.compareTo (name)==0&&idtemp.compareTo (id)!=0)
{queryString = "update channel set channelid='"+id+"',type='"+type+"',modulename='"+module+"',parent='"+parent+"' where channelid='"+temp+"'";
htmlOut.addString ("<center><font size=3>频道名无法修改!已有此频道名</font></center>");
}
if(nametemp.compareTo (name)!=0&&idtemp.compareTo (id)==0)
{queryString = "update channel set channelname='"+name+"',type='"+type+"',modulename='"+module+"',parent='"+parent+"' where channelid='"+temp+"'";
htmlOut.addString ("<center><font size=3>频道代码无法修改!已有此频道代码</font></center>");
}
if(nametemp.compareTo (name)==0&&idtemp.compareTo (id)==0)
{queryString = "update channel set type='"+type+"',modulename='"+module+"',parent='"+parent+"' where channelid='"+temp+"'";
htmlOut.addString ("<center><font size=3>频道名和频道代码无法修改!已有此频道名和频道代码</font></center>");
}*/
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>");
}
}
}
}
}
//显示
queryString = "select channelname,channelid,type,modulename,parent from channel";
rs = DB.executeQuery ( queryString );
content= content+"<center>"+"<table border=0 width=750 bgcolor=#000080 cellspacing=0 cellpadding=0><tr><td width=100%>"+"<table border=0 width=100% cellspacing=1 cellpadding=0><tr height=10><td align=center valign=middle width=120 bgcolor=#EEEEEE>选择</td><td align=center valign=middle width=120 bgcolor=#EEEEEE>频道名称</td><td align=center valign=middle width=120 bgcolor=#EEEEEE>频道代码</td><td align=center valign=middle width=120 bgcolor=#EEEEEE>频道属性</td><td align=center valign=middle width=120 bgcolor=#EEEEEE>频道模块</td><td align=center valign=middle width=120 bgcolor=#EEEEEE>parent属性</td></tr></tr>";
i=0;
if(rs!=null){
try{
while(rs.next())
{ i=i+1;
name = rs.getString(1).trim();
id = rs.getString(2).trim();
type = rs.getString(3).trim();
module = rs.getString(4).trim();
try{
parent = rs.getString(5);
}
catch(Exception er){
parent=null;
}
if(i<=j*10&&i>j*10-10)
{
if(parent!=null)
{
content=content+"<tr height=10><td align=center valign=middle bgcolor=#FFFFF8><INPUT type=checkbox name="+i+"checkbox value='"+id+"'>"+"</td><td align=center valign=middle bgcolor=#FFFFF8>"+name+"</td><td align=center valign=middle bgcolor=#FFFFF8>"+id+"</td><td align=center valign=middle bgcolor=#FFFFF8>"+type+"</td><td align=center valign=middle bgcolor=#FFFFF8>"+module+"</td><td align=center valign=middle bgcolor=#FFFFF8>"+parent+"</td></tr>";
}
else
content=content+"<tr height=10><td align=center valign=middle bgcolor=#FFFFF8><INPUT type=checkbox name="+i+"checkbox value='"+id+"'>"+"</td><td align=center valign=middle bgcolor=#FFFFF8>"+name+"</td><td align=center valign=middle bgcolor=#FFFFF8>"+id+"</td><td align=center valign=middle bgcolor=#FFFFF8>"+type+"</td><td align=center valign=middle bgcolor=#FFFFF8>"+module+"</td><td align=center valign=middle bgcolor=#FFFFF8>"+"空"+"</td></tr>";
}
}
}catch (Exception er){
}
}
content=content+"</td></tr></table>";
content=content+"</table><center><input type=submit value=删除 name=delete> ";
content=content+"<input type=submit value=新增 name=add> ";
content=content+"<input type=hidden value="+i+" name=count>";
content=content+"<input type=submit value=更改 name=modify></form>页面选择:第";
if(i%10==0)
{
for(j=1;j<=i/10;j++)
{
content=content+"<a href=ChannelManage?selectpage="+j+">"+" ["+j+"] "+"</a>";
}
}
else
{
for(j=1;j<=i/10+1;j++)
{
content=content+"<a href=ChannelManage?selectpage="+j+">"+" ["+j+"] "+"</a>";
}
}
content=content+"页"+"<br>"+"<a href=/WebManage>返回</a>";
;
DB.close ();
htmlOut.addString (content);
htmlOut.outHtml ();
}
public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
doGet(request,response);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -