Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Clase para conectar a la base de datos
- package Classes;
- import Interfaces.frmLogin;
- import java.sql.DriverManager;
- import java.sql.Connection;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class Conexion {
- public Connection conn;
- private Statement stmnt;
- public Statement comando;
- public ResultSet reg;
- private PreparedStatement psInsertar;
- private static String driver = "com.mysql.jdbc.Driver";
- private static String user = "root";
- private static String password = "lenovoroot";
- private static String url = "jdbc:mysql://localhost:3306/tienda";
- frmLogin frm = new frmLogin();
- public Conexion() {
- conn = null;
- try {
- Class.forName(driver);
- conn = DriverManager.getConnection(url, user, password);
- if (conn != null) {
- System.out.println("Conexion establecida");
- }
- } catch (Exception e) {
- System.out.println("Error al conectar " + e);
- }
- }
- //Metdo para saber estamos conectados.
- public Connection getConnection() {
- return conn;
- }
- //Metodo para desconectarse de la base de datos.
- public void desconectar() {
- conn = null;
- if (conn == null) {
- System.out.println("Conexion terminada");
- }
- }
- public void IngresarProductos(int codigo, String descripcion, float precio) throws SQLException {
- stmnt = conn.createStatement();
- psInsertar = conn.prepareStatement("INSERT INTO productos (Codigo,Descripcion,Precio)" + "values(?,?,?)");
- psInsertar.setString(1, String.valueOf(codigo));
- psInsertar.setString(2, descripcion);
- psInsertar.setString(3, String.valueOf(precio));
- psInsertar.executeUpdate();
- }
- public void setFecha(int codigo, String fecha) throws SQLException {
- stmnt = conn.createStatement();
- psInsertar = conn.prepareStatement("INSERT INTO ticket (codigo,fecha)" + "values(?,?)");
- psInsertar.setString(1, String.valueOf(codigo));
- psInsertar.setString(2, fecha);
- psInsertar.executeUpdate();
- }
- public void IngresarDatosBoleto(int ticket,int codigo,int cantidad) throws SQLException{
- stmnt = conn.createStatement();
- psInsertar = conn.prepareStatement("INSERT INTO boleto (ticket,codigo,cantidad)"+"values(?,?,?)");
- psInsertar.setString(1, String.valueOf(ticket));
- psInsertar.setString(2, String.valueOf(codigo));
- psInsertar.setString(3, String.valueOf(cantidad));
- psInsertar.executeUpdate();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement