Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public UsuarioDAO(String jdbcURL, String jdbcUsername, String jdbcPassword) {
- this.jdbcURL = jdbcURL;
- this.jdbcUsername = jdbcUsername;
- this.jdbcPassword = jdbcPassword;
- }
- protected void connect() throws SQLException {
- if (jdbcConnection == null || jdbcConnection.isClosed()) {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- } catch (ClassNotFoundException e) {
- throw new SQLException(e);
- }
- jdbcConnection = DriverManager.getConnection(
- jdbcURL, jdbcUsername, jdbcPassword);
- }
- }
- protected void disconnect() throws SQLException {
- if (jdbcConnection != null && !jdbcConnection.isClosed()) {
- jdbcConnection.close();
- }
- }
- public boolean insertUsuario(Usuario usuario) throws SQLException {
- String sql = "INSERT INTO usuario (nome, endereco, cidade, estado, telefone, celular, email) VALUES (?, ?, ?, ?, ?, ?, ?)";
- connect();
- PreparedStatement statement = jdbcConnection.prepareStatement(sql);
- statement.setString(1, usuario.getNome());
- statement.setString(2, usuario.getEndereco());
- statement.setString(3, usuario.getCidade());
- statement.setString(1, usuario.getEstado());
- statement.setString(2, usuario.getTelefone());
- statement.setString(3, usuario.getCelular());
- statement.setString(7, usuario.getEmail());
- boolean rowInserted = statement.executeUpdate() > 0;
- statement.close();
- disconnect();
- return rowInserted;
- }
- public List<Usuario> listTodosUsuarios() throws SQLException {
- List<Usuario> listUsuario = new ArrayList<>();
- String sql = "SELECT * FROM usuario";
- connect();
- PreparedStatement statement = (PreparedStatement) jdbcConnection.prepareStatement(sql);
- ResultSet resultSet = statement.executeQuery(sql);
- while (resultSet.next()) {
- int id = resultSet.getInt("usuario_id");
- String nome = resultSet.getString("nome");
- String endereco = resultSet.getString("endereco");
- String cidade = resultSet.getString("cidade");
- String estado = resultSet.getString("estado");
- String telefone = resultSet.getString("telefone");
- String celular = resultSet.getString("celular");
- String email = resultSet.getString("email");
- Usuario usuario = new Usuario(id, nome, endereco, cidade, estado, telefone, celular, email);
- listUsuario.add(usuario);
- }
- resultSet.close();
- statement.close();
- disconnect();
- return listUsuario;
- }
- public boolean deleteUsuario(Usuario usuario) throws SQLException {
- String sql = "DELETE FROM usuario where usuario_id = ?";
- connect();
- PreparedStatement statement = jdbcConnection.prepareStatement(sql);
- statement.setInt(1, usuario.getId());
- boolean rowDeleted = statement.executeUpdate() > 0;
- statement.close();
- disconnect();
- return rowDeleted;
- }
- public boolean updateUsuario(Usuario usuario) throws SQLException {
- String sql = "UPDATE usuario SET nome = ?, endereco = ?, cidade = ?, estado = ?, telefone = ?, celular = ?, email = ?";
- sql += " WHERE usuario_id = ?";
- connect();
- PreparedStatement statement = jdbcConnection.prepareStatement(sql);
- statement.setString(1, usuario.getNome());
- statement.setString(2, usuario.getEndereco());
- statement.setString(3, usuario.getCidade());
- statement.setString(4, usuario.getEstado());
- statement.setString(5, usuario.getTelefone());
- statement.setString(6, usuario.getCelular());
- statement.setString(6, usuario.getEmail());
- statement.setInt(4, usuario.getId());
- boolean rowUpdated = statement.executeUpdate() > 0;
- statement.close();
- disconnect();
- return rowUpdated;
- }
- public Usuario getUsuario(int id) throws SQLException {
- Usuario usuario = null;
- String sql = "SELECT * FROM usuario WHERE usuario_id = ?";
- connect();
- PreparedStatement statement = jdbcConnection.prepareStatement(sql);
- statement.setInt(1, id);
- ResultSet resultSet = statement.executeQuery();
- if (resultSet.next()) {
- String nome = resultSet.getString("nome");
- String endereco = resultSet.getString("endereco");
- String cidade = resultSet.getString("cidade");
- String estado = resultSet.getString("estado");
- String telefone = resultSet.getString("telefone");
- String celular = resultSet.getString("celular");
- String email = resultSet.getString("email");
- usuario = new Usuario(id, nome, endereco, cidade, estado, telefone, celular, email);
- }
- resultSet.close();
- statement.close();
- return usuario;
- }
- usuario_id int(11) NOT NULL AUTO_INCREMENT,
- nome varchar(45) NOT NULL,
- endereco varchar(45) NOT NULL,
- cidade varchar(45) NOT NULL,
- estado varchar(45) NOT NULL,
- telefone varchar(45) NOT NULL,
- celular varchar(45) NOT NULL,
- email varchar(45) NOT NULL,
- PRIMARY KEY (usuario_id)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement