import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Conexion {
private static String url = "jdbc:mysql://localhost:3306/bd1?useTimezone=true&serverTimezone=UTC";
private static String usuario = "root";
private static String password = "mysql";
public static Connection conectar() {
Connection conexion = null;
try {
conexion = DriverManager.getConnection(url, usuario, password );
} catch (SQLException e) {
System.out.println("Ocurrio un error al concetar a la base de datos" + e.getMessage());
}
return conexion;
}
}
-----------------------------------------------------------------------------------------------------------------------------------------------------
- Agregar
conexion = Conexion.conectar();
try {
preparedStatement = conexion
.prepareStatement("Insert into articulos (descripcion, precio) values(?,?)");
preparedStatement.setString(1, txtDesc.getText());
preparedStatement.setString(2, txtPrecio.getText());
