Package com.firefly.demo1.service.impl

Source Code of com.firefly.demo1.service.impl.UserServiceImpl

package com.firefly.demo1.service.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.sql.DataSource;

import com.firefly.annotation.Component;
import com.firefly.annotation.Inject;
import com.firefly.demo1.model.User;
import com.firefly.demo1.service.UserService;

@Component
public class UserServiceImpl implements UserService {

  @Inject
  private DataSource dataSource;

  @Override
  public List<User> getUsers() {
    Connection connection = null;
    PreparedStatement preparedStatement = null;
    ResultSet resultSet = null;
    List<User> ret = new ArrayList<User>();
    try {
      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) {
      try {
        if (connection != null)
          connection.rollback();
      } catch (SQLException e1) {
        e1.printStackTrace();
      }
      e.printStackTrace();
    } finally {
      try {
        if (resultSet != null)
          resultSet.close();
        if (preparedStatement != null)
          preparedStatement.close();
        if (connection != null)
          connection.close();
      } catch (SQLException e1) {
        e1.printStackTrace();
      }
    }
    return ret;
  }

}
TOP

Related Classes of com.firefly.demo1.service.impl.UserServiceImpl

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.