ColorLifeService.java

package com.sp2p.service.admin;

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

import com.shove.base.BaseService;
import com.shove.data.dao.MySQL;
import com.sp2p.dao.ColorLifeDao;

public class ColorLifeService extends BaseService {
	
	private ColorLifeDao colorLifeDao;

	public List<String> importInfo(List<Map<String, String>> paramList)
			throws SQLException {
		Connection conn = null;
		List<String> errorList = new ArrayList<String>();
		Long result = -1L;
		Map<String, String> paramMap;
		try {
			conn = MySQL.getConnection();
			for (int i = 0; i < paramList.size(); i++) {
				paramMap = paramList.get(i);
				Long id = colorLifeDao.addColorLife(conn, paramMap);
				if (id <= 0) {
					result = -1L;
					errorList.add("第" + (i + 2) + "行插入失败!");
				}
				result = 1L;
			}
			if (result > 0) {
				conn.commit();
			}
		} catch (SQLException e) {
			errorList.add("导入失败!");
			conn.rollback();
			e.printStackTrace();
		} finally {
			if (conn != null)
				conn.close();
		}
		return errorList;
	}

	public void setColorLifeDao(ColorLifeDao colorLifeDao) {
		this.colorLifeDao = colorLifeDao;
	}

}