public List<User> getMessageUserList(String userName) { List<User> userList; userList = new ArrayList<User>(); User user = new User(); try { Statement sta = con.createStatement(); final String selSQL = "SELECT * FROM \"USER\" Where USERNAME = ?"; PreparedStatement ps; ResultSet rs = null; ps = con.prepareStatement(selSQL); ps.setString(1, userName); rs = ps.executeQuery(); if (rs.next()) { user.setName(rs.getString("NAME")); user.setUsurname(rs.getString("USERNAME")); user.setId(rs.getInt("ID")); } else { user = null; } rs.close(); ps.close(); sta.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (Exception e) { // Handle errors for Class.forName e.printStackTrace(); } finally { } return userList; }