private CV createCV() {
CV cv = new CV();
Category category = new Category();
category.setName("Technology");
cv.setCategory(Collections.singletonList(category));
User user = new User();
user.setGender(Gender.FEMALE);
user.setName("Ann");
cv.setOwner(user);
cv.setText("Python, Java, Ruby");
cv.setTitle("Software developer");
return cv;
}
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;
}