RSTI - Conexao.java

package com.mycompany.javacomsql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 *
 * @author User
 */
public class Conexao {

static final String JDBC_DRIVER = "org.mariadb.jdbc.Driver";
static final String DB_URL = "jdbc:mariadb://localhost:3306/sistema";

static final String USER = "root";
static final String PASS = "";

public Connection conectar() {

Connection conn = null;

try {
conn = DriverManager.getConnection(DB_URL,USER,PASS);
System.out.println("Conectado");

return conn;

//conn.close();

} catch (SQLException ex) {
System.out.println("Erro " + ex);
conn = null;

}
return conn;

}

public void desconectar(Connection conn) {
try {
  if(conn != null && !conn.isClosed()) {
conn.close();
System.out.println("Desconectou do banco de dados.");
  }
} catch (SQLException ex) {
  System.out.println("Não conseguiu desconectar do BD.");
}
  }




}