Olá, gostaria de ajuda para resolver esse erro no meu CRUD, estou com erro na linha destacada.
public class CadastroUsuarioControl implements CadastroControl {
PreparedStatement stmt;
Connection con;
Conexao cone;
public CadastroUsuarioControl() {
cone = new Conexao();
}
@Override
public void save(CadastroUsuario cadastroUsuario) {
String sqlSalvar = "INSERT INTO CadastroUsuario (NOME, LOGIN, SENHA, FUNCAO) VALUES (? , ?, ?, ?)";
try {
int index = 0;
**cone.stmt.openConection().prepareStatement(sqlSalvar);**
stmt.setString(++index, cadastroUsuario.getNome());
stmt.setString(++index, cadastroUsuario.getLogin());
stmt.setString(++index, cadastroUsuario.getSenha());
stmt.setString(++index, cadastroUsuario.getFuncao());
stmt.executeUpdate();
} catch (SQLException ex) {
Logger.getLogger(CadastroUsuarioControl.class.getName()).log(Level.SEVERE, null, ex);
}
throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
}
}
String url = “jdbc:mysql://localhost:3306/sistemaADV”;
String driver = “com.mysql.jdbc.Driver”;
String user = “root”;
String password = “”;
public void openConection() throws SQLException {
try {
Class.forName(driver);
con = (Connection) DriverManager.getConnection(url, user, password);
stmt = (PreparedStatement) con.createStatement();
} catch (ClassNotFoundException ex) {
Logger.getLogger(Conexao.class.getName()).log(Level.SEVERE, null, ex);
}
}
public static void main (String[] args) throws SQLException {
Conexao cone = new Conexao();
cone.openConection();
}
}
