simpleexample.java

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

package com.domain;

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

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

/**
 * This is not a best practices class. It's just an example to give you an idea
 * of how iBATIS works. For a more complete example, see JPetStore 5.0 at
 * http://www.ibatis.com.
 */
public class SimpleExample {

	/**
	 * SqlMapClient instances are thread safe, so you only need one. In this
	 * case, we'll use a static singleton. So sue me. ;-)
	 */
	private static SqlMapClient sqlMapper;

	/**
	 * It's not a good idea to put code that can fail in a class initializer,
	 * but for sake of argument, here's how you configure an SQL Map.
	 */
	static {
		try {
			Reader reader = Resources
					.getResourceAsReader("com/domain/SqlMapConfig.xml");
			sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
			reader.close();
		} catch (IOException e) {
			// Fail fast.
			throw new RuntimeException(
					"Something bad happened while building the SqlMapClient instance."
							+ e, e);
		}
	}

	public static List selectAllAccounts() throws SQLException {
		List list = sqlMapper.queryForList("selectAllAccounts");
		return list;
	}

	public static PManageForm selectAllTitle(String title) throws SQLException {
		return (PManageForm) sqlMapper.queryForObject("selectAccountById", title);
	}

	public static void insertAccount(PManageForm pmf) throws SQLException {
		sqlMapper.insert("insertAccount", pmf);
	}

	public static void updateAccount(PManageForm pmf) throws SQLException {
		sqlMapper.update("updateAccount", pmf);
	}

	public static void deleteAccount(String title) throws SQLException {
		sqlMapper.delete("deleteAccountById", title);
	}

}