Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package clases;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.Statement;
- import javax.swing.JOptionPane;
- public class coneccion {
- Statement stmt=null;
- // ESTA PORONGA PARA EL ID
- //
- private static int ID;
- private static Connection conn;
- private static final String driver="com.mysql.jdbc.Driver";
- private static final String user="root";
- private static final String password="@ArianCalabrese1";
- private static final String url="jdbc:mysql://127.0.0.1:3306/?user=root";
- public coneccion(String nom, String psw){
- conn=null;
- try {
- Class.forName(driver);
- conn = DriverManager.getConnection(url, user, password);
- if(conn!=null){
- System.out.println("Conexion exitosa");
- stmt = conn.createStatement();
- stmt.executeUpdate("INSERT INTO mydb.Usuario VALUES('"+ 0 + "','"+nom+"','"+psw+"')");
- System.out.println("Valores agregados a la base de datos");
- }
- } catch (Exception e) {
- System.out.println("Error: "+ e);
- }
- }
- // este metodo nos retorna la conexion
- public Connection getConnection(){
- return conn;
- }
- // con este metodo nos desconectamos de la bd
- public void desconectar (){
- conn=null;
- if (conn==null){
- System.out.println("Conexion termianda");
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement