@Test
public void testExecuteQuery() throws SQLException {

    TGroupConnection conn = null;
    PreparedStatement stat = null;
    try {
        conn = tgds.getConnection();
        stat = conn.prepareStatement("select * from xxx where id=?");
        stat.setByte(1, (byte) 5);
        MockDataSource.addPreData("id:1,name:2");
        ResultSet result = stat.executeQuery();
        Assert.assertEquals(result.next(), true);
        Assert.assertEquals(result.getLong(1), 1L);
        Assert.assertEquals(result.getLong(2), 2L);
        MockDataSource.showTrace();
    } finally {
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
            }
            if (stat != null) {
                try {
                    stat.close();
                } catch (SQLException e) {
                }
            }
        }
    }
}