connection = dataSource.getConnection();
preparedStatement = connection
.prepareStatement("select id, name, password from cms_user");
resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
User user = new User();
user.setId(resultSet.getString("id"));
user.setName(resultSet.getString("name"));
user.setPassword(resultSet.getString("password"));
ret.add(user);
}
connection.commit();
} catch (SQLException e) {