idを抽出して、numberに入っている値と同じか確認する単体テストを作るにはどうすればいいですか?
継承クラス
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import org.sasami.tcm.bean.CustomerBean;
public class CustomerSearch {
public CustomerBean search (String Id) {
Connection connection =null;
PreparedStatement preparedStatement =null;
ResultSet resultSet =null;
CustomerBean customerBean = new CustomerBean();
try {
Class.forName("org.postgresql.Driver");
connection = DriverManager.getConnection( "jdbc:postgresql://);
String SQL = "SELECT ID, PASSWORD"
- "ADDRESS, TEL TB_CUSTOMER "
- "WHERE ID = ?";
preparedStatement = connection.prepareStatement(SQL);
preparedStatement.setString(1, Id);
resultSet = preparedStatement.executeQuery();
while(resultSet.next()){
customerBean.setId(resultSet.getInt("ID"));
customerBean.setAddress(resultSet.getString("ADDRESS"));
customerBean.setTel(resultSet.getString("TEL")); }
} catch (Exception e) {
e.printStackTrace();
}finally{
try{
if(resultSet != null){
resultSet.close();
} if(preparedStatement != null){
preparedStatement.close();
}if(connection != null){
connection.close();
}
}catch (Exception e) {
e.printStackTrace();
}
} return customerBean;
}
}
単体テスト import org.junit.Test; import org.sasami.tcm.bean.CustomerBean;
import junit.framework.TestCase;
public class CustomerSearchTest extends TestCase{
public CustomerSearchTest(String Id) {
super(Id);
}
@Test public void testSearch() {
String Id = null;
CustomerSearch customersearch = new CustomerSearch();
CustomerBean number = customersearch.search(Id);
assertEquals(Id, number);
}
}