testbst.java

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

package com.bts;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import junit.framework.TestCase;

public class TestBst extends TestCase {

	/**
	 * 测试数据库是否有连接
	 *
	 */
	public void testDBConn() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/bts", "root", "");
			assertNotNull(conn);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

	/**
	 * 测试对数据库执行操作admin 用户名为su
	 *
	 */
	public void testCRUD() {
		Connection conn = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/bts", "root", "");
			// assertNotNull(conn);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

		try {
			Statement stmt = conn.createStatement();
			ResultSet rst = stmt.executeQuery("select * from admin");
			while (rst.next()) {
				assertEquals("su", rst.getString(2));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

	public void testdeleteSu() {
		Connection conn = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/bts", "root", "");
			// assertNotNull(conn);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

		try {
			Statement stmt = conn.createStatement();

			assertEquals(false, stmt
					.execute("delete from admin where admin_name ='su'"));
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}
}