Junit基本使用

Junit基本用法

1.创建Junit Test Case

2.基本使用（以oracle数据库操作为例）

package com.csit.adminsystem1.tests;

import static org.junit.Assert.*;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.csit.adminsystem1.domains.TProduct;
import com.csit.adminsystem1.domains.TUser;

public class JdbcTest {
	Connection conn;
	//每次执行测试时调用，在这里为数据库连接操作
	@Before
	public void init() throws ClassNotFoundException, SQLException{
		System.out.println("数据库初始化中...");
		Class.forName("oracle.jdbc.driver.OracleDriver");
		Properties po = new Properties();
		po.put("user", "yourUsername");
		po.put("password", "yourPassword");
		conn = DriverManager.getConnection("jdbc:oracle:thin:127.0.0.1:1521:orcl", po);
		
	}
	//此处为调试内容，点击函数名，右键run as Junit Test
	@Test
	public void select() throws SQLException {
		Statement ste = conn.createStatement();
		ResultSet rs = ste.executeQuery("select * from t_product");
		List<TProduct> users = new ArrayList<TProduct>();
		while (rs.next()) {
			TProduct user = new TProduct();
			user.setProductId(rs.getInt("product_id"));
			user.setProductName(rs.getString("product_name"));
			user.setProductPrice(rs.getDouble("product_price"));
			users.add(user);
		}
		System.out.println(users);
	}
	@Test
	public void insert() throws SQLException {
		Statement ste = conn.createStatement();
		TProduct product = new TProduct(0, "可口可乐", 3.0);
		StringBuffer sbf = new StringBuffer("insert into t_product (product_id,product_name,product_price) values(");
		sbf.append(product.getProductId()).append(",");
		sbf.append("'").append(product.getProductName() ).append("'").append(",");
		sbf.append(product.getProductPrice()).append(")");
		try{
			ste.execute(sbf.toString());
		}catch(Exception e) {
			System.out.println("insert fail!"+e.getMessage());
			throw e;
		}
		System.out.println("insert successful!");
	}
	@Test
	public void delete() throws SQLException {
		String sql = "delete from t_product where product_id = ?";
		PreparedStatement ste = conn.prepareStatement(sql);
		ste.setInt(1, 0);
		try{
			ste.execute();
		}catch(Exception e) {
			System.out.println("delete fail!"+e.getMessage());
			throw e;
		}
		System.out.println("delete successful!");
		
	}
	//执行完毕后调用，关闭数据库
	@After
	public void end() throws SQLException {
		conn.close();
		System.out.println("over...");
	}
}

分别执行查询，插入，查询，删除，查询操作后执行结果如下图：