package?com.ceshi.lei;

import?java.io.IOException;
import?java.text.SimpleDateFormat;
import?java.util.Date;
import?java.util.Random;
import?java.io.PrintWriter;

import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;
import?java.sql.*;
public?class?all?extends?HttpServlet?{

	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
??????????????doPost（requestresponse）;
	}
	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
	
		????????String?datetime=time.getDate（）;
		????????
		???????
		?????????Random?rom=new?Random（）;
				?int??n=rom.nextInt（）;
				
		String?userid=new?String（request.getParameter（“userid“）.getBytes（“iso8859-1“）“gbk“）;
		String?type=new?String（request.getParameter（“yadress“）.getBytes（“iso8859-1“）“gbk“）;
		String?title=new?String（request.getParameter（“title“）.getBytes（“iso8859-1“）“gbk“）;
		String?oEditor=new?String（request.getParameter（“oEditor“）.getBytes（“iso8859-1“）“gbk“）;
		String?img=new?String（request.getParameter（“bgimg“）.getBytes（“iso8859-1“）“gbk“）;
		?
		Connection?con1=ConnectionFactory.getCon（）;
		Statement?st=null;?
		?ResultSet?r=null;
		?String?sum=null;
		?String?s1=“select?userid?from?ZhuCe?where?email=‘“+type+“‘“;???
		try?{
			?st=con1.createStatement（）;
			??r=st.executeQuery（s1）;
			???if（r.next（））
			???{
				???sum=r.getString（“userid“）;
			???}
			????r.close（）;
			????st.close（）;
			????con1.close（）;
			???
		}?catch?（SQLException?e1）?{
			//?TODO?Auto-generated?catch?block
			e1.printStackTrace（）;
		}
		
		
		?
		
		String?sql=“insert?into?ReceiveLetter（useridsendpobreceivepobtopictextvaluedateletteridbgimage）?values（‘“+sum+“‘‘“+123+“‘‘“+type+“‘‘“+title+“‘‘“+oEditor+“‘‘“+datetime+“‘‘“+n+“‘‘“+img+“‘）“;
		Connection?con=ConnectionFactory.getCon（）;
		Statement?stmt=null;
		
		try?{
			stmt=con.createStatement（）;
	????????stmt.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			
			e.printStackTrace（）;
		}
		try?{
			stmt.close（）;
			con.close（）;
		}?catch?（SQLException?e）?{
			
			e.printStackTrace（）;
		}
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????2293760??2010-06-24?10:17??電子郵件\email.mdf

?????文件?????573440??2010-06-24?10:17??電子郵件\email_log.LDF

?????文件????????410??2010-05-13?15:49??電子郵件\inbox\.classpath

?????文件????????288??2010-06-24?07:50??電子郵件\inbox\.mymetadata

?????文件???????1223??2010-05-16?11:05??電子郵件\inbox\.project

?????文件????????334??2010-05-13?15:45??電子郵件\inbox\.settings\org.eclipse.jdt.core.prefs

?????文件???????2332??2010-06-24?08:48??電子郵件\inbox\src\com\ceshi\lei\all.java

?????文件???????1711??2010-05-20?18:36??電子郵件\inbox\src\com\ceshi\lei\apper.java

?????文件???????1599??2010-05-19?12:01??電子郵件\inbox\src\com\ceshi\lei\back1.java

?????文件???????1806??2010-05-19?12:08??電子郵件\inbox\src\com\ceshi\lei\back2.java

?????文件????????556??2010-05-17?16:39??電子郵件\inbox\src\com\ceshi\lei\ConnectionFactory.java

?????文件????????946??2010-05-19?12:08??電子郵件\inbox\src\com\ceshi\lei\hei.java

?????文件???????1527??2010-05-18?13:14??電子郵件\inbox\src\com\ceshi\lei\inlink.java

?????文件???????1623??2010-05-20?11:30??電子郵件\inbox\src\com\ceshi\lei\jiechu.java

?????文件???????1938??2010-05-20?15:39??電子郵件\inbox\src\com\ceshi\lei\jin.java

?????文件???????1867??2010-06-24?09:33??電子郵件\inbox\src\com\ceshi\lei\no.java

?????文件???????1573??2010-05-21?06:41??電子郵件\inbox\src\com\ceshi\lei\Response.java

?????文件???????1484??2010-05-19?20:42??電子郵件\inbox\src\com\ceshi\lei\server.java

?????文件???????1485??2010-05-19?10:58??電子郵件\inbox\src\com\ceshi\lei\showfrend.java

?????文件???????1126??2010-05-19?12:10??電子郵件\inbox\src\com\ceshi\lei\shuchu.java

?????文件???????1616??2010-05-20?18:35??電子郵件\inbox\src\com\ceshi\lei\tianjia.java

?????文件????????386??2010-06-24?09:07??電子郵件\inbox\src\com\ceshi\lei\time.java

?????文件???????1635??2010-05-17?17:27??電子郵件\inbox\src\com\ceshi\lei\xianshi.java

?????文件???????1448??2010-05-19?12:12??電子郵件\inbox\src\com\ceshi\lei\yanzheng.java

?????文件???????1138??2010-05-16?10:03??電子郵件\inbox\src\com\DB\p1\ConnectionFactory.java

?????文件???????1421??2010-05-18?15:42??電子郵件\inbox\src\com\inbox\p1\Delete.java

?????文件???????4635??2010-05-19?15:08??電子郵件\inbox\src\com\inbox\p1\Function.java

?????文件???????1396??2010-05-17?18:03??電子郵件\inbox\src\com\inbox\p1\GetCount.java

?????文件???????4242??2010-05-17?17:23??電子郵件\inbox\src\com\inbox\p1\GetDate.java

?????文件???????2475??2010-05-19?13:51??電子郵件\inbox\src\com\inbox\p1\ReceiveLetter.java

............此處省略254個文件信息