junit测试mysql_Junit应用代码（读取mysql表数据）

1. 封装连接数据库的类：

import java.sql.ResultSet;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class DBhelp {

public static final String url = "jdbc:mysql://***:3306/databasename";

public static final String user = "user";

public static final String password = "password";

public java.sql.Connection con = null;

public java.sql.PreparedStatement ps = null;

ResultSet rs = null;

userdata userdata= new userdata();

public DBhelp(String sql) {

try {

con = DriverManager.getConnection(url, user, password);//获取连接

ps = con.prepareStatement(sql);//准备执行语句

rs = ps.executeQuery();

} catch (Exception e) {

e.printStackTrace();

}

}

public void close() {

try {

this.con.close();

this.ps.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

2. 封装sql查询的结果

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import com.mysql.jdbc.*;

public class DBsqlUtils {

public static List driverJDBC(String URL, String user, String password) {

List list = new ArrayList();

java.sql.Connection con = null;

PreparedStatement ps = null;

ResultSet rs = null;

String sql = "select USER_NM,PASSWORD from data_user";

//int sum= Integer.parseInt("select count(*) from data_user");

try {

Class.forName("org.gjt.mm.mysql.Driver");

con = DriverManager.getConnection(URL, user, password);

ps = con.prepareStatement(sql);

//ps.setInt(1, USER);

rs = ps.executeQuery();

while (rs.next()) {

String[] tmp = new String[2];

tmp[0] = rs.getString("USER_NM");

tmp[1] = rs.getString("PASSWORD");

list.add(tmp);

}

}catch (Exception e) {

e.printStackTrace();

}

finally {

try {

rs.close();

ps.close();

con.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

return list;

}

}

3. 使用junit读取数据测试

package MaijiaT;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.junit.runners.Parameterized;

import org.junit.runners.Parameterized.Parameters;

import java.util.Collection;

@RunWith(value = Parameterized.class)

public class TestJDBCjunit {

private String username;

private String password;

public TestJDBCjunit(String username, String password) {

this.username = username;

this.password = password;

}

@Parameters

public static Collection getData() {

return DBsqlUtils.driverJDBC("jdbc:mysql://192.168.44.128:3306/testdata", "wangqq","testpwd");

}

@Test

public void test() {

System.out.println(this.username + " " + this.password);

}

}

对于该测试可以使用junit执行测试，也可以使用testng.xml配置执行测试，需配置