import java.sql.*;
import javax.swing.JOptionPane;

/**
*
* @author noniko
*/
public class MyDBConnection {
public String host_in;
public String user_in;
public String psw_in;

private Connection myConnection;

/** Creates a new instance of MyDBConnection */
public MyDBConnection() {

}

public void init(){

try{

Class.forName("com.mysql.jdbc.Driver");
myConnection=DriverManager.getConnection(
"jdbc:mysql://"+host_in+"/libcassa",user_in,psw_in
);
}
catch(Exception e){
System.out.println("Failed to get connection");
JOptionPane.showMessageDialog(null, "Collegamento al database non avvenuto..", "Errore", JOptionPane.ERROR_MESSAGE);
e.printStackTrace();
}
}


public Connection getMyConnection(){
return myConnection;
}


public void close(ResultSet rs){

if(rs !=null){
try{
rs.close();
}
catch(Exception e){}

}
}

public void close(java.sql.Statement stmt){

if(stmt !=null){
try{
stmt.close();
}
catch(Exception e){}

}
}

public void destroy(){

if(myConnection !=null){

try{
myConnection.close();
}
catch(Exception e){}


}
}

}