testdbunit.java

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

package su.bts1.junit;

import junit.framework.*;
import java.sql.*;
import java.util.List;

import su.bts1.bean.UserFormBean;
import su.bts1.dao.IUserDB;
import su.bts1.imp.AdminUserImp;
import su.bts1.imp.ProgramerDBImp;
import su.bts1.imp.ProjectBeansDB;
import su.bts1.imp.UserDBImp;

public class TestDBUnit 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 TestDBUnit() {
		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();
		}
	}

	/**
	 *
	 * 查询部门人员为：su 密码：su是否存在
	 *
	 */
	public void testUserDB() {

		UserFormBean userBean = new UserFormBean();
		userBean.setUserName("su");
		userBean.setPassword("su");
		userBean.setDepartID("2");
		IUserDB user = new UserDBImp(userBean);
		try {
			assertTrue(user.selectUser(conn));
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

	/**
	 * 查询管理人员存在：su 密码:sd 不存在
	 *
	 */
	public void testAdminDB() {

		// 查询管理员的用户:
		UserFormBean adminBean = new UserFormBean();
		adminBean.setUserName("su");
		adminBean.setPassword("su");
		adminBean.setDepartID("3");
		IUserDB admin = new AdminUserImp(adminBean);
		try {
			assertTrue(admin.selectUser(this.conn));
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

	public void testProgramDB() {
		// 查看开发人员：
		UserFormBean programBean = new UserFormBean();
		programBean.setDepartID("1");
		programBean.setUserName("p");
		programBean.setPassword("p");
		IUserDB programer = new ProgramerDBImp(programBean);
		try {
			assertTrue(programer.selectUser(conn));
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}


}