public static Connection ConnessioneDB()
{
    try
    {
        Class.forName("org.sqlite.JDBC");
        Connection con = DriverManager.getConnection("jdbc:sqlite:Rottamazione.sqlite");

        return con;

    }
    catch (Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }
    return null;
}

Connection con = DriverManager.getConnection("jdbc:sqlite:resource:Rottamazione.sqlite");