newsreturn.java

JAVA邮件系统

/* 
 *
 */

import java.io.*;
import java.text.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 * 
 *
 * @author Chen Xin Wu
 */

public class NewsReturn extends HttpServlet {


    public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
		HtmlOut htmlOut = new HtmlOut (response);

		// 得到名字和口令
		String name,pass;

		Person person = new Person();
		person.setName (CommonMethods.GetUserName(request));
		pass = CommonMethods.GetUserPass (request);
        if (pass ==null)
			pass="";
		else
			pass=pass.trim();
		if( person.getName ()==null || (!person.checkPassword(pass)) )
		{
			htmlOut.setErrorID (htmlOut.USER_NEED_LOGIN,
								"","用户不存在或用户密码错误","Login?action=reLog");
			htmlOut.outHtml ();
			return;
		}
		name= person.getName ().trim();
	   
		int i=0 ,length=0;
		String sChannelName= new String ();
		sChannelName= request.getParameter ("channelname");
		if ((sChannelName==null)||(sChannelName.trim ().length ()<1))
		{
			htmlOut.setErrorID (htmlOut.SHOW_SIMPLE_MESSAGE ,
								"","请选择要编辑的新闻频道","Login");
			htmlOut.outHtml ();
			return;
		}
		sChannelName=sChannelName.trim ();
		
		//取得相关参数插入ps_news表中
		DBOperater DB = new DBOperater ("ps_news");
		DB.executeUpdate ("delete from ps_news where username='"+name+"' and channelname='"+sChannelName+"'");
		if ((request.getParameter ("col") != null)&&(request.getParameter ("col").trim().length ()>0))
		{
			length = request.getParameterValues ("col").length ;
			String[] result =  new String [length];
			result = request.getParameterValues ("col");
			String sLength=new String ();
			String sOrd=new String ();
			String sCateId=new String ();
			for (int j=0;j<length;j++)
			{
				sLength=request.getParameter ("length"+result[j]);
				if ((sLength==null)||(sLength.trim ().length ()<1))
					sLength="0";
				if ((sLength.trim ().compareTo ("请选择")==0)||((sLength.trim ().compareTo ("0")==0)))
					sLength="5";
				sOrd=request.getParameter ("ord"+result[j]);
				if ((sOrd==null)||(sOrd.trim ().length ()<1))
					sOrd="1000";
				if ((sOrd.trim ().compareTo ("请选择")==0)||((sOrd.trim ().compareTo ("0")==0)))
					sOrd="1000";
				sCateId=request.getParameter ("cateid"+result[j]);
				if ((sCateId==null)||(sCateId.trim ().length ()!=8))
				{
					return;
				
				}
				DB.executeUpdate ( " INSERT INTO ps_news ( username, cateid,length,ord,   channelname )  VALUES ( '"+
								   name+"', '"+sCateId+"',    '"+sLength+"',    '"+sOrd+"',    '"+sChannelName+ "') ");
			}
		}
		DB.close ();
		//重定向到Login界面
		response.sendRedirect ("Login?channel="+sChannelName);
	}
    public void doPost(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
		doGet(request,response);
	}
}