?? editfightutil.java
字號:
/**
*
*/
package com.air.backend.util;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import com.air.exceptions.AirException;
import com.air.form.FightForm;
import com.air.persistence.DataSrcUtil;
import com.air.persistence.IsqlDataSource;
/**
* @author jelly_yang
*
*/
public class EditFightUtil {
private static Log log = LogFactory.getLog(EditFightUtil.class);
private EditFightUtil() {
// TODO Auto-generated constructor stub
}
public static class EditFightUtilHolder{
static EditFightUtil editFightUtil = new EditFightUtil();
}
public static EditFightUtil getInstance(){
return EditFightUtilHolder.editFightUtil;
}
public boolean editFight(FightForm fightForm)throws AirException{
int result = 0 ;
String sSql = "update fights set fight_name='"+fightForm.getFightName()+"',fight_no='"+fightForm.getFightNo()+
"',leave_city='"+fightForm.getLeaveCity()+"',arrive_city='"+fightForm.getArriveCity()+
"',leave_time='"+fightForm.getLeaveTime()+"',arrive_time='"+fightForm.getArriveTime()+
"',price="+Double.parseDouble(fightForm.getPrice())+",fuel_rate="+Double.parseDouble(fightForm.getFuelRate())+
",build_rate="+Double.parseDouble(fightForm.getBuildRate())+",leave_date='"+fightForm.getLeaveDate()+
"',special_num="+Integer.parseInt(fightForm.getSpecialNum())+",economic_num="+Integer.parseInt(fightForm.getEconomicNum())+
",business_num="+Integer.parseInt(fightForm.getBusinessNum())+",head_num="+Integer.parseInt(fightForm.getHeadNum())+
" where fid="+fightForm.getFightId();
IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
Connection conn = null;
log.debug("editFight() -- sSql["+ sSql+ "]");
try
{
conn = src.getConnection();
Statement stmt = conn.createStatement();
result = src.executeUpdate(stmt, sSql);
}
catch(SQLException se)
{
log.error("editFight() caught SQLException: " + se);
}
catch(Exception ex)
{
log.error("editFight() caught Exception: " + ex);
}
finally
{
src.closeConn(conn);
}
if(result==0){
return false;
}
return true;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -