?? adddestineutil.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.DestineForm;
import com.air.model.Passenger;
import com.air.persistence.DataSrcUtil;
import com.air.persistence.IsqlDataSource;
/**
* @author jelly_yang
*
*/
public class AddDestineUtil {
private static Log log = LogFactory.getLog(QueryFightUtil.class);
private AddDestineUtil() {
// TODO Auto-generated constructor stub
}
public static class AddDestineUtilHolder{
static AddDestineUtil addDestineUtil = new AddDestineUtil();
}
public static AddDestineUtil getInstance(){
return AddDestineUtilHolder.addDestineUtil;
}
public String addDestine(DestineForm destineForm)throws AirException{
int result = 0;
String sSql = "insert into destine(fid,adult_num,child_num,baby_num,contact_person,contact_phone," +
"insurance_price,insurance_num,distribute_style,pay_style,send_address,post_address," +
"take_self_address,send_date,send_time,post,status) " +
" values("+destineForm.getFightId()+",'"+destineForm.getAdultNum()+"','"+
destineForm.getChildNum()+"','"+destineForm.getBabyNum()+"','"+destineForm.getContactPerson()+"','"+
destineForm.getContactPhone()+"',"+Double.parseDouble(destineForm.getInsurancePrice())+","+Double.parseDouble(destineForm.getInsuranceNum())+",'"+
destineForm.getDistributeStyle()+"','"+destineForm.getPayStyle()+"','"+
destineForm.getSendAddress()+"','"+destineForm.getPostAddress()+"','"+
destineForm.getTakeSelfAddress()+"','"+destineForm.getSendDate()+"','"+destineForm.getSendTime()+"','"+destineForm.getPost()+"','正在處理中')";
IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
Connection conn = null;
log.debug("addDestine() -- sSql["+ sSql+ "]");
try
{
conn = src.getConnection();
Statement stmt = conn.createStatement();
result = src.executeUpdate(stmt, sSql);
}
catch(SQLException se)
{
log.error("addDestine() caught SQLException: " + se);
}
catch(Exception ex)
{
log.error("addDestine() caught Exception: " + ex);
}
finally
{
src.closeConn(conn);
}
if(result==0){
return "0";
}
return destineForm.getFightId();
}
public boolean addPassengers(Passenger passenger)throws AirException{
int result = 0;
String sSql = "insert into passenger(name,credentials,number,fid,born_date) " +
" values('"+passenger.getName()+"','"+passenger.getCredentials()+"','"+
passenger.getNumber()+"',"+passenger.getFightId()+",'"+passenger.getBornDate()+"')";
IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
Connection conn = null;
log.debug("addDestine() -- sSql["+ sSql+ "]");
try
{
conn = src.getConnection();
Statement stmt = conn.createStatement();
result = src.executeUpdate(stmt, sSql);
}
catch(SQLException se)
{
log.error("addDestine() caught SQLException: " + se);
}
catch(Exception ex)
{
log.error("addDestine() caught Exception: " + ex);
}
finally
{
src.closeConn(conn);
}
if(result==0){
return false;
}
return true;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -