pmanagedaoimpl.java

来自「Struts+iBatis做的增删改查功能。开发工具：MyEclipse+MyS」· Java 代码 · 共 91 行

package com.crm.common.dao.impl;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.crm.common.dao.PManageDAO;
import com.crm.common.vo.form.PManageForm;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class PManageDAOImpl implements PManageDAO {
	private static SqlMapClient sqlMapper;

	public PManageDAOImpl() {
		try {
			Reader reader = Resources
					.getResourceAsReader("com/crm/common/dao/iBatis/SqlMapConfig.xml");
			sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
			reader.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	// 增加操作
	public boolean insert(PManageForm pm) {
		try {
			sqlMapper.insert("insertpManage", pm);
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return false;
	}

	// 修改操作
	public boolean update(PManageForm pm) {
		try {
			System.out.println(pm.getCatalog());
			sqlMapper.update("updatePManage",pm);
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return false;
	}

	// 删除操作
	public boolean delete(PManageForm pm) {
		try {
			sqlMapper.delete("deleteId", pm);
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return false;
	}

	// 查询单个内容
	public PManageForm queryId(PManageForm pm) {
		PManageForm pmf = new PManageForm();
		try {
			pmf = (PManageForm) sqlMapper.queryForObject("selectId",pm);	
			return pmf;
		} catch (SQLException e) {
			e.printStackTrace();
			return pmf;
		}
	}

//	 按名称查询全部
	public List queryAllTitle() {
		List list = new ArrayList();
		try {
			list = sqlMapper.queryForList("selectAllTitle");
			return list;
		} catch (SQLException e) {
			e.printStackTrace();
			return list;
		}
	}

	// 模糊查询
	public List queryByLike(String title) throws Exception {
		return null;
	}
}