pmanagetestcase.java

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

package com.domain;

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

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;

import junit.framework.TestCase;

public class PManageTestCase extends TestCase {
	private static SqlMapClient sqlMapper;

	public void setUp() throws Exception {
		try {
			Reader reader = Resources
					.getResourceAsReader("com/domain/SqlMapConfig.xml");
			sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
			reader.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	public void Insert() {
		PManageForm pm = new PManageForm();
		pm.setTitle("a");
		pm.setNewProduct("b");
		pm.setCatalog("c");
		pm.setCatalogTitle("d");
		pm.setCatalogId("e");
		pm.setKind("f");
		pm.setKindId("g");
		pm.setProductTitle("h");
		pm.setSupplyTrader("i");
		pm.setModel("j");
		pm.setProductCP("k");
		try {
			sqlMapper.insert("insertPManage", pm);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void Query() {
		try {
			List list = sqlMapper.queryForList("selectAll");
			System.out.println(list);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void View() {
		try {
			PManageForm form = (PManageForm) sqlMapper.queryForObject(
					"selectAllTitle", "tommytommy");
			System.out.println(form.getTitle());
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void Delete() {
		try {
			sqlMapper.delete("deleteTitle", "tommytommy");
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void Update() {
		SimpleExample ex = new SimpleExample();
		PManageForm pmf = new PManageForm();
		pmf.setTitle("zzzzz");
		// account.setFirstName("firstnameaaaaaaa");
		// account.setLastName("lastname");
		// update account set firstname='null' ,email='[e-mail]' where
		try {
			ex.updateAccount(pmf);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}