Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private Connection conector;
- private Statement declaracion;
- private PreparedStatement declaracionPreparada; // NEW!
- private ResultSet lectura;
- public void conectarBD(){
- try {
- Class.forName("com.mysql.jdbc.Driver");
- conector = DriverManager.getConnection("jdbc:mysql://localhost/bd_uno", "sa", "12345");
- catch ...
- }
- public boolean insertarProducto(){
- String sql = "INSERT INTO producto (CODPROVEEDOR, NOMBRE, DESCRIPCION, PRECIO, DESCONTINUADO) VALUES (?, ?, ?, ?, ?);"; l
- declaracionPreparada = conector.prepareStatement(sql);
- declaracionPreparada.setInt(1, this.codProveedor);
- declaracionPreparada.setString(2, this.nombre);
- declaracionPreparada.setString(3, this.descripcion);
- declaracionPreparada.setInt(4, this.precio);
- declaracionPreparada.setBoolean(5, this.descontinuado);
- declaracionPreparada.executeUpdate();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement