testerdbunit.java

来自「BUG跟踪系统是用来对开发软件时发现的bug进行跟踪。里面包括用户管理模块」· Java 代码 · 共 88 行

package su.bts1.junit;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;

import su.bts1.imp.BugBeansDB;
import su.bts1.imp.ProjectBeansDB;
import junit.framework.TestCase;

public class TesterDBUnit extends TestCase {
	public static final String DriverName = "sun.jdbc.odbc.JdbcOdbcDriver";

	public static final String URL = "jdbc:odbc:bts";

	public static final String UserName = "root";

	public static final String PassWord = "root";

	private Connection conn = null;

	public TesterDBUnit() {
		try {
			Class.forName(DriverName);
			Connection conn = DriverManager.getConnection(URL, UserName,
					PassWord);
			assertNotNull(conn);
			this.conn = conn;
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	/**
	 * ������ݿ��Ƿ����l��
	 *
	 */
	public void testISConn() {

		try {
			Class.forName(DriverName);
			Connection conn = DriverManager.getConnection(URL, UserName,
					PassWord);
			assertNotNull(conn);
			this.conn = conn;
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	/**
	 * 测试project表 取出所有project bean
	 *
	 */
	public void testProjectDB() {
		ProjectBeansDB project = new ProjectBeansDB();
		List list = null;
		try {
			list = project.projBeans(this.conn);
			assertEquals(2, list.size());
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

	/**
	 *
	 * 测试项目名为‘bug’的项目，总共有多少Bug
	 */
	public void testBugDbView() {
		BugBeansDB bug = new BugBeansDB();
		List list = null;
		try {
			list = bug.bugBeans("bug", conn);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		assertEquals(2, list.size());

	}
}