/*
?*?Generated?by?MyEclipse?Struts
?*?Template?path:?templates/java/JavaClass.vtl
?*/
package?com.trade.action;


import?java.util.Calendar;

import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;
import?org.apache.struts.action.Action;
import?org.apache.struts.action.ActionForm;
import?org.apache.struts.action.ActionForward;
import?org.apache.struts.action.ActionMapping;

import?com.trade.bean.*;
import?com.trade.db.DB;
import?com.trade.form.BuyInfoForm;

/**?
?*?MyEclipse?Struts
?*?Creation?date:?12-10-2007
?*?
?*?XDoclet?definition:
?*?@struts.action?path=“/buyInfo“?name=“buyInfoForm“?scope=“request“?validate=“true“
?*/
public?class?BuyInfoAction?extends?Action?{
	/*
	?*?Generated?Methods
	?*/

	/**?
	?*?Method?execute
	?*?@param?mapping
	?*?@param?form
	?*?@param?request
	?*?@param?response
	?*?@return?ActionForward
	?*/
	public?ActionForward?execute（ActionMapping?mapping?ActionForm?form
			HttpServletRequest?request?HttpServletResponse?response）?throws?Exception?{
		BuyInfoForm?buyInfo?=?（BuyInfoForm）?form;//?TODO?Auto-generated?method?stub
		
		String?putName?=?CodeToString.codeToString（buyInfo.getPutName（））;?//發布人的姓名
		String?putPhone?=?CodeToString.codeToString（buyInfo.getPutPhone（））;?//發布人的聯系方式
		String?commName?=?CodeToString.codeToString（buyInfo.getCommName（））;?//商品名稱
		String?commText?=?CodeToString.codeToString（buyInfo.getCommText（））;?//商品描述
		String?commNum?=?buyInfo.getNumber（）;?//商品數量
		String?isTwo?=?buyInfo.getIsTwo（）;?//商品是否二手
		String?price?=?buyInfo.getPrice（）;?//商品價格
		
		/**?用戶有可能傳過來的是空值，故做如下處理*/
		if?（commNum?==?null?||?““.equals（commNum））?{
			commNum?=?“1“;?????????????????????????????//默任商品數量為1
		}
		if?（isTwo?==?null?||?““.equals（isTwo））?{
			isTwo?=?“0“;???????????????????????????????//“0“代表商品為全新的
		}
		if?（price?==?null?||?““.equals（price））?{
			price?=?“0“;???????????????????????????????//“0“代表價格面議??
		}
		
		Calendar?currentCalendars=?Calendar.getInstance（）;
	??????int?years=?currentCalendars.get（Calendar.YEAR）;//年
	??????int?months=?currentCalendars.get（Calendar.MONTH）+1;//月
	??????int?days=?currentCalendars.get（Calendar.DAY_OF_MONTH）;//日
	????String?time?=?String.valueOf（years）?+?“-“?+?String.valueOf（months）?+?“-“?+?String.valueOf（days）;??//?獲取系統當前時間
		
	????buyInfo.setCommName（““）;
	????buyInfo.setCommText（““）;
	????buyInfo.setPutName（““）;
	????buyInfo.setPutPhone（““）;
	????buyInfo.setPrice（““）;
	????buyInfo.setNumber（““）;
	????
		DB?db?=?new?DB（）;
		java.sql.ResultSet?rs_id?=?db.query（“select?max（id）+1?from?comm_info?group?by?id“）;?//數據表中最大的id+1
		if?（rs_id.next（））?{?
			rs_id.last（）;
			int?id?=?rs_id.getInt（1）;
			String?sql?=?“insert?into?comm_info（idput_timeput_nametelcomm_namecomm_textnumberis_twopriceis_sale）?values（“+id;
			???sql?+=?“‘“?+?time?+?“‘‘“?+?putName?+“‘‘“?+?putPhone?+?“‘‘“?+?commName?+?“‘‘“?+?commText;
			???sql?+=?“‘“+?commNum?+?““?+?isTwo?+?““?+?price

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-07-07?00:39??校園小商品交易系統\
?????目錄???????????0??2015-07-07?00:43??校園小商品交易系統\bibigou\
?????文件????????2151??2015-06-24?23:38??校園小商品交易系統\bibigou\.classpath
?????目錄???????????0??2015-07-07?00:46??校園小商品交易系統\bibigou\.myeclipse\
?????文件?????????288??2007-12-12?12:38??校園小商品交易系統\bibigou\.mymetadata
?????文件?????????362??2007-10-26?22:13??校園小商品交易系統\bibigou\.mystrutsdata
?????文件????????2087??2015-07-07?00:42??校園小商品交易系統\bibigou\.project
?????目錄???????????0??2015-07-07?00:39??校園小商品交易系統\bibigou\.settings\
?????文件?????????522??2015-06-24?23:38??校園小商品交易系統\bibigou\.settings\.jsdtscope
?????文件?????????390??2015-06-24?23:38??校園小商品交易系統\bibigou\.settings\com.genuitec.eclipse.migration.prefs
?????文件?????????364??2015-06-24?23:38??校園小商品交易系統\bibigou\.settings\org.eclipse.jdt.core.prefs
?????文件?????????623??2015-07-07?00:42??校園小商品交易系統\bibigou\.settings\org.eclipse.wst.common.component
?????文件?????????411??2015-06-24?23:38??校園小商品交易系統\bibigou\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2015-06-24?23:38??校園小商品交易系統\bibigou\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-06-24?23:38??校園小商品交易系統\bibigou\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2015-07-07?00:44??校園小商品交易系統\bibigou\WebRoot\
?????目錄???????????0??2015-07-07?00:39??校園小商品交易系統\bibigou\WebRoot\Flash\
?????文件??????241152??2007-12-12?12:09??校園小商品交易系統\bibigou\WebRoot\Flash\navi04.fla
?????文件???????28136??2007-12-13?16:57??校園小商品交易系統\bibigou\WebRoot\Flash\navi04.swf
?????目錄???????????0??2015-07-07?00:39??校園小商品交易系統\bibigou\WebRoot\meta-INF\
?????文件??????????39??2007-10-26?21:15??校園小商品交易系統\bibigou\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2015-07-07?00:39??校園小商品交易系統\bibigou\WebRoot\WEB-INF\
?????文件????????3408??2007-12-12?22:47??校園小商品交易系統\bibigou\WebRoot\WEB-INF\.struts-config.mex
?????目錄???????????0??2015-07-07?00:42??校園小商品交易系統\bibigou\WebRoot\WEB-INF\classes\
?????目錄???????????0??2015-07-07?00:42??校園小商品交易系統\bibigou\WebRoot\WEB-INF\classes\meta-INF\
?????文件??????????25??2015-06-24?23:38??校園小商品交易系統\bibigou\WebRoot\WEB-INF\classes\meta-INF\MANIFEST.MF
?????目錄???????????0??2015-07-07?00:42??校園小商品交易系統\bibigou\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2015-07-07?00:42??校園小商品交易系統\bibigou\WebRoot\WEB-INF\classes\com\trade\
?????文件??????????75??2007-11-26?19:36??校園小商品交易系統\bibigou\WebRoot\WEB-INF\classes\com\trade\ApplicationResources.properties
?????目錄???????????0??2015-07-07?00:42??校園小商品交易系統\bibigou\WebRoot\WEB-INF\classes\com\trade\action\
?????文件????????3855??2015-07-07?00:42??校園小商品交易系統\bibigou\WebRoot\WEB-INF\classes\com\trade\action\BuyInfoAction.class
............此處省略263個文件信息