package droolsbook.transform;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;
import org.drools.StatelessSession;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
/**
*/
public class Main {
public static final void main(String[] args)
throws SQLException, IOException {
// @extract-start 03 01
Reader reader = Resources
.getResourceAsReader("SqlMapConfig.xml");
SqlMapClient sqlMapClient = SqlMapClientBuilder
.buildSqlMapClient(reader);
reader.close();
// @extract-end
// @extract-start 03 02
List customers = sqlMapClient
.queryForList("findAllCustomers");
List addresses = sqlMapClient.queryForList(
"findAddressByCustomerId", new Long(654258));
// @extract-end
System.out.println("customers:" + customers);
System.out.println("addresses:" + addresses);
addresses = sqlMapClient.queryForList(
"findAddressByCustomerId", new Long(1));
System.out.println("addresses:" + addresses);
List accounts = sqlMapClient.queryForList(
"findAccountByCustomerId", new Long(654258));
System.out.println("accounts:" + accounts);
}
}