public static int insertUser(Users u) { int status = 0; try { conn = ConnectionFactory.getCon(); pst = conn.prepareStatement("insert into test VALUES (?,?,?,?,?)"); pst.setInt(1, u.getId()); pst.setString(2, u.getLogin()); pst.setString(3, u.getPassword()); pst.setString(4, u.getLastName()); pst.setString(5, u.getFirstName()); status = pst.executeUpdate(); conn.close(); } catch (Exception ex) { System.out.println(ex); } return status; }
public static List<Users> getUsers() throws SQLException { conn = ConnectionFactory.getCon(); pst = conn.prepareStatement( "SELECT test.id, test.login,test.password,test.firstname,test.lastname FROM test"); ResultSet resultSet = pst.executeQuery(); ArrayList<Users> user = new ArrayList<Users>(); while (resultSet.next()) { int id = resultSet.getInt(1); String login = resultSet.getString(2); String password = resultSet.getString(3); String firstName = resultSet.getString(4); String lastName = resultSet.getString(5); user.add(new Users(id, login, password, firstName, lastName)); } conn.close(); return user; }
public static String checkUser(String login, String password) throws SQLException { String FIO = ""; conn = ConnectionFactory.getCon(); pst = conn.prepareStatement( "SELECT test.login,test.password, test.firstname, test.lastname FROM test WHERE test.login =? AND test.password =?"); pst.setString(1, login); pst.setString(2, password); ResultSet resultSet = pst.executeQuery(); boolean myResultSetEmpty = isMyResultSetEmpty(resultSet); // если нет пользователя то true System.out.println(myResultSetEmpty); if (myResultSetEmpty == false) { resultSet.next(); FIO = resultSet.getString(3) + "" + resultSet.getString(4); return FIO; } System.out.println(pst.toString()); System.out.println(resultSet); conn.close(); System.out.println(FIO); return FIO; }