edittaketicketaddressutil.java

主要是航空预订系统

/**
 * 
 */
package com.air.backend.util;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Map;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.air.exceptions.AirException;
import com.air.form.AddressForm;
import com.air.model.Address;
import com.air.model.LoginUser;
import com.air.persistence.DataSrcUtil;
import com.air.persistence.IsqlDataSource;
import com.air.util.ValHelper;

/**
 * @author jelly_yang
 *
 */
public class EditTakeTicketAddressUtil {
	private static Log log = LogFactory.getLog(RetrieveUsersUtil.class);
	private EditTakeTicketAddressUtil() {
		// TODO Auto-generated constructor stub
	}

	public static class EditTakeTicketAddressUtilHolder{
		static EditTakeTicketAddressUtil editTakeTicketAddressUtil = new EditTakeTicketAddressUtil();
	}
	
	public static EditTakeTicketAddressUtil getInstance(){
		return EditTakeTicketAddressUtilHolder.editTakeTicketAddressUtil;
	}
	
	public boolean editTakeTicketAddress(String aid, String addre)throws AirException{
		int result = 0 ;
		String sSql = "update take_ticket_self_address set detail='"+addre+"' where ttsaid="+Integer.parseInt(aid);
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		log.debug("retrieveFight() -- sSql["+ sSql+ "]");
		try
		{
			conn = src.getConnection();
			Statement stmt = conn.createStatement();
			result = src.executeUpdate(stmt, sSql);
		}
		catch(SQLException se)
		{
			log.error("deleteUser() caught SQLException: " + se);
		}
		catch(Exception ex)
		{
			log.error("deleteUser() caught Exception: " + ex);
		}
		finally
		{
			src.closeConn(conn);
		}
		if(result==0){
			return false;
		}
		return true;
	}
	
	public Address getAddressById(String aid)throws AirException{
		Address address = new Address();
		Map<String, String> result = new HashMap<String, String>();
		String sSql = "select * from take_ticket_self_address where ttsaid="+Integer.parseInt(aid);
		   
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		try
		{
			conn = src.getConnection();
			result = src.retrieveSingleRow(conn, sSql);
		}
		catch(SQLException se)
		{
			se.printStackTrace();
			log.error("searchUserByUserName() caught SQLException: " + se);
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
			log.error("searchUserByUserName() caught Exception: " + ex);
		}
		finally
		{
			src.closeConn(conn);
		}
		if(!result.isEmpty())
		{
			String id = ValHelper.getInstance().getValue(result, "ttsaid");
			String city = ValHelper.getInstance().getValue(result, "city");
			String detail = ValHelper.getInstance().getValue(result, "detail");
			address.setId(id);
			address.setCity(city);
			address.setAddress(detail);
		}
		return address;
	}
}