fwxxdaoimpl.java

JAVA E拍网上购物业务管理 使用CRM业务流程

package org.ch02zf.dao.daoImpl;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.ch02zf.dao.FWXXDao;
import org.ch02zf.web.form.FwxxForm;

public class FWXXDaoImpl implements FWXXDao {

	@SuppressWarnings("unchecked")
	public int insertFWXX(FwxxForm item) {
		// TODO Auto-generated method stub
		CommonDao cd = new CommonDao();
		cd.setConn(BasicDao.getCon());
		String sql = "insert into TBL_FWXX(uid,jdid,lxid,shi,ting,fwxx,zj,title,date,telephone,lxr) values(?,?,?,?,?,?,?,?,?,?,?)";
	    List list = new ArrayList();
	    list.add(item.getUid());
	    list.add(item.getJdid());
	    list.add(item.getLxid());
	    list.add(item.getShi());
	    list.add(item.getTing());
	    list.add(item.getFwxx());
	    list.add(item.getZj());
	    list.add(item.getTitle());
	    list.add(item.getDate());
	    list.add(item.getTelephone());
	    list.add(item.getLxr());
	    cd.setSqlvalue(sql);
	    cd.setValues(list);
	    int ret = 0;
	    try {
			ret = cd.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	    return ret;
	    
	}

}