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...");    }}

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