public static usuarioBean login(usuarioBean bean) {
Connection c = UsuarioDAO.getConnection();
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps =
c.prepareStatement(
"select login, senha, nome from usuario where login = ? and senha = ?");
ps.setString(1, bean.getLogin());
ps.setString(2, bean.getSenha());
rs = ps.executeQuery();
if (rs.next()) {
bean.setNome(rs.getString("nome"));
bean.setLogin(rs.getString("login"));
bean.setSenha(rs.getString("senha"));
bean.setCpf(rs.getString("cpf"));
bean.setEmail(rs.getString("email"));
bean.setUsuarioValido(true);
}
return bean;
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {;
}
rs = null;
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {;
}
ps = null;
}
if (c != null) {
try {
c.close();
} catch (SQLException e) {;
}
c = null;
}
}
return null;
}
public static usuarioBean login2(usuarioBean bean) {
Statement stmt = null;
String login = bean.getLogin();
String senha = bean.getSenha();
String searchQuery =
"select login,"
+ " senha,"
+ " nome"
+ " from usuario "
+ " where login='******'"
+ " and senha='"
+ senha
+ "';";
System.out.println("Login: "******"Senha: " + senha);
System.out.println("Query: " + searchQuery);
/*try {
currentCon = ConnectionManager.getConnection();
stmt = currentCon.createStatement();
rs = stmt.executeQuery(searchQuery);
boolean result = rs.next();
if (!result) {
//login e senha informados invalidos
bean.setUsuarioValido(false);
}
else if (result) {
// bean.setNome(rs.getString("nome"));
// bean.setLogin(rs.getString("login"));
// bean.setSenha(rs.getString("senha"));
// bean.setCpf(rs.getString("cpf"));
// bean.setEmail(rs.getString("email"));
// bean.setUsuarioValido(true);*/
bean.setNome("nome");
bean.setLogin("login");
bean.setSenha("senha");
bean.setCpf("cpf");
bean.setEmail("email");
bean.setUsuarioValido(true);
/*}
} catch (Exception ex) {
System.out.println("Erro no login: " + ex);
}
finally {
if (rs != null) {
try {
rs.close();
} catch (Exception e) {
}
rs = null;
}
if (stmt != null) {
try {
stmt.close();
} catch (Exception e) {
}
stmt = null;
}
if (currentCon != null) {
try {
currentCon.close();
} catch (Exception e) {
}
currentCon = null;
}
}*/
return bean;
}