mylayoutsave.java

JAVA邮件系统

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

/**
 * 
 *
 * @author Zhu Ke Jun
 */

public class MyLayoutSave extends HttpServlet {

     public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
      
		HtmlOut htmlOut = new HtmlOut (response);
		String queryString,zai,kuan;
		int start=0,i=0,posi,j,p,zaicount,kuancount;
		String selectvalue,username; 
		Person person = new Person();
		person.setName (CommonMethods.GetUserName(request));
		username=person.username;
		Enumeration e;
		e = request.getParameterNames();
		selectvalue=request.getParameter("selectValue");
		p=Integer.valueOf(request.getParameter ("p")).intValue ();
		//获取用户改变后的zai串,kuan串信息
		posi=selectvalue.indexOf ("*",0);
		zai=selectvalue.substring (0,posi);
		posi=posi+1;
		kuan=selectvalue.substring (posi,selectvalue.length ());
		//zai串的信息存入数组zaichannel
		String zaichannel[];
		zaichannel=new String[100];
		while(true)
		{
		
			posi =zai.indexOf(",",start);
			
			if(posi==-1)
				break;
			zaichannel[i]=zai.substring (start,posi);
			
			start=start+zaichannel[i].length()+1 ;
			i=i+1;
		}
			zaicount=i;
		//kuan串的信息存入数组kuanchannel
		start=0;
		String kuanchannel[];
		kuanchannel=new String[100];
		while(true)
		{
		
			posi =kuan.indexOf(",",start);
			
			if(posi==-1)
				break;
			kuanchannel[i]=kuan.substring (start,posi);
			
			start=start+kuanchannel[i].length()+1 ;
			i=i+1;
		}
		kuancount=i;
		
		
			DBOperater DB = new DBOperater ("userchannel");
						
			//更新窄频道的orderid
			for(i=0;i<zaicount;i++)
			{
				
				j=i+1;
				queryString ="update userchannel set orderid="+j+" where username='"+CommonMethods.DealWithSQLParameter(username)+"' and channelid='"+CommonMethods.DealWithSQLParameter(zaichannel[i])+"'";				
				DB.executeUpdate(queryString);
				
			}
			//更新宽频道的orderid
			for(i=0;i<kuancount;i++)
			{
				
				j=i+1;
				queryString ="update userchannel set orderid="+j+" where username='"+CommonMethods.DealWithSQLParameter(username)+"' and channelid='"+CommonMethods.DealWithSQLParameter(kuanchannel[i])+"'";				
				DB.executeUpdate(queryString);
				
			}
			DB.close ();
				
		htmlOut.setRedirect("Login?p="+p);
		htmlOut.outHtml ();
		
		
	
	}
	 public void doPost(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
		 doGet(request,response);
	}
    
}